Observations are taken on net revenue from sales of a certain LCD TV at 50 retail outlets. The regression model was Y = net revenue (thousands of dollars), X1 = shipping cost (dollars per unit), X2 = expenditures on print advertising (thousands of dollars), X3 = expenditure on electronic media ads (thousands), X4 = rebate rate (percent of retail price).
(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 differ significantly from zero? LCDTV
(c) Use Excel to find the p-value for each coefficient.

Transcribed Image Text:

Predictor Coefficient SE Intercept ShipCost 4.310 -0.0820 2.265 2.498 16.697 70.82 4.678 1.050 0.8457 3.570 WebAds Rebate%