To start with we will make a frequency table and histogram by hand, no Excel formula for this part! 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 data falls into a bin, split the interval (Min - 1, Max + 1] into six sub intervals. The length of cach sub interval will be ((Max + 1) - (Min -1)/6. We call this the bin width. 3) Compute the bin width

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
State
Record High (°F)
To start with we will make a frequency table and histogram by hand, no Excel
formula for this part!
Legend
Alabama
112
If a cell is shaded
You should
Alaska
100
Blue
Enter a text response
Arizona
128
1) Sort the data by temperature.
Green
Enter a number
Arkansas
120
2) Find the range of the data. Range Max Min
Gold
Enter an Excel formula
California
134
Any other color
Make no changes
Split the data up into 6 equal length bins. To make sure that all of the data falls into a bin, split
the interval (Min - 1, Max + 1] into six sub intervals. The length of each sub interval will be
((Max + 1) - (Min -1))/6. We call this the bin width.
Colorado
118
Connecticut
106
Delaware
110
Florida
109
3) Compute the bin width
Georgia
112
4) Complete the following table.
Hawaii
100
Bin
Low
High
Frequency
Relative Frequency
Idaho
118
1
Illinois
117
2
Indiana
116
Iowa
118
4
Kansas
121
Kentucky
114
Hint: Highlight the sorted data in the table so that the color of the data matches the color of the
bin. This provides a visual representation of the bins. Then use this to easily fill out the table. You
may use an Excel formula for the relative frequency.
Louisiana
114
Maine
105
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
109
107
Relative Frequency = Frequency/Total
112
5) Create a hand generated relative frequency histogram where each bar is color coded to match
your chosen colors above. Make sure to add the labels and the counts.
114
115
118
20
Montana
Nebraska
Nevada
117
19
118
18
125
17
New Hampshire
New Jersey
New Mexico
New York
106
16
110
15
122
14
108
13
North Carolina
North Dakota
110
12
121
11
Ohio
113
10
Oklahoma
120
9
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
119
8
111
7
104
6.
113
120
4
Tennessee
113
3
Теxas
120
Utah
117
1
Vermont
105
Virginia
Washington
West Virginia
110
118
112
Wisconsin
114
Wyoming
115
Transcribed Image Text:State Record High (°F) To start with we will make a frequency table and histogram by hand, no Excel formula for this part! Legend Alabama 112 If a cell is shaded You should Alaska 100 Blue Enter a text response Arizona 128 1) Sort the data by temperature. Green Enter a number Arkansas 120 2) Find the range of the data. Range Max Min Gold Enter an Excel formula California 134 Any other color Make no changes Split the data up into 6 equal length bins. To make sure that all of the data falls into a bin, split the interval (Min - 1, Max + 1] into six sub intervals. The length of each sub interval will be ((Max + 1) - (Min -1))/6. We call this the bin width. Colorado 118 Connecticut 106 Delaware 110 Florida 109 3) Compute the bin width Georgia 112 4) Complete the following table. Hawaii 100 Bin Low High Frequency Relative Frequency Idaho 118 1 Illinois 117 2 Indiana 116 Iowa 118 4 Kansas 121 Kentucky 114 Hint: Highlight the sorted data in the table so that the color of the data matches the color of the bin. This provides a visual representation of the bins. Then use this to easily fill out the table. You may use an Excel formula for the relative frequency. Louisiana 114 Maine 105 Maryland Massachusetts Michigan Minnesota Mississippi Missouri 109 107 Relative Frequency = Frequency/Total 112 5) Create a hand generated relative frequency histogram where each bar is color coded to match your chosen colors above. Make sure to add the labels and the counts. 114 115 118 20 Montana Nebraska Nevada 117 19 118 18 125 17 New Hampshire New Jersey New Mexico New York 106 16 110 15 122 14 108 13 North Carolina North Dakota 110 12 121 11 Ohio 113 10 Oklahoma 120 9 Oregon Pennsylvania Rhode Island South Carolina South Dakota 119 8 111 7 104 6. 113 120 4 Tennessee 113 3 Теxas 120 Utah 117 1 Vermont 105 Virginia Washington West Virginia 110 118 112 Wisconsin 114 Wyoming 115
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Frequency Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON