This preview shows pages 1–3. Sign up to view the full content.
George Mason University
School of Management
OM 210:
STATISTICAL ANALYSIS FOR MANAGEMENT
Prof. Harvey Singer
TEST #3:
Inference and Regression (SAMPLE)
Multiple Linear Regression Problem
The sampled data listed below gives data for weekly gross revenue (in thousands
of dollars) for a large regional retailer as a function of advertising expenditures in
both newspapers and television (TV) (in thousands of dollars) for eight
consecutive weeks.
Weekly Gross
Revenue
($1000s)
Television
Advertising
($1000s)
Newspaper
Advertising
($1000s)
96
5.0
1.5
90
2.0
2.0
95
4.0
1.5
92
2.5
2.5
95
3.0
3.3
94
3.5
2.3
94
2.5
4.2
94
3.0
2.5
A multiple regression was performed in Excel using TV and newspaper
advertising expenditures (both in thousands of dollars) as independent variables.
The Excel output report is shown below.
In that report, the thousands of dollars
spent on TV advertising is x1 and the thousands of dollars spent on newspaper
advertising is x2.
© 2010 Harvey A. Singer
Page 1 of 3
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentSUMMARY OUTPUT
Regression Statistics
Multiple R
0.958663444
R Square
0.9190356
Adjusted R Square
0.88664984
Standard Error
0.642587303
Observations
8
ANOVA
df
SS
MS
F
Significance F
Regression
2
23.43540779
11.7177039
28.37776839
0.001865242
Residual
5
2.064592208
0.412918442
Total
7
25.5
Coefficients
Standard Error
t Stat
Pvalue
Lower 95%
Upper 95%
Intercept
83.23009169
1.573868952
52.88247894
4.57175E08
79.18433275
87.27585063
x1
2.290183621
0.304064556
7.531899313
0.000653232
1.508560797
3.071806445
x2
1.300989098
0.320701597
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '08
 SINGER

Click to edit the document details