Regression Homework Assignment

profileRock1027
classfilesfall09.xls
Home>Business & Finance homework help>Management homework help>Regression Homework Assignment

CB_DATA_

sales

Year Quarter Sales
1 1 144
2 151
3 134
4 151
2 1 145
2 145
3 141
4 166
3 1 151
2 164
3 151
4 176
4 1 170
2 180
3 156
4 187
5 1 166
2 182
3 154
4 169

Sales+

Year Quarter Sales Advertising
1 1 144 41
2 151 51
3 134 32
4 151 45
2 1 145 48
2 145 34
3 141 29
4 166 43
3 1 151 40
2 164 51
3 151 39
4 176 54
4 1 170 41
2 180 52
3 156 48
4 187 47
5 1 166 44
2 182 48
3 154 44
4 169 36

salesmedia

YEAR QTR SALES TV RADIO NEWS
1993 1 88 100 95 87
2 80 99 99 98
3 96 101 103 101
4 76 93 95 91
1994 1 80 95 102 88
2 73 95 94 84
3 58 80 89 74
4 116 116 112 102
1995 1 104 106 110 105
2 99 105 87 97
3 64 90 90 88
4 126 113 101 108
1996 1 94 96 100 89
2 71 98 85 78
3 111 109 99 109
4 109 102 101 108
1997 1 100 100 93 102
2 127 107 108 110
3 99 108 100 95
4 82 95 69 90
1998 1 67 91 95 85
2 100 114 91 103
3 78 93 80 80
4 115 115 85 104
1999 1 83 97 105 83

crates

year Month Crates
1999 Jan 20400
Feb 13600
Mar 17000
Apr 30600
May 23800
Jun 17000
Jul 27200
Aug 30600
Sep 34000
Oct 45900
Nov 40800
Dec 30600
2000 Jan 13600
Feb 23800
Mar 30600
Apr 25500
May 27200
Jun 30600
Jul 23800
Aug 47600
Sep 37400
Oct 45900
Nov 44200
Dec 17000
2001 Jan 20400
Feb 13600
Mar 30600
Apr 22100
May 23800
Jun 30600
Jul 28900
Aug 34000
Sep 42500
Oct 47600
Nov 30600
Dec 30600
2002 Jan 25500
Feb 20400
Mar 23800
Apr 30600
May 25500
Jun 30600
Jul 34000
Aug 37400
Sep 44200
Oct 47600
Nov 34000
Dec 37400
2003 Jan 25500
Feb 37400
Mar 30600
Apr 30600
May 27200
Jun 34000
Jul 47600
Aug 47600
Sep 34000
Oct 51000
Nov 37400
Dec 47600