Please help me I am not able to get a, b, and c. Thank you!

4 1/2.5 points awarded Scored = Print D References TurboX is an 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 the accompanying data file 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). Click here for the Excel Data File a. The variable Satisfaction contains 5 ordered categories: Very Dissatisfied, Dissatisfied, Neutral, Satisfied, and Very Satisfied. Replace the category names with scores ranging from 1 (Very Dissatisfied) to 5 (Very Satisfied). What is the average satisfaction score of the players? Note: Round your answer to two decimal places. Average satisfaction score of the players 3.76 0 b. The variable Enjoyment contains 5 ordered categories: Very Low, Low, Neutral, High, and Very High. Replace the category names with scores ranging from 1 (Very Low) to 5 (Very High). What is the average enjoyment score of the players? Note: Round your answer to two decimal places. Average enjoyment score of the players 4.269 c. The variable Recommend contains 5 ordered categories: Definitely Will Not, Will Not, Neutral, Will, and Definitely Will. Replace the category names with scores ranging from 1 (Definitely Will Not) to 5 (Definitely Will). What is the average recommendation score of the players? Note: Round your answer to two decimal places. Average recommendation score of the players | 3.75@ | d. The variable Type contains 3 unordered game categories: Action, Role Play, and Sports. To facilitate subsequent analyses, transform Type into dummy variables. Use the least frequent category as the reference category. Which category is the reference category? How many dummy variables should be created? AutoSave O A A 5 . CD ... 13: Ch2_Q57_V20_Data_File.xIsx - Read-Only Q Search (Cmd + Ctrl + U) Share Home Insert Draw Page Layout Formulas Data Review View Automate Comments Insert v Calibri (Body) v 11 AA General Ex Delete v $ ~ % 9 Conditional Format Cell D. Sort & Find & Sensitivity Add-ins Analyze Paste BIU BV S DVAv E 00 -20 Formatting as Table Styles Format Filter Select Data 016 - X V fx K M N Q R S U W Satisfaction Enjoyment Recommend Type SpendingLastYear SpendingThisYear BirthDate 2 Very Satisfied Very Low Neutral Role Play 379 661 1/30/92 3 Very Dissatisfied Very Low Will Not Action 400 320 10/17/84 4 Neutral High Definitely Wil Role Play 324 625 9/22/8. 5 Very Satisfied Neutral Will Action 452 150 1/7/88 6 Very Dissatisfied Very High Definitely Wil Action 398 716 11/18/91 Very Dissatisfied Very Low Definitely Wil Sports 168 555 9/6/9 8 Very Satisfied Low Definitely Wil Sports 203 519 11/26/85 9 Very Satisfied Very Low Neutral Sports 252 259 7/14/84 10 Dissatisfied Very Low Will Action 217 475 4/1/9 11 Satisfied High Will Action 288 140 9/26/83 12 Very Satisfied LOW Definitely Wil Action 429 432 10/5/86 13 Very Dissatisfied High Will Not Action 190 166 2/26/96 14 Neutral Low Will Sports 161 237 3/14/92 15 Very Satisfied Very Low Neutral Role Play 406 190 10/7/87 16 Neutral Very High Will sports 426 726 1/6/86 17 Dissatisfie High Definitely Wil Sports 436 125 2/4/90 18 Dissatisfied High Neutral Sports 347 368 9/17/85 19 Very Dissatisfied Neutral Definitely Wil Sports 482 677 5/23/9 20 Neutral Neutral Definitely Wil Sports 324 704 4/1/84 21 Dissatisfied Very Low Definitely Wil Action 380 363 1/1/98 22 Very Satisfied Neutral Neutral Sports 474 569 1/28/91 23 Very Dissatisfied Low Will Not Action 209 172 10/27/82 Dissatisfied Neutral Neutral Action 276 156 3/8/90 25 S High Definitely Wil Action 338 245 9/9/82 26 Dissatisfied Very High Neutral Role Play 220 331 12/27/86 27 Neutral Very High Definitely Wil Action 295 484 10/16/97 28 Very Satisfied Low Definitely Wil Role Play 430 304 9/21/83 29 Satisfied Low Definitely Wil Action 177 322 8/18/97 30 Neutral LOW Neutral Role Play 302 658 1/22/84 31 Very Dissatisfied Low Will Role Play 327 545 9/9/ 94 32 Neutral High Definitely Wil Action 249 215 33 Very Dissatisfied Neutral Definitely Wil Role Play 229 769 10/2/92 34 Neutral LOW Definitely Wil Action 476 634 12/30/82 35 Neutra Very High Definitely Wil Sports 329 638 3/31/84 36 Very Satisfied Very Low Will Not Role Play 284 239 7/25/94 37 Neutral Low Neutral Sport 309 472 6/15/9 38 Satisfied Very Low Will Not Sports 414 448 2/9/95 39 Neutra Very High Definitely Wil Action 264 632 3/10/9 40 Very Dissatisfied Low Will Not Sports 408 154 5/4/85 41 Very Satisfied Neutral Definitely Wil Action 273 772 2/24/90 42 Very Dissatisfied Low Definitely Wil Sports 360 392 3/22/82 43 Very Satisfied Low Will Not Sports 154 120 6/29/84 44 Satisfied Very Low Will Sports 222 719 4/23/87 45 Very Satisfied Neutral Definitely Wil Sports 150 575 5/25/87 Game_Players + - + 100% Ready 1 Accessibility: Good to goAutoSave O n A 5 . CP ... 13: Ch2_Q57_V20_Data_File.xIsx - Read-Only Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Calibri (Body) v 11 AA 27 V General Insert v Ex Delete v $ ~ % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Paste BIU V V Q Mv Av Formatting as Table Styles Format D. Filter Select Data 016 - XV fx H K M N P Q R S U V W X 45 Very Satisfied Neutral Definitely Wil Sports 150 575 5/25/87 46 Very Dissatisfied Very Low Will Not Action 485 563 11/28/95 Neutral High Neutral Role Play 353 247 9/17/94 48 Very Dissatisfied Very High Neutral Action 164 774 10/19/93 49 Very Dissatisfied Very High Neutral Sports 192 641 6/16/90 50 Very Dissatisfied Very High Definitely Wil Role Play 293 370 7/29/8 51 Very Dissatisfied Neutral Will Sports 189 299 1/19/91 52 Very Dissatisfied Neutral Will Role Play 248 250 7/23/83 53 Very Satisfied High Will Action 191 129 9/25/91 54 Very Satisfied High Definitely Wil Sports 316 156 11/23/85 55 Neutral Very High Will Not Sports 289 654 3/27/97 56 Very Dissatisfied Low Definitely Wil Action 220 376 3/23/95 57 S Very Low Will Not Sports 211 344 8/23/83 58 Very Dissatisfied Very Low Definitely Wil Action 332 207 12/6/95 59 Very Satisfied Very Low Definitely Wil Action 193 705 7/8/82 60 Very Dissatisfied Very Low Will Sports 376 507 5/27/92 61 Dissatisfied Neutral Definitely Wil Action 193 294 8/2/96 62 Dissatisfied Very Low Will Action 372 77 4/10/92 63 Neutral Neutral Neutral Action 347 555 3/12/88 64 Satisfied Very Low Definitely Wil Sports 252 270 1/6/94 65 Satisfied Low Definitely Wil Role Play 487 174 7/7/8 66 Very Satisfied Very Low Definitely Wil Role Play 281 494 9/10/97 67 Neutra Neutral Will Not Sports 287 506 3/22/89 68 Very Dissatisfied Very Low Definitely Wil Sports 322 463 5/13/9 69 Dissatisfied Very Low Definitely Wil Sports 234 675 9/13/9 70 Neutral Very Low Will Action 377 438 5/11/98 71 Very Satisfied Very High Neutral Sports 391 300 1/28/9 72 Dissatisfied Low Will Sports 270 471 3/28/8 73 Satisfied Neutral Will Not Action 186 255 9/13/9 74 Dissatisfied Low Will Role Play 243 253 1/24/87 75 Satisfied Very Low Will ole Play 436 627 3/10/9 76 Satisfied High Will Not Action 193 767 9/17/8 77 Dissatisfied Very High Will Not Sports 481 676 9/30/83 78 Dissatisfied High Neutral Sports 374 654 10/31/90 79 Satisfied High Will Not Sports 388 457 1/23/91 80 Satisfied Very High Neutral Action 346 385 12/2/90 81 Dissatisfied Neutral Will Not Sports 358 410 1/14/94 82 Neutral Neutral Neutral Sports 197 329 8/9/88 83 Very Dissatisfied Hig Will Not Action 344 201 9/10/92 84 Very Dissatisfied Very High Neutral Action 388 143 9/17/92 85 Very Satisfied Neutral Will Action 215 780 5/17/86 86 Very Satisfied Very High Definitely Wil Sports 449 547 4/1/83 87 Satisfied Neutral Will Action 220 211 1/6/95 88 Satisfied Very High Definitely Wil Sports 244 139 5/19/96 89 Satisfied Very High Definitely Wil Action 464 571 10/13/88 Game_Players + 100% Ready 1 Accessibility: Good to go - +AutoSave O n A 5 . CD ... Ch2_Q57_V20_Data_File.xIsx - Read-Only Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Insert v Calibri (Body) v 11 AA 27 V General Ex Delete v Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Paste BIUVE By Av $ ~ % 9 Formatting as Table Styles Format D . Filter Select Data 016 X V fx W G K M N P Q R S U X 59 Very Satisfied Very Low Definitely Wil Action 193 705 1/8 /82 60 Very Dissatisfied Very Low Will Sports 376 607 5/27/92 61 Dissatisfied Neutral Definitely Wil Actio 193 294 8/2/96 62 Dissatisfied Very Low Will Action 372 377 4/10/92 63 Neutral Neutral Neutral Action 347 555 3/12/88 64 S Very Low Definitely Wil Sports 252 270 1/6/94 Satisfied Low Definitely Wil Role Play 487 174 7/7/85 66 Very Satisfied Very Low Definitely Wil Role Play 281 494 9/10/97 67 Neutral Neutral Will Not Sports 287 506 3/22/89 68 Very Dissatisfied Very Low Definitely Wil Sports 322 463 5/13/95 69 Dissatisfied Very Low Definitely Wil Sports 234 675 9/13/93 70 Neutral Very Low Will Action 377 438 5/11/98 71 Very Satisfied Very High Neutral Sport 391 300 1/28/98 72 Dissatisfied Low Will Sports 270 471 3/28/ 89 73 Satisfied Neutral Will Not Action 186 255 9/13/97 74 Dissatisfied Low Will Role Play 243 253 1/24/8 75 Very Low Will Role Play 436 627 3/10/96 76 Satisfied High Will Not Action 193 767 9/17/89 77 Dissatisfied Very High Will Not Sports 481 676 9/30/83 78 Dissatisfied High Neutral Sports 374 654 10/31/90 79 Satisfied High Will Not Sports 388 457 1/23/91 80 Satisfied Very High Neutral Action 346 385 12/2/90 81 Dissatisfied Neutral Will Not Sports 358 410 1/14/94 82 Neutral Neutral Neutral Sports 197 329 8/9/ 8 8 83 Very Dissatisfied High Will Not Action 344 201 9/10/92 84 Very Dissatisfied Very High Neutral Action 388 143 9/17/92 85 Very Satisfied Neutral Will Action 215 789 6/17/86 86 Very Satisfied Very High Definitely Wil Sports 449 547 4/1/83 87 Satisfied Neutral Will Action 220 211 1/6/95 8 8 s Very High Definitely Wil Sports 244 139 5/19/96 89 Satisfied Very High Definitely Wil Action 464 571 10/13/88 90 Dissatisfied Neutral Definitely Wil Sports 377 152 9/25/95 91 Satisfied Neutral Will Action 170 588 1/26/93 92 Dissatisfied Very Low Neutral Action 191 605 3/11/83 93 Neutral Very High Neutral Sports 180 621 11/21/95 94 Satisfied Neutral Definitely Wil Action 228 326 12/19/97 95 Satisfied Very High Neutral Sports 303 729 8/14/88 96 Dissatisfied Low will Sports 179 293 5/29/8 97 Very Dissatisfied Very Low Definitely Wil Sports 471 420 10/14/8 98 Very Satisfied Very High Will Not Action 464 598 3/18/9 99 Satisfied Neutral Definitely Wil Action 492 214 1/15/84 100 Very Dissatisfied Low Will Sports 325 309 6/3/84 101 Very Dissatisfied Very Low Neutral Role Play 244 635 8/11/88 102 103 Game_Players + 100% Ready Accessibility: Good to go - +