In: Math
The average number of acres burned by fires in New Mexico County is assumed to be normally distributed with a mean of 9000 and a standard deviation of 695 acres. You are told that the probability of the number of acres burned between 9350-R and 9350+R is .7802. Find R. (Hint: Draw a picture to see the area along with the given probability. Can Goal-Seek or trial and error help you find the value of R?)
How would I solve for R using goal seek in excel
Set the excel formula like this:
1.
2.
3.
4.
Hence R = 959.836806962631
Please upvote. Let me know in the comments if anything is unclear. I will reply ASAP!