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.
CollegesYear 1
Year 2
Year 3
Year 4
Year 5
College 165
67
63
68
70
College 270
75
77
82
75
College 388
95
90
97
98
College 455
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 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?
What will be an ideal response?
a. 
b. College 3 has the highest average pass percentage between years 1 through 5 followed by College 2, College 1, and College 4. This performance has been consistent throughout the five years.
c.
We observe that College 3 is leading in each year consistently.
You might also like to view...
If the risk of a negative outcome is slight, the BEST course of action might be to:
A) Minimize it. B) Share it. C) Transfer it. D) Accept it.
Research shows that job satisfaction has ________ correlation with normative commitment.
A. moderate weak B. weak negative C. moderate D. weak positive E. strong positive
Two airlines offer conveniently scheduled flights to the airport nearest your corporate headquarters. Historically, flights have been scheduled as reflected in this transition matrix.
a. If your last flight was on B, what is the probability your next flight will be on A?
b. If your last flight was on B, what is the probability your second next flight will be on A?
c. What are the steady-state probabilities?
Setting an element's position to relative is done within which of the following?
a)
b)
c)
d)