Sample Test 3 (multiple regression) answers

# Sample Test 3 (multiple regression) answers - George Mason...

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 Document
SUMMARY 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 P-value Lower 95% Upper 95% Intercept 83.23009169 1.573868952 52.88247894 4.57175E-08 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.

## This note was uploaded on 02/19/2011 for the course OM 210 taught by Professor Singer during the Spring '08 term at George Mason.

### Page1 / 4

Sample Test 3 (multiple regression) answers - George Mason...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online