Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A B C D E F G 1 One sample t test 2 3 Subject Weight Loss count 12 =COUNT(B4:815) 4 1 23 mean 4.666667
A B C D E F G 1 One sample t test 2 3 Subject Weight Loss count 12 =COUNT(B4:815) 4 1 23 mean 4.666667 =AVERAGE(B4:B15) 5 2 15 std dev 11.15456 =STDEV.S(B4:815) 6 3 -5 std err 3.220045 =E5/SQRT(E3) 7 4 7 8 5 1 hyp mean 0 LO 6 -10 O 0.05 10 7 12 tails 1 11 8 -8 df 11 =E3-1 12 9 20 t stat 1.449255 =(E4-E8)/E6 13 10 8 p value 0.087585 =T.DIST.RT(E12,E11) 14 11 -2 t crit 1.795885 =T.INV(1-E9,E11) 15 12 -5 sig no =IF(E13
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started