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
Home loans typically involve "points," which are fees charged by the lender. Each point charged means that the borrower must pay
nirvana33 [79]

Answer:

Ans. The effective annual interest rate charged on the loan is 12.99% effective annually. (Please see the attached excel spread sheet)

Explanation:

Hi, attached is the amortization table that I made for this case. Notice that there is a yellow and green cell, the yellow one is the result of using the "IRR" function of MS Excel which provides an effective monthly rate, since the payments are made every month, then we have to transform that monthly effective rate into an effective annual rate, this is the formula to use.

EffectiveAnnual=(1+EffectiveMonthly)^{\frac{1}{12} } -1

That is:

EffectiveAnnual=(1+0.012267477)^{\frac{1}{12} } -1=0.12986448

Which we round to 12.99% effective annually.

Finally, notice that I didnt use the payments to find the effective rate, I used the cash flow, that was because you didn´t receive all the 100K (the fee, remember?), you received $98,000.

Best of luck.

Download xlsx
3 0
3 years ago
Ms. Pay, who has a 40.8 percent marginal tax rate on interest income (37 percent income tax 3.8 percent Medicare contribution ta
Butoxors [25]

Answer:

After tax cash flow    $44,281.60

After tax cash flow   ($30,518.40)

After tax cash flow   $8856.32

Explanation:

In the first case when the interest income of $74,800 ,the after-tax cash flow would be taxed as follows"

before tax cash flow   $74,800.00

tax at 40.8%*$74,800 ($30,518.40)

After tax cash flow      $44,281.60  

If the entire interest income is re-invested after tax cash flow is computed thus:

before tax cash flow   $0

tax at 40.8%*$74,800 ($30,518.40)

After tax cash flow      ($30,518.40)

If the entire interest income represents the original  issue discount,which is the difference between the face value and the issue price,after tax cash  flow is computed thus:

The OID is taxable as if it accrues over the duration of the investment(bonds),hence a portion of the OID would be assessed to tax each year (assume the duration of investment is 5 years)

Annual portion of OID=$74,800/5

before tax cash flow    $14,960 .00

tax at 40.8%*$74,800  ($6103.68 )

After tax cash flow         $8856.32

After tax cash flow      $44,281.60  

3 0
3 years ago
While working in the yard, Tina found a beat-up ring. Becca, an eighteen-year old neighbor, came over to visit and liked the rin
andreev551 [17]

Answer:

The correct answer is letter "B": A gift inter vivos.

Explanation:

A gift inter-vivos refers to the transfer of a property from one party to another while the donor is alive. This transfer must be celebrated through a written agreement providing the beneficiary absolute ownership of the property. In such a case, the donor cannot request the property back and gives up any right over it.

The beneficiary must accept the gift for the transfer to be complete and if the property has value, the beneficiary will accept it as well.

<em>The issue between Tina and Becca relies on not having signed any document for the transfer of the diamond ring but they are involved in an inter-vivos gift.</em>

8 0
3 years ago
Which type of scientific statement is defined as a hypothess D
Lilit [14]
A hypothesis is a educated guess made about the predicted outcome of the experiment. They are made before starting the scientific experiment.
4 0
3 years ago
Read 2 more answers
General Mills and Nestlé work together to distribute General Mills products in about 140 international markets from Mexico to Ch
Flura [38]

Answer: a strategic channel alliance

                                   

Explanation: In simple words, strategic alliance refers to a business arrangement in which two organisations combine their resources for their mutual benefits.

Under such an arrangement two organisation agrees to combine their activities and efforts for a particular objective but still remain independent as two separate entities.

Such alliances are generally evident in situation where companies wants to exploit foreign markets. Hence from the above we can conclude that the arrangement between general mills and nestle is a strategic alliance.

5 0
3 years ago
Other questions:
  • The profile of five partnerships firms
    6·1 answer
  • Macroeconomics Which of the following statements is true? a. A college degree does not influence the earnings of workers. b. The
    5·1 answer
  • Big AD and AS general equilibrium system (2 points): Assume that the short-run equilibrium output and price combination Yeq,Peq
    13·1 answer
  • Mrs. Arnold is spending all her money income by buying bottles ofsoda and bags of pretzels in such amounts that the marginal uti
    10·1 answer
  • A flower distributor asked the Fresh Farms sales representative if the company had any red roses in stock. The sales representat
    14·1 answer
  • Explain the following sentence when thinking about the international data Electra bikes is using to run its business. It is neve
    6·1 answer
  • Stan is a real estate broker in Colorado. He has identified a property for a fast food outlet and has asked four friends to cont
    6·2 answers
  • In Los Angeles County, the median price rose 0.5% to $618,000 in June and sales fell 12.1%.
    11·1 answer
  • What is yall favorite song minez is mood swings by pop smoke
    15·2 answers
  • A retirement account in which investments are not tax-deferred but can be
    6·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!