Part 3: 1. In the Excel file, "Part 3" worksheet, the annual incomes of 30 hospital employees. The incomes are reported as number of thousand dollars (ex $55,000 = "55"). The

incomes are to be rearranged in the following intervals: Less than 41 41 - 60 61-75 76-99 100 and more a. Using the provided intervals, construct a frequency distribution to display these data. Add a column to the table to give the percentages, cumulative frequencies, and cumulative percentages. b. What are the midpoints for each interval? c. What are the real limits for the stated limits provided for the intervals? d. Construct a histogram to display the frequency distribution of the annual incomes. e. Write a paragraph to interpret your findings.