Question

In a city with three high schools, all the ninth graders took a Standardized Test, with these results:High Scool Mean Score test Number of ninth gradeGlenwood 79 285Central city 94 336Lincoln High 72 191The city's PR manager, who never took statistics, claimed the mean score of all ninth graders in the city was 81.7 . Of course, that is incorrect. What is the mean score for all ninth graders in the city? USE EXCEL. Round your answer to one decimal place.

Answer 1

Answer: 83.56

Step-by-step explanation:

To calculate the mean score for all ninth graders in the city, we multiply the mean score test for each school by the number of months grade students and then add all together and divide by the total ninth grade students. This is solved below.

Mean = [(79 × 285) + (94 × 336) + (72 × 191)]/285+336+191

= (22515+31584+13752)/812

= 67851/812

= 83.56