A survey on the average pass percentage achieved by four of the top-ranked colleges of a city for five different years was conducted to rate the quality of teaching in each of these colleges. $$\begin{array} { | c | c | c | c | c | c | }
\hline \text { Colleges } & \text { Year 1 } & \text { Year 2 } & \text { Year 3 } & \text { Year 4 } & \text { Year 5 } \
\hline \text { College 1 } & 65 & 67 & 63 & 68 & 70 \
\hline \text { College 2 } & 70 & 75 & 77 & 82 & 75 \
\hline \text { College 3 } & 88 & 95 & 90 & 97 & 98 \
\hline \text { College 4 } & 55 & 57 & 53 & 59 & 55 \
\hline
\end{array}$$
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 years 1 through 5 data. 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?

Question

A survey on the average pass percentage achieved by four of the top-ranked colleges of a city for five different years was conducted to rate the quality of teaching in each of these colleges. $$\begin{array} { | c | c | c | c | c | c | } 
\hline \text { Colleges } & \text { Year 1 } & \text { Year 2 } & \text { Year 3 } & \text { Year 4 } & \text { Year 5 } \
\hline \text { College 1 } & 65 & 67 & 63 & 68 & 70 \
\hline \text { College 2 } & 70 & 75 & 77 & 82 & 75 \
\hline \text { College 3 } & 88 & 95 & 90 & 97 & 98 \
\hline \text { College 4 } & 55 & 57 & 53 & 59 & 55 \
\hline
\end{array}$$ 
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 years 1 through 5 data. 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?

Quizplus · Accepted Answer

The Answer of A survey on the average pass percentage achieved by four of the top-ranked colleges of a city for five different years was conducted to rate the quality of teaching in each of these colleges. $$\begin{array} { | c | c | c | c | c | c | } 
\hline \text { Colleges } & \text { Year 1 } & \text { Year 2 } & \text { Year 3 } & \text { Year 4 } & \text { Year 5 } \
\hline \text { College 1 } & 65 & 67 & 63 & 68 & 70 \
\hline \text { College 2 } & 70 & 75 & 77 & 82 & 75 \
\hline \text { College 3 } & 88 & 95 & 90 & 97 & 98 \
\hline \text { College 4 } & 55 & 57 & 53 & 59 & 55 \
\hline
\end{array}$$ 
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 years 1 through 5 data. 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?

A Survey on the Average Pass Percentage Achieved by Four