A Survey on the Average Pass Percentage Achieved by Four

question 34

Essay

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?

---

Definitions:

Generating Solutions

The process of coming up with multiple answers or ways to address problems or challenges.

Practical Solution

A viable and straightforward answer or method to resolve a problem or address a situation, often emphasizing effectiveness and simplicity.

Ridiculous Alternatives

A technique used in problem-solving or therapeutic contexts to spur creativity by considering seemingly absurd or impractical options.

Allostasis

The process by which the body responds to stressors by changing its physiological parameters to maintain homeostasis.