An engine has a normally distributed horsepower output with mean 5,000 hp and standard deviation of 50 hp. Find a lower specification (find x) limit such that only 0.5% of the engines will not exceed this limit 

homework 55

-Please complete the first question on excel

-Question 2-3-4 can be completed on a piece of paper, then take a picture (or scan it or do it on MS Word) of the solutions and submit it along with the excel file (question 1)

1-) “SEMO” is producing “metal washer” that will have to fit into a slot in an assembly. The dimensions are given as below (in millimeters). Assume that you are hired as a manufacturer engineer and company SEMO is requesting following items from you

Please build a histogram in excel and interpret it (25pts)

Sample x
1 28 42 54 46 64 54
2 33 36 28 75 63 48
3 36 38 36 37 62 61
4 34 45 47 37 62 48
5 54 45 75 55 18 85

2-) An engine has a normally distributed horsepower output with mean 5,000 hp and standard deviation of 50 hp. Find a lower specification (find x) limit such that only 0.5% of the engines will not exceed this limit (35pts)

3-) The average IQ score for an engineering class is 100, with a standard deviation of 15. What percentage of this class is expect to have an IQ between 90 and 120? Also, draw the normal curve and shade the area (25pts)

4-) The time to complete an order is given as {96,104,102,108,128,126,156,150}-(15pts)

A) Calcalate the sample average (4pts)

B) Calculate the sample standard deviation (8pts)

C) Calculate the sample variance (3pts)

“Get 15% discount on your first 3 orders with us”
Use the following coupon
FIRST15

Order Now

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *