Question

In: Statistics and Probability

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 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
101 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 an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals).

Revenue = _____ + _____ TVAdv + _____ NVAdv

c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)?

[- Select your answer -] Yes, the coefficients are the same/No, the coefficients are not the same

d. Predict weekly gross revenue for a week when $3.6 thousand is spent on television advertising and $1.6 thousand is spent on newspaper advertising?

NOTE: To compute the predicted revenues, use the coefficients you have computed rounded to two decimals, as you have entered them here. Then, also round your predicted revenue to two decimal places.

$______in thousands

Solutions

Expert Solution

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------


Related Solutions

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., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (x1) and newspaper advertising (x2). Values of y, x1, and x2 are expressed in thousands of dollars. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 96 5 1.5 90 2 2    95 4 1.5 92    2.5 2.5 95 3 3.3 94    3.5 2.3...
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. 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...
#1) Use computer software packages, such as Excel, to solve this problem. The owner of Showtime...
#1) Use computer software packages, such as 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. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 105 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 93 3.0 3.3 94 3.5 2.3 94 2.5 4.2 a) Develop an estimated regression equation with the amount of television advertising as the independent variable (to...
#2) Use computer software packages, such as Excel, to solve this problem. Consider the following data...
#2) Use computer software packages, such as Excel, to solve this problem. Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 95 46 11 108 24 18 113 51 16 178 40 6 94 52 19 175 74 8 170 36 12 117 60 14 142 77 17 211 a) If you ran a multiple regression model using both independent variable what would the p-value of the overall...
Use computer software packages, such as Excel, to solve this problem. The Jacobs Chemical Company wants...
Use computer software packages, such as Excel, to solve this problem. The Jacobs Chemical Company wants to estimate the mean time (minutes) required to mix a batch of material on machines produced by three different manufacturers. To limit the cost of testing, four batches of material were mixed on machines produced by each of the three manufacturers. The times needed to mix the material follow. Manufacturer 1 Manufacturer 2 Manufacturer 3 17 29 17 23 27 16 21 32 20...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do NOT use Excel built-in functions or solvers (except t.inv() and f.inv() to obtain critical t and f values). The tensile strength of Portland cement is being studied. Four different mixing techniques can be used economically. A completely randomized experiment was conducted and the following data were collected: Technique Tensile Strength Tensile Strength Tensile Strength Tensile Strength 1 3129 3000 2865 2890 2 3200 3300...
In order to compare two computer software packages, a manager has 15 individuals use each software...
In order to compare two computer software packages, a manager has 15 individuals use each software package to perform a standard set of tasks typical of those encountered in the office. Of course, in carrying out the comparison the manager was careful to use individuals who did not have an established preference of skill with either type of software, and 15 individuals were randomly selected to use software A first while the other 15 used software B first. The time...
In order to compare two computer software packages, a manager has 15 individuals use each software...
In order to compare two computer software packages, a manager has 15 individuals use each software package to perform a standard set of tasks typical of those encountered in the office. Of course, in carrying out the comparison the manager was careful to use individuals who did not have an established preference of skill with either type of software, and 15 individuals were randomly selected to use software A first while the other 15 used software B first. The time...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with sample size, n = 40, mean = 20 and standard deviation = 11. Write the generated data in the following table. Answer: 1 11 21 31 2 12 22 32 3 13 23 33 4 14 24 34 5 15 25 35 6 16 26 36 7 17 27 37 8 18 28 38 9 19 29 39 10 20 30 40 Conduct the...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% 20 through 49 30% 50 through 99 40% 100 or more 50% Create an application that allows the user to enter the number of units sold for each software package. The application should calculate and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT