A survey on the average pass percentage achieved by four of…

A survey on the average pass percentage achieved by four of the top-ranked colleges in a city for five different years was conducted to rate the quality of teaching in each of these colleges. The following table gives the survey results. Colleges Year 1 Year 2 Year 3 Year 4 Year 5 College 1 65 67 63 68 70 College 2 70 75 77 82 75 College 3 88 95 90 97 98 College 4 55 57 53 59 55 ​ a. Construct a line chart for the time series data for Years 1 through 5 showing the average pass percentage in each college. Show the time series for all four colleges on the same graph. b. What does the line chart indicate about the average pass percentage of the colleges between Years 1 through 5? Discuss. c. Construct a clustered column chart showing average pass percentage in each college using the data for Years 1 through 5. Represent the years along the horizontal axis, and cluster the average pass percentages for the four colleges in each year. Which college is leading in each year?