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

Expert Solution

orchestra answered 2 years ago

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

(Try to work this question WITHOUT using Excel, get answer by using the formula and show...

(Try to work this question WITHOUT using Excel, get answer by using the formula and show the calculations in detail) Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years...

Two numbers are drawn, each in the range {0,1}. What is the probability that their sum...

Two numbers are drawn, each in the range {0,1}. What is the probability that their sum is less than 1 while their product is greater than 1/5?

This is for an EXCEL formula. Problem 23. Contrast the probability distribution for the value of...

This is for an EXCEL formula. Problem 23. Contrast the probability distribution for the value of the 2 card hand dealt form standard deck of 52 cards. (All Face cards have a value of 10 and the Ace has value of 11). What is the probability of being dealt 21? What is the probability of being dealt 16? Construct a chart for the cumulative distribution function. What is the probability of being a 16 or less? Between 12 and16? Between...

answer needs to be entered by formula not numbers Excel assignment Loan amount $ 67,500 Interest...

answer needs to be entered by formula not numbers Excel assignment Loan amount $ 67,500 Interest rate 7% Loan term 5 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Loan payment:..................... year- beginning balance- total payment- interest paid- principal paid- ending balance 1 2 3 4 5 Total interest paid.................

(EXCEL) On a new sheet called Hello, insert numbers into the range A1: E10. The following...

(EXCEL) On a new sheet called Hello, insert numbers into the range A1: E10. The following code is used to format some data. This code works perfectly well, but it is quite repetitive. Rewrite it by using as many with constructions as make sense. Using appropriate indentation and then run your modified code to make sure it still works. Sub FormatARange() ActiveWorkbook.Worksheets("Hello").Range("B1").Font.Bold = True ActiveWorkbook.Worksheets("Hello").Range("B1").Font.Size = 14 ActiveWorkbook.Worksheets("Hello").Range("B1").Interior.Color = vbYellow ActiveWorkbook.Worksheets("Hello").Range("B1").HorizontalAlignment = xlLeft ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Font.Bold = True ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Font.Italic = True ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Interior.Color...

Use Excel and write formula of Chi square to Find the critical values check your answers...

Use Excel and write formula of Chi square to Find the critical values check your answers with the tables of Chi square Critical Value: 1- χ^2_(.05,25) 2- χ^2_(.01,6) 3- χ^2_(.05,10)

How would you calculate this with an excel formula on excel: •What is the future value...

How would you calculate this with an excel formula on excel: •What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (this is asking you take the future value of the cash flows. Please find the future value at year 4. ))

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

What are two examples for normal distributions with numbers and formula?

Question