Data Analysis and Presentation Skills Part 6 pps

true population mean. The equation for the standard error may be seen in

Equation 4.3:

SEM ¼ standard deviation

H number in sample ðEquation 4:3Þ

If we wanted to check that the value of the standard error calculated in the

Descriptive Statistics function was correct then we would insert the following

formula into a cell on the spreadsheet, using the data from Group 1 as an

example:

¼3.7/SQRT(9)

DESCRIPTIVE STATISTICS 83

Figure 4.1 Descriptive Statistics functions in Excel