Requirement	AvailableMarks	MarksAchieved	Comments
What variables should be used in this analysis? Scatter plots and correlation metrics can be used to analyze potential relationships between different variables. Using the excel provided, complete scatterplots for the players Correlation metrics of the data sets for the players (2 tables showing different variables in the correlation set)	40 marks		Scatter plot - 30 marks - 5 marks for each players scatterplot Correlation graphs - 6 marks - 3 marks for each graph 4 marks for summarizing the information - you need a paragraph here.
What factors should be considered when evaluating player performance? General managers of NBA teams try to predict player performance as a function of several factors. Multiple linear regression can be used to identify significant independent variables. Generally, the following steps can accomplish this: Construct a model with all the independent variables. Check to see that the variable is significant by examining p-values. If p-values are significant at the pre-specified significance level (i.e., most commonly used significance level of 0.05), those variables need to be included in the next iteration. If p-values are not significant, identify the independent variable with the largest p-value that exceeds the significance level. Then, remove that variable from the next iteration. However, do not remove all non-significant variables at once; only remove one at a time. Repeat the process until all independent variables are significant.	12 marks		10 marks for regression analysis 2 marks for summary
3.How good a measure is PIE? What can be done to improve it? Do you think it is a good measure of a player's contribution of efficiency?	5 marks		5 marks for discussion points here. Support your point.
Using the data provided, predict which player will contribute more to Magic's success. Using the regression equation developed earlier in assignment question 2, the PIE for Ross and Gay can be predicted. Refer to the inputs provided by the management team's projected statistics for each player (see case Exhibit 2). Inputting the significant variables into the regression equation developed earlier provides the predicted PIE of each player. Calculate the regression equation using Excel	32 marks		5 marks for the regression of each player. 2 marks for summary.
5. Who should Magic pursue in free agency? Make a recommendation and support your answer with your data.	5 marks
Presentation of Excel and Word Document. - How well and clear is your excel file to read and understand. - Did you use a word document? - Did you make it so your summary document had screenshots or inserted graphics? - Could you just review the word document to understand the recommendations and question responses?	6 marks
Total	100