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%”?

Expert Solution

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

X ~ Normal(1.495, 0.05²)

Excel formula :

orchestra answered 1 year ago

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%”?

Please solve all answers on Excel and show step by step how you get the WACC...

Please solve all answers on Excel and show step by step how you get the WACC answer. Tornado Motors is a major producer of sport and utility trucks. It is a family owned company, started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B ) and a larger, heavy-duty work truck (Model C)....

The correct answers are already bolded, but please show your work/explain how you get the answer....

The correct answers are already bolded, but please show your work/explain how you get the answer. 1. Rick can cut 6 pieces of wood or catch 6 fish per day. Timmy can cut 9 pieces of wood or catch 18 fish per day. Which one of the following points is not on the Timmy’s production possibility frontier fish is on the horizontal axis and pieces of wood is on the vertical axis? a. (0, 9) b. (18, 0) c. (8,...

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

Use Excel to show your work and include the formula in the cell to show how...

Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...

what is the formula in excel to get probability answers on range of numbers - Question:...

what is the formula in excel to get probability answers on range of numbers - Question: mean number is 10.3 per day standard deviation is 2.25 per day for any day what is the probability that the number of customers returning items is between 12 and 14 I don't know how to write the equation to obtain P

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 show your work and formula on excel You are now 25 years old. You would...

please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

Show your numerical answer(s) and the Excel function(s) and inputs you used to get the answer. You...

Show your numerical answer(s) and the Excel function(s) and inputs you used to get the answer. You may use up to 25 words (50 for #4) to supplement your numbers, tables and Excel functions. 1. State Retirement Funding (5 points – 1 page with table, functions and 25 words) A state retirement plan has been frozen. It is considered fully-funded, with $635,244,352.26 of assets on hand and makes payouts to 1,000 recipients. It assumes it will earn 7.5% per year on these assets. The...

please show your work and formula on excel You can afford to pay $375 monthly car...

please show your work and formula on excel You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000?

Question