37 69 78 82 90 47 70 79 84 92 54 74 79 85 92 58 76 79 85 92 58 77 79 85 92 64 77 79 87 94 64 78 82 88 97 64 78 82 89 98 (a) (4 pts) Construct a relative frequency distribution with a lower class limit of the first class equal to 30 and a class width of 10. (Type integers for Class and round to three decimal places for Relative Frequency.) Class Relative Frequency 30 40 - - - - (b) (4 pts) Draw a relative frequency histogram of the data. Choose the correct answer below. Be sure to construct the histogram in Excel (two points will be deducted otherwise). Homework Scores 0.4- Relative Frequency 0.2 0-1 30 40 50 60 70 80 90 100 Score OB. Homework Scores a 0.4- Relative Frequency 0.22 8 Trum 0-1 30 41 51 61 71 Score 81 91 100 O C. Homework Scores 0.4 Relative Frequency 0.2 07 30 40 50 60 70 80 90 100 G Score 8m (c) (2 pts) Determine the mean and median homework score. The mean score is and the median score is I (Type integers or round to three decimal places as appropriate.) (d) (1 pt) Describe the shape of the distribution based on the results from parts (b) and (c). Choose the correct answer below. Skewed right Uniform Bell-shaped Skewed left (e) (1 pt) Determine the sample standard deviation. The standard deviation is (Round to two decimal places as needed..) (f) (1 pt) What is the probability a randomly selected student fails the homework (scores less than 70)? The probability is (Simplify your answer to two decimal places.) (g) (3 pt) Using approach presented in class, find the score that represents the 80th percentile. Show your work in Excel and highlight the answer in yellow. 37 69 78 82 90 47 70 79 84 92 54 74 79 85 92 58 76 79 85 92 58 77 79 85 92 64 77 79 87 94 64 78 82 88 97 64 78 82 89 98 (a) (4 pts) Construct a relative frequency distribution with a lower class limit of the first class equal to 30 and a class width of 10. (Type integers for Class and round to three decimal places for Relative Frequency.) Class Relative Frequency 30 40 - - - - (b) (4 pts) Draw a relative frequency histogram of the data. Choose the correct answer below. Be sure to construct the histogram in Excel (two points will be deducted otherwise). Homework Scores 0.4- Relative Frequency 0.2 0-1 30 40 50 60 70 80 90 100 Score OB. Homework Scores a 0.4- Relative Frequency 0.22 8 Trum 0-1 30 41 51 61 71 Score 81 91 100 O C. Homework Scores 0.4 Relative Frequency 0.2 07 30 40 50 60 70 80 90 100 G Score 8m (c) (2 pts) Determine the mean and median homework score. The mean score is and the median score is I (Type integers or round to three decimal places as appropriate.) (d) (1 pt) Describe the shape of the distribution based on the results from parts (b) and (c). Choose the correct answer below. Skewed right Uniform Bell-shaped Skewed left (e) (1 pt) Determine the sample standard deviation. The standard deviation is (Round to two decimal places as needed..) (f) (1 pt) What is the probability a randomly selected student fails the homework (scores less than 70)? The probability is (Simplify your answer to two decimal places.) (g) (3 pt) Using approach presented in class, find the score that represents the 80th percentile. Show your work in Excel and highlight the answer in yellow