3) According to the Us bureau of labor statistics the following are the averages for the manufacturing industry in the U.S.

Average Annual Payroll $3,250,000

The average number of employees is 64,000

A candidate for government office claims that the Average payroll and average number of employees are actually less than what was claimed in the bureau report. They are using this claim as an incentive to push certain tax incentive laws for the manufacturing industry. The candidate samples 199 manufacturing sectors

Use the Manufacturing hypothesis test excel data( DATA SET MODULE) to perform a hypothesis test to the candidates claim

a) test the average annual payroll 0.05 significance level

State the null and alternate hypothesis

State the conclusion of your test in a complete sentence using the context of the problem

b) test average number of employees at the 0.05 significance level

State the null and alternate hypothesis

State the conclusion of your test in a complete sentence using the context of the problem

Link for this question:

https://docs.google.com/spreadsheets/d/1g8B0M9Jc96-xiRVG--wrtoQ_GsuCgl1jWKrUJTUBpsA/edit?usp=sharing