An economist is interested in the variability of hourly wages at a production plant. She collects data

Question:

An economist is interested in the variability of hourly wages at a production plant. She collects data on 50 hourly wage earners.
a. Set up the competing hypotheses to test whether the variance of hourly wages exceeds 35 ($2).
b. Calculate the value of the test statistic.
c. Use Excel's function (CHISQ.DIST.RT or CHISQ.DIST) to calculate the p-value.
d. At the 5% significance level, does the variance of hourly wages exceed 35 ($2)? Explain.