Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting 2010 housing starts using the 2008 and 2009 data in the Excel

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting 2010 housing starts using the 2008 and 2009 data in the Excel file Housing Starts.

Month Number
Jan 1990 99.2
Feb 1990 86.9
Mar 1990 108.5
Apr 1990 119.0
May 1990 121.1
Jun 1990 117.8
Jul 1990 111.2
Aug 1990 102.8
Sep 1990 93.1
Oct 1990 94.2
Nov 1990 81.4
Dec 1990 57.4
Jan 1991 52.5
Feb 1991 59.1
Mar 1991 73.8
Apr 1991 99.7
May 1991 97.7
Jun 1991 103.4
Jul 1991 103.5
Aug 1991 94.7
Sep 1991 86.6
Oct 1991 101.8
Nov 1991 75.6
Dec 1991 65.6
Jan 1992 71.6
Feb 1992 78.8
Mar 1992 111.6
Apr 1992 107.6
May 1992 115.2
Jun 1992 117.8
Jul 1992 106.2
Aug 1992 109.9
Sep 1992 106.0
Oct 1992 111.8
Nov 1992 84.5
Dec 1992 78.6
Jan 1993 70.5
Feb 1993 74.6
Mar 1993 95.5
Apr 1993 117.8
May 1993 120.9
Jun 1993 128.5
Jul 1993 115.3
Aug 1993 121.8
Sep 1993 118.5
Oct 1993 123.3
Nov 1993 102.3
Dec 1993 98.7
Jan 1994 76.2
Feb 1994 83.5
Mar 1994 134.3
Apr 1994 137.6
May 1994 148.8
Jun 1994 136.4
Jul 1994 127.8
Aug 1994 139.8
Sep 1994 130.1
Oct 1994 130.6
Nov 1994 113.4
Dec 1994 98.5
Jan 1995 84.5
Feb 1995 81.6
Mar 1995 103.8
Apr 1995 116.9
May 1995 130.5
Jun 1995 123.4
Jul 1995 129.1
Aug 1995 135.8
Sep 1995 122.4
Oct 1995 126.2
Nov 1995 107.2
Dec 1995 92.8
Jan 1996 90.7
Feb 1996 95.9
Mar 1996 116.0
Apr 1996 146.6
May 1996 143.9
Jun 1996 138.0
Jul 1996 137.5
Aug 1996 144.2
Sep 1996 128.7
Oct 1996 130.8
Nov 1996 111.5
Dec 1996 93.1
Jan 1997 82.2
Feb 1997 94.7
Mar 1997 120.4
Apr 1997 142.3
May 1997 136.3
Jun 1997 140.4
Jul 1997 134.6
Aug 1997 126.5
Sep 1997 139.2
Oct 1997 139.0
Nov 1997 112.4
Dec 1997 106.0
Jan 1998 91.2
Feb 1998 101.1
Mar 1998 132.6
Apr 1998 144.9
May 1998 143.3
Jun 1998 159.6
Jul 1998 156.0
Aug 1998 147.5
Sep 1998 141.5
Oct 1998 155.5
Nov 1998 124.2
Dec 1998 119.6
Jan 1999 106.8
Feb 1999 110.2
Mar 1999 147.3
Apr 1999 144.6
May 1999 153.2
Jun 1999 149.4
Jul 1999 152.6
Aug 1999 152.9
Sep 1999 140.3
Oct 1999 142.9
Nov 1999 127.4
Dec 1999 113.6
Jan 2000 104.0
Feb 2000 119.7
Mar 2000 133.4
Apr 2000 149.5
May 2000 152.9
Jun 2000 146.3
Jul 2000 135.0
Aug 2000 141.4
Sep 2000 128.9
Oct 2000 139.7
Nov 2000 117.1
Dec 2000 100.7
Jan 2001 106.4
Feb 2001 108.2
Mar 2001 133.2
Apr 2001 151.3
May 2001 154.0
Jun 2001 155.2
Jul 2001 154.6
Aug 2001 141.5
Sep 2001 133.1
Oct 2001 139.8
Nov 2001 121.0
Dec 2001 104.6
Jan 2002 110.4
Feb 2002 120.4
Mar 2002 138.2
Apr 2002 148.8
May 2002 165.5
Jun 2002 160.3
Jul 2002 155.9
Aug 2002 147.0
Sep 2002 155.6
Oct 2002 146.8
Nov 2002 133.0
Dec 2002 123.1
Jan 2003 117.8
Feb 2003 109.7
Mar 2003 147.2
Apr 2003 151.2
May 2003 165.0
Jun 2003 174.5
Jul 2003 175.8
Aug 2003 163.8
Sep 2003 171.3
Oct 2003 173.5
Nov 2003 153.7
Dec 2003 144.2
Jan 2004 124.5
Feb 2004 126.4
Mar 2004 173.8
Apr 2004 179.5
May 2004 187.6
Jun 2004 172.3
Jul 2004 182.0
Aug 2004 185.9
Sep 2004 164.0
Oct 2004 181.3
Nov 2004 138.1
Dec 2004 140.2
Jan 2005 142.9
Feb 2005 149.1
Mar 2005 156.2
Apr 2005 184.6
May 2005 197.9
Jun 2005 192.8
Jul 2005 187.6
Aug 2005 192.0
Sep 2005 187.9
Oct 2005 180.4
Nov 2005 160.7
Dec 2005 136.0
Jan 2006 153.0
Feb 2006 145.1
Mar 2006 165.9
Apr 2006 160.5
May 2006 190.2
Jun 2006 170.2
Jul 2006 160.9
Aug 2006 146.8
Sep 2006 150.1
Oct 2006 130.6
Nov 2006 115.2
Dec 2006 112.4
Jan 2007 95.0
Feb 2007 103.1
Mar 2007 123.8
Apr 2007 135.6
May 2007 136.5
Jun 2007 137.8
Jul 2007 127.9
Aug 2007 121.2
Sep 2007 101.5
Oct 2007 115.0
Nov 2007 88.8
Dec 2007 68.9
Jan 2008 70.8
Feb 2008 78.4
Mar 2008 82.2
Apr 2008 89.5
May 2008 91.7
Jun 2008 102.5
Jul 2008 86.7
Aug 2008 76.4
Sep 2008 73.9
Oct 2008 68.2
Nov 2008 47.5
Dec 2008 37.7
Jan 2009 31.9
Feb 2009 39.8
Mar 2009 42.7
Apr 2009 42.5
May 2009 52.2
Jun 2009 59.1
Jul 2009 56.8
Aug 2009 52.9
Sep 2009 52.6
Oct 2009 44.5
Nov 2009 42.3
Dec 2009 36.6
Jan 2010 38.9
Feb 2010 40.7
Mar 2010 54.7
Apr 2010 62.0
May 2010 56.2
Jun 2010 53.8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Business Analytics

Authors: Troy Adair

1st Edition

1119132002, 9781119132004

More Books

Students also viewed these Mathematics questions

Question

An improvement in the exchange of information in negotiations.

Answered: 1 week ago

Question

1. Effort is important.

Answered: 1 week ago