HLT 362 Module 1 Descriptive Statistics Excel Worksheet

Please type your selection in the cell beside the question:

1.  A formula for the sample mean is

2.  A formula for the sample variance is

3.  A formula for the sample standard deviation is

4.  A computational formula for the sample variance is

5.  For the following sample of scores:

     2, 6, 1, 4, 2, 2, 4, 3, 2

     Find the mean, variance and standard deviation

6.  A sample of size 7 (n = 7) has a mean of M = 9.

One of the sample scores is changed from x = 19 to x = 5. What is the value for the new sample mean?

7.  Using Excel create a histogram and a line graph using the scores in the following table:

NOTE: When you wish to plot one series (the column f in this problem) select only that column, then you insert the column and line graph.

Insert your histogram and line graph here: