Question

What is the range of Apple’s revenues for next year given their 2019 average sales levels...

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.

Homework Answers

Answer #1

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
On a given Sunday, 14 children were born at a maternity ward. a. On an average,...
On a given Sunday, 14 children were born at a maternity ward. a. On an average, out of these children, how many girls are expected, what is the standard deviation in the number of girls? b. What would be the usual range for the number of girls? c. Given the above, would 9 girls be unusually high? d. What is the probability that at least 10 of the children are girls? Show work/excel commands for binomial dist.
A company’s weighted average cost of capital is 12.1% per year and the market value of...
A company’s weighted average cost of capital is 12.1% per year and the market value of its debt is $70.1 million. The company’s free cash flow last year was $12.3 million and it is expected to grow 30% per year for the next three years. Thereafter, the free cash flow is expected to grow forever at a rate of 6.7% per year. If the company has six million shares of common stock outstanding, what is the value per share? Please...
A market research firm supplies manufacturers with estimates of the retail sales of their products from...
A market research firm supplies manufacturers with estimates of the retail sales of their products from samples of retail stores. Marketing managers are prone to look at the estimate and ignore sampling error. An SRS of 10 10 stores this year shows mean sales of 82 82 units of a small appliance, with a standard deviation of 9.2 9.2 units. During the same point in time last year, an SRS of 14 14 stores had mean sales of 89.82 89.82...
Given the data set A = {5, 4, 6, 14, 2, 2, 11, 4, 5, 8,...
Given the data set A = {5, 4, 6, 14, 2, 2, 11, 4, 5, 8, 3, 1, 12, 15, 13}, which is the data of a sample taken from a larger population. Please Solve NOT Using Excel Calculate the mean deviation Show all work! (5 pts) Mean= 7 MD= (|5-7|+ |4-7|+ |6-7|+|14-7|+|2-7|+|2-7|+|11-7|+| 4-7|+ |5-7|+| 8-7|+| 3-7|+|1-7|+|12-7|+ |15-7|+| 137|)/7              Mean deviation = 4.13 Calculate the variance Show all work! (5 pts) Calculate the standard deviation Show all work! (5...
The home range of an animal is the average area it occupies while foraging for food...
The home range of an animal is the average area it occupies while foraging for food and defending its territory. It is thought that home ranges of animals usually do not change, except when an area is under environmental stress. As part of a study of white-tailed deer in Florida, the deer were fitted with radio collars and their movements were followed over the course of a year. The home range data are shown below, where the range is expressed...
A local pizza place claims that they average a delivery time of 7.32 minutes. To test...
A local pizza place claims that they average a delivery time of 7.32 minutes. To test this claim, you order 11 pizzas over the next month at random times on random days of the week. You calculate the average delivery time and sample standard deviation from the 11 delivery times (minutes), and with the sample mean and sample standard deviation of the time (minutes), you create a 95% confidence interval of (7.648, 9.992). (delivery time is normally distributed) a. What...
The Bureau of Labor Statistics reported that the average yearly income of dentists in the year...
The Bureau of Labor Statistics reported that the average yearly income of dentists in the year 2018 was $110,000. A sample of 81 dentists, which was taken in 2019, showed an average yearly income of $120,000. Assume the standard deviation of the population of dentists in 2019 is $36,000. We want to test to determine if there has been a significant difference in the average yearly income of dentists. Following the steps for hypothesis testing, conduct this hypothesis test at...
A cruise company would like to estimate the average beer consumption to plan its beer inventory...
A cruise company would like to estimate the average beer consumption to plan its beer inventory levels on future​ seven-day cruises.​ (The ship certainly​ doesn't want to run out of beer in the middle of the​ ocean!) The average beer consumption over 20 randomly selected​ seven-day cruises was 81,654 bottles with a sample standard deviation of 4,537 bottles. Complete parts a and b below. a. Construct a 95​% confidence interval to estimate the average beer consumption per cruise. The 95​%...
Please provide the solution in excel. Thank you. Consider investing in your stock and assume that...
Please provide the solution in excel. Thank you. Consider investing in your stock and assume that the daily change is normally distributed. Using your mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have: (how do I do this? It won't let me post the entire history. Here are the first 9 days ) A decrease of 0.5 point or more (X ≤ –0.5)? An increase of more than 0.5 point...
Data given below the questions: Estimate demand for the next month using Holt’s model with alpha...
Data given below the questions: Estimate demand for the next month using Holt’s model with alpha = 0.05 and beta = 0.1. For this model use the level at Period 0 to be Lo=948 and the trend at Period 0 to be To=109 (both are obtained through regression). h.    Evaluate the MAD at n=12. i.    Evaluate the MAPE at n=12. j.    Evaluate the MSE at n=12. k.    Evaluate the bias at n=12. l.    Evaluate the TS at n=12. Copy...