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
Assume that you manage a risky portfolio with an expected rate of return of 17% and a standard deviation of 27%. The T-bill rate
Mice21 [21]

Answer:

The slope of the CML = (13% - 7%)/25% = 0.24

Explanation:

Given that:

expected rate of return of 17%

standard deviation of 27%.

The T-bill rate is 7%.

You estimate that a passive portfolio invested to mimic the S&P 500 stock index yields an expected rate of return of 13% with a standard deviation of 25%.

The slope of the CML is

Slope of the CML = (Expected return of Market - Risk free return)/Standard deviation of market

The slope of the CML = (13% - 7%)/25% = 0.24

= (0.13 - 0.07) /0.25

= 0.24

8 0
3 years ago
KLM Corporation's quick assets are $6,123,000, its current assets are $13,440,000 and its current liabilities are $8,144,000. It
galben [10]

Answer:

the acid-test ratio is 0.75 times

Explanation:

The computation of the acid-test ratio is shown below:

We know that

Acid-test ratio is

= Quick assets ÷ current liabilities

= $6,123,000 ÷ $8,144,000

= 0.75 times

Hence, the acid-test ratio is 0.75 times

basically we divided the quick assets from the current liabilities so that the acid-test ratio could come

8 0
3 years ago
What does a formula do in a spreadsheet program? Apex
inessss [21]

A formula helps you understand the problem better!!!

4 0
3 years ago
Read 2 more answers
Read the passage. Then answer the question that follows. Nikia designs and produces board games that she sells online. She forme
liberstina [14]

I would say the C. is the correct answer, because if the 3D Printer prints the pieces faster, the games are sold more frequently. I hope this helps, and that it makes sense to you.

6 0
3 years ago
Carry the hourly rate and the overtime rate to 3 decimal places and then round off to 2 decimal places (round the hourly rate to
gladu [14]

Answer:

OASDI maximum amount in any financial do change but for the year 2020, the OASDI limit is $137,700

if Carson is getting $2,700 each week

Carson will hit the OASDI limit in   ($137,700/$2,700) weeks = 51 weeks.

Explanation:

6 0
3 years ago
Other questions:
  • Which of the following is NOT a capital component when calculating the weighted average cost of capital (WACC) for use in capita
    12·1 answer
  • Kent Manufacturing produces a product that sells for $64.00 and has variable costs of $35.00 per unit. Fixed costs are $348,000.
    10·1 answer
  • A woman bought acreage but never saw it and did not use it; although, she regularly paid the real estate taxes on it. Without he
    14·1 answer
  • The technical and socio-cultural dimensions of project management are two sides of the same coin. Explain
    11·1 answer
  • Which of the following is not a characteristic of a leader
    6·2 answers
  • Click this link to view O*NET's Tasks section for Actors.
    5·2 answers
  • A ______ inventory turnover ratio may result in a reduction in storage and obsolescence costs as well as reduced borrowing.
    7·1 answer
  • Which best describes the relationship between total utility and marginal utility?.
    7·1 answer
  • In order to successfully carry out an acquisition, the managers at Pink Inc. prepared a list of potential target companies that
    7·1 answer
  • starskeep, inc., is a fast-growing technology company. the firm projects a rapid growth of 40 percent for the next two years and
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!