Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the data file, run descriptive statistics of N. What are mean and standard deviation respectively? (Hint: Use Data Analysis add-on in excel and
Using the data file, run descriptive statistics of N. What are mean and standard deviation respectively? (Hint: Use "Data Analysis" add-on in excel and select descriptive statistics). a) 100, 11.18 b) 100, 99 c) 100.43, 3.34 d) 100.43, 0.33 Using the data file, what is the probability of N is less than 98? (Hint: you will need to find mean and standard deviation from the descriptive statistics results from the above question before using the NORMDIST command) a) 76.63% b) 2.25% c) 23.37% d) O Using the data file, what is the probability of N is greater than 105? a) 23.37% b) 15.96% c) O d) 8.58% The company wants to find out after how many times handles have been used to lift the bottles, then around 90% of the bottles break? (Hint: You will need to use NORMINV function. Answer needs to round to integers) a) 98 b) 109 c) 105 d) 100 Using the data file, what is the 95% confidence interval? a) (99.00, 102.76) b) (100.43, 109) c) (99.77, 101.09) d) (100.43, 109)
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