Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to Analysis

Authors: William R. Wade

4th edition

132296381, 978-0132296380

More Books

Students also viewed these Mathematics questions