I included all the questions as a reference to what is being asked, but I ONLY n

Question

I included all the questions as a reference to what is being asked, but I ONLY need answers for 7-12. Please use Excel data analysis toolpack, and please do not round any answers. Thank you!!

Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales AdvertisingName: 3,000 5,000 7,000 9,000 11,000 13,000 15,000 17,000 19,000 21,000 23,000 9,000 11,200 18,500 29,500 41,900 74,000 90,400 148,000 200,500 295,000 340,000 Do not change the data sets. Instructions: This is a study of whether advertising spending affects sales. Or, are other variables at play? The type of business is your call- use your imagination. Questions are worth 1 point each for a total of 15 This is an open book/notes test. You may use Excel or SPSS to complete this exam. This is an individual effort, so no collaborating with others. Keep answers within the yellow spaces 1. State the null and alternative hypotheses for this study Ho: 2. Run the regression analysis using a 95% confidence level and include the report.

Explanation / Answer

regression eqn: sales = -999645.9 + 16.46227*adv

given value of advertising i can predict sales by puting value of advertising in regrssion eqn:

excel output:

adv sales 25000 =-999645.9+16.46227*25000 -588089 27000 =-999645.9+16.46227*27000 -555165 29000 =-999645.9+16.46227*29000 -522240 31000 =-999645.9+16.46227*31000 -489316 33000 =-999645.9+16.46227*33000 -456391 35000 =-999645.9+16.46227*35000 -423466

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---