Question
Hello can you help me calculate the asnwers to the following problems? I need some help finding the percentage when inputted in excel using the
Hello can you help me calculate the asnwers to the following problems? I need some help finding the percentage when inputted in excel using the NORM.DIST function.
Mean: $35,874.50
Standard Deviation: $14,289.50
New standard deviation: 7144.75 (Just the square root of 4)
For the next 4 cars that are sampled, what is the probability that the price will be less than $500 dollars below the mean? Make sure you interpret your results.
Please note: we are given a new sample size, we will need to calculate a new SD. Then, to find the value that is $500 below the mean you will need to take the mean and subtract $500 from it. For example, if the mean is $15,000 then $500 below this would be $14,500. Thus the probability you would want to find is P(x < 14,500).
For the next 4 cars that are sampled, what is the probability that the price will be higher than $1000 dollars above the mean? Make sure you interpret your results. Use the same logic as above. If your mean is $15,000 then $1,000 above is 15,000 + 1,000 = $16,000. Thus the probability you would want to find is P(x > 16,000).
For the next 4 cars that are sampled, what is the probability that the price will be equal to the mean? Make sure you interpret your results. Use the same logic as above.
For the next 4 cars that are sampled, what is the probability that the price will be $1500 within the mean? Make sure you interpret your results. Use the same logic as above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started