$1,55\mathrm{.}52$

Applied Lab

In this scenario, you're in charge of two events at the annual County Fair $-$ The giant produce growing contest and the horse race. You've already measured the weight of the submitted produce and the times of the horse racers in their first heat. Now you want to perform some analysis on your data. For the produce contest, you want to find the total weight of each kind of produce, the average weight of each item grown, and the total number of each item submitted. For the horse race, you want to know which racers had a good enough time to qualify for the next round. Perform the following tasks:

On the Giant Produce sheet, use SUMIF, AVERAGEIF, and COUNTIF to complete the table found in $117$:$K19.$

On the Horse Race sheet, create a formula in F$5$ that will return Yes if the race time is less than or equal to the qualifying time and No if the race time is greater than the qualifying time. Instead of typing the qualifying time into the formula, use $H5$ as an absolute reference. When the formula is done, use the fill handle to copy it to F$6$: F$13.$

Sign in

$117$

Accessibility: Investigate

MacBook Pro