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: Zin AI - Your personal assistant for all your inquiries!

Become a Member

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

90.2K

Verified Solution

Question

Statistics

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students

a. Using the Euclidean Algorithm and Extended Euclidean Algorithm, show that gcd(99; 5) = 1 and...

Your task is to create a book ordering form using VISUAL STUDIOS, with the code and...

A couple has a child with cystic fribrosis. They want to know if they both carry the...

What are your specific career goals? What professional skills are needed to get where you want to...

Divide the following numbers in scientific notation a express the result in scientific notation 1...

annually Unless otherwise indicated assume monthly payments are made Unless otherwise indicated assume the interest...

NPV and IRR: Equal Annual Net Cash Inflows Winter Fun Company is evaluating a capital...

Instruction: Genuine Spice Inc. began operations on January 1 of the current year. The company...

(B) Doras Dresses new computerised stock control system has the following features incorporated into the...

What is not a logical operator in R? & ol

Marin Company makes several products, including canoes. The company reports a loss from its canoe...

Brief Hypotheticals: Sole Proprietorships Total points: 3/5 Attempts left: 1 Evelyn decides to open a...

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