Click here for the Excel Data File Observations are taken on sales of a certain

Question

Click here for the Excel Data File

Observations are taken on sales of a certain mountain bike in 30 sporting goods stores. The regression model was Ys total sales (thousands of dollars), Xi-display floor space (square meters), X2 competitors' advertising expenditures (thousands of dollars), X3 Fadvertised price (dollars per unit) &Click; here for the Excel Data File (a) Fill in the values in the table given here (confidence level 99%). (Negative values should be indicated by a minus sign. Leave no cells blank be certain to enter "O" wherever required. Round your t values to 3 decimal places and p-values to 4 decimal places.) SE 397.3 1.330 3.905 alue Predictor Intercept FloorSpace Competing Ads-6.935 Price Coefficient 1,225.4 11.522 calc 0.14955 0.08927 (b-1) What is the critical value of Student's t in Appendix D for a two-tailed test at a01? (Round your answer to 3 decimal places.) t-value-

Explanation / Answer

here as tcalc=coefficient/SE

b-1)

t value =2.779

predictor coefficient SE tcalc p value intercept 1225.4 397.3 3.084 0.0048 floorspace 11.522 1.33 8.663 0.0000 competing ads -6.935 3.905 -1.776 0.0874 price -0.14955 0.08927 -1.675 0.1059

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.