can you show your work how to do these? also, I don\'t understand how to get the
ID: 3261229 • Letter: C
Question
can you show your work how to do these? also, I don't understand how to get the p value. thanks.
Explanation / Answer
Solution
Let xi = weight gained by the ith mouse fed with diet A
Let yi = weight gained by the ith mouse fed with diet B
n is the sample size common to both A and B.
Then, Xbar = sample mean of X and Ybar = sample mean of Y
s12 = sample variance of X and s22 = sample variance of Y.
Let s2 = (s12 + s22)/2
Part (a)(i)
Test statistic: t = (Xbar - Ybar)/s(2/n)
From the given data the following are obtained using Excel Functions
Xbar
9.5
Ybar
12.7
s1^2
149.5556
s2^2
28.9
s^2
89.22778
s
9.446046
t
- 0.7575 ANSWER
Part (a)(ii)
The above t has t-distribution with degrees of freedom = 2(n - 1) = 18.
So, p-value = P(t18 < - 0.7575) = 0.2293 [obtained using Excel Function] ANSWER
Method to find p-value using Excel Function for t-Distribution
In Excel Worksheet, click ‘fX’. Screen displays ‘Insert Function’ In the window ‘Search for a function’ type ‘TDIST’ and click ‘Go’. Under ‘Select a function’, TDIST appears. Click ‘Ok’
Screen displays three windows. Against ‘X’ window, type the mod of calculated value (i.e., without - sign) of the test statistic. Against the ‘Deg_freedom’ type the degrees of freedom and in the other window ‘Tails’ type 1
Required probability, i.e., the p-value, is displayed below the windows against ‘=’ sign.
The above method is illustrated below
tcal
| tcal |
DF
Prob = p-value
-0.7575
0.7575
18
0.229276453
Part (b)
Since p-value is very high, even greater than 10% (i.e., 0.1), we accept the null hypothesis that there is no difference between the mean of gain in weights of the two diets. This => that we fail to reject null hypothesis that diet B shows a greater weight gain
The last option ANSWER
Xbar
9.5
Ybar
12.7
s1^2
149.5556
s2^2
28.9
s^2
89.22778
s
9.446046
t
- 0.7575 ANSWER
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.