Question

In: Statistics and Probability

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

Solutions

Expert Solution


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%”?
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...
(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...
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.................
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. ))
What are two examples for normal distributions with numbers and formula?
What are two examples for normal distributions with numbers and formula?
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)....
hello Could I get the answers for Question 5 here's the question: QUESTION5 You are the...
hello Could I get the answers for Question 5 here's the question: QUESTION5 You are the Chief Technology Officer of Vegas Girl's Pizza involved as part of the IT overnance team to provide your opinion and solutions for the following questions Consider the following additional paragraph s and answer the question that follows: Back at his desk, Peter Greyton is thinking of the day's developments. He reflects uporn his meeting with Jim Saxton and Elaine Black. He considers where the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT