Perform a regression analysis on the data

Reference no: EM13140422

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.

Reference no: EM13140422

Questions Cloud

Probability one of three audited had charitable deduction : What is the probability exactly one of the three audited had a charitable deduction of more than $1,000? What is the probability at least one of the audited returns had a charitable contribution of more than $1,000?

What is the work in joules done : what is the work in joules done on the system to compress He gas from 24.0 L to 12.5 L against a pressure of 1.5 atm at a constant temperature of 37.4 C?

Understanding of the power of prayer : Write a detailed discussion on your understanding of the power of prayer or lack thereof in the healing process. Give your rationale for your perspective, making it as strong as possible to persuade others

Calculate the molar enthalpy change : Calculate the molar enthalpy change when mercury is cooled 10 K. The molar heat capacity of mercury is 27.8 J/K*mol

Perform a regression analysis on the data : Observations are taken on net revenue from sales of Hughes, HNS, and satellite services to see if offering rebates is beneficial for the organization.

Biblical creation theory : Would you help me to get started on a paper that talks about the creation of the earth in the Biblical sense of how the earth was created versus how some archeologists say it was formed?

God-centered versus human-centered : Secular Humanists feel that, "The good is not what some abstract God dictates, but what contributes to the liberation, growth, and progress of human beings.

Amount of interest expense recorded annually : Garrison Company issued $500,000 bonds with a stated interest rate of 10% for $480,000 in 2009. The bonds pay interest annually and have a 10 year maturity. The amount of interest expense that should be recorded annually should be ?

Christian and humanistic worldviews-sexuality : A secular humanist believes that humans are the ultimate source of truth, standards and values and right and wrong. There is some debate in the secular humanist camp regarding whether there is any responsibility to society.

User Account

All Pages