Question: what will be the conclusions? PH 2.EOC.65-E Question Help Golf Galaxy, a major golf equipment retailer, would like to investigate the relationship between the brand

PH 2.EOC.65-E Question Help 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 accompanying data lists the golf club brand purchased by the last 90 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? Hint Group the ages of the customers with a class width of 10 years. Click here to view the data on golf club brands and customer apes. Click here to view the steps for grouping customer.ages. Group the ages of the customers with a class width of 10. Complete the following table. un (Type integers or decimals. Do not round.) Age Callaway Nike 20-29 2 30-39 40-49 50-59 Total 14 3 28 14 5 3 24 Taylor Made 16 8 5 38 Total 22 30 27 11 What conclusions can be drawn about the golf club brand and age of the customer? se Younger golfers (from 20 to 39) tend to prefer Nike clubs. Older golfers (40 and up) tend to prefer Callaway clubs. tend to prefer Nike clubs. tend to prefer Callaway clubs. tend to prefer Taylor Made clubs. have no brand preference. e H inmi mbo rum : Col Pl AL ry 2.EOC.65-E 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 accompanying data lists the golf club brand purchased by the last 90 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? Hint Group the ages of the customers with a class width of 10 years. Click here to view the data on golf club brands and customer.ages. Click here to view the steps for grouping customer.ages. Group the ages of the customers with a class width of 10. Complete the following table. mun (Type integers or decimals. Do not round.) Age Nike 20-29 2 30-39 14 40-49 5 3 Callaway 4 7 14 50-59 3 Total 28 msib What conclusions can be drawn about the golf club brand and age of the customer? mase Younger golfers (from 20 to 30) tend to prefer Nike clubs. Taylor Made 16 9 Total 22 30 27 11 Older golfers (40 and up) tend to prefer Callaway clubs. Question Help have no brand preference. tend to prefer Callaway clubs. tend to prefer Nike clubs. tend to prefer Taylor Made clubs.
Step by Step Solution
3.33 Rating (156 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
