TurboX is a online video game company that makes three types of video games: action, role play, and sports. It is interested in understanding its millennial customers. By combining the data from its customer database and a customer survey, TurboX compiled a data set that has the following variables: the player’s satisfaction with the online game purchase experience (Satisfaction), the enjoyment level of the game played (Enjoyment), whether the player will recommend the game to others (Recommend), which type of game the player played (Type), total spending on games last year (SpendingLastYear), total spending on games this year (SpendingThisYear), and the date of birth of the player (BirthDate).

a. Bin the total spending on games last year into four equal size groups. Label the groups using numbers 1 (lowest values) to 4 (highest values). How many customers are assigned to group 4? 

b. Bin the total spending on games this year into four equal interval groups. Label the groups using numbers 1(lowest values) to 4 (highest values). How many customers are assigned to group 3? 

c. Bin the total spending on games this year into the following three groups: < 250, between 250 and 500, and > 500. Label the groups using numbers 1 (lowest values) to 3 (highest values). How many observations are assigned to group 2? 

d. Create a new variable called “Difference” that contains the difference between this year’s and last year’s spending on games for the players (i.e., SpendingThisYear - SpendingLastYear). What is the average difference? 

e. Create a new variable called “PercentDifference” that contains the percent difference between this year’s and last year’s spending on games for the players (i.e., (SpendingThisYear - SpendingLastYear)/SpendingLastYear). What is the average percent difference? 

f. Create a new variable “Age” that contains the players’ ages as of January 1, 2019. What is the average age of the players? 

g. Create a new variable “BirthMonth” that contains the players’ birth month extracted from their dates of birth. Which month is the most frequent birth month?

Transcribed Image Text:

Satisfaction Enjoyment Recommend Satisfied High Neutral Very Satisfied High B High ⠀ Neutral Will I Will *** BirthDate 7/30/1992 10/17/1984 I 8/11/1988