BMGT 3370, Spring 2013

BMGT 3370, Spring 2013 Computer Case This assignment is due March 27st or 28th, at the beginning of class. You are being assigned a specific San Antonio Spurs game to analyze. Your data set is the “Box Score” for the game. For your game, I want you to analyze the following four variables for EACH team: TOT – Number of Total Rebounds per Player AST – Number of Assists per Player TO – Number of Turnovers per Player PTS – Number of Points per Player Your analysis will have three parts: Part 1 - Using an Excel spreadsheet, determine the “Descriptive Statistics” for each variable. Part 2 - Then you will need to determine the “Coefficient of Variation” for each variable. Part 3 – Then you will use the Pearson function in Excel to determine the “Pearson’s Correlation” between PTS (dependent variable) and the other 3 variables TOT, AST, and TO (independent). Part 4 - Then you will need to write a two page “Letter to Coach POP” explaining the final score and ultimate outcome (win or lose) of the game. The information to be turned in is as follows: 1) Cover Page 2) Managerial Report 3) Printed “Box Score” 4) Printouts of all work done in Excel