- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

Nicole Becker - Assignment 4 TIME SERIES ANALYSIS

Complete the following questions:

Chapter 16 PDF: Exercises 4, 10, 12, and 26.

4. Listed below is the net sales in $million for Home Depot Inc. and its subsidiaries from 1993 to 2004.

Determine the least squares equation. According to this information, what are the estimated sales for 2008 and 2009?

Determine a typical seasonal index for each of the four quarters.

12.Team Sports Inc. sells sporting goods to high schools and colleges via a nationally distributed catalogue. Management at Team Sports estimates it will sell 2000 Wilson Model A2000 catcher’s mitts next year. The deseasonalized sales are projected to be the same for each of the four quarters next year. The seasonal factor for the second quarter is 145. Determine the seasonally adjusted sales for the second quarter of next year.

26.The quarterlyproductionofpinelumber in millionsofboardfeet,byNorthwestLumbersince2004is:

Quarter

a)Determine the typical seasonal pattern for the production data using the ratio-to-moving-average method.

b)Interpret the pattern.

c)Deseasonalizethedataanddeterminethelineartrendequation.

d)Project the seasonally adjusted production for the four quarters of 2009.

Complete the following questions:

Chapter 16 PDF: Exercises 4, 10, 12, and 26.

4. Listed below is the net sales in $million for Home Depot Inc. and its subsidiaries from 1993 to 2004.

Year | Net Sales | Year | Net Sales |

1993 | $9,239 | 1999 | $38,434 |

1994 | 12477 | 2000 | 45738 |

1995 | 15470 | 2001 | 53553 |

1996 | 19535 | 2002 | 58247 |

1997 | 24156 | 2003 | 64816 |

1998 | 30219 | 2004 | 73094 |

Determine the least squares equation. According to this information, what are the estimated sales for 2008 and 2009?

- The Appliance Centre sells a variety of electronic equipment and home appliances. For the last four years the following quarterly sales (in $ millions) were reported.

Year | I | II | III | IV |

2005 | $5.30 | $4.10 | $6.80 | $6.70 |

2006 | 4.8 | 3.8 | 5.6 | 6.8 |

2007 | 4.3 | 3.8 | 5.7 | 6 |

2008 | 5.6 | 4.6 | 6.4 | 5.9 |

Determine a typical seasonal index for each of the four quarters.

12.Team Sports Inc. sells sporting goods to high schools and colleges via a nationally distributed catalogue. Management at Team Sports estimates it will sell 2000 Wilson Model A2000 catcher’s mitts next year. The deseasonalized sales are projected to be the same for each of the four quarters next year. The seasonal factor for the second quarter is 145. Determine the seasonally adjusted sales for the second quarter of next year.

26.The quarterlyproductionofpinelumber in millionsofboardfeet,byNorthwestLumbersince2004is:

Quarter

Winter | Spring | Summer | Fall |

7.8 | 10.2 | 14.7 | 9.3 |

6.9 | 11.6 | 17.5 | 9.3 |

8.9 | 9.7 | 15.3 | 10.1 |

10.7 | 12.4 | 16.8 | 10.7 |

9.2 | 13.6 | 17.1 | 10.3 |

a)Determine the typical seasonal pattern for the production data using the ratio-to-moving-average method.

b)Interpret the pattern.

c)Deseasonalizethedataanddeterminethelineartrendequation.

d)Project the seasonally adjusted production for the four quarters of 2009.

Answered Same DayDec 20, 2021

4. Listed below is the net sales in $million for Home Depot Inc. and its subsidiaries from

1993 to 2004.

Year Net Sales Year Net Sales

1993 $9,239 1999 $38,434

1994 12477 2000 45738

1995 15470 2001 53553

1996 19535 2002 58247

1997 24156 2003 64816

1998 30219 2004 73094

Determine the least squares equation. According to this information, what are the

estimated sales for 2008 and 2009?

Solution:

Here we fit a regression line on Net Sales using year. The results are given below:

SUMMARY

OUTPUT

Regression Statistics

Multiple R 0.992

R Square 0.984

Adjusted R Square 0.982

Standard E

or 2901.118

Observations 12

ANOVA

df SS MS F Significance F

Regression 1 5147676005 5.15E+09 611.618 0.000

Residual 10 84164869.9 8416487

Total 11 5231840875

Coefficients

Standard

E

or t Stat P-value

Intercept -11953541.161 484844.206 -24.654 0.000

Year 5999.811 242.604 24.731 0.000

Here the least square equations are:

y-bar = α + β*x-bar

∑xy = α∑x + β∑x

2

Hence the least square equations are:

37081.5 = α + β*1998.5

890146506 = 23982*α + 47928170*β

Therefore here the least square regression line is: Net Sales = -11953541.161 + 5999.811*Year

According to this information,

The estimated sales for 2008 = -11953541.161 + 5999.811*2008 = $94079.327

and for 2009 = -11953541.161 + 5999.811*2009 = $100079.138

10. The Appliance Centre sells a variety of electronic equipment and home appliances.

For the last four years the following quarterly sales (in $ millions) were reported.

Quarter

Year I II III IV

2005 $5.30 $4.10 $6.80 $6.70

2006 4.8 3.8 5.6 6.8

2007 4.3 3.8 5.7 6

2008 5.6 4.6 6.4 5.9

Determine a typical seasonal index for each of the four quarters.

Solution:

The following table shows the seasonal indices for the 4 quarters:

Year I II III IV Total

2005 5.3 4.1 6.8 6.7 22.9

2006 4.8 3.8 5.6 6.8 21

2007 4.3 3.8 5.7 6 19.8

2008 5.6 4.6 6.4 5.9 22.5

Total 20 16.3 24.5 25.4 86.2

Seasonal Index...

1993 to 2004.

Year Net Sales Year Net Sales

1993 $9,239 1999 $38,434

1994 12477 2000 45738

1995 15470 2001 53553

1996 19535 2002 58247

1997 24156 2003 64816

1998 30219 2004 73094

Determine the least squares equation. According to this information, what are the

estimated sales for 2008 and 2009?

Solution:

Here we fit a regression line on Net Sales using year. The results are given below:

SUMMARY

OUTPUT

Regression Statistics

Multiple R 0.992

R Square 0.984

Adjusted R Square 0.982

Standard E

or 2901.118

Observations 12

ANOVA

df SS MS F Significance F

Regression 1 5147676005 5.15E+09 611.618 0.000

Residual 10 84164869.9 8416487

Total 11 5231840875

Coefficients

Standard

E

or t Stat P-value

Intercept -11953541.161 484844.206 -24.654 0.000

Year 5999.811 242.604 24.731 0.000

Here the least square equations are:

y-bar = α + β*x-bar

∑xy = α∑x + β∑x

2

Hence the least square equations are:

37081.5 = α + β*1998.5

890146506 = 23982*α + 47928170*β

Therefore here the least square regression line is: Net Sales = -11953541.161 + 5999.811*Year

According to this information,

The estimated sales for 2008 = -11953541.161 + 5999.811*2008 = $94079.327

and for 2009 = -11953541.161 + 5999.811*2009 = $100079.138

10. The Appliance Centre sells a variety of electronic equipment and home appliances.

For the last four years the following quarterly sales (in $ millions) were reported.

Quarter

Year I II III IV

2005 $5.30 $4.10 $6.80 $6.70

2006 4.8 3.8 5.6 6.8

2007 4.3 3.8 5.7 6

2008 5.6 4.6 6.4 5.9

Determine a typical seasonal index for each of the four quarters.

Solution:

The following table shows the seasonal indices for the 4 quarters:

Year I II III IV Total

2005 5.3 4.1 6.8 6.7 22.9

2006 4.8 3.8 5.6 6.8 21

2007 4.3 3.8 5.7 6 19.8

2008 5.6 4.6 6.4 5.9 22.5

Total 20 16.3 24.5 25.4 86.2

Seasonal Index...

SOLUTION.PDF## Answer To This Question Is Available To Download

- Group Assignment_Part II_Porridge Questionnaire_final to use Breakfast and Snack Survey Do you eat breakfast or do you prefer a mid-morning snack? A new on-to-go porridge snack has been developed and...SolvedDec 29, 2021
- For calculation, please use precision level at least three digits after the decimal point. For hypothesis tests, use significance level of α = 0.05. Apple Inc. Stock Closing Prices To manage an...SolvedDec 29, 2021
- This is the question that my professor has asked after your turning in the answer you gave. I think your example of a normal curve is good. You did a good job defining the bell curve in terms of...SolvedDec 26, 2021
- Discussion Assignment Directional and nondirectional hypotheses can be easily interchanged according to the hypothesis the researcher is testing. For instance, a drug company might predict that a drug...SolvedDec 26, 2021
- Problem 3. Use the dynamic programming method to solve the following knapsack problem: max z=5x1 + 4x2 + 2x3s.t. 4x1 + 3x2 + 2x3 x1, x2, x3 ? Z+SolvedDec 26, 2021
- NPR0915_Cover_Puneet.indd Ovarian cancer: Ensuring early diagnosis www.tnpj.com The Nurse Practitioner • September XXXXXXXXXXvarian cancer is the most fatal of all gynecologic cancers. There is a...SolvedDec 25, 2021
- A high-end market research firm has contacted your boss and is trying to sell some business to your organization. Upper management does not want to appear incompetent, so they have asked you to...SolvedDec 25, 2021
- • Xt denotes the observed time series, • n is the sample size; • Zt denotes the white noise generating ARMA(p,g) model, • Wt denotes the rescaled residuals obtained after the model is fitted. Recall:...SolvedDec 25, 2021
- 3. The three models AR(2), MA(1), and ARMA(2,1) are fitted to the following time series: Year Quarter 1 Quarter 2 Quarter 3 Quarter XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX110 The results using R are as...SolvedDec 25, 2021
- ARIMA Models INSTRUCTIONS: Use MINITAB 17 to complete the following questions. You are to work independently on this assignment. All data sets for this assignment have been provided. Please submit...SolvedDec 25, 2021

Copy and Paste Your Assignment Here

Copyright © 2022. All rights reserved.