1. Fifty pro-football rookies were rated on a scale of 1 to 5 based on performance at a training camp. A ranking of 1 is a poor prospect and a ranking of 5 is an excellent prospect. Enter the below data into Excel. Construct a relative frequency and a cumulative relative frequency. Rating Frequency
1 4
2 10
3 14
4 18
5 4
A. How many of the rookies received a rating of 4 or better?
B. How many of the rookies received a rating of 2 or worse?
C. What percent received a rating of 5?
D. What percent received a rating of 3 or better?
2. A recent survey asked 5,000 people: "What's most important to you when choosing where to live?" The responses are shown below.
Relative
Response Frequency
Good Jobs 0.25
Affordable Homes 0.15
Good Schools 0.35
Low Crime 0.15
Things to do 0.1
A. Construct the frequency distribution. You have to go backwards using 5,000 people.
B. How many of the people chose good jobs as the most important?
3. The file (Math SAT) can be found in Blackboard. The file contains data on average math SAT scores for each state in the US.
A. Construct a frequency distribution (relative & cumulative) and histogram using the data analysis toolbar. You should use the 4 steps of constructing a histogram.
B. Interpret the relative frequency.