1.1 Curry Analysis Instructions.pdf

(51 KB) Pobierz

Analysis of the 2016-2017 NBA Season of Stephen Curry

This Practice Test includes:

Text File 1 – Curry Raw Data.txt

•

The text file is a pipe delimited file that has data from Stephen Curry’s 2016-2017 NBA

Season for all the games that Curry was active

Excel File 1 – Vegas Betting Data.xlsx

•

Vegas Spreads and Over/Unders for the 2016-2017 Warriors games

Excel File 2 – Field Explanation.xlsx

•

Explanation for all of the fields in the Curry Raw Data.txt and Curry Raw Data.txt

Excel File 3 – All Scores - Curry Test.xlsx

•

Final scores of

ALL

games (not just Golden State Warriors games) in the 2016-2017 NBA

Season

The text file is a pipe delimited file that has data from Stephen Curry’s 2016-2017 NBA Season for all the

games that Curry was active. For this Practice Test you need to do the following:

1. Based on Game Score, did he play better or worse on Christmas compared to his average game?

How about on his birthday?

2. Get the average margin of victory/defeat for home games and away games. Which opponent

did his team struggle with the most? Which opponent did his team have the most success

against?

3. Make a line graph tracking the True-Shooting Percentage (TS%) for each game throughout the

season, along with the 5-game running average of the TS%.

a. The formula for TS% is:

4. This problem uses the Vegas Betting Spreads and Over/Unders. If you placed $100 on the

Warriors to cover the spread (i.e. win with respect to the Spread on the game) and $150 for the

two teams to score over the Over/Under Point Total for every game Curry played, how much

money would you have won (or lost)?

a. See the Field Explanation file for more explanation on the Vegas Betting Data fields

b. You will need to use the All Scores - Curry Test.xlsx and Vegas Betting Data.xlsx file to

get your answer