Posted inUncategorized

You will need the data for “Current Cap Hit” (CCH), goals and total points (goals plus assists) for this assignment and the other columns of the data can be deleted. Trim the data

You will need the data for “Current Cap Hit” (CCH), goals and total points (goals plus assists) for this assignment and the other columns of the data can be deleted. Trim the data (delete the rows) for forwards who played fewer than 20 games to eliminate minor league call-ups and players injured most of the season. a) Present two separate graphs: (i) salaries (CCH) on the y-axis and goals (G) on the x-axis and (ii) salaries (CCH) on the y-axis and points (PTS) on the x-axis. Use the Excel graph functions to label your axes and to draw a linear trend through the data in each graph. b) Estimate the impact on salary in dollars of (i) an additional goal and (ii) an additional point to the forwards on your team using the Excel regression function or linear trend line. [If you use regression, you must present the results. If you use the trend line, you must explain your calculations.] c) Which factor (goals or points) appears to explain salaries better? Explain your reasoning briefly. [Hint: If you use the regression function, you can obtain the coefficient of determination (R2 ), which tells you what proportion of the variation in the salary series is explained by the regression line (and therefore how much cannot be explained by the regression line alone).] d) A new star emerges on your team with 30 goals and 60 points in 2022-23. [You assume that there are no restrictions on the player’s salary.] Using your regression or trend line results, predict what this player’s salary will be. e) Estimate the impact on salary in percentage terms of (i) goals and (ii) points for forwards on your team. [Hint: You can use the @l

Related posts:

  1. Think from the aspect of the tools found in a toolbox in many homes, such as a h
  2. A reflective report with an evaluation of the project’s progress including alternative strategies that could have been followed with an analysis of the repercussions or advantages of such strategies. The report must also identify the l
  3. Business research report
  4. Social Media Content Audit: Conduct a social media content audit of the Client and TWO of its competitors. Formulate ONE S.M.A.R.T. campaign goal for the Client that builds on the audit observations of its social media content.
Last updated on