Question: help and explanation using an excel sheet please . The Glendale office of statistics believes that the minimum salary of workers in the city is

help and explanation using an excel sheet please .

The Glendale office of statistics believes that the minimum salary of workers in the city is about $120,000. Some students at Glendale Community College believe this claim may be incorrect and surveyed some residents of the city. The results are provided below. At a level of significance of 2%, can we conclude that workers at Glendale make $120,000 annually?

yearly Income140,000

200000

65000

70,000

130,000

475,000

80,000

45,000

120,000

10,000

40,000

85,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!