Question

In: Statistics and Probability

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

  1. 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

  1. Develop the equation of the simple regression line to predict sales on advertising expenditures using these data.                                                                                                              [10 Marks]
  2. Find out the sales that are likely to be attained when advertising expenditure is 25

million.                                                                                                           [2 Marks]

  1. Compute the coefficient of correlation and coefficient of determination and interpret their values. [4 Marks]
  2. Test the hypothesis that the population correlation coefficient is zero at 5% level of significance. [4 Marks]

Solutions

Expert Solution

Solution:

1) simple regression line is

Y= -46.29 + 15.24X

2) for X=25 find Y

Y= -46.29 + 15.24*25

Y= 334.71

calculation:

1) correlation coefficient r= 0.948 and coefficient of determination R²= 0.8981

​​​Calculation:

2) Test for hypothesis is:

​​​​


Related Solutions

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...
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 Develop the equation of the simple regression line to predict sales from...
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...
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...
A sales manager is interested in determining the relationship between the amount spent on advertising and...
A sales manager is interested in determining the relationship between the amount spent on advertising and total sales. the manger collects data for the past  months and runs a regression of sales on advertising expenditures. The results wıth some missing values are presented below. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.492 0.242 0.208 40.975 ANOVA df SS MS F Significance Regression Residual Total 1 Coefficients Standard Error t Stat P-value Constant Advertising To test the...
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...
Planner Corporation owns 60 percent of Schedule Company’s voting shares. During 20X3, Planner produced 27,000 computer...
Planner Corporation owns 60 percent of Schedule Company’s voting shares. During 20X3, Planner produced 27,000 computer desks at a cost of $96 each and sold 12,000 of them to Schedule for $108 each. Schedule sold 8,000 of the desks to unaffiliated companies for $136 each prior to December 31, 20X3, and sold the remainder in early 20X4 for $146 each. Both companies use perpetual inventory systems. Required: a. What amounts of cost of goods sold did Planner and Schedule record...
1. Selling price and amount spent advertising were entered into a multiple regression to determine what...
1. Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. The regression coefficient for Price was found to be -0.03055, which of the following is the correct interpretation for this value? Select one: A. Holding the amount spent on advertising constant, an increase of $100 in the price of the Sony Bravia will decrease sales by 0.03%. B. None of these. C. For a given amount spent on...
Your friend believes that the government should not try to reduce the pollution amount in companies....
Your friend believes that the government should not try to reduce the pollution amount in companies. He believes every single environmental regulation is bad. Write a response (5-8 sentences) about why it is socially efficient for there to be efforts to reduce pollution. (Make sure to use some economic terms in your response).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT