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 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 data; use x = $20, sε = $111.9M, and the equation of the regression line, y^ = -48.54 + 15.26 x.

Do not round the intermediate values. Round your answers to 2 decimal places.

Enter a value.  ≤ E(y20) ≤ Enter a value. 

eTextbook and Media

 

 

 

 

Construct a 98% prediction interval for a single value of y for the given data; use x = $20, sε = $111.9M, and the equation of the regression line, y^ = -48.54 + 15.26 x.

Do not round the intermediate values. Round your answers to 2 decimal places.

Enter a value.  ≤ y20 ≤ Enter a value.  

eTextbook and Media

 

 

 

 

Which is wider? Why?

The prediction interval for the Select an option.                                      

                                  average value of ysingle value of y is wider than the confidence interval for the Select an option.                                                                        single value of yaverage value of y because the average is more towards the Select an option.                                                                        rightmiddleleft and individual values of Select an option.                                                                       can vary more thancan't vary more than values of the average.

eTextbook and Media

 

Solutions

Expert Solution

I used R software to solve this question.

R codes and output:

> ad=c(12.5,3.7,21,60,37.6,6.1,17.9,41.2)
> sales=c(141,55,338,994,541,89,126,379)
> fit=lm(sales~ad)
> fit

Call:
lm(formula = sales ~ ad)

Coefficients:
(Intercept) ad
-48.54 15.26

> data=data.frame(ad=20)
> predict(fit,newdata=data,interval='confidence',level=0.98)
fit lwr upr
1 256.5926 127.7146 385.4707
> predict(fit,newdata=data,interval='prediction',level=0.98)
fit lwr upr
1 256.5926 -117.9173 631.1025

98% confidence interval for the average value of y for the given data:

127.71 < E(Y20) < 385.47

98% prediction interval for the average value of y for the given data:

-117.92 < (Y20) < 631.10

The prediction interval for the single value of y is wider than the confidence interval for the average value of y because the average is more towards the middle and individual values of y can vary more than values of the average.


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