Difference between revisions of "Manuals/calci/CONFIDENCE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''CONFIDENCE(a,sd,s)'''</div><br/>  
+
<div style="font-size:30px">'''CONFIDENCE (Alpha,StandardDeviation,Size)'''</div><br/>  
*<math>a</math>  is alpha value which is indicating the significance level.
+
*<math>Alpha</math>  is alpha value which is indicating the significance level.
*<math>sd</math> is the standard deviation.
+
*<math>StandardDeviation</math> is the value of the standard deviation.
*<math>s</math> is the size of the sample.
+
*<math>Size</math> is the size of the sample.
 +
**CONFIDENCE(), returns the confidence interval for a population mean.
  
  
Line 15: Line 16:
 
     4. Specify the confidence interval.  
 
     4. Specify the confidence interval.  
 
*Normally once standard error value is calculated, the confidence interval is determined by multiplying the standard error by a constant that reflects the level of significance desired, based on the normal distribution.  
 
*Normally once standard error value is calculated, the confidence interval is determined by multiplying the standard error by a constant that reflects the level of significance desired, based on the normal distribution.  
*In <math>CONFIDENCE(a,sd,s)</math> , <math>a</math> is the alpha value which is indicating the significance level used to find the value of the confidence level.  
+
*In <math>CONFIDENCE (Alpha,StandardDeviation,Size)</math> , <math>Alpha</math> is the alpha value which is indicating the significance level used to find the value of the confidence level.  
*It equals <math>100*(1-alpha)%</math>, or alpha of 0.05 indicates a 95 percent confidence level.
+
*It equals <math>100*(1-Alpha)%</math>, or alpha of 0.05 indicates a 95 percent confidence level.
*This value is <math> \plusmn</math> {1.96}
+
*This value is <math> \pm </math> 1.96
*<math> sd </math> is the standard deviation of the population for the data range.
+
*<math> StandardDeviation </math> is the standard deviation of the population for the data range.
*<math> s </math> is the size of the sample.
+
*<math> Size </math> is the size of the sample.
 
*Confidence interval is calculated using the following formula:  
 
*Confidence interval is calculated using the following formula:  
 
     <math>Confidence interval = sample statistic + Margin of error</math>.  
 
     <math>Confidence interval = sample statistic + Margin of error</math>.  
*So  <math> confidence interval =\bar{x}\plusmn {1.96}(\frac{\sigma}{\sqrt {s}})</math>
+
*So  <math> confidence interval =\bar{x}\pm 1.96(\frac{\sigma}{\sqrt {s}})</math>
 
*where <math>\bar{x}</math> is the sample mean,sigma is the standard deviation.
 
*where <math>\bar{x}</math> is the sample mean,sigma is the standard deviation.
 
*This function will give the result as error when  
 
*This function will give the result as error when  
 
   1. Any one of the argument is nonnumeric.  
 
   1. Any one of the argument is nonnumeric.  
   2.Suppose <math>0\le alpha\le1 </math>
+
   2.Suppose <math>0\le Alpha\le1 </math>
 
   3. value of s is less than 1.
 
   3. value of s is less than 1.
 
*Suppose with the population of 10 for the standard deviation 3.2, with the alpha value 0.2 then, CONFIDENCE(0.2,3.2,10) =1.296839.  
 
*Suppose with the population of 10 for the standard deviation 3.2, with the alpha value 0.2 then, CONFIDENCE(0.2,3.2,10) =1.296839.  
*So the Confidence interval value is <math> 10\plusmn 1.296839= approximately[11.29,8.70]</math>.
+
*So the Confidence interval value is <math> 10\pm 1.296839= approximately[11.29,8.70]</math>.
 +
 
 +
==ZOS==
 +
 
 +
*The syntax is to calculate CONFIDENCE in ZOS is <math>CONFIDENCE (Alpha,StandardDeviation,Size)</math>.
 +
**<math>Alpha</math>  is  value of the significance level.
 +
*<math>Size</math> is the size of the sample.
 +
*For e.g., CONFIDENCE(0.2,3.1,20)
 +
*CONFIDENCE(0.67,8.3..10.3,51)
  
 
==Examples==
 
==Examples==
Line 36: Line 45:
 
#=CONFIDENCE(0.001,18.8,50) = 8.74859415
 
#=CONFIDENCE(0.001,18.8,50) = 8.74859415
  
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|siqx4PbqJ6s|280|center|CONFIDENCE}}
  
 
==See Also==
 
==See Also==
Line 43: Line 56:
  
 
==References==
 
==References==
*<math>\plusmn</math>
+
[http://en.wikipedia.org/wiki/Confidence_interval CONFIDENCE]
*<math>\sigma</math>
+
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:20, 7 August 2018

CONFIDENCE (Alpha,StandardDeviation,Size)


  • is alpha value which is indicating the significance level.
  • is the value of the standard deviation.
  • is the size of the sample.
    • CONFIDENCE(), returns the confidence interval for a population mean.


Description

  • This function gives value of the confidence intervals.
  • Confidence intervals are calculated based on the standard error of a measurement.
  • It is measures the probability that a population parameter will fall between lower bound and upper bound of the values.
  • There are four steps to constructing a confidence interval.
   1. Identify a sample statistic.
   2. Select a confidence level. 
   3. Find the margin of error.
   4. Specify the confidence interval. 
  • Normally once standard error value is calculated, the confidence interval is determined by multiplying the standard error by a constant that reflects the level of significance desired, based on the normal distribution.
  • In , is the alpha value which is indicating the significance level used to find the value of the confidence level.
  • It equals , or alpha of 0.05 indicates a 95 percent confidence level.
  • This value is 1.96
  • is the standard deviation of the population for the data range.
  • is the size of the sample.
  • Confidence interval is calculated using the following formula:
    . 
  • So
  • where is the sample mean,sigma is the standard deviation.
  • This function will give the result as error when
 1. Any one of the argument is nonnumeric. 
 2.Suppose 
 3. value of s is less than 1.
  • Suppose with the population of 10 for the standard deviation 3.2, with the alpha value 0.2 then, CONFIDENCE(0.2,3.2,10) =1.296839.
  • So the Confidence interval value is .

ZOS

  • The syntax is to calculate CONFIDENCE in ZOS is .
    • is value of the significance level.
  • is the size of the sample.
  • For e.g., CONFIDENCE(0.2,3.1,20)
  • CONFIDENCE(0.67,8.3..10.3,51)

Examples

  1. =CONFIDENCE(0.6,4.6,20) = 0.539393789
  2. =CONFIDENCE(0.09,8.1,25) = 2.746544290
  3. =CONFIDENCE(0.001,18.8,50) = 8.74859415


Related Videos

CONFIDENCE

See Also


References

CONFIDENCE