Using Excel Total row and Sort & filter options, display the following statistics. Hint: You will...

 

Transcribed Image Text:

Using Excel Total row and Sort & filter options, display the following statistics. Hint: You will need to change your data to a table format. Enter your answers/formulas in cells M2:M4 on the Customer Survey sheet. (Show your results with zero decimal places) Average age of Undisclosed Gender in Owen Sound who spent money on Gaming. Create a header to include your First and Last Name on the left, the answer to question (a) on the right and the current date filed in the center, on the Customer Survey worksheet. Average age of males likely to purchase games in the city found to have the highest population. Average age of all genders in all locations. Using Excel Total row and Sort & filter options, display the following statistics. Hint: You will need to change your data to a table format. Enter your answers/formulas in cells M2:M4 on the Customer Survey sheet. (Show your results with zero decimal places) Average age of Undisclosed Gender in Owen Sound who spent money on Gaming. Create a header to include your First and Last Name on the left, the answer to question (a) on the right and the current date filed in the center, on the Customer Survey worksheet. Average age of males likely to purchase games in the city found to have the highest population. Average age of all genders in all locations.