Question

What are the various excel formulas to get the numerical answers? Could you show the cells with the formulas in them?

edit: Apologies. For example, in step 3, what are the excel formulas for:

Sample Standard Deviation, Sample Mean, Sample Size

Standard Error of The Mean, Degrees of Freedom, t Value, Interval Half Width,

Interval Lower Limit, Interval Upper Limit.

Answer 1

Formula for standard Deviation- select the range =STDEV.S(A1:A10), the number 1 and 10 represent range of cells in the coloum and similarly for row.

Formula for sample mean-select the range =AVERAGE(A1:A10), the number 1 and 10 represent range of cells in the coloum and similarly for row.

Formula for Sample Size-select the range =COUNT(A1:A10), the number 1 and 10 represent range of cells in coloum similarly for row.

Formula for Standard Error of Mean-  Standard Error = STDEV(sampling range)/SQRT(COUNT(sampling range)) and it represents Standard deviation / square root of total number of samples.

Formula for Degree of Freedom- = (R – 1) * (C – 1) where R represents number of rows and C represents number of coloums.(ROWS(sampling range)-1)*COLOUMS(sampling range)-1)

Formula for T value- if your mean is in cell A2, population mean in cell B2, standard deviation in cell C2, square root of degrees of freedom in E2, type the formula as =(A2-B2)/(C2/E2).

Formula for Internal half width- Find the CRITICAL NUMBER *(Standard of error is standard deviation / SQRT(n))

Formula for maximum and minimum value for upper and lower limit-

=MAX(“Your range of cells ”) function

=MIN(“Your range of cells”) function