Golf Galaxy, a major golf equipment retailer, would like to investigate the relationship between the brand of golf clubs (Taylor Made, Nike, and Callaway) and the age of the golfer who purchased them. The Excel file titled golf clubs. xlsx lists the golf club brand purchased by the last 100 customers along with the customers’ ages. Using Excel, construct a pivot table for these data. What conclusions can be drawn about the golf club brand and age of the customer?
a. After the initial pivot table is constructed, right click on one of the ages.
b. In the drop down menu, left click on Group.
c. In the Group dialog box, input the following values:
1. Starting at = 20
2. Ending at = 59
3. By = 10
d. Click OK.