THIS PROBLEM NEEDS TO BE SOLVED ONLY USING EXCEL SOFTWARE! 1. Use the following data set to...

90.2K

Verified Solution

Question

Statistics

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.

Answer & Explanation Solved by verified expert

3.7 Ratings (602 Votes)

Data and descriptive statistics North dbh South dbh1 n 235 s 172 n 435 s 446 n 66 s 441 n 115 s 355 n 172 s 51 n 387 s 216 n 23 s 441 n 315 s 112 n 105 s 36 n 237 s 421 n 138 s 32 n 52 s 255 n 315 s 365 n 221 s 39 n 67 s 259 n 26 s 208 n 63 s 32 n 511 s 577 n 54 s See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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