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.
Year INM +5 3 4 Returns 14% 28 9 10 Y 18% 29 10 -26 20 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation answers as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance answers to 5 decimal places, e.g., 16161.) Average returns Variances Standard deviations X 8.00 % 17.90 % Y 10,20 % 21.34 %
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%
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.)
Use the following output from a market model regression of the weekly percentage returns on the AIG commodities index on a market index to answer questions a. - f. a. What is the formula for the Commodities Index' characteristic line? b. You forecast a market return of 1.0% for next week. What is next week's expected return for the commodities index? c. What is the correlation between the return on the commodities index and the return on the market Index? d. How much of the variation in the commodities index's returns are explained by the model? e. Based on these regression results, the commodities index would be considered what kind of an investment? f. Does this regression have much explanatory power? Why or why not?
The returns on assets C and D are strongly correlated with a correlation coefficient of 0.80. The variance of returns on C is 0.0009, and the variance of returns on D is 0.0036. What is the covariance of returns on C and D? Give typing answer with explanation and conclusion
Returns for the Alcoff Company over the last 3 years are shown below. What's the standard deviation of the firm's returns? (Hint: This is a sample, not a complete population, so the sample standard deviation formula should be used.) Year Return 2010 21.00% 2009 -12.50% 2008 25.00% a. 20.08% b. 20.59% c. 21.11% d. 21.64% e. 22.18%
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.
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%