a. Plot the monthly data. b. Forecast September sales volume using the following: 1) A linear regression 2) A 6-month moving average 3) Exponential smoothing with a smoothing constant equal to 0.20 and assuming a March forecast of 600,000. 4) The naïve approach 5) A weighted average using 0.7 for Dec, 0.2 for November and 0.1 for October. 6) Correlation Which mothod in hl the MOST appropriate method to be used? Why?

a. Plot the monthly data. b. Forecast September sales volume using the following: 1) A linear regression 2) A 6-month moving average 3) Exponential smoothing with a smoothing constant equal to 0.20 and assuming a March forecast of 600,000. 4) The naïve approach 5) A weighted average using 0.7 for Dec, 0.2 for November and 0.1 for October. 6) Correlation Which mothod in hl the MOST appropriate method to be used? Why?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

. Using 625 trading days of data, you estimated the daily log return follows a normal distribution with a mean of 5 bps and and a stdev of 125 bps. Q1a. based on information above, what is the probability of true daily log return average is 0? can you reject the true mean is 0? can you reject the true mean is 10 bps? Q1b. what is the 90, 95, and 99% confidence interval for your mean return estimate? Q1c. what is the mean log return and stdev of log return over one year period and four year period (assuming 252 trading days per year)? Q1d. based on Q1c what is the probably of losing money (negative log return) or doubling your money (total log return = ln(2)) over 1 year and 4 year period?
We have 50 years of annual data on (detrended) ex post prices P∗ t and on (detrended) actual stock prices Pt . We find that the sample variances (svar) are as follows: svar(P∗ t ) = 120 and svar(Pt) = 80. What does this tell us and why?
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year Returns X Y 1 9% 23% 2 27 44 3 16 -6 4 -17 -20 5 18 52 Calculate the arithmetic average return for X. Calculate the arithmetic average return for Y.
Use the following returns for X and Y. Year 1 2 3 4 5 Returns X 22.1% -17.1 10.1 20.2 5.1 Y 27.3% -4.1 29.3 -15.2 33.3 a. Calculate the average returns for X and Y. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. b. Calculate the variances for X and Y. Note: Do not round intermediate calculations and round your answers to 6 decimal places, e.g., .161616. c. Calculate the standard deviations for X and Y. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. X Answer is complete but not entirely correct. X 8.06 a. Average return b. Variance c. Standard deviation 136.454400 % 11.67 X % Y 14.04 377.286400 x % 19.42%
Macro Corporation has had the following returns for the past three years: -10 percent, 10 percent, and 30 percent. Use the following formulas to calculate the standard deviation of the returns: Multiple Choice 10.00 percent 16.33 percent 18.21 percent 30.00 percent
Use the following returns for X and Y. Returns Year x y 1 21.8% 26.4% 2 -16.8 -3.8 3 9.8 28.4 4 19.6 -14.6 5 4.8 32.4 a. Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.) c. Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
please show steps in excel
10. Given the data below, what is the simple linear regression model that can be used to predict sales in future weeks? Week 1 3 4 5 Sales 150 157 162 166 177
4. The sales manager of a company projected the following sales for next year with the following probabilities: Scenario Sales (in Millions) Probability 0.10 1 20 2 0.30 18 0.30 15 4 0.30 14 Find the (a) variance and (b) standard deviation
There is a probability of 0.53 that there will be extremely cold weather this coming Winter. If it does, we expect investors of Star & Bucks to achieve a return of 0.15. Else, investors may expect a lower return of 0.07. Can you estimate the variance of this rate of return? (In Excel with Formulas) Please answer fast i give you upvote.
Megaworld Corporation has the following returns for the past three years: 7 percent, 13 percent, and 10 percent. Use the following formulas to calculate the variance of the returns and the standard deviation of the returns: Variance (m) = expected value of (m-rm)² Standard deviation of m = √variance(rm). 30.00 and 10.00% 124.00 and 11.10% 64.00 and 8.00% 6.00 and 2.45%
4. Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year 1 2 3 4 5 X 12% 28% 9% -7% 10% Return Y 25% 34% 13% -27% 14%