Problem 8-13a
Aussieburgers, Ltd.
Descriptive Statistics and Frequency Chart
This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells.
Note: The data and cell boundaries below were sorted in ascending order to more accurately show the increasing values on the histogram
as contrasted with decreasing values in the even-numbered solutions in the text.
Australian Hamburger Weights
Frequency Table – Problem 8-13a
Upper Cell
Sorted Boundaries Frequencies
DATA Values
1112 Cell 1 112.00 3
2112 Cell 2 112.67 0
8113 More 0
9114
10 114 Standard Statistical Measures
11 114
12 114 Mean 113.96
13 114 Median 114.00
14 114 Mode 114.00
15 114 Standard deviation 1.14
16 114 Variance 1.29
17 114 Max 116.00
18 115 Min 112.00
19 115 Range 4.00
20 115
21 115
22 115
23 115
24 116
25 116
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
3112 Cell 3 113.33 5
4113 Cell 4 114.00 9
5113 Cell 5 114.67 0
6113 Cell 6 115.33 6
7113 Cell 7 116.00 2
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Freq. Distrib. 8-13a
Problem 8-13a
Aussieburgers, Ltd.
7
8
9
10
Frequency Distribution – Problem 8-13a
Page 3
Aussieburgers, Ltd.
Bins
Scale A Scale B 111
118 116 116 118 117 113 112 115 115 113 112
114 115 115 116 116 114 115 114 116 114 113
Bin Frequency Bin Frequency
111 0111 1
112 0112 2
113 0113 5
114 1114 8
8
10
12
Scale A
6
7
8
9
Scale B
115 116 117 116 117 115 116 111 114 115 114
117 116 116 118 117 113 114 115 114 115 116