Question: Please create the following models using the data below: Two-period moving average Five-period moving average Two-period weighted moving average using weights of .8 and .2

Please create the following models using the data below: Two-period moving average Five-period moving average Two-period weighted moving average using weights of .8 and .2 Five-period weighted moving average using weights of .33, .27, .2, .13, .07

Please do the models for both the daily data and aggregated monthly data.

Assess each model using the MAPE method and let me know which model works best for both the daily and monthly aggregations. Also let me know whether we got a more accurate prediction using the daily or monthly version.

https://kennesaw.view.usg.edu/d2l/common/viewFile.d2lfile/Database/MTE1NjMyMTIy/Extra%20Credit%20Assignment.xlsx?ou=2514594

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Description: A Chinese pharmaceutical company supplies its most popular drug to its sole distributor in Hong Kong on a monthly basis. Shipments usually take 6 - 8 weeks and contractual agreements are...

Forecasting Group Assignment Description: A Chinese pharmaceutical company supplies its most popular drug to its sole distributor in Hong Kong on a monthly basis. Shipments usually take 6 - 8 weeks...

( 2 pts ) Using the provided data set, compute the Na ve , Two - period Moving Average, Three - period Moving Average, Two - period Weighted Moving Average with weights ( 0 . 6 , 0 . 4 ) , Three -...

Problem 1. (10 points) A manager recorded the number of gallons of ice cream sold for the past six periods. He asked you to choose a forecasting model to predict the demand for gallons of ice cream...

please help with all questions For all the problems, to receive full score, you must show your complete and accurate work, i.e., show how you calculated the numbers you use. If you only provide the...

help with all please For all the problems, to receive full score, you must show your complete and accurate work, i.e., show how you calculated the numbers you use. If you only provide the final...

Please show the formulas that i may put into microsoft excel i must show my professor the formulas in the cells on excel below. Styles Cells Inactive. lo use for free, sign in and use the Web...

I need to know the equations that were used to solve this Please Click on the Data Sheet in the next tab. Using the provided data, compute the following 4 tasks: 1- Compute forecasting for that data...

4.1 The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks Week or Pints Used August 31 360 September 7 389 September 14 410 September 21 381 September...

Click on the Data Sheet in the next tab. Using the provided data, compute the following 4 tasks: 1- Compute forecasting for that data using 4 methods: a- Simple moving average with n= 2 b- Weighted...

You work in the capital gains tax section of the tax division of an accounting firm. You had a meeting with your client, Brad Ferguson on 4 July 2021, who provided you with the following information....

(a) You are required to explain and discuss the alternative methods of accounting for normal and abnormal spoilage. (b) Weston Harvey Ltd assembles and finishes trapfoils from bought-in components...

What was the approximate delinquency rate in a typical year prior to the 2 0 0 8 - 2 0 0 9 recession?

Explain the aspects needed to create a usable and successful HRM plan.

2. In this chapter, the reader should reflect on the following concepts: Systemic structuring, the displaced error, the communicable part of knowl-edge, tacit knowledge, hidden knowledge, analogy,...

2. List five points that are crucial to pay attention to if you want to positively influence someone from a foreign culture.

1. Discuss what you think is meant by the following statements: a) Splitting an egg into half to get two chickens. b) We cannot study time by taking apart a clock.