Observations are taken on net revenue from sales of Hughes, HNS, and satellite services to see if offering rebates is beneficial for the organization. Dealers don't get rebates, but customers get a $100 mail in rebate and to keep customers when they call into Hughes to cancel the services, HNS will offer another $50 credit to the account. The regression model is Y = net revenue, X1 = shipping cost (dollars per unit), X2 = purchase pole mounts, X3 = dealers cost per equipment including dish, radio, and modem, X4 = Ads, X5 = installation. Regression: Y = X1 + X2 + X3 + X4 + X5...
Predictor Coefficient
Shipping Cost 60.00
Pole Mounts 65.00
Equipment 200.00
Ads 40.00
Rebate 100.00
Perform a regression analysis on the data using MS Excel.