A. (3 points) Use 3 and 4-month moving average on all the data and plot...

90.2K

Verified Solution

Question

Accounting

image

A. (3 points) Use 3 and 4-month moving average on all the data and plot the averages B. (3 points) Use 3 and 4-month weighted moving average on all the data and plot the the prices. (0.5,0.3,0.2 for 3 month; and 0.4,0.2,0.2, and 0.2 for 4 month) C. (3 points) Compute the forecasts for each month using exponential smoothing, with forecast for January of $2.30. Use a=.1, then a=.3, and finally a=.5. D. (3 points) Compute the forecasts for each month using trend adjusting exponential s an initial forecast for January of $2.30 and trend $0.25. Use =.3, and =.4. E. (3 points) Develop a regression relationship. F. (5 points) Compare forecasting methods using MAD, MSE, and MAPE. HINT: ExcelOM calculates all formulas for you if you just plug in the numbers! Question 1 Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the pas. months were as follows

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students