Using the dataset Exercise $1$ Dataset, use Excel functions to answer the questions. The required functions must be used in the Excel file and placed in the cell requested. Just entering the number in the cell will not receive credit.

Arithmetic functions SUM, AVERAGE, MIN, and MAX can be easily used on numeric variables.

a$.$ Using the AVERAGE, MIN and MAX functions, calculate the average, min, and max calories for Wendy's burgers. Place your answers in cells Q$3,$ Q$4,$ and Q$5.$

b$.$ Which burger from Wendy's has the most calories? Type your answer in cell Q$7.$

c$.$ Using the SUM function, what is the total calories for Wendy's burgers. Place your answer in cell Q$9.$

The IF function can be used in a number of ways using a logical argument. It makes identifying differences or relationships easy.

a$.$ Using the IF function, identify which burgers for all the restaurants is greater than $25$ grams of total fat. In column N$,$ mark the burgers greater than $25$ grams total fat "Yes" and the burgers that are less than $25$ grams mark as $"$No$".$

The functions AVERAGEIF, SUMIF, and COUNTIF allow you to set a criterion, such as a specific restaurant.

a$.$ For Breaded Chicken Sandwiches from all the restaurants, use the SUMIF function to determine the total Carbs for these sandwiches. Place your answer in cell Q$11.$

b$.$ For Breaded Chicken Sandwiches, using the COUNTIF function, how many restaurants offer a Breaded Chicken Sandwich? Place your answer in cell Q$13.$

c$.$ For Breaded Chicken Sandwiches, using the AVERAGEIF function, what is the average Carbs for these sandwiches? Place your answer in cell Q$15.$

The functions AVERAGEIFS, COUNTIFS, and SUMIFS allow you to set multiple criteria, such as a specific restaurant and type of food.

a$.$ For Whataburger, use the AVERAGEIFS function to determine the average sodium for the burgers it serves. Place your answer in cell Q$17.$

b$.$ For Wendy's, use the AVERAGEIFS function to determine the average sodium for the burgers it serves. Place your answer in cell Q$19.|$

c$.$ Based on the two average calculations, which restaurant has the highest average sodium in its burgers? Type you answer in cell Q$21.$

Sometimes you may be interested in a particular dimension. You can filter the data to view only the dimension of interest.

a$.$ Filter by type and burgers.

b$.$ Using the MAX function, which restaurant has the burger with the most calories? Place your answer in cell Q$23.$