Merrick Stevens is a sports analyst working for ACE Sports Management, a sports agency that represents over 200 athletes. He is interested in understanding the relationship between an NBA player’s salary and his physicality and performance statistics. Merrick has constructed a data set that contains information on 30 competing NBA teams and 445 players. A portion of the NBA_Data worksheet is shown in the table below. A detailed description of each field in the data set can be found in NBA Information.docx. Create a regression tree model for predicting an NBA player’s salary (salary). Select the best-pruned tree for scoring and display the full-grown, best-pruned, and minimum error trees.

a. How many leaf nodes are in the best-pruned tree and minimum error tree? 

b. Display the best-pruned tree. What are the predictor variable and split value for the first split of the best-pruned tree?

c. What are the RMSE and MAD of the best-pruned tree on the test data?

d. Score the three NBA players Merrick is trying to sign as ACE Sports Management clients in the NBA_Score worksheet using the pruned tree. What is the average predicted salary of the three players?  

Transcribed Image Text:

player_number 1 2 I 445 salary 947276 25000000 525093 age 36 37 1 23 *** points 13.5 17.6 I 1.2