Answer: 0.6225
Explanation:
$P\left(3,000<X<4,800\right)=0.6225
The mean is μ=4500 and the standard deviation is σ=780. Because the probability between two values is to be calculated, subtract the probability of the lower value from the higher value. In this case, you have to use the NORMDIST function twice.
1. Open Excel and click on any empty cell. Click Insert function, fx.
2. Search for NORMDIST in the search for a function dialog box and click GO.
3. Make sure NORMDIST is on top in select a function. Then click OK.
4. In the function arguments of the NORMDIST function, enter 4800 for X, 4500 for mean, 780 for Standard_dev, and TRUE for Cumulative, all for the higher value of X. Thus, the answer, rounded to four decimal places, is 0.6497.
5. Click on any other empty cell. Click Insert function, fx.
6. Search for NORMDIST in the search for a function dialog box and click GO.
7. Make sure NORMDIST is on top in select a function. Then click OK.
8. In the function arguments of the NORMDIST function, enter 3000 for X, 4500 for mean, 780 for Standard_dev, and TRUE for Cumulative, all for the lower value of X. Thus, the answer, rounded to four decimal places, is 0.0272.
Now subtract: 0.6497−0.0272=0.6225. Thus, the probability that between 3,000 and 4,800 acres will be burned in any given year is 0.6225.