Describing, Exploring, and Comparing Data Using Excel

profilesam001
ADTimeSpentonHomework.xls
Home>Mathematics homework help>Statistics homework help>Describing, Exploring, and Comparing Data Using Excel

Raw Data

Time Spent on Homework in Minutes
46
63
85
99
110
47
91
108
45
61
110
111
73
73
40
56
93
118
125
52
71
125
70
96
103
109
78
89
109
126

Calculated Frequency

Bin Range Frequency
45 31-45 2 Range Frequency
60 46-60 4 0-30 0
75 61-75 6 31-45 2
90 76-90 3 46-60 4
105 91-105 5 61-75 6
120 106-120 7 76-90 3
135 121-135 3 91-105 5
106-120 7
121-135 3
136-150 0
For Paretto Chart
Range Frequency Cumulative Frequency Cumulative % Range Frequency Cumulative %
106-120 7 7 23.33 106-120 7 23.33
61-75 6 13 43.33 61-75 6 43.33
91-105 5 18 60.00 91-105 5 60.00
46-60 4 22 73.33 46-60 4 73.33
76-90 3 25 83.33 76-90 3 83.33
121-135 3 28 93.33 121-135 3 93.33
31-45 2 30 100.00 31-45 2 100.00

Calculated Frequency
Frequency
Frequency Bar Diagram

Frequency Distribution
Frequency
Frequency Pie Chart
Frequency
Frequency Polygon
Frequency
Cumulative %
Time Spent on Homework in Minutes Upper Limits Labels
46 45 31-45
63 60 46-60
85 75 61-75
99 90 76-90
110 105 91-105
47 120 106-120
91 135 121-135
108
45
61
110
111
73
73
40
56
93
118
125
52
71
125
70
96
103
109
78
89
109
126