https://docs.google.com/spreadsheets/d/1QWaZviKZCaf0qD8KpfnU5CL2faTYkb3UDOFThud3
ID: 3063572 • Letter: H
Question
https://docs.google.com/spreadsheets/d/1QWaZviKZCaf0qD8KpfnU5CL2faTYkb3UDOFThud36EA/copy
Dr. Olsen is a population biologist who has been studying white oak trees in the Appalachian mountains of Pennsylvania for many years. Every year of his study, he has collected seeds (acorns) from two populations of White Oaks. For each year he wants to know if there is a difference in the size of the acorns between the two populations. Here is the data for the 2015 Acorn Study - click the link, it will take you to a Google spreadsheet where you will need to copy the correct year's data to your own spreadsheet in order to calculate the following data:
Q1: What is the mean weight of the acorns from the Riverside site? (this should be a positive value to 3 decimal places).
Q2: What is the mean weight of the acorns from the Ridgeline site? (this should be a positive value to 3 decimal places).
Q3: Using the data from the prior questions, what is the standard deviation (s-value) to 3 decimal places for the acorn weights from oaks at the Riverside site?
Q4: Using the data from the previous questions, what is the standard deviation (s-value) to 3 decimal places for the acorn weights from oaks at the Ridgeline site?
Q5: Using the data from the prior questions, what is the s2 value (variance) to 3 decimal places for the acorn weights from oaks at the Riverside site?
Q6: Using the data from the previous questions, what is the s2 value (variance) to 3 decimal places for the acorn weights from oaks at the Ridgeline site?
Q7: Below is the equation for calculating the t-value we are using in this problem set, how many degrees of freedom are there if we were going to calculate the t value from the data set in Q2?
Q8: Using the formula above with the means and standard deviations that you have calculated for the White Oak data set, calculate the t-value to 3 decimal places.
Q9: Using the degrees of freedom that you have calculated from the White Oaks data, use the t-Table below to determine the closest critical value if we want a 95% confidence level and a two-tailed distribution
Q10: Based on the calculated t-value from the White Oak data and the critical value determined from the t-Table, should you "fail to reject" or "reject" the null hypothesis?
X,-X, ( (N, -1) +(N,-1); N,+N, -2 JN, N,Explanation / Answer
Solution1:
=AVERAGE(A3:A22)
5.685180393
ANSWER
5.685
(TO 3 DECIMALS)
Solution2:
=AVERAGE(B3:B22)
=5.032198857
ANSWER:
5.032
Solution3:
STDDEVA(A3:A22)
0.4473165442
S=.447
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.