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
An entrepreneur establishes a social justice online retail company. The company purchases authentic artwork, jewelry and crafts
Greeley [361]

Answer:

a. Developing a robust marketing program to promote the social justice elements of the business and gain insights into consumer purchasing behavior on the website

Explanation:

In order to sustain the business, the entrepreneur should create a robust marketing program in which he is able to promote the components of social justice and also the behavior of the consumer on the website so that he gets to know how much people are active in his website, what are the problem people are facing, etc

Hence, the correct option is a

3 0
3 years ago
this flight is operated by a partner airline united seat selection and changes are not available for this flight at this time. y
-Dominant- [34]

Partner Airline
Partnerships
between or among airlines are known as airline alliances. Through these partnerships, airlines can pool resources, add or expand partner routes, and even provide the opportunity for customers to accrue and redeem miles through one another's rewards systems.

Main Content
For the spring of 2020, I'm looking into multi-city flights from Seattle to Rome and Rome to Seattle. On Lufthansa, premium economy is not an option for the dates I'm considering. However, I can discover routes flown by Lufthansa on the United website and have the option of choosing premium economy. However, I am unable to choose seats on the United website. It informs me "On this flight, there are no available advance seat assignments on united.com. You can go to the operating airline's website for more information after completing your purchase." I am less than certain that we will truly enter premium economy and may instead wind up in ordinary economy as a result of this. Please share your insights into this kind of reservation! Thanks!

to learn more about Partner Airline
brainly.com/question/15058902
#SPJ4

3 0
1 year ago
What are the two most popular ways people make networking contacts?
Semmy [17]

Answer:

Explanation:

Every contact you meet should lead you to new contacts. That's why it's called networking – just like a net, every connection leads off in two or more directions. Your contacts fall into two groups: those who you immediately know might be able to help you, and those who you don't see any point in talking to.

5 0
2 years ago
The USDA maintains ethanol has an impact on food prices. "Higher ethanol production definitely and directly raises the price of
aleksklad [387]

Answer:

new corn farmers will enter the market and decrease the market price.

Explanation:

In regards to the information provided, it can be said that in a long term perspective if the production of ethanol keeps increasing then new corn farmers will enter the market and decrease the market price. This is because as ethanol production increases, so does the price of corn. This will continue up to a certain point were profitability for farmers is high and many new farmers will enter the market hoping to profit from the corn as well. All these new farmers will drastically increase the production of corn and as the supply of corn rises the prices will begin to fall.

5 0
3 years ago
How many trade schools are there for Avionics Technicians?
Vadim26 [7]
43 colleges offer avionics
3 0
2 years ago
Read 2 more answers
Other questions:
  • You live in a town with 300 adults and 200 children, and you are thinking about putting on a play to entertain your neighbors an
    9·1 answer
  • Suppose that Norway is a small country and currently produces 100,000 board feet of lumber at $600 per 1,000 board feet. Then it
    15·1 answer
  • Lebron james, stephen curry, and other athletes are paid huge sums of money by companies for celebrity endorsements. if endorsem
    6·1 answer
  • You own an art supply store and the total sales in your trading area equal $17,500. your store accounts for $6,000 of the total.
    14·1 answer
  • What is a construction foreman
    12·2 answers
  • The sales and marketing plans are typically developed separately from the aggregate operations plan as a way of cross-checking r
    9·1 answer
  • Rector Corporation is examining its quality control program. Which of the following statements​ is/are correct? I. Rework costs
    9·1 answer
  • Joe and Fred are economists. Joe thinks that the wealthiest 10% of the US population should be taxed a rate higher than the rest
    7·1 answer
  • What is the introduction of management ?​
    7·1 answer
  • The goals of labor unions differ from those of management because employers want more profits and labor wants: Multiple choice q
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!