Question: TABLE #2. Week (t) Time Series Value (Yt) Forecast Error Absolute Deviation Error Square Abs. % error 1 17 2 21 3 19 4 23

TABLE #2.

Week (t)	Time Series Value (Yt)	Forecast	Error	Absolute Deviation	Error Square	Abs. % error
1	17
2	21
3	19
4	23
5	18
6	16
7	20
8	18
9	22
10	20
11	15
12	22

a. Use table #2 above to calculate the Mean Square Error calculation for the exponential smoothing forecast of gasoline sales with smoothing constant .2

NOTE: Show your answers on the table.

b. Based on the table you constructed above, calculate the Mean Absolute Deviation (MAD)

c. Based on the table you constructed above, calculate the Mean Square Error (MSE)

d. Based on the table you constructed above, calculate the Mean Absolute Percent Error (MAPE).

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!

The forecasts generated by two forecasting methods and actual sales have been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop forecast...

Calculate the MAE, MSE, and the MAPE for the example mentioned in the book in table 6.7 ( Section 6.2). The 3 measurements should be calculated as per the Naive method and the Average of the Past...

oft Excel Activity #6: Forecast Accuracy Comparison x 3. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations....

Unlike Softdrink sales, you have no data for 2008, Q1 through Q4. You must create those 4 quarters of forecast. MAE MAPE Time 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Quarter 2004 Q1 2004...

Linear Trend - Multiple Regression The average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below: Month 1999 2000 2001 January...

CLASS9 HW GSB420 Let's consinder a mortgage application using HMDA (The Home Mortgage Disclosure Act). Here is a sample from 30 mortgage applications (excel file is available in D2L) : ID 1 2 3 4 5 6...

As a business analyst in a financial institution, you are asked to analyze Extended Large Credit Europe Operations, Outstanding Debt Quarterly, and Outstanding Debt Annually datasets (see Project-2...

Week Four Homework Assignment - Forecasting Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several...

Set Week Three During this week, we will look at ways of testing multiple (more than two) data samples at the same time. We will continue to use the data and assignment file that we opened in Week 2,...

Use SAS for analysis. Assignment Detail..... I have selected Mayonnaise as the product category for analysis and Metropolitan Chicago as the market. The data set provides information on weekly unit...

Using the following array: [27, -3, 4, 5, 35, 2, 1, -40, 7, 18, 9, -1, 16, 100] Create a Python script called sort_and_search.py Which searching algorithm would be appropriate to use on the given...

Articulate motivations role in consumer behavior and marketing strategy?

Transactions can be grouped into different types or categories of transactions. Match the following transactions with one of the four categories ( Customers , Suppliers, Team, Other ) . a . Bank...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...