Homework Answers
a ) using excel >stat>basic stat>regression
we have
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.833137 | |||||||
| R Square | 0.694118 | |||||||
| Adjusted R Square | 0.643137 | |||||||
| Standard Error | 1.316561 | |||||||
| Observations | 8 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 23.6 | 23.6 | 13.61538 | 0.01021 | |||
| Residual | 6 | 10.4 | 1.733333 | |||||
| Total | 7 | 34 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 88.8 | 1.613362 | 55.04033 | 2.42E-09 | 84.85224 | 92.74776 | 84.85224 | 92.74776 |
| TV Add | 1.6 | 0.433616 | 3.689903 | 0.01021 | 0.538981 | 2.661019 | 0.538981 | 2.661019 |
Revenue = 88.8 + 1.6 TV add
Ans 2 )
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.967691 | |||||
| R Square | 0.936426 | |||||
| Adjusted R Square | 0.910997 | |||||
| Standard Error | 0.657495 | |||||
| Observations | 8 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 2 | 31.8385 | 15.91925 | 36.82453 | 0.001019 | |
| Residual | 5 | 2.161501 | 0.4323 | |||
| Total | 7 | 34 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 83.5768 | 1.442479 | 57.93969 | 2.9E-08 | 79.86879 | 87.28481 |
| TV Add | 2.121675 | 0.247334 | 8.578194 | 0.000355 | 1.485884 | 2.757466 |
| News Add | 1.359488 | 0.311418 | 4.365474 | 0.007253 | 0.558962 | 2.160015 |
Revenue = 83.58 + 2.12TV add + 1.36News Add
ans 3 ) No the coefficient for television advertising expenditure is not same .
Ans 4) For tv add = $5 , News Add = 3.6
predicted Revenue = 83.58 + 2.12*5 + 1.36*3.6 = 83.58+10.6+4.896 = $ 99.08
Add Answer to:
f Delete this text then place your Simple Regression output in this shaded area. Output range $E$1 * Weekly Gross...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = TVAdv b. Develop...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising exp...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = + TVAdv b....
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters....
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Televison Newspaper Advertising Advertising Revenue ($1000s) ($1000s) ($1000s) 1.5 2 1.5 2.5 3.3 2.3 90 2 4 2.5 92 95 94 94 94 3.5 2.5 2.5 a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals) Revenue = 83.78 1.78 TVAdv + | 1.47 NewsAdv
After reading these instructions delete all text in this shaded area. B C D E F...
After reading these instructions delete all text in this shaded area. B C D E F G HI J Conf Yds Atin At Win% Part a. 66 0043 501 After reading these instructens delete all text in this shaded area. K XLMiner Analysis ToolPak * Team 2 Arona Cardinals NFC Anova: Single Factor Carolina Panthers NFC Anova: Two-Factor With Replication 73 60 0.033 0.027 374 56.4 AFC Use the XL Miner Analysis ToolPak to conduct Your Linear regression and After...
thousands of dollars. , I1, and 2 are expressed Values of Newspaper Televison Weekly Advertising Advertising Gross ($10...
thousands of dollars. , I1, and 2 are expressed Values of Newspaper Televison Weekly Advertising Advertising Gross ($1000s) ($1000s) Revenue ($1000s) 1.5 5 95 2 1.5 4 95 2.5 .5 92 3.3 3 95 2.3 3. 5 94 4.2 2.5 94 2.5 3 94 The estimated regression equation was 842.01z 1.312 spent on newspaper advertising (x2 = 1.8) (to 3 a. What is the estimated gross revenue for a week where $3.5 thousand is spent on television (x =3.5) and...
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters....
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals). Revenue = X TV Adv + NewsAdv
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 1.5 ($1,000s) 105 102 3.0 2.5 a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 1 decimal). Revenue TVAdv b. Develop...
eBook Video Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime...
eBook Video Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc, would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of elght weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 103 30 2.5 a. Develop...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y)...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (1) and newspaper advertising (C2). Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 2.5 The estimated regression equation was y = 85.5+ 2.0621 -0.37x2. The computer solution provided SST = 26, SSR = 24.356. a. Compute RP (to 3 decimals). Compute RX (to 3 decimals). b. When television advertising was the only independent variable, R2 =...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y)...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (1) and newspaper advertising (22) Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 1.5 البة بة جة The estimated regression equation was y = 88.4 +1.85&1 - 0.1722 The computer solution provided SST = 23.5, SSR = 22.035. a. Compute R2 (to 3 decimals). Compute R2 (to 3 decimals). Compute RX (to 3 decimals). b. When...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = TVAdv b. Develop...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = + TVAdv b....
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Televison Newspaper Advertising Advertising Revenue ($1000s) ($1000s) ($1000s) 1.5 2 1.5 2.5 3.3 2.3 90 2 4 2.5 92 95 94 94 94 3.5 2.5 2.5 a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals) Revenue = 83.78 1.78 TVAdv + | 1.47 NewsAdv
After reading these instructions delete all text in this shaded area. B C D E F G HI J Conf Yds Atin At Win% Part a. 66 0043 501 After reading these instructens delete all text in this shaded area. K XLMiner Analysis ToolPak * Team 2 Arona Cardinals NFC Anova: Single Factor Carolina Panthers NFC Anova: Two-Factor With Replication 73 60 0.033 0.027 374 56.4 AFC Use the XL Miner Analysis ToolPak to conduct Your Linear regression and After...
thousands of dollars. , I1, and 2 are expressed Values of Newspaper Televison Weekly Advertising Advertising Gross ($1000s) ($1000s) Revenue ($1000s) 1.5 5 95 2 1.5 4 95 2.5 .5 92 3.3 3 95 2.3 3. 5 94 4.2 2.5 94 2.5 3 94 The estimated regression equation was 842.01z 1.312 spent on newspaper advertising (x2 = 1.8) (to 3 a. What is the estimated gross revenue for a week where $3.5 thousand is spent on television (x =3.5) and...
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals). Revenue = X TV Adv + NewsAdv
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 1.5 ($1,000s) 105 102 3.0 2.5 a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 1 decimal). Revenue TVAdv b. Develop...
eBook Video Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc, would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of elght weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 103 30 2.5 a. Develop...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (1) and newspaper advertising (C2). Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 2.5 The estimated regression equation was y = 85.5+ 2.0621 -0.37x2. The computer solution provided SST = 26, SSR = 24.356. a. Compute RP (to 3 decimals). Compute RX (to 3 decimals). b. When television advertising was the only independent variable, R2 =...
The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (1) and newspaper advertising (22) Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 1.5 البة بة جة The estimated regression equation was y = 88.4 +1.85&1 - 0.1722 The computer solution provided SST = 23.5, SSR = 22.035. a. Compute R2 (to 3 decimals). Compute R2 (to 3 decimals). Compute RX (to 3 decimals). b. When...
Most questions answered within 3 hours.
-
When might an index slow down the overall performance of the
database? Choose the best answer....
asked 3 minutes ago -
Due to a recession, expected inflation this year is only 2.25%.
However, the inflation rate in...
asked 5 minutes ago -
Write four functions: (IN PYTHON 3)
1) bound(l) - given a list of integers l, compute...
asked 7 minutes ago -
A quarterback throws a football. When the football leaves his
hand, it has a horizontal velocity...
asked 15 minutes ago -
he term "reproductive isolation mechanism" refers to
inability of a species to continue reproduction
specific areas...
asked 17 minutes ago -
In a certain binary-star system, each star has the same mass
which is 4.4 times of...
asked 21 minutes ago -
Use the model of the small open economy (Apply the small
open economy model of real...
asked 29 minutes ago -
The structure Car is declared as follows: struct Car { string
carMake; string carModel; int yearModel;...
asked 38 minutes ago -
Consider a transformer with 125 turns of wire in the primary
winding and 1475 turns of...
asked 38 minutes ago -
Let h be the depth below the surface of the ocean at which the
absolute pressure...
asked 40 minutes ago -
Apply the four-stage New Product Development model shown in page
325 of your text book
(Concept...
asked 49 minutes ago -
An enzyme catalyzes the reaction A ⇌ B. The enzyme is present at
a concentration of...
asked 57 minutes ago