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
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...
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdbcb995e-87c5-4465-8fc4-a938a6f5dc8f%2F4045cdbb-ef02-4953-8519-01c01e5fed73%2Fa8d2p6_processed.jpeg&w=3840&q=75)
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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps

Knowledge Booster
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.Recommended textbooks for you

A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON


A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
