# Question: Observations are taken on net revenue from sales of a

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.

(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.

## Answer to relevant Questions

In 2009, US Airways Flight 1549 made a successful emergency landing in the Hudson River, after striking birds shortly after takeoff. Are bird strikes an increasing threat to planes? (a) Make an Excel graph of the data on ...For each of the following tted trends, make a prediction for period t = 17: a. yt = 2286 e.076t b. yt = 1149 + 12.78t c. yt = 501 + 18.2t – 7.1t2 (a) Plot the data on leisure and hospitality employment. (b) Describe the trend (if any) and discuss possible causes. (c) Fit the linear and exponential trends. Would these trend models give credible forecasts? Explain. ...(a) Plot the data on gas bills. (b) Can you see seasonal patterns? Explain. (c) Use MegaStat or MINITAB to calculate estimated seasonal indexes and trend. (d) Which months are the most expensive? The least expensive? Can ...(a) Make an Excel line graph of the exchange rate data. Describe the pattern. (b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m = 2, 4, 6, etc.). Include a copy of ...Post your question