please solve it as soon as possible I will thumb you up

Problem #6 Using the "true" regression results given in Problem #4, calculate (in cell) each of your players' estimated salary based on their 2018/2019 performance. Create a table containing the results of your calculations like the example below and include it in your Word or .pdf report. Which players on your team were overpaid? Which players on your team were underpaid? For example, for the Utah Jazz (partial numbers from a different season)... Difference (actual - est.) Name 2012/1? Salary Estimated Salary Effect Alec Burks 2020200 2932962 -912762 2574099 -868648 1705451 762195 -1011680 1773875 De Marre Carroll Jeremy Evans Derrick Favors Devin Harris 4443360 5477743 -1034383 9319000 4966966 4352034 underpaid underpaid overpaid underpaid overpaid underpaid underpaid overpaid overpaid underpaid Gordon Hayward 2532960 5650650 -3117690 2150000 4656432 -2506432 Josh Howard Al Jefferson 14000000 11567127 2432873 Enes Kanter 4133280 2516826 1616454 C.J. Miles 3700000 3895287 -195287 G H 811998.11 1379.79 912.48 389371.45 242001.58 202053.54 -179470.49 -64011.95 $1 B2 B3 B4 B5 B6 B7 S S $ S S S S S S S S S S S S S S S Salary Estimated Salary 4,384,616.00 4,279,046.92 19,500,000.00 S 9,186,975.73 26,011,913.00 S 6,479,070.47 4,536,120.00 S 7,388,001.63 4,221,000.00 S 4,619,805.23 20,000,000.00 $ 5,228,373.14 4,441,200.00 S 3.249.922.66 1,349,383.00 S 1,815,223.02 2494.346.00 S 5,346,236.24 1,544,951.00 S 2,342,533.52 14,357,750.00 S 2,712,809.74 1,991,520.00 S 851,648.33 1,311,265.00 S 1,406,026.91 1.544.951.00 S 1,735,278.83 3,263,295.00 S 1,425,545.30 1,349,383.00 S 1,493,270.60 8,470,980.00 S 10.244.74 Difference (Actual - Estimated) $105,569.08 $10,313,024.27 $19,532,842.53 -$2.851,881.63 -$398,805.23 $14,771,626.87 $1,191,277.34 -$465,840.02 - $2,851,890.24 -$797,582.52 $11,644,940.27 $1,139,871.67 -$94,761.91 -$190,327.83 $1,837,749.70 -$143,887.60 $8,460,735.26 Overpaid/Underpaid Overpaid Overpaid Overpaid Underpaid Underpaid Overpaid Overpaid Underpaid Underpaid Underpaid Overpaid Overpaid Underpaid Underpaid Overpaid Underpaid Overpaid 1 Player Name 2 Justin Holiday 3 Zach LaVine 4 Otto Porter 5 Lauri Markkanen 6 Kris Dunn 7 Jabari Parker 8 8 Wendell Carter 9 Ryan Arcidiacono 10 Bobby Portis 11 Wayne Seldon 12 Robin Lopez 13 Chandler Hutchison 14 Shaquille Harrison 15 Timoth Luwawu-Cabarrot 16 Cameron Payne 17 Antonio Blakeney 18 Cristiano Felicio 19 20 21 22 29 ga 23 Player's Name 24 Justin Holiday 25 Zach LaVine 26 Otto Porter 27 Lauri Markkanen 28 Kris Dunn 29 Jabari Parker 30 Wendell Carter 31 Ryan Arcidiacono 32 Bobby Portis 33 Wayne Seldon 34 Robin Lopez 35 Chandler Hutchison 36 Shaquille Harrison 37 Timoth Luwawu-Cabarrot 38 Cameron Payne 39 Antonio Blakeney 40 Cristiano Felicio 41 Salary 4384616 19500000 26011913 4536120 4221000 20000000 4441200 1349383 2494346 1544951 14357750 1991520 1311265 1544951 3263295 1349383 8470980 Career Games 275 230 343 68 130 183 0 24 199 49 692 0 23 121 113 19 152 Minutes/game 34.9 34.5 32.8 32.3 30.2 26.7 25.2 24.2 24.1 22.9 21.7 20.3 19.6 18.8 17.3 14.5 12.4 Points/game 11.6 23.7 17.5 18.7 11.3 14.3 10.3 6.7 14.1 8 9.5 5.2 6.5 6.8 5.7 7.3 4 4 Assists/game Rebounds/game (Block + Steals/game / / / 2.2 4.4 2.4 4.5 4.7 1.4 2.7 5.5 1.8 1.4 9 1.3 6 4.1 2 2.2 6.2 1 1.8 7 1.9 3.3 2.7 0.8 1.3 7.3 0.9 1.7 3.2 0.7 1.2 3.9 1.2 0.8 4.2 0.6 1.9 3 3 1.6 0.8 2.7 0.7 2.7 1.7 0.8 0.7 1.9 0.4 0.6 3.6 0.3 Problem #6 Using the "true" regression results given in Problem #4, calculate (in cell) each of your players' estimated salary based on their 2018/2019 performance. Create a table containing the results of your calculations like the example below and include it in your Word or .pdf report. Which players on your team were overpaid? Which players on your team were underpaid? For example, for the Utah Jazz (partial numbers from a different season)... Difference (actual - est.) Name 2012/1? Salary Estimated Salary Effect Alec Burks 2020200 2932962 -912762 2574099 -868648 1705451 762195 -1011680 1773875 De Marre Carroll Jeremy Evans Derrick Favors Devin Harris 4443360 5477743 -1034383 9319000 4966966 4352034 underpaid underpaid overpaid underpaid overpaid underpaid underpaid overpaid overpaid underpaid Gordon Hayward 2532960 5650650 -3117690 2150000 4656432 -2506432 Josh Howard Al Jefferson 14000000 11567127 2432873 Enes Kanter 4133280 2516826 1616454 C.J. Miles 3700000 3895287 -195287 G H 811998.11 1379.79 912.48 389371.45 242001.58 202053.54 -179470.49 -64011.95 $1 B2 B3 B4 B5 B6 B7 S S $ S S S S S S S S S S S S S S S Salary Estimated Salary 4,384,616.00 4,279,046.92 19,500,000.00 S 9,186,975.73 26,011,913.00 S 6,479,070.47 4,536,120.00 S 7,388,001.63 4,221,000.00 S 4,619,805.23 20,000,000.00 $ 5,228,373.14 4,441,200.00 S 3.249.922.66 1,349,383.00 S 1,815,223.02 2494.346.00 S 5,346,236.24 1,544,951.00 S 2,342,533.52 14,357,750.00 S 2,712,809.74 1,991,520.00 S 851,648.33 1,311,265.00 S 1,406,026.91 1.544.951.00 S 1,735,278.83 3,263,295.00 S 1,425,545.30 1,349,383.00 S 1,493,270.60 8,470,980.00 S 10.244.74 Difference (Actual - Estimated) $105,569.08 $10,313,024.27 $19,532,842.53 -$2.851,881.63 -$398,805.23 $14,771,626.87 $1,191,277.34 -$465,840.02 - $2,851,890.24 -$797,582.52 $11,644,940.27 $1,139,871.67 -$94,761.91 -$190,327.83 $1,837,749.70 -$143,887.60 $8,460,735.26 Overpaid/Underpaid Overpaid Overpaid Overpaid Underpaid Underpaid Overpaid Overpaid Underpaid Underpaid Underpaid Overpaid Overpaid Underpaid Underpaid Overpaid Underpaid Overpaid 1 Player Name 2 Justin Holiday 3 Zach LaVine 4 Otto Porter 5 Lauri Markkanen 6 Kris Dunn 7 Jabari Parker 8 8 Wendell Carter 9 Ryan Arcidiacono 10 Bobby Portis 11 Wayne Seldon 12 Robin Lopez 13 Chandler Hutchison 14 Shaquille Harrison 15 Timoth Luwawu-Cabarrot 16 Cameron Payne 17 Antonio Blakeney 18 Cristiano Felicio 19 20 21 22 29 ga 23 Player's Name 24 Justin Holiday 25 Zach LaVine 26 Otto Porter 27 Lauri Markkanen 28 Kris Dunn 29 Jabari Parker 30 Wendell Carter 31 Ryan Arcidiacono 32 Bobby Portis 33 Wayne Seldon 34 Robin Lopez 35 Chandler Hutchison 36 Shaquille Harrison 37 Timoth Luwawu-Cabarrot 38 Cameron Payne 39 Antonio Blakeney 40 Cristiano Felicio 41 Salary 4384616 19500000 26011913 4536120 4221000 20000000 4441200 1349383 2494346 1544951 14357750 1991520 1311265 1544951 3263295 1349383 8470980 Career Games 275 230 343 68 130 183 0 24 199 49 692 0 23 121 113 19 152 Minutes/game 34.9 34.5 32.8 32.3 30.2 26.7 25.2 24.2 24.1 22.9 21.7 20.3 19.6 18.8 17.3 14.5 12.4 Points/game 11.6 23.7 17.5 18.7 11.3 14.3 10.3 6.7 14.1 8 9.5 5.2 6.5 6.8 5.7 7.3 4 4 Assists/game Rebounds/game (Block + Steals/game / / / 2.2 4.4 2.4 4.5 4.7 1.4 2.7 5.5 1.8 1.4 9 1.3 6 4.1 2 2.2 6.2 1 1.8 7 1.9 3.3 2.7 0.8 1.3 7.3 0.9 1.7 3.2 0.7 1.2 3.9 1.2 0.8 4.2 0.6 1.9 3 3 1.6 0.8 2.7 0.7 2.7 1.7 0.8 0.7 1.9 0.4 0.6 3.6 0.3