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
EastWind [94]
2 years ago
7

In the "Input Analysis" section of the spreadsheet model, calculate the correlations between the sales of each type of product a

nd event attendance. Use appropriate ranges from the "Past Event" worksheet for your calculations.
Business
1 answer:
rodikova [14]2 years ago
7 0

Answer:

The correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

Explanation:

To calculate the correlation between the sales of each kind of product and event attendance, from the Input analysis part of the spreadsheet model.

According to the information provided, in the targeted cell, we will use formula

=Average(data cells)

and for other part of the question is to calculate sales. For this part we can simply use the sum formula, first, we will sum the sales for a single item in past events column than at the end of the past column.

Thus, the correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

You might be interested in
What is the primary characteristic that differentials a zero based budget from a conventional budget. A. A zero based budget doe
Oksana_A [137]

Answer:

B. The zero based budget requires managers to re-justify every planned expenditure every year.

Explanation:

A zero based budget is one that does not take into account historical data when it is considering the present year budget. Each departmental requirement is re-evaluated and a new amount is assigned as budget for the year.

However conventional budgets carryover the previous year's expenses as a base data point. This results in similar budgeting across years.

So the main difference between the two is that zero based budget requires managers to re-justify every planned expenditure every year.

8 0
3 years ago
If you want to know whether a company had a profit or a loss during a specific period of time, which financial statement would b
rosijanka [135]

Answer:

The answer is D. Income statement

Explanation:

5 0
2 years ago
The inventory data for an item for November are:a. Nov. 1: Inventory 20 units at $19b. Nov. 10: Purchased 30 units at $20c. Nov.
Zigmanuir [339]

Answer:

the cost of the merchandise sold for November if the company uses LIFO is c. $590

Explanation:

LIFO Inventory System sells the Inventory recently acquired first followed by the Older Inventory Acquired.

<u>Cost of the merchandise sold for November - Calculation</u>

November 4 : 10 units × $19    =$190

November 17 : 20 units × $20 =$400

Total                                          =$590

4 0
2 years ago
Read 2 more answers
which of the following is not a requirement of the unlimited marital deduction? a.in order to claim a marital deduction on the 7
tamaranim1 [39]

The gross value of qualifying property left to the surviving spouse is included in the marital deduction. This is not a requirement of the unlimited marital deduction.

Hence, option D is the correct answer.

Unlimited marital deduction is a clause that enables a person to give their spouse limitless property at any time. This clause belongs to the federal estate of the United States. No limitation on the transfer of property is imposed.

There is no requirement for the gross value of the property that is kept for the surviving spouse under the unlimited marital deduction.

Option a is wrong because a husband and wife must be married in order to qualify for the unlimited marital deduction, this choice is incorrect.

Option b is improper since the property should be passed to the spouse through real estate under unlimited marital deductions.

Option c is erroneous because, in order to qualify for the unlimited marital deduction, the surviving spouse must be a citizen of the United States.

To know more about unlimited marital deduction: brainly.com/question/17983054

#SPJ4

5 0
1 year ago
During the year, Sophie (a self-employed marketing consultant) went from Omaha to Lima (Peru) on business. She spent four days o
baherus [9]

Answer:

e. None of these.

Explanation:

The deductible expenses are expenses that are wholly, necessarily and exclusively for business purpose. This excludes the entertainment cost which is the only avoidable cost in the classes of cost given.

Hence, Sophie's deductible expenses are

= $3,000 + $800 + $600

= $4,400

4 0
3 years ago
Other questions:
  • Business writers prefer the active voice because in active-voice sentences the __________. a. subject is the recipient of the ac
    11·1 answer
  • The article describes many ways you can communicate supportively by being assertive. Consider the following defensive comment "Y
    7·2 answers
  • A company decides on the worth of a product, keeping in mind the disposable income of customers
    7·1 answer
  • Currently, at a price of $1 each, 100 popsicles are sold per day in the perpetually hot town of Rostin. Consider the elasticity
    11·1 answer
  • Which one of the four Ps of the Marketing Mix signifies and communicates how the product will reach the end-user (Customer/Consu
    5·1 answer
  • Galvin grew up on a farm. He worked on his father’s farm and then inherited the business when his dad retired. For which career
    7·2 answers
  • Omar is covered by a disability income policy. he is hurt while performing an occupation more hazardous than the occupation list
    11·1 answer
  • Question 1 (2 points)
    14·1 answer
  • How do occupancy rate and potential gross rate relate​
    11·1 answer
  • Louise works for a tax firm that caters to individuals and small businesses. Each year when tax season rolls around, the firm is
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!