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:

Transactions

Financial activities that involve the exchange of assets, provision of services, or other business activities that affect a company's financial position.

Debit And Credit

In accounting, debit and credit are entries that record changes in value to accounts, where debits increase asset or expense accounts and decrease liability, equity, and revenue accounts.

Increase And Decrease

General terms referring to the upward or downward movement in value, quantity, or level of something over time.

Compound Journal Entry

An accounting journal entry that involves more than two accounts, where there is at least one debit and two or more credits, or vice versa.