Question: 4. (5 pts) Here is a small data set about the relationship between TV ads spending and profit: Quarter TVadSpend Sales 1 0 236 2

4. (5 pts) Here is a small data set about the relationship between TV ads spending and profit: Quarter TVadSpend Sales 1 0 236 2 0 456 3 10 675 4 25 799 5 30 910 6 30 971 - mi 931 8 Ei 2 1177 3 40 950 10 40 962 11 45 1476 12 45 1359 13 50 1200 14 50 1260 15 55 1329 16 55 1330 Running this data through Excel, | got the following results: SUMMARY OUTPUT Regression Statistics Multiple R 0.9027 R Square 0.8148 Adjusted R Sq 0.8016 Standard Error 148.1904 Observations 16 ANOVA a ss MS F Significance F Regression 1 1352635.29 1,352635.29 6149 0.09 Residual 14 307,445.65 21,960, 40 Total 15 1,660 060 94 Coefficrents Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 437 8799 62.3477 5.3175 0.0001 201.2617 614 4981 261.2617 614.4981 $ TV ads 16.9448 2.1591 7.8482 0.0000 12.3141 21.5756 12.3141 21.5756 a. What does R squared tell us in this analysis? Is this a good model that fits the data well? b. Is there a significant relationship between ads spending and profit? How did you come to your conclusion? c. Write the equation that shows the linear relationship between ads spending and profit. If my ads spending is 100, what is the expected profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and...

Final PDF to printer MHE-FTR-018 0077645065 BRE T T P. MAT HE RNE S T E VE GOVE DAVI D T HORNBL AD The Movie Exhibition Industry 2013 IT IS APT that 2012's top-grossing film was The Avengers, because...

MKT500 Assignment 4 Requirements. Please design and create a PowerPoint Presentation that meets the criteria stated in the attachment. The slides should have bullet points and the notes or talking...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

BBUS 4701: Business Policy and Strategy Yahoo 2012 Annual Report Assignment 4 By Yahoo! Yahoo!. (2012). Yahoo 2012 Annual Report. Retrieved from: http://investor.yahoo.net/annuals.cfm 2 01 2 A N N UA...

1. Why was Olam vulnerable to a short-seller attack in 2012? 2. Identify one or more businesses that you think Olam should divest. Give your reasons. 3. What are the lessons learnt from Olam's...

MKT500 Week 8 Discussion Board 8 attached are the questions, scenario, and supportive reading materials. MKT500 DB 8 "The Importance of Social Media and Web Analytics" 1.) From the scenario,...

Please open the attached file and answer only questions 9 and 10. one and ahalf page ISSUES IN ACCOUNTING EDUCATION Vol. 27, No. 2 2012 pp. 441-459 American Accounting Association DOI:...

Case study: Remedy Physiotherapy. I need help in drafting a marketing plan Names of people and businesses are disguised. Some aspects of the local area and the physiotherapy industry are simplified...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Now assume Citrus Products begins producing the same liter of orange juice in Spain. The product costs 2.0 euros to produce and ship to Sweden, where it can be sold for 20 kronas. What is the dollar...

As an Accounting Information System expert, you provide consultancy services to various clients in Australia. MPS Limited is one of your clients, and Miss Angela, the head of its accounting...

Carefully read this case study, a case study for suffering, this case study is about a person who is suffering. Fill in the first two columns about Proverbs and Job. Proverbs Job Summarize the book's...

You have bought a Call spread with a bought strike of 40 and a sold strike of 50. Say whether the following are always positive, always negative, or does it depend on where the stock price is. 1....