Sample Test 3 (multiple regression) answers

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

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online