# Must show all Excel work, answer all parts of the

Must show all Excel work, answer all parts of the question, and write necessary explanations to earn full points. You have to use Excel to solve this numerical problem (project).

The following table gives monthly data for four years in million tons of consumption of ice cream in a country. Plot the series and comment on the visible seasonality and trend. Estimate the centered moving averages for this monthly series. Plot CMA and comment. Next, estimate the S,I component which only includes seasonal and irregular movements of the series. Then find the seasonal indexes for the twelve months removing the irregular component. Find the de-seasonalized levels for the series. Plot De-seasonalized Y and comment. Then estimate the trend values for the four sample years and the 12 months of the year 2015 using linear regression. Finally, make the forecast for the 12 months of 2015 using the Ratio-to-Moving Average method to capture the Trend and Seasonal patterns, using Excel. Plot the forecasted values for the 60 periods including 12 months of the year 2015. Plot the errors for in-sample periods and calculate RMSE. Comment on the error plot with respect to the existence of pattern or lack of visible pattern.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Phase II: Company Profile and Industry Overview Company Profile This is an

Phase II: Company Profile and Industry Overview Company Profile This is an overview of your organization including who is involved and the scope of what

### you will analyze asymmetric and symmetric encryption. Evaluate the differences between the two of them and which one that you

you will analyze asymmetric and symmetric encryption. Evaluate the differences between the two of them and which one that you would determine is the most

### Memo: Choose one of the two options below and write

Memo: Choose one of the two options below and write a brief (one page) memo addressing the described audience; make sure to include a

### Watch the Excel remediation video, Hypothesis Testing. An optional supplementary textbook

Watch the Excel remediation video, Hypothesis Testing. An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there. Use the lab

### As a Family Nurse Practitioner, you are assigned to analyze

As a Family Nurse Practitioner, you are assigned to analyze a case study on Acute Sinusitis in a 10 years old boy.  1. Provide

### Respond to the following question:  As part of the financial planning

Respond to the following question:  As part of the financial planning process, a common practice in the corporate finance world is restructuring through the process

The Cano article, in your Learning Resources, links diversity among and within organizations with the ability to successfully serve communities and advocate for social change

### I have the introduction part of the Mobile Spyware essay,

I have the introduction part of the Mobile Spyware essay, and I want to write the 3-page literature study section of the essay (where it

### Assignment: Peter S. Yung began working for Rio Rojo Publishing,

Assignment:  Peter S. Yung began working for Rio Rojo Publishing, Inc. pursuant to the agreement linked below. Rio Rojo is a publisher of industrial manuals

Instructions For this week’s assignment, you will present your answers to the following questions in a formal paper format. Please separate each question with a

### Sales Classification Assignment Background Universal Control Corp, is a leading

Sales Classification Assignment Background Universal Control Corp, is a leading supplier for process control systems and equipment used by a wide variety of production and

### Discuss briefly the process of transition for a student who

Discuss briefly the process of transition for a student who is approaching transition age.  What must the educational system do for planning for this student5t?

New questions