Descriptive Statistics Excel Worksheet

Name: Bin

Date: Frequency 1 2 2 1 Directions: Answer all problems and submit to instructor at the end of module 1 3 6 4 7 5 4 6 4 7 1 8 1 More 0 Q1

Descriptive Statistics Excel Worksheet

b

Q2

d

Q3

e

Q4

b

5. For the following sample of scores: 2, 6, 1, 4, 2, 2, 4, 3, 2

Mean variance standard deviation

2.889 2.099 1.537

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?

New Sample Mean

7

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. Once you select the column, then you insert the column and line graph.

Line Graph
8 7 6 5 4 3

Insert your histogram and line graph here:

X 1 2 3 4

f 2 1 6 7

2

1 2 3 3

1 0 1 2 3 4 5 6

5 6 7 8

4 4 1 1

3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 6 6 6 6 7 8 1

Histogram
8

6
4 2 0 1 2 3 4 5 6 7

6

7

8

8

More