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
Roxanne has developed a new adult milk beverage that is enhanced with vitamins. there has never been a product like this before
KIM [24]
For the answer to the question above, I think that
Roxanne is likely to use the <u><em>"Test market"</em></u> <span>method to forecast demand. </span>
I hope my answer helped you. Have a nice day!
8 0
3 years ago
Which payment option takes money out of your bank immediately?.
Oduvanchick [21]

Answer:

auto pay takes money out automatically

3 0
3 years ago
25 points --
Ilia_Sergeevich [38]

Answer:

1 and 3 or A and C

Explanation:

I did it on edgnuity mark me brainliest

8 0
2 years ago
Fire Chief McGuire could see the problem from a mile away. Flames were leaping out of the old barn, blown by a west wind. Arrivi
EastWind [94]

Answer:

The correct answer is dominating.

Explanation:

Generally, different definitions of "social conflict" are offered, differences that call our attention to complementary aspects of the concept: For example, Stephen Robbins: "A process that begins when one party perceives that another has affected it negatively or that It is about to negatively affect some of its interests ”2 and that of Lewis A. Sew for whom the social conflict is a struggle for values and for the status, power and scarce resources, in the course of which opponents want to neutralize, damage or eliminate their rivals. A conflict will be social when it transcends the individual and comes from the structure of society itself.

4 0
3 years ago
A coupon bond that pays semiannual interest is reported in the Wall Street Journal as having an ask price of 116% of its $1,000
Anna35 [415]

Answer:

$1,174.75

Explanation:

The computation of the invoice price of the bond is shown below:

As we know that

Invoice Price of Bond = Ask Price of Bond + Accrued interest

where,

Ask Price is

= $1,000 × 116%

= $1,160

Interest accrued for 3 months is

= $1,000 × 5.90% × 3 months ÷ 12 months

= $14.75

So,

Invoice Price of Bond is

= $1,160.00 + $14.75

= $1,174.75

3 0
3 years ago
Other questions:
  • Business writing is more forceful if it uses active-voice verbs. Revise the following sentences so that verbs are in the active
    6·1 answer
  • All the following are benefits of attending a community college except that
    13·1 answer
  • If the exchange rate between the dollar and the Swiss franc changes from 1.8 to 1.5 francs per dollar, the franc depreciates and
    5·1 answer
  • A statistical method for identifying cost behavior
    9·1 answer
  • An initial investment amount​ P, an annual interest rate​ r, and a time t are given. Find the future value of the investment whe
    9·1 answer
  • 1) Suppose you wish to retire 35 years from today. You determined that you will need $250,000 per year after you retire, with th
    11·1 answer
  • Last year Harrington Inc. had sales of $325,000 and a net income of $19,000, and its year-end assets were $250,000. The firm's t
    10·1 answer
  • Perfect elasticity and zero elasticity refer to the same event, which occurs when quantity demanded or quantity supplied change
    14·1 answer
  • Please help answer economics questions for 100 points and brainliest
    12·1 answer
  • What is the best way to help students use materials successfully in learning centers?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!