Question: Using the data for hospitals and schools (AMP_graph_public.csv): Create a table for hospitals and schools, showing the mean management score and criteria score (monitoring, targets,
Using the data for hospitals and schools (AMP_graph_public.csv): Create a table for hospitals and schools, showing the mean management score and criteria score (monitoring, targets, incentives) for each country, as in Figure 6.2a. (Hint: You may find it helpful to use Excels PivotTable optionsee Excel walk-through 3.1.) Make separate bar charts for hospitals and schools showing the mean overall management score for each country, sorted from highest to lowest, as in Figure 6.1. Are the country rankings similar to those in manufacturing? Using your average criteria scores from Question 5(a), suggest some explanations for the observed rankings in either hospitals or schools. (You may find it helpful to research healthcare or educational policies and reforms in those countries to support your explanations.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
