Question
i just need it present in excel. I really appreciate your help! Q1(11). Upload ONE excel file including your solutions for all parts. For the
i just need it present in excel. I really appreciate your help!
Q1(11). Upload ONE excel file including your solutions for all parts. For the given random sample (excel with data attached) 11.3,8.6,14.8,13.5,9.9,16.8,12.3,15.2,15.7,12,8.9, 14.1,17.8,11.9,13.1,13.7,15.3,11.2,10.7,14.8,14.7, 18.4,13.7,14.6,16.7,16.8,10.1,16.6,14.7,19.7,12.6, 16.3,14.1,19.7,18.7,17.8,19.5,13.6,11.5,17,17.5,14.2, 15.9,9.5,16.6,17.7,15.9,18.3,20.3,14.9 1(6). Calculate 94% t confidence interval for . 2(5). Do a lower one tailed t-test 0:=16,:<16.H0:=16,Ha:<16. request to calculate value of test statistic and P-value, and use =0.01=0.01 to make conclusion.
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