MATH 146 Statistics - South Seattle College. Paper 2 Statistics.

MATH 146 Statistics - South Seattle College. Paper 2 Statistics. Refer to the "Tornadoes" data set, which you can find at the Data Sets page. a. Construct a frequency and relative frequency distribution of the values of F scale, including the value of -9. i. b. Create a relative frequency bar graph of F scale. i. c. Which state had the most tornadoes in 2017? Explain how you could figure this out using the data set and technology. i. ii. According to the data above, Texas had the most tornadoes in 2017. iii. Using excel, I did a filter on the column containing each of the states used in the dataset and copied it to another location with only unique records. From there I used the countif to count the total occurrences of each state from the state column. d. Construct a relative frequency histogram of the length of all the tornadoes, using a lower class limit of 0 and a class width of 5. i. e. What is the relative frequency of tornadoes between 5 and 9.999 miles in length? . ii. 212 tornadoes were recorded as being between 5 and 9.999 miles in length. 212 / 1472 (total # of tornadoes) gives a relative frequency of 0.144 2. to the "Best Actress/Actor at the Academy Awards" data set, found at the Data Sets page. a. Construct a relative frequency histogram of the ages of the Best Actress winner, using a lower class limit of 20 and a class width of 5. i. b. What is the shape of the distribution? i. The shape of this distribution is skewed to the right because a large majority of actresses are young. c. What percentage of all Best Actress winners are less than 40 years old? Explain how you computed this. i. 71.4% of all Best Actress winners are less than 40 years old. I computed this value by adding the relative frequencies of the ages 20-39 which came out to be 0.714  0.714 * 100 = 71.4% 3. The following data represent the median household income (in dollars) for the 50 states and the District of Columbia in 2017. a. With the first class having a lower class limit of 40,000 and a class width of 5000, construct a frequency distribution, then construct a frequency histogram. Describe the shape of the distribution.