1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
mrs_skeptik [129]
3 years ago
6

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 Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = + TVAdv Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = + TVAdv + NewsAdv Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? Predict weekly gross revenue for a week when $4.9 thousand is spent on television advertising and $3.9 thousand is spent on newspaper advertising (to 2 decimals)?
Business
1 answer:
hoa [83]3 years ago
5 0

Answer:

The predicted value of Revenue is $98.24.

Explanation:

The data provided is for the weekly gross revenue, the amount of television advertising and the amount of newspaper advertising.

Determine the regression equation developed to estimate the amount of weekly gross revenue based on television advertising using Excel.

Consider the Excel image for Summary Output for Weekly Revenue Vs. T.V. Adv.

The estimated regression equation with the amount of television advertising as the independent variable is:

<em>Revenue </em>= 89.31 + 1.27 <em>TVAdv</em>

Consider the Excel image for Summary Output for Weekly Revenue Vs. T.V. Adv. & News Adv.

The estimated regression equation with both television advertising and newspaper advertising as the independent variables is:

<em>Revenue </em>= 83.78 + 1.78 <em>TVAdv</em> + 1.47 <em>NewsAdv </em>

For TVAdv = $4.9 and NewsAdv = $3.9 predict the value of Revenue as follows:

\text{Revenue} = 83.78 + 1.78\ \text{TVAdv} + 1.47\ \text{NewsAdv}

             =83.78 + (1.78 \times 4.9) + (1.47 \times 3.9)\\\\=98.235\\\\\approx 98.24

Thus, the predicted value of Revenue is $98.24.

You might be interested in
About how many federal law enforcement offices ate employed in the United States
koban [17]

Answer:

Approximately 18,000

Explanation:

6 0
2 years ago
Read 2 more answers
What are static, routine, daily business processes such as stocking inventory, checking out customers, or daily opening and clos
denis23 [38]

Answer:

operational business processes

Explanation:

The processes carried out within a company are divided into:

  • operational business processes: carried out by entry level employees and includes routine daily business processes
  • tactical or managerial business processes: carried out by lower management or supervisors and includes semi-routine monthly business processes
  • strategic business processes: carried out by upper management and includes dynamic, non-routine long-term business decision processes

6 0
3 years ago
Pina Corporation entered into an operating lease agreement to lease equipment from Badger, Inc. on January 1, 2017. The lease ca
posledela

Answer:

= $80,273

Explanation:

Value of the right of use asset = Value of lease liability - cash incentive received + costs incurred for lease

                  = $82,773 -$ 6,000 + $3,000 + $500

                     =$80,273

4 0
3 years ago
There is little relationship between CSR behaviors and consumer reaction to the products and services of the firm according to s
Korvikt [17]

Answer: false

Explanation:

CSR behavior are simply behavioral aspects of CSR. According to the definition of corporate social responsibility, companies should conduct their business in a way that gives back to the society at large.

The statements that there' little relationship between CSR behaviors and consumer reaction to the products and services of the firm according to survey results listed in the Harvard Business Review is not true.

8 0
3 years ago
This table can be used to organize Gigi’s credit card balances and payments over 6 months. The annual percentage rate on the cre
Alchen [17]

Answer:

-16.34

Explanation:

  • Disclaimer: I am not sure, sorry. It might be -16.34, 16.34, or 15.75. Once again, sorry.
8 0
2 years ago
Read 2 more answers
Other questions:
  • A local partnership is liquidating and is currently reporting the following capital balances: LO 15-1 LO 15-1 LO 15-3 LO 15-3 Ba
    11·1 answer
  • A company uses proprietary computer software to offer services that other companies have not been able to emulate. These service
    8·1 answer
  • The owner and a property manager sign a property management agreement. The property manager advertises the property, shows the r
    6·1 answer
  • 1. Match the following terms with the options given in below:
    11·1 answer
  • In fiscal 2016, Microsoft Corp. reported a statutory tax rate of 35% and an effective tax rate of approximately 15%. The 2016 in
    14·1 answer
  • In a statement of approximately 75 words explain why the economic systems in countries with dictatorships or closed systems of g
    9·1 answer
  • Inflation is undesirable because it: Multiple Choice always makes the nation poorer. redistributes income from those who can rai
    10·1 answer
  • By what authority was the creation and existence of a u. S. National bank deemed legitimate?.
    7·1 answer
  • NAME 2 COSTS/DRAWBACKS OF SETTING UP A FRANCHISE?
    9·1 answer
  • question 5 you're anticipating audience questions, especially one asking how you were able to connect the campaign with the resu
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!