Question
Observations are taken on sales of a certain mountain bike in 30 sporting goods stores. The regression model was Y = total sales (thousands of
Observations are taken on sales of a certain mountain bike in 30 sporting goods stores. The regression model was Y = total sales (thousands of dollars), X1 = display floor space (square meters), X2 = competitors' advertising expenditures (thousands of dollars), X3 =advertised price (dollars per unit).
Use Excel to fill in the p-values in the table given here. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round p-values to 4 decimal places.)
Predictor | Coefficient | SE | tcalc |
| p-value | ||||
Intercept |
| 1,225.4 |
|
| 397.3 |
| 3.084 |
| |
FloorSpace |
| 11.522 |
|
| 1.330 |
| 8.6632 |
| |
Competing Ads |
| -6.935 |
|
| 3.905 |
| -1.7759 |
| |
Price |
| -0.14955 |
|
| 0.08927 |
| -1.6753 |
| |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started