Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Analysis

Authors: Richard L. Burden, J. Douglas Faires

9th edition

538733519, 978-1133169338, 1133169333, 978-0538733519

More Books

Students also viewed these Mathematics questions

Question

Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago