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), X₁ = display floor space (square meters), X₂ = competitors' advertising expenditures (thousands of dollars), X₃ = advertised price (dollars per unit). 

(a) Calculate the t statistic for each coefficient to test for β = 0. 

(b) Look up the critical value of Student's t in Appendix D for a two-tailed test at α = .01. Which coefficients Bikes differ significantly from zero? 

(c) Use Excel to find the p-value for each coefficient.

Transcribed Image Text:

Predictor Coefficient SE intercept FloorSpace CompetingAds Price 1225.4 397.3 11.522 -6.935 -0.14955 1.330 3.905 0.08927