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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!