Question

In: Statistics and Probability

A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising...

A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, she gathers the following sales and advertising information from several of the companies for 2009 ($ millions).

Advertising:

12.5

3.7

21.6

60

37.6

6.1

16.8

41.2

Sales:

148

55

338

994

541

89

126

379

  1. Develop the equation of the simple regression line to predict sales from advertising expenditures using these dat
  2. Produce the excel output table and separately show the calculations including formula used.
  3. Determine Se, R-square and Multiple R for the data. What is its interpretation.
  4. Test the slope of the regression line determines in b. Use α=0.10
  5. Construct a 98% confidence interval for average value of y and prediction interval for a single value of y using x=$20M. which one is wider? Why?

Solutions

Expert Solution


Related Solutions

A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising...
A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, she gathers the following sales and advertising information from several of the companies for 2017 (in millons) advertising($12.5 , 3.7 ,21.0 ,60.0 ,37.6 ,6.1 ,17.9 ,41.2 ) sales($141, 55 ,338 ,994 ,541 ,89 ,126 ,379) Construct a 98% confidence interval for the average value of y for the given...
A corporation owns several companies. The strategic planner for the corporation believes amount spent on advertising...
A corporation owns several companies. The strategic planner for the corporation believes amount spent on advertising can to some extent be a predictor of total sales. As an aid in long term planning, she gathers the following sales and advertising information from several of the companies in millions for the year 2019. Advertising 12.5 3.7 21.6 60.0 37.6 6.1 16.8 41.2 Sales 148 55 338 994 541 89 126 379 Develop the equation of the simple regression line to predict...
A corporation owns several companies. The strategic planner for the corporation believes amount spent on advertising...
A corporation owns several companies. The strategic planner for the corporation believes amount spent on advertising can to some extent be a predictor of total sales. As an aid in long term planning, she gathers the following sales and advertising information from several of the companies in millions for the year 2019.                 Advertising          12.5        3.7          21.6        60.0        37.6        6.1          16.8        41.2                 Sales                    148        55           338         994         541         89           126         379 Develop the equation of the simple regression...
End of Section Problem 12.46 A corporation owns several companies. The strategic planner for the corporation...
End of Section Problem 12.46 A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, she gathers the following sales and advertising information from several of the companies for 2011 ($ millions). Advertising Sales 12.5 148 3.7 55 21.6 338 60.0 994 37.6 541 6.1 89 16.8 126 41.2 379 a. Construct a 98% confidence interval for...
You are given the following schemas for a corporation database. The corporation owns several subsidiary companies...
You are given the following schemas for a corporation database. The corporation owns several subsidiary companies (e.g. Disney Corporation owns Lucasfilm Ltd). Managers are also Employees. Answer the following questions using the schemas. Employee(ssn, name, street, city) Company(company_name, asset) Company_Branches(company_name, branch_num, city) Works(ssn, company_name, branch_num, salary) Managed_By(ssn, manager_ssn) 6) Does the current design allow us to enforce the constraint that each employee must have a manager (without using external check or triggers)? Why or why not? 7) If the answer...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and the profits (in millions of dollars). Determine if there is a significant negative linear correlation between advertising cost and profit . Use a significance level of 0.01 and round all values to 4 decimal places. Advertising Cost Profit 3 18 4 22 5 16 6 29 7 24 8 31 9 22 10 29 11 25 Ho: ρ = 0 Ha: ρ < 0...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and the profits (in millions of dollars). Determine if there is a significant positive linear correlation between advertising cost and profit . Use a significance level of 0.01 and round all values to 4 decimal places. Advertising Cost Profit 3 23 4 29 5 28 6 21 7 29 8 32 9 21 Ho: ρ = 0 Ha: ρ > 0 Find the Linear Correlation...
The data below represent a firm’s dollars spent on advertising for a sample of 4 months...
The data below represent a firm’s dollars spent on advertising for a sample of 4 months and the firm’s sales (in units sold) for those months. month advertising expenditures (x) units sold (y) 1 $2215 543 2 $2975 664 3 $2150 538 4 $2060 575 1. What is the correct interpretation of the coefficient of determination? 2. What are expected sales if advertising spending is $3000? 3. What is the size of the error term for month 1? 4. Because...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and...
Listed below are paired data consisting of amounts spent on advertising (in millions of dollars) and the profits (in millions of dollars). Determine if there is a significant linear correlation between advertising cost and profit . Use a significance level of 0.01 and round all values to 4 decimal places. Advertising CostProfit 323 422 523 626 723 825 919 1025 1133 Ho: ρ = 0 Ha: ρ ≠ 0 Find the Linear Correlation Coefficient r = Find the p-value p-value...
Planner Corporation owns 60 percent of Schedule Company’s voting shares. During 20X3, Planner produced 25,000 computer...
Planner Corporation owns 60 percent of Schedule Company’s voting shares. During 20X3, Planner produced 25,000 computer desks at a cost of $82 each and sold 10,000 of them to Schedule for $94 each. Schedule sold 7,000 of the desks to unaffiliated companies for $130 each prior to December 31, 20X3, and sold the remainder in early 20X4 for $140 each. Both companies use perpetual inventory systems. Required: a. What amounts of cost of goods sold did Planner and Schedule record...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT