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
Government regulations on credit aim to
stepan [7]

Answer:

A. ensure lenders are rapaid.

6 0
3 years ago
Read 2 more answers
Black Horse deposits $2,000 in cash in his checking account at Bank for the People of West Dakota. The reserve requirement is 25
AfilCa [17]

Answer:

d. $8,000

Explanation:

Reserve requirement = 25% = 0.25

The money multiplier = 1 /Required reserve

The money multiplier = 1/0.25

The money multiplier = 4

The initial deposits = $2,000

The maximum possible expansion of deposits = Initial deposits * The money multiplier  = $2,000 * 4 = $8,000. Thus, the maximum expansion of the money supply possible from the original deposit is $8,000

6 0
2 years ago
etermining Gross Profit During the current year, merchandise is sold for $990,000. The cost of the merchandise sold is $693,000.
otez555 [7]

Answer:

Results are below.

Explanation:

<u>A: To calculate the gross profit, we need to use the following formula:</u>

Gross profit= sales - cost of goods sold

Gross profit= 990,000 - 693,000

Gross profit= $297,000

B: <u>Now, the gross profit percentage:</u>

Gross profit percentage= (gross profit / sales)*100

Gross profit percentage= (297,000 / 990,000)*100

Gross profit percentage= 30%

C: F<u>inally, a net income is reported in the income statement at the moment of the sale</u>. It doesn't matter if the sale was paid or not.

6 0
2 years ago
Assume a company's current ratio and acid-test ratio are less than 1.0 before it purchases inventory on credit. When it makes th
I am Lyosha [343]

Answer: b. Its quick ratio decreases.

Explanation:

The Quick ratio is calculated net of inventory to determine if a company can cover its current liabilities with its more liquid current assets. The formula is to subtract Inventory from the Current Assets and then divided that by the Currency liabilities.

The Quick ratio will be less than before because the number of current assets will not change but the amount of current liabilities will change as the goods were purchased on credit. With a larger denominator, the resultant ratio will be less than before.

7 0
3 years ago
Teams have better communication than other workers because they get to ______. A. Know each other better b. Attend communication
nadya68 [22]

A. Know each other better

Team refers to a group of people who come together to carry out interdependent task whilst also accomplishing a common mission or specific objective.

Team comprises individuals or employees who have complementary skills, knowledge and experience needed to execute a project successfully.

When a person is working in a team, he or she has the privilege of interacting with other team members hence create performance and strengthen the level of relationship amongst them.

It therefore means that teams have better communication than other workers because they get to know each other better in the course carrying out their duties.

learn more at : brainly.com/question/19724748

7 0
2 years ago
Other questions:
  • The epa tries to balance protecting business interests with protecting
    10·2 answers
  • Many small businesses choose to outsource their payroll activities to firms that specialize in providing payroll services. Dolor
    5·1 answer
  • Herb Company manufactured more product than it was able to sell during the current year. If the salaries of the sales staff of H
    13·1 answer
  • ​If, in the long​ run, real GDP returns to its potential​ level, then in the long​ run, A. the Phillips curve represents a struc
    11·2 answers
  • Explain the difference between implicit and explicit costs
    11·1 answer
  • Bob is a recognized french horn player. Bob has played for several major symphonies. Last year Bob went through bankruptcy and i
    15·1 answer
  • What is the step by step process of making money in the united states?
    14·1 answer
  • Refer to the following lease amortization schedule. The 10 payments are made annually starting with the beginning of the lease.
    5·1 answer
  • Monroe Minerals Company purchased a copper mine for $122,000,000. The mine was expected to produce 50,000 tons of copper over it
    15·1 answer
  • Like other limited liability companies, for federal jurisdictional purposes, Rodeo Productions LLC is most likely a citizen of
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!