A.

The U.S. Bureau of Labor Statistics reports that 10% of U.S. workers belong to unions. Suppose a sample of 400 U.S. workers is collected in 2014 to determine whether union efforts to organize have increased union membership.The sample results show that 41of the workers belonged to unions.

Compute the p-value.

B. The U.S. Bureau of Labor Statistics reports that 11.3% of U.S. workers belong to unions. Suppose a sample of 400 U.S. workers is collected in 2014 to determine whether union efforts to organize have increased union membership at 0.025level of significance.The sample results in a test statistic (z) of 2.1.

We conclude thatunion membership increased in 2014.(Enter 1if the conclusionis correct. Enter 0 otherwise.)

C.

The mean annual premium for automobile insurance in the United State is $1100. You would like to test whether automobile insurance is cheaper in the state of Texas. Data are collected on automobile insurance premiums in Texas. At =0.1, test this hypothesis using the excel tool t-test. State your conclusion in the excel file. Upload your excel file.