Question: Problem 2 13 points! Consider the dataset in the Travel2 worksheet. a) Use the IF statement (or the nested [F statement) to fill in column

Problem 2 13 points! Consider the dataset in the Travel2 worksheet. a) Use the IF statement (or the nested [F statement) to fill in column D (Age Group) as follows: Age Age Group Less than or equal to 34 1 More than 34, but less than or equal to 44 2 More than 44, but less than or equal to 54 3 More than 54 4 b} Use the COUNTIF statement to determine the number of people in each age group. Fill in the highlighted sections of the provided table. c) Use a PivotTable to nd the average amount spent on travel by age group. Which age group spends most (on average)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
