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
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