Question: Use the trend projection method, and the trend projection with seasonal adjustment method to create forecasting models in Excel. Next, using the two models, compute

Use the trend projection method, and the trend projection with seasonal adjustment method to create forecasting models in Excel.

Next, using the two models, compute the forecasted values of monthly total passengers between 2010 to 2012

Compare the above two models using MAD, MSE, and MAPE

Please explain which of the two models is performing better and why?

Use the trend projection method, and the trend projection with seasonal adjustment method to create forecasting models in Excel. Next, using the two models, Use the best model to forecast the monthly total passengers for year 2013

\begin{tabular}{|c|c|c|c|} \hline Period # & Year & Month & #Passengers \\ \hline 37 & 2013 & Jan & \\ \hline 38 & 2013 & Feb & \\ \hline 39 & 2013 & Mar & \\ \hline 40 & 2013 & Apr & \\ \hline 41 & 2013 & May & \\ \hline 42 & 2013 & Jun & \\ \hline 43 & 2013 & Jul & \\ \hline 44 & 2013 & Aug & \\ \hline 45 & 2013 & Sept & \\ \hline 46 & 2013 & Oct & \\ \hline 47 & 2013 & Nov & \\ \hline 48 & 2013 & Dec & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Period # & Year & Month & #Passengers \\ \hline 37 & 2013 & Jan & \\ \hline 38 & 2013 & Feb & \\ \hline 39 & 2013 & Mar & \\ \hline 40 & 2013 & Apr & \\ \hline 41 & 2013 & May & \\ \hline 42 & 2013 & Jun & \\ \hline 43 & 2013 & Jul & \\ \hline 44 & 2013 & Aug & \\ \hline 45 & 2013 & Sept & \\ \hline 46 & 2013 & Oct & \\ \hline 47 & 2013 & Nov & \\ \hline 48 & 2013 & Dec & \\ \hline \end{tabular}

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 Finance Questions!

Supply Chain Linear Program Problem 1st discription sets up original problem. 2nd discription changes problem with direct sourcing from factories Thank you! Network Design Case Study You work for a...

The \"oligopoly.dta\" attached give quarterly sales of the popular game Oligopoly at the J-Mart variety store. Please use the multiplicative decomposition method to forecast Oligopoly sales for year...

a) Based on the Monthly Sales charts, follow the steps for Forecast Procedure for Seasonal Data Step 1. Identify data pattern and select forecast method. (Approach charting, common sense knowledge,...

Quantitative forecasting methods do not require that patterns from the past will necessarily continue in the future. Select the correct response. O True O FalseThe forecasting method that is...

perform certain calculations discussed in the assigned reading in order to derive an answer for each problem. use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that...

The Indian Institute of Business Management & Studies SUBJECT: Business Administration Marks: 100 CASE - 1 BHEL'S Strategic Intent Bharat Heavy Electricals Ltd (BHEL) is major Indian public sector...

Please answer a) to f). Thank you. (a) Using a four-quarter weighted moving average with weights of 0.5 for the most recent quarter and then 0.25 for the next recent quarter and then 0.15 and 0.1...

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...

CHAPTER 17TIME SERIES ANALYSIS AND FORECASTING MULTIPLE CHOICE 1. Which of the following is not present in a time series? a. seasonality b. operational variations c. trend d. cycles ANS: B PTS: 1...

The three major types of forecasts used by organizations in planning future operations are: A) strategic, tactical, and operational. B) economic, technological, and demand. C) exponential smoothing,...

Assume that a corporate bond has a par value of $1,000 and 15 years until it matures. Also assume that investors require an annual effective rate of return of 12.36% (compounded semi-annually), that...

Calculate the molarity of a solution prepared by dissolving 4.00 g NaOH into 100.0 mL of water. a little more than 4.00 M O 4.00 M O a little less than 1.00 M a little less than 4.00 M O 1.00 M O a...

EXERCISE 7-3. Internet Assignment Go to the financial glossary Investorwords.com at http://www.investorwords.com/ and look up the words "sunk cost" and "opportunity cost." Why is it that sunk costs...

A borrower has taken out a 700,000, 5/1 ARM. The term on this 5/1 ARM is 30 years with monthly payments. The initial rate of 3% is locked in for five years. Calculate the new monthly payment after...

Types of Interpersonal Relationships?

Self-Disclosure and Interpersonal Relationships?

4. Practice listening styles that are less familiar to you. Some people dont paraphrase well; others are uncomfortable being person-centered. The best way to try this out is to look back at the...