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 

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

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)