Using the data file, run descriptive statistics of N. What are mean and standard deviation respectively?...

Transcribed Image Text:

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) 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)