What is the range of Apple’s revenues for next year given their 2019 average sales levels of of 260.17 billion and a standard deviation of revenue’s over the last 5 years of 11. Calculate this range at a 95% outcome level.
Show your work in Excel please. Thank you.
In a normal distribution, 95% of the values will lie within 1.96 standard deviations of the mean.
Upper range of revenues = average revenues + (1.96 * standard deviation of revenues)
Lower range of revenues = average revenues - (1.96 * standard deviation of revenues)
Upper range of revenues = $281.73 billion
Lower range of revenues = $238.61 billion
Get Answers For Free
Most questions answered within 1 hours.