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]
3 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]3 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 American business had a monopoly on the fur trade in the Far West?
navik [9.2K]
C. John Jacob Astor.

The American business that had a monopoly on the fur trade in the far west was founded by John Jacob Astor.

The business was called American Fur Company. Since it was founded, the company grew to monopolize the fur trade in the United States by 1830. It became one of the largest and wealthiest businesses in the United States.
7 0
3 years ago
Tru or false? the older traditional form of management structure is the horizontal organization
Tamiku [17]
The answer is false.
7 0
3 years ago
Review your pre and post scores from "Where Are You Now." Did your scores improve? What activities did you complete that facilit
DIA [1.3K]

Answer:

what do you mean did our scores improve, if so, idk yet

3 0
3 years ago
1. Ira Schwab opens up a Schwab IRA and places $2,000 in his retirement account at the beginning of each year for 10 years. He b
s2008m [1.1K]

Answer:

He will have $102,979 in his retirement account in 10 years.

Explanation:

Annual Payment = $2,000

Number of Year = n = 10

Interest rate = i = 5%

Compounded Quarterly

Future value after 10 years

FV = A [ ( ( 1 + ( r / m )^mt ) - 1 / ( r / m )

FV = $2,000 [ ( ( 1 + ( 0.05 / 4 )^40 ) - 1 / ( 0.05 / 4 )

Future value = $102,979

So, Ira Schwab will have $102,979 in his retirement account in 10 years.

5 0
3 years ago
A depositor places $10,000 in cash in a commercial bank, where the required reserve ratio is 10 percent. The bank sends the $10,
garik1379 [7]

Answer:

C) $10,000, $1,000, and $9,000, respectively.

  • actual reserves increase by $10,000
  • required reserves increase by $1,000
  • excess reserves increase by $9,000

Explanation:

the money deposited by the client = $10,000

bank's reserve ratio is 10% = $10,000 x 10% = $1,000

since the bank kept the whole $10,000 as reserves, then:

  • actual reserves increase by $10,000
  • required reserves increase by $1,000
  • excess reserves increase by $9,000

The bank is only required to keep $1,000 in reserves, this means it can borrow the remaining $9,000 whenever they want.

7 0
3 years ago
Other questions:
  • Example 1: Your manager enters your office with receipts from a restaurant and bar and asks for reimbursement. The manager claim
    12·1 answer
  • Rick took his family to a major league baseball game. he gave his son $100 to buy food and drinks for the group. hot dogs cost $
    11·1 answer
  • On July 9, you purchased 600 shares of Blue Water stock for $32 a share. On August 4, you sold 100 shares of this stock for $33
    5·1 answer
  • Which is true regarding elasticity of supply ?
    7·1 answer
  • An entity entered into a contract to construct a building. Based on the contract’s terms, the entity appropriately determined th
    12·1 answer
  • Given the following cost and activity observations for Smithson Company’s utilities, use the high-low method to calculate Smiths
    14·1 answer
  • Suppose your company reports $210 of net income and $50 of cash dividends paid, and its comparative balance sheet indicates the
    8·1 answer
  • Mattress​ Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last​ year, cost of goods sold was ​$7
    5·1 answer
  • Zook Manufacturing's total six-month sales were $85 million, with $25.5
    5·1 answer
  • What is the future value of a 500 annuity payment over wight years if interest rates are 14 percent?
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!