Question

In: Statistics and Probability

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...

Please use Excel and show the formula you used. Thank you :)

A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Solutions

Expert Solution

Let X denotes the diameter of a randomly selected connecting rod.

X ~ Normal(1.495, 0.052)

Excel command to get P(Z <=a), NORMINV(a,0,1)

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and...
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2015 $ 106 $ 5 2016 101 5 2017 89 5 2018 94 5 An investor buys three shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all four remaining shares at the beginning...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
**Can u show the steps and formula used for each question please and thank you! Super...
**Can u show the steps and formula used for each question please and thank you! Super Sales Company is the exclusive distributor for a high-quality knapsack. The product sells for $120 per unit and has a CM ratio of 25%. The company’s fixed expenses are $405,000 per year. The company plans to sell 14,000 knapsacks this year. 1. What are the variable expenses per unit? 2. Use the equation method for the following: a. What is the break-even point in...
Please show the calculation process in Excel, thank you With the gasoline time series data from...
Please show the calculation process in Excel, thank you With the gasoline time series data from Table 8.1, show the exponential smoothing forecasts using α=0.1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of α=0.1 or α=0.2 for the gasoline sales time series? Are the results the same if you apply MAE as the measure of accuracy? What are the results if MAPE is used? Week Sales (1000s of gallons) 1 17 2 21 3...
Please use excel then show the formula. and screenshot 6. Assume that you want to buy...
Please use excel then show the formula. and screenshot 6. Assume that you want to buy a home. You find a home for which you will owe $140,000 after paying the down payment. Assume that you are able to get a 5% mortgage loan for 30 years. Payments are made monthly in arrears (at the end of the month). At the end of the 30 years, you will have paid off the entire loan. A) How much will your monthly...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT