A boat cost $11,800 and decreases in value by 10% per year. How much will the boat be worth after 8 years?
1 answer:
You might be interested in
Answer:
<em>D. 1 – NORM.DIST(100, 75, 10, TRUE)</em>
Step-by-step explanation:
<u>Excel's Normal Distribution</u>
The normal distribution has two parameters: the mean value and the standard deviation
. Since it's a symmetric function the values at the right side of the center value
The normal distribution is a function which integral cannot be expressed in terms of elemental functions. That is why the cumulative probability is usually found in tables, graphs or any digital media like Excel.
The formula NORM.DIST computes the cumulative values for the left tail or for a given mean and standard deviation. The parameters are
This last parameter tells the formula we want the cumulative left-tail probability or just the value at Xo. This value must be set to TRUE to compute the probability for a range of values, like in the problem at hand.
Since the formula computes the left-tail of the function, we must take advantage of the symmetry of the distribution if we want to compute right-tail values we just subtract the result from 1.
Thus, the correct formula to calculate the required probability is
D. 1 – NORM.DIST(100, 75, 10, TRUE)