Prob 6-12 Statistics
Rivercereek Labs
Summary Statistics Using Excel Data Analysis Tool – “Descriptive Statistics”
Note that the data must be put into a unidimensional array in order to run the summary statistics
Summary Data in
Original Data
Ascending Order
1.5 2.3 3.7 3.6 4.7 3.4 3.3 2.7 3.6 1.9 1.7
1.7 Column1 5.0 4.5 3.7 4.1 2.7 4.1 2.5 4.2 3.5 3.1
1.7 3.4 3.7 2.3 4.0 2.9 3.9 4.8 1.5 3.1 4.3
1.8 Mean 3.528 4.4 3.2 4.1 2.7 5.1 3.8 3.1 4.4 3.9 4.1
1.8 Standard Error 0.084 1.7 2.5 3.4 4.2 1.8 4.3 3.9 4.5 2.4 4.4
2.6
2.7
2.7
2.7
2.8
2.9
2.9 Column1
2.9
3.0 Mean 3.528
3.0 Standard Error 0.084
3.1 Median 3.600
3.1 Mode 4.100
3.1 Standard Deviation 0.841
3.2 Sample Variance 0.707
3.3 Kurtosis -0.191
3.3 Skewness -0.314
3.3 Range 3.900
3.3 Minimum 1.500
3.3 Maximum 5.400
3.4
3.4
3.4
3.4
3.5
3.5
3.5
3.5
3.5
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.8
3.8
3.8
3.8
3.9
3.9
3.9
4.0
4.0
4.1
Page 1
1.9 Median 3.600 3.5 3.6 4.1 3.6 4.4 3.8 3.7 3.3 2.6 4.7
1.9 Mode 4.100 3.0 3.4 3.0 4.6 4.8 2.6 3.6 2.9 2.8 3.7
2.3 Standard Deviation 0.841 4.1 3.8 3.6 5.1 4.0 3.5 3.3 3.7 4.4 1.8
2.3 Sample Variance 0.707 2.9 4.7 2.4 3.3 3.3 2.6 4.1 1.9 3.6 3.7
2.4 Kurtosis -0.191 3.7 3.7 3.8 3.3 5.4 2.6 3.3 3.5 3.5 4.4
2.4 Skewness -0.314
2.5 Range 3.900
2.5 Minimum 1.500
2.6 Maximum 5.400
2.6 Sum 352.800
Prob 6-12 Statistics
4.1
4.1
4.1
4.1
4.1
4.1
4.2
4.2
4.3
4.3
4.4
4.4
4.4
4.4
4.4
4.4
4.5
4.5
4.6
4.7
4.7
4.7
4.8
4.8
5.0
5.1
5.1
5.4
Page 2
Prob 6-12 Histogram
Problem 6-12
Histogram Using Excel Data Analysis Tool – “Histogram”
Input Bin Bin Frequency
Data Here 1.9 5
1.9 2.2 2
2.2 2.5 6
2.5 2.8 8
2.8 3.1 8
3.1 3.4 12
3.4 3.7 21
3.7 4 9
4.0 4.3 11
1.5
2.3 3.7 3.6 4.7 3.4 3.3 2.7 3.6 1.9 1.7
1.7
5.0 4.5 3.7 4.1 2.7 4.1 2.5 4.2 3.5 3.1
1.7
3.4 3.7 2.3 4.0 2.9 3.9 4.8 1.5 3.1 4.3
1.8
4.4 3.2 4.1 2.7 5.1 3.8 3.1 4.4 3.9 4.1
1.8
1.7 2.5 3.4 4.2 1.8 4.3 3.9 4.5 2.4 4.4
3.5 3.6 4.1 3.6 4.4 3.8 3.7 3.3 2.6 4.7
3.0 3.4 3.0 4.6 4.8 2.6 3.6 2.9 2.8 3.7
4.1 3.8 3.6 5.1 4.0 3.5 3.3 3.7 4.4 1.8
2.9 4.7 2.4 3.3 3.3 2.6 4.1 1.9 3.6 3.7
3.7 3.7 3.8 3.3 5.4 2.6 3.3 3.5 3.5 4.4
2.4
2.5
2.5
2.6
2.6
2.6
2.6
2.7
2.7
2.7
2.8
2.9
2.9
2.9
3.0
3.0
3.1
3.1
3.1
3.2
3.3
3.3
3.3
3.3
3.3
3.3
3.3
3.4
3.4
3.4
10
15
20
25
Frequency
Histogram
Frequency
Page 3
Prob 6-12 Histogram
3.4
3.5
3.5
3.5
3.5
3.5
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.8
3.8
3.8
3.8
3.9
3.9
3.9
4.0
4.0
4.1
4.1
4.1
4.1
4.1
4.1
4.1
4.2
4.2
4.3
4.3
4.4
4.4
4.4
4.4
4.4
4.4
4.5
4.5
4.6
4.7
4.7
4.7
4.8
4.8
5.0
5.1
5.1
5.4
Page 4