Need assistance with properly building a regression model in excel. I am using the data in the screenshots attached.

1. Model Building

• Develop an Initial regression model, including output and the residual plot
• Sketch of regression work
• Describe the steps you took in the analysis and why you took.

1. Final Model Analysis

• Final fitted regression model, including output and the residual plot
• Interpretation of your model choice and intuition about what the output means
• Explain slope values,R2 values, p-values, etc. [Also: If the R2 is not very high, why do you think that is?
• Relevant example to interpret the regression equation, using either an observation from your actual dataset or a separate, but meaningful set of input values.
• Post-regression recommendations
• What recommendations would you have for improving the model?

Excel File Edit View Insert Format Tools Data Window Help 60 C / -1 RPM (1) $ 2 Q 2 4 Sun Dec 13 6:24 PM .. . AutoSave . OFF ~ HE. 6 0 . Video_Games_Sales_2016_Edge Gruope_JMP Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Cut Helvetica Neue ab Wrap Text v General Norma Bad Good AutoSum v A [ Copy Fill Paste B U E Merge & Center v $ ~ % " Conditional Forma Neutral Calculation Check Cell Insert Delete Format Sort & Format Formatting as Table Clear v Find & ideas Create and Share Filter Select Adobe PDF N34 X V fx A B C D E F H K L M N O Name -1 Platform Platform-DUMMY Genre-DUMMY Global_Sal Critic_Score Critic_Count User_Score User_Count Rating-DUMM 7 Days to Die PS4 2 0.14 45 16 5.9 140 3 7 Days to Die XOne 0.05 35 17 5.2 74 3 4 Aegis of Earth: Protonovus Assault PS4 0.03 57 11 7.8 94 5 Agatha Christie's The ABC Murders PS4 0.03 67 - N - 17 6.2 124 6 Anima - Gate of Memories PS4 0.02 52 13 7.9 34 4 Assassin's Creed The Ezio Collection PS4 0.2 72 32 7.4 49 3 8 Assassin's Creed The Ezio Collection XOne 0.08 74 13 7.6 24 3 Battleborn PC 0.08 69 34 6.9 400 4 Battleborn PS4 0.26 68 55 6.8 402 4 Battleborn XOne 0.15 71 20 7.2 171 4 Battlefield 1 PC 0.38 8 8 54 7.6 1137 3 Battlefield 1 PS 4.08 8 8 31 3.4 809 3 Battlefield 1 XOne 2.25 87 37 8.2 140 3 Battlezone PS4 7 31 4 - 00 00 00 W 00 00 - 60 00 00 00 00 00 - - 0.04 66 39 BioShock The Collection PS4 0.37 84 39 8.5 210 3 BioShock The Collection XOne .16 84 16 8.3 79 3 BlazBlue Central Fiction PS4 0.08 85 21 7.6 39 4 Call of Duty: Infinite Warfare PC 0.14 73 16 3 440 3 20 Call of Duty: Infinite Warfare PS4 4.46 77 82 3.4 1129 3 Call of Duty: Infinite Warfare XOne 2.42 78 17 3.1 290 3 22 Carmageddon: Max Damage PS4 0.01 51 28 5.5 39 3 23 Carmageddon: Max Damage XOne 0.02 52 15 7.1 12 3 24 Dark Souls Ill PC . N W N W N - W N - N W N - N N W N W N N - W N W N - N W N N W N - W N - W N N N NG 0.07 89 56 3.6 1848 3 25 Dark Souls III PS4 1.65 89 8.8 940 3 26 Darksiders: Warmastered Edition PS4 0.02 79 8.5 15 3 27 Darksiders: Warmastered Edition XOne 0.01 80 7.9 143 28 Dead Island Definitive Collection PS4 0.14 63 6.4 15 3 29 Dead Island Definitive Collection XOne 0.05 67 4.9 18 3 30 Dead Rising PS4 0.04 78 5.6 30 3 31 Dead Rising 2 PS4 0.03 82 6.6 8 3 32 Deus Ex: Mankind Divided PC 0.03 83 6.1 684 3 33 Deus Ex: Mankind Divided PS4 0.38 84 59 7.6 511 3 34 Deus Ex: Mankind Divided XOne 0.17 83 18 7.2 175 3 35 Digimon Story: Cyber Sleuth PS4 0.11 75 45 8.5 289 4 36 DIRT Rally PC 0.03 86 33 3.7 288 1 37 DIRT Rally PS4 0.37 85 46 8.1 196 1 8 DIRT Rally XOne 0.12 86 17 60 1 39 Dishonored 2 PC 0.12 86 37 383 3 40 Dishonored 2 PS4 0.64 88 56 7.7 569 3 Dishonored 2 XOne 0.22 88 22 6.8 156 3 42 Dragon Ball: Xenoverse 2 PS4 0.71 73 54 7.8 17 4 43 Dragon Ball: Xenoverse 2 XOne 0 .2 73 7.3 29 4 44 EA Sports UFC 2 PS4 10 0.93 79 38 6.2 157 4 45 EA Sports UFC 2 xOne 10 0.41 76 77 4 2016 Clean Data_Regression + 140%Excel File Edit View Insert Format Tools Data Window Help 57 C /-1 RPM 1) $ 2 Q 2 4 Sun Dec 13 6:24 PM .. . AutoSave . OFF ~ H E . 6 0 . Video_Games_Sales_2016_Edge Gruope_JMP Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments AutoSum v A X Cut Helvetica Neue 10 ab Wrap Text v General Norma Bad Good 4 [ Copy Fill Conditional Format Neutral Calculation Check Cell Insert Delete Format Sort & Find & ideas Create and Share Paste B E Merge & Center $ ~ % " Formatting as Table Clear v Select Adobe PDF Format U Filter N34 X v fx D F H L M A G N B C E K O 1 Name -1 Platform Platform-DUMMY Genre-DUMMY Global_Sal Critic_Score Critic_Count User_Score User_Count Rating-DUMM 4 EA Sports UFC 2 PS4 2 10 0.93 79 38 6.2 157 4 XOne 10 0.41 76 42 6 77 4 45 EA Sports UFC 2 NC 2 0.07 72 31 46 Eagle Flight PS4 7.8 22 2 47 Far Cry: Primal PC 0.16 74 18 4.8 368 3 48 Far Cry: Prima PS4 2.26 76 91 6.3 635 3 49 Far Cry: Primal XOne 0.88 77 27 6.4 94 3 CO - PC 0.65 64 5 8 20 1 50 Farming Simulator 17 51 Farming Simulator 17 PS4 g 0.41 69 17 8.7 12 1 PC 10 12 4.2 160 1 52 FIFA 17 0.12 84 5 398 1 53 FIFA 17 PS4 10 7.59 85 41 54 FIFA 17 XOne 10 2.65 84 50 5.5 201 1 55 Homefront: The Revolution PC 0.04 54 3.5 284 3 3.8 56 Homefront: The Revolution PS4 0.35 48 212 3 xOne 0.14 49 4.1 106 3 57 Homefront: The Revolution CO 6 2 58 Just Dance 2017 KOne 0.04 75 7 87 2 59 LEGO Marvel's Avengers PS4 0.73 71 O LEGO Marvel's Avengers XOne 0.35 71 5.1 15 2 - N- N - - - - A C0 00 09 7.5 91 2 61 Lego Star Wars: The Force Awakens PS4 0.7 78 0 . 3 76 18 2 62 Lego Star Wars: The Force Awakens xone 63 Life is Strange PC 0.04 83 3.6 1620 3 64 Life is Strange PS4 0.4 85 3.6 $72 3 XOne 0.13 85 123 3 65 Life is Strange 8.7 PS4 1.75 82 4.9 66 Madden NFL 17 83 1 1.23 83 39 1 67 Madden NFL 17 xone 68 Mafia Ill PC 0.19 63 3.2 881 3 - W N - W N N N W N W N - W N - W N - W N W N - W N W N W W N - W N - N- 69 Mafia Ill PS4 1.81 68 5.1 1147 3 4.6 274 3 70 Mafia III XOne 0.62 67 20 Mirror's Edge Catalyst PC 0.06 74 24 4.4 606 4 Mirror's Edge Cataly PS4 0.35 69 50 4.7 578 4 XOne 0.16 72 46 4.4 266 4 Mirror's Edge Catalyst 52 1 NBA 2K17 PC 0.01 90 6.3 75 NBA 2K17 PS4 1.88 8 8 47 6.7 162 1 NBA 2K17 XOne 1.02 90 17 6.2 91 1 NHL 17 PS4 0.33 78 26 5.8 67 2 XOne 0.24 77 23 4 38 2 78 NHL 17 94 4.5 5096 4 79 No Man's Sky PS4 1.7 71 80 Odin Sphere: Leifthrasir PS4 0.2 87 8.2 1784 PS4 0.35 66 7.8 194 1 One Piece: Burning Blood 82 One Piece: Burning Blood xOne 0.06 60 5.8 12 4 PC 0.53 91 6.8 4052 4 3 Overwatch 1358 4 84 Overwatch PS4 2.14 90 31 6.1 1.06 91 5.6 5 Overwatch XOne 568 4 7.5 86 Plants vs. Zombies: Garden Warfare 2 PC 0.05 82 14 2 81. 87 Plants us. Zombies: Garden Warfare 0 49 112 2016 Clean Data_Regression 140%Excel File Edit View Insert Format Tools Data Window Help 68 C / -1 RPM 1) $ 2 Q 2 4 Sun Dec 13 6:24 PM .. . AutoSave . OFF ~ H E . 6 0 . Video_Games_Sales_2016_Edge Gruope_JMP Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Cut Helvetica Neue ab Wrap Text General Norma Bad Good AutoSum v A [ Copy Fill Paste B Merge & Center v $ ~ % " Conditional Format Neutral Calculation Check Cell Insert Delete Format Sort & ideas Create and Share U E Formatting as Table Clear v Find & Format Filter Select Adobe PDF N34 fx A B C D E F H K L M N O Name 1 Platform Platform-DUMMY Genre-DUMMY Global_Sal Critic_Score Critic_Count User_Score User_Count Rating-DUMM 85 Overwatch XOne 8 1.06 91 18 5.6 668 4 86 Plants vs. Zombies: Garden Warfare 2 |PC 0.05 82 6 7.5 44 2 87 Plants vs. Zombies: Garden Warfare 2 PS4 18 0.49 81 29 7.7 111 2 88 Plants vs. Zombies: Garden Warfare 2 XOne 8 0.48 80 64 8.1 79 2 89 Pro Evolution Soccer 2017 PC 0.02 69 9 3.7 137 1 10 90 Pro Evolution Soccer 2017 PS4 10 0.45 85 61 7 . 6 178 91 Pro Evolution Soccer 2017 XOne 10 0.05 87 12 6.1 84 1 92 Prototype: Biohazard Bundle PS4 1 0.02 48 4 2 53 3 93 Prototype: Biohazard Bundle XOne 0.01 56 4 3.1 143 94 Psycho-Pass: Mandatory Happiness PS4 0.04 72 26 8.3 194 95 Quantum Break PC 0.02 99 14 4.3 539 3 96 Quantum Break XOne 0.56 77 106 6.8 659 3 Resident Evil 6 PS4 0.08 60 19 6.7 94 3 98 Resident Evil 6 XOne 0.05 5.3 34 3 CAN 99 Ride 2 PC 0.01 78 7.9 141 100 Ride 2 PS4 0.05 71 8 12 101 Rocket League PC 0.06 86 20 8.2 580 1 102 Rocket League PS4 0.37 85 8.7 290 1 103 Rocket League XOne 0.24 87 8.3 194 1 104 Song of the Deep PC 0.03 73 6.3 15 1 5 Song of the Deep PS4 0.08 69 7.3 30 06 Song of the Deep XOne 0.06 66 12 6.9 20 1 107 Street Fighter V PC 0.06 74 33 2.9 431 4 W N W N - W N - W N - W N - ( N N N N N - W N - W N - N - W N W - N W N W N - WN. 108 Street Fighter V PS4 0.9 77 80 3.4 221 4 109 Super Dungeon Bros PS4 0.01 42 2.3 7 2 - 0 0 0 00 00 00 00 00 CO V - - 2 00 - W W - - - - - - 09 09 00 00 - - N - - 110 Super Stardust Ultra VR PS4 0.01 66 13 6.2 13 2 111 Sword Art Online: Hollow Realization PS4 0.19 69 32 7.7 52 4 12 Teenage Mutant Ninja Turtles: Mutants in Manhattan PS4 0.09 44 49 5.5 63 4 13 Teenage Mutant Ninja Turtles: Mutants in Manhattan XOne 0.04 55 14 6 38 4 4 The Technomance PC 0.01 56 34 6.8 493 115 The Technomancer |PS4 0.06 60 38 6.7 116 3 116 The Technomancer XOne 0.03 68 12 7.4 55 3 117 Titanfall 2 PC 0.08 85 27 8 488 3 3.4 18 Titanfall 2 PS4 0.75 89 56 704 3 19 Titanfall 2 xOne 0.57 87 31 261 3 120 Tom Clancy's The Division PC 0.41 79 33 5.8 1188 3 121 Tom Clancy's The Division PS4 3.8 80 64 7 2219 3 122 Tom Clancy's The Division XOne 2.16 80 33 6.9 614 3 123 Valentino Rossi: The Game PC 0.01 72 14 1 124 Valentino Rossi: The Game PS4 0.08 75 8 50 1 25 Valentino Rossi: The Game XOne 0.03 74 8.1 7 1 126 Worms: WMD PS4 0.03 78 7.6 19 2 127 Worms: WMD XOne 0.01 75 24 8.1 7 2 128 WWE 2K17 PS4 10 0.6 69 50 88 4 2016 Clean Data_Regression + 140%Excel File Edit View Insert Format Tools Data Window Help 57 C /-1 RPM ) $ 2 Q 2 4 Sun Dec 13 6:24 PM .. . AutoSave . OFF ~ HE. 6 0 . Video_Games_Sales_2016_Edge Gruope_JMP Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Cut Helvetica Neue ab Wrap Text v General Norma Bad Good AutoSum v A [ Copy Fill Paste Format B U E Merge & Center v $ ~ % " Conditional Forma Neutral Calculation Check Cell Insert Delete Format ideas Clear v Sort & Find & Create and Share Formatting as Table Filter Select Adobe PDF N34 X v fx A B C D E F K L M N O Name -1 Platform Platform-DUMMY Genre-DUMMY Global_Sal Critic_Score Critic_Count User_Score User_Count Rating-DUMM 107 Street Fighter V PC 0.06 74 33 2.9 431 4 108 Street Fighter V PS4 2 0.9 77 80 3.4 1221 4 109 Super Dungeon Bros PS4 0.01 42 9 2.3 7 2 10 Super Stardust Ultra VR PS4 0.01 66 13 6.2 13 2 1 Sword Art Online: Hollow Realization PS4 0.19 69 32 7.7 52 4 12 Teenage Mutant Ninja Turtles: Mutants in Manhattan PS4 0.09 44 49 5.5 163 4 113 Teenage Mutant Ninja Turtles: Mutants in Manhattan |XOne 0.04 55 14 6 38 4 14 The Technomancer PC 0.01 56 34 6.8 149 3 15 The Technomancer PS4 0.06 60 38 6.7 116 3 16 The Technomancer XOne 0.03 68 12 7.4 55 3 117 Titanfall 2 PC 0.08 85 27 8 - - -0 0 0 00 00 00 00 00 CO V V V - - V CO - W W 188 3 18 Titanfall 2 PS4 0.75 89 56 3.4 704 3 119 Titanfall 2 XOne 0.57 87 31 8 261 3 120 Tom Clancy's The Division PC 0.41 79 33 5.8 1188 3 W N - W N W N W N - W N - W N - W N - W N N NN 121 Tom Clancy's The Division PS4 3.8 80 64 2219 3 122 Tom Clancy's The Division XOne 2.16 80 33 614 3 23 Valentino Rossi: The Game PC 0.01 72 62 14 1 124 Valentino Rossi: The Game PS4 0.08 75 19 8 50 1 125 Valentino Rossi: The Game XOne 0.03 74 5 8.1 7 1 126 Worms: WMD PS4 0.03 78 23 7.6 192 127 Worms: WMD XOne 0.01 75 3.1 7 2 128 WWE 2K17 PS4 0.6 69 50 6.9 884 129 WWE 2K17 XOne 0.26 68 12 5.5 27 4 130 XCOM 2 PC 0.23 88 104 7.1 1221 4 131 XCOM 2 PS4 11 0.14 88 28 8 116 4 132 XCOM 2 XOne 11 0.05 87 17 8.1 10 4 133 134 135 136 137 138 139 140 142 143 145 146 148 149 150 2016 Clean Data_Regression + 140%