THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCELSOFTWARE!
1. Use the following data set to answer the following:
| ew | dbh |
| e | 23.5 |
| e | 43.5 |
| e | 6.6 |
| e | 11.5 |
| e | 17.2 |
| e | 38.7 |
| e | 2.3 |
| e | 31.5 |
| e | 10.5 |
| e | 23.7 |
| e | 13.8 |
| e | 5.2 |
| e | 31.5 |
| e | 22.1 |
| e | 6.7 |
| e | 2.6 |
| e | 6.3 |
| e | 51.1 |
| e | 5.4 |
| e | 9 |
| e | 43 |
| e | 8.7 |
| e | 22.8 |
| e | 2.9 |
| e | 22.3 |
| e | 43.8 |
| e | 48.1 |
| e | 46.5 |
| e | 39.8 |
| e | 10.9 |
| w | 17.2 |
| w | 44.6 |
| w | 44.1 |
| w | 35.5 |
| w | 51 |
| w | 21.6 |
| w | 44.1 |
| w | 11.2 |
| w | 36 |
| w | 42.1 |
| w | 3.2 |
| w | 25.5 |
| w | 36.5 |
| w | 39 |
| w | 25.9 |
| w | 20.8 |
| w | 3.2 |
| w | 57.7 |
| w | 43.3 |
| w | 58 |
| w | 21.7 |
| w | 35.6 |
| w | 30.9 |
| w | 40.6 |
| w | 30.7 |
| w | 35.6 |
| w | 18.2 |
| w | 2.9 |
| w | 20.4 |
| w | 11.4 |
- Make a back to back stemplot (usehttps://www.learner.org/courses/againstallodds/interactives/stemplots.htmlclick \"go\" under \"plot your data mode\" and then click \"back to backdatasets\".
- Make side by side boxplots (usehttp://www.imathas.com/stattools/boxplot.html)
A) Is it appropoiate to use t-procedures to compare the mean DBHof trees in the north half of the tract with the mean DBH of thetrees in the south half. Are conditions met? Check them.
B)Null hypothesis? alternative hypothesis? for comparing the twosamples of tree DBHs? give reasons for your choices.
C) Perform a significance tesr. Report the test statistic, thedregress of freedom, and the p-value.
D) Find 95% confidence interval for the difference mean DBHs.Explain how this interval provides additional information aboutthis problem.
