MAT 144 GCU Sort the Data by Temperature Worksheet

Check out this video of me explaining the DQ:

https://youtu.be/cA-TUW9kFxc

State
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
To start with we will make a frequency table and histogram by ha
formula for this part!
Record High (°F)
112
100
128
120
134
118
106
110
109
112
100
118
117
116
118
121
114
114
105
109
107
112
114
115
118
117
118
125
106
110
122
108
110
121
113
120
119
111
104
113
120
113
120
117
105
1) Sort the data by temperature.
2) Find the range of the data. Range = Max – Min
Split the data up into 6 equal length bins. To make sure that all of the da
bin, split the interval (Min – 1, Max + 1] into six sub intervals. The length
interval will be ((Max + 1) – (Min -1))/6. We call this the bin width.
3) Compute the bin width
4) Complete the following table.
Bin
Low
High
1
2
3
4
5
6
Hint: Highlight the sorted data in the table so that the color of the data m
color of the bin. This provides a visual representation of the bins. Then us
fill out the table. You may use an Excel formula for the relative frequency
Relative Frequency = Frequency/Total
5) Create a hand generated relative frequency histogram where each bar is
match your chosen colors above. Make sure to add the labels and the cou
20
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
Virginia
Washington
West Virginia
Wisconsin
Wyoming
110
118
112
114
115
ncy table and histogram by hand, no Excel
ns. To make sure that all of the data falls into a
] into six sub intervals. The length of each sub
. We call this the bin width.
Frequency
Relative Frequency
ble so that the color of the data matches the
presentation of the bins. Then use this to easily
ormula for the relative frequency.
Frequency/Total
ncy histogram where each bar is color coded to
sure to add the labels and the counts.
Legend
If a cell is shaded
You should
Blue
Enter a text response
Green
Enter a number
Gold
Enter an Excel formula
Any other color
Make no changes
State
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Record High (°F)
112
100
128
120
134
118
106
110
109
112
100
118
117
116
118
121
114
114
105
109
107
112
114
115
118
117
118
125
106
110
122
108
110
121
113
120
119
111
104
113
120
113
120
117
105
Now repeat the first part, but using Excel formulas and ch
1) Find the range of the data. Range = Max – Min
We want to split the data up into 6 equal length bins. To make sure that a
falls into a bin we will split the interval [Min – 1, Max + 1) into six sub inte
of each sub interval will be ((Max + 1) – (Min -1))/6 rounded to one decim
the bin width.
2) Compute the bin width
3) Complete the following table.
Bin
Low
High
1
2
3
4
5
6
Hint: Highlight the sorted data in the table so that the color of the data m
color of the bin. This provides a visual representation of the bins. Then us
fill out the table. You may use an Excel formula for the relative frequency
Relative Frequency = Frequency/Total
4)
Create a histogram using the Excel (clustered) column chart (2D or 3D).
Virginia
Washington
West Virginia
Wisconsin
Wyoming
110
118
112
114
115
but using Excel formulas and charts.
l length bins. To make sure that all of the data
Min – 1, Max + 1) into six sub intervals. The length
Min -1))/6 rounded to one decimal. We call this
Frequency
Relative Frequency
ble so that the color of the data matches the
presentation of the bins. Then use this to easily
ormula for the relative frequency.
Frequency/Total
ered) column chart (2D or 3D).
Legend
If a cell is shaded
You should
Blue
Enter a text response
Green
Enter a number
Gold
Enter an Excel formula
Any other color
Make no changes