Question: hii! can someone please do this ASAP. I need it in excel sheet thank you!! Table Two (20%): A) Calculate a 3-month weighted moving average

hii! can someone please do this ASAP. I need it in

$excel sheet thank you!! Table Two (20\%): A) Calculate a 3-month weighted$

hii! can someone please do this ASAP. I need it in excel sheet thank you!!

Table Two (20\%): A) Calculate a 3-month weighted moving average with weighting of .5, .3, .2, for AprDec of 2021. Calculate the Mean Absolute Deviation, the mean squared error and the mean absolute percent error. B) Calculate a second 3-month Weighted moving average using weights of .8, .15, .05 for Apr-Dec of 2021. Calculate the Mean Absolute Deviation, mean squared error and mean absolute percent error for this method. C) Create a text box beside the table indicating which of the two forecasts might be more accurate and why

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 General Management Questions!

MBA 6300 online Homework Assignment #4 Forecasting Models Instructions: After the student calculates the answers to this homework he/she must submit the answers by placing them in the Assignment # _...

Forecasting Models Scenario: Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several competitors who currently...

Elite Electric is a GTA based company that has been in business for over 30 years. They manufacture a variety of products in the Electrical Supply Industry in Canada and the U.S. Many of their...

Elite Electric - OPM400 Assignment #1 12.5% of Final Mark (Source: Ionex) Elite Electric is a GTA based company that has been in business for over 30 years. They manufacture a variety of products in...

2021 Sales Elite Electric Units Sold Jan 250 Feb 270 Mar 210 Apr 314 May 346 Jun 297 Jul 165 Aug 361 Sep 310 Oct 347 Nov 290 Dec 311 Submit ONE EXCEL Document containing: Your name, section, and...

10. (LO 5) Below are the data for the maximum production of the only two products for the countries of Oz and Zas. Oz: 40 food units OR 20 equipment units Zas: 20 food units OR 30 equipment units a)...

DO it in Excel Spreadsheet please!! ard Font ALT Paragraph 567.1 Styles X 12 34 819 10 11 12 13 14 2021 Sales Energy Storage System Units Sold Jan 315 Feb 390 367 Mar Apr May 418 411 Jun 398 Jul 357...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

Hello! Im a bit confused on the following questions, can someone help me work them out? Thank you in advance! Question 3 20 pts The following are the recent historical sales of iPhone 12 at a local...

Discuss the effectiveness of the following sampling designs: A research company obtains a sample for a focus group through organized groups such as church groups, clubs, and schools. The...

On August 1, 1987, Dori Leeds signed a guarantee of credit with Sun Control Systems, which guaranteed the prompt payment, when due, of every claim of [Sun Control Systems] against [Dori Leeds dba...

Which of the following items might be considered alimony for a divorce executed prior to 2 0 1 9 ? a . Payments made for the 1 2 months period after the death of the recipient spouse b . child...

Consider this example: You have just started college and you are having a discussion with your parents about how your college will be funded. Your parents explain that they have been investing in a...