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)