A Survey on the Average Pass Percentage Achieved by 4

question 3

Essay

A survey on the average pass percentage achieved by 4 of the top-ranked colleges of a city for 5 different years was conducted to rate the quality of teaching in each of these colleges.

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:

Externalities

Economic side effects or consequences that affect uninvolved third parties; can be either positive or negative.

Social Costs

The total cost of an action or decision, including both private costs and any externalities borne by society at large.

Positive Externality

Positive Externality occurs when a transaction or activity benefits a third party not directly involved, like the societal benefit of education or vaccinations.

External Benefit

A benefit that an individual or firm confers on others without receiving compensation.