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 weekly 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 weekly 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 per week on TV advertising is x1 and the thousands of dollars spent per
week on newspaper advertising is x2.
© 2007 Harvey A. Singer
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 SINGER
 Regression Analysis, weekly gross revenue, TV Advertising

Click to edit the document details