Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to deseasonalized data in excel

27/11/2021 Client: muhammad11 Deadline: 2 Day

4. In a time-series decomposition of sales (in millions of units), the following trend has been estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for quarters 1, 2, 3, and 4, respectively. Use these actual sales figures along with your forecasts to calculate the root-mean-squared error for the forecast period.

5. A tanning parlor located in a major shopping center near a large New England city has the following history of customers over the last four years (data are in hundreds of customers):

a. Construct a table in which you show the actual data (given in the table), the centered moving average, the centered moving-average trend, the seasonal factors, and the cycle factors for every quarter for which they can be calculated in years 1 through 4.

b. Determine the seasonal index for each quarter.

c. Do the best you can to project the cycle factor through 2008.

d. Make a forecast for each quarter of 2008.

e. The actual numbers of customers served per quarter in 2008 were 6.8, 5.1, 4.7, and 6.5 for quarters 1 through 4, respectively (numbers are in hundreds). Calculate the

RMSE for 2008.

f. Prepare a time-series plot of the actual data, the centered moving averages, the long-term trend, and the values predicted by your model for 2004 through 2008 (where data are available).

8. Kim Brite and Larry Short have developed a series of exclusive mobile-home parks in which each unit occupies a site at least 100  150 feet. Each site is well landscaped to provide privacy and a pleasant living environment. Kim and Larry are considering opening more such facilities, but to help manage their cash flow they need better forecasts of mobile-home shipments (MHS), since MHS appears to influence their vacancy rates and the rate at which they can fill newly opened parks. They have 16 years of data on mobile-home shipments, beginning with 1988Q1 and ending with 2003Q4, as shown:

Assuming that Kim Brite and Larry Short have hired you as a forecasting consultant:

a. Provide a time-series plot of the actual MHS data along with the deseasonalized data. Write a brief memo in which you report the nature and extent of the seasonality in the data. Include seasonal indices in your report.

b. Develop a long-term linear trend for the data, based on the centered moving averages. Let time equal 1 for 1988Q1 in your trend equation. On the basis of this trend, does the future look promising for Brite and Short?

c. One of the things Ms. Brite and Mr. Short are concerned about is the degree to which MHS is subject to cyclical fluctuations. Calculate cycle factors and plot them in a time-series graph, including projections of the cycle factor through 2004. In evaluating the cycle factor, see whether interest rates appear to have any effect on the cyclical pattern. The rate for 1988Q1 through 2003Q4 is provided in the following table, should you wish to use this measure of interest rates.

d. Demonstrate for Ms. Brite and Mr. Short how well your time-series decomposition model follows the historical pattern in the data by plotting the actual values of MHS and those estimated by the model in a single time-series plot.

e. Prepare a forecast for 2004 and calculate the root-mean-squared error (RMSE), given the actual values of MHS for 2004 shown:

13. a. Use the following data on millions of dollars of jewelry sales (JS) to prepare a time-series decomposition forecast of JS for the four quarters of 2005:

The actual data for 2005 are:

b. Evaluate your model in terms of fit and accuracy using RMSE.

c. Plot your forecast values of JS along with the actual values.

d. Look at the seasonal indices, and explain why you think they do or do not make sense.

e. Compare the results from your time-series decomposition model with those obtained using a Winters’ exponential smoothing model in terms of both fit and accuracy.

4. In a time

-

series decomposition of sales (in millions of

units), the following trend has

been

estimated:

CMAT

=

4.7

*

0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were

17.2, 13.2, 10.8

, and 14.2 for

quarters 1, 2, 3, and 4, respectively. Use these actu

al sales

?

gures along with your

forecasts

to calculate the root

-

mean

-

squared error for the forecast period.

5. A tanning parlor located in a major shopping center ne

ar a large New England city has

the following history of customers over the last four

years (data are in hundreds of

custome

rs):

4. In a time-series decomposition of sales (in millions of units), the following trend has been

estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for

quarters 1, 2, 3, and 4, respectively. Use these actual sales ?gures along with your forecasts

to calculate the root-mean-squared error for the forecast period.

5. A tanning parlor located in a major shopping center near a large New England city has

the following history of customers over the last four years (data are in hundreds of

customers):

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
A+GRADE HELPER
WRITING LAND
24/7 Assignment Help
Unique Academic Solutions
Peter O.
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$47 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$21 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$39 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$16 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$18 Chat With Writer
Peter O.

ONLINE

Peter O.

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Overpaid rent refund victoria - Bay city electric san diego - Chapman company obtains 100 percent of abernethy - Nursing Leadership and Management - English language partners nz - Translate shakespeare to modern english - Oligopolies may emerge in an industry because of - Thumbs up elbows back feet apart - Newly revised strong interest inventory - Week 5 Discussion - Cognitive assessment of minnesota scoring sheet - University of michigan powerpoint template - Refrigeration oil cross reference - National schools observatory website - 1 metre in cm - Www2 warwick ac uk insite - Strong campbell interest inventory test - Political science - Natgraph screen printing table - Alder hey imagine appeal - Balloon circumference vs temperature experiment - Assignment - Reactions in aqueous solutions lab key - Chinese dragon pearl story - Essentials of services marketing pdf - Project management - Why can't two species occupy the same niche - The inverted u theory - The practice of statistics 2nd edition pdf - Dr pepper snapple group financial statements - Eating christmas in the kalahari answers - PSY 361 - 4 - Naplan persuasive writing topics year 3 - Essay - Which of the statements below best describes office layout - Cross price elasticity of demand tutor2u - Allen the alien bullying no way - Harding university high school - Wheels within wheels the crucible - Freedom rides australia newspaper articles - Algebra with pizzazz objective 5 e answers - Seed lab sql injection - Stockholder Analysis - Hp to amps rapid tables - Module 5 Sociology - Ballad of sexual dependency pdf - Informative speech about stress outline - How to calculate fnet - Cert 2 drilling operations cost - Vce english exam report - The scarlet letter chapter 3 study guide answers - Manrose 1351 remote bathroom fan timer control - Biology - Conclusion on why cell phones should be allowed in school - Kaufman test of educational achievement subtests - Healthcare Environment - Teaching and learning english in the arabic speaking world - Army air assault school study guide - The story of yingying summary - Week 10 discussion - Nursing head to-toe assessment script - DB posts - Spielberg suggests that this film raises profound questions about infinity - Carrier-mediated transport is necessary when - Scsa history year 8 - Law test - Information paper - Scholastic book review template - My timetable planner uts - Frontal lobe function while driving - La trobe lms log in - His week’s content addresses Assault, Battery, and Other Personal Crimes and Property and Computer Crimes - The best leadership style for unfavorable conditions is - Kokhono megh kokhono brishti - Random number generator iwb - 100 words summary - Ryan wood under armour net worth - Conflict resolution role play scenarios - If the ad shortfall is $600 billion and the mpc is 0.8, - How much is abstudy - 500 words essay - How to find center of circle with endpoints of diameter - Richard neis had symptoms of excessive secretion of pth - Business case study - APA style 6 pages - Racq car insurance call - Project 1 for 2 pages - Elizabethan context romeo and juliet - Find a book title - N n0e λt derivation - The elements of narrative - Batting clean up and striking out dave barry - Equations of motion worksheet with answers - Mirror ray diagram worksheet answers - Performace Improvement Project - Part 1 (HIMA350) - Methods of Service" Please respond to the following: - Walden nurs 6630 final exam - Wipo dl 101 final exam answers - But if vast numbers of Muslims across the world believe.......... - Balanced chemical equation for combustion - Visionary