Question

In the "Input Analysis" section of the spreadsheet model, calculate the correlations between the sales of each type of product and event attendance. Use appropriate ranges from the "Past Event" worksheet for your calculations.

Answer 1

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)