Estimation and Hypothesis Testing (a) Use Excel to draw histogram for your sample "Wages (dollar per hours)" data.

(b) Use Excel and your sample data file to produce a suitable output, to test, at the 1% level of significance, the hypothesis that, for Wages (dollar per hours) in the population with mean is 25$.

(c) Is this a one-tailed or two-tailed test? Briefly explain the reasoning behind your answer.

(d) Write, in precise symbolic form, the null and alternative hypotheses.

(e)Define Z or T test and also calculate the value of test statistics.

(f) Define critical values based on the nature of the problem.

(g) State the conclusion based on the sample evidence.

(h) Find 99% confidence interval for the Wages (dollar per hours) in the population.

(I) Reconsider this procedure at the 5% level of significance, the hypothesis that, for Wages (dollarper hours) in the population with mean is greater than 25 $

(J)Make the decision based on the critical value.

(k) Find 95% confidence interval for the Wages (dollar per hours) in the population.

(L)Find precision and also interpret the confidence interval.

\f29 245 16.50 2 38 30 61 19.50 6 34 31 252 30.00 29 32 164 22.50 35 33 23 11.25 6 27 -0 3 30 0-0 0 34 333 16.86 21 35 83 18.30 6 60 36 40 36.60 6 30 37 99 24.00 6 37 38 135 14.40 6 31 39 282 12.39 3 22 40 299 15.00 18 41 300 23.07 3 37 42 74 10.50 6 22 43 375 22.95 4 38 44 155 18.75 6 19 45 170 19.74 42 46 31 26.70 6 33 47 21 17.13 6 34 48 335 14.55 3 32 49 291 10.50 43 50 31 26.70 6 33 51 377 22.50 4 27 52 82 39.78 6 34