MGMT $47900$ Data Visualization, Spring $2024$

Individual Assignment Set $1$

Due Date: $11$:$59$ pm on Jan. $24$th$,2024$

Note: The deliverable for this assignment will be an Excel file $($titled $$NBA data$)$ with all required charts. For questions with no charts related, please create a new worksheet and write your answers on it$.$ For discussions about a chart, please include the discussions on the same worksheet as where the chart is located.

Question $1$: Using data on the $$NBA Salary$$ worksheet

$1\mathrm{.}1.$ Draw a bar chart of salaries for the top five NBA players in the data. On the chart, you are expected to display the names of those players and clearly label the chart with a title. Order the players by salary $($highest first$).$

$1\mathrm{.}2.$ Draw a bar chart to show the total salary paid by each team and rank them in descending order $($from highest to lowest$).$ Use the color coding below: Green for the top five teams, orange for the bottom five, and grey for the rest. Properly label the chart with a title.

$1\mathrm{.}3.$ Based on the same set of information in Question $1\mathrm{.}2,$ draw a treemap showing the top five teams $($by total salary$).$ Properly label the chart with a title.

$1\mathrm{.}4.$ Draw a box and whisker plot to show the distributions of salaries by team. Properly label the chart with a title. $($Note: Each team gets its own box and whisker plot, and put all plots in one big graph.$)$

$1\mathrm{.}5.$ Please highlight two insights from the data and support your reasoning with charts generated above. $($Note: Create a new worksheet on the Excel file and list your insights on the sheet$)$

Question $2.$ Using data on the $$NBA Performance Stats$$ worksheet

$2\mathrm{.}1.$ Draw a scatter plot to show the relationship between $$Age$$ and $$PTS$($points scored in the season$).$ Please interpret the chart you generated. Properly label the plot with a title. $($Hint: As an example, you can discuss whether the relationship is positive or negative.$)$

$2\mathrm{.}2.$ Draw a dual$-$axis combo chart to show the relationship between average age and the total PTS of a team. Sort the teams by average age in descending order $($from largest to smallest$).$ Please use the total PTS on the primary axis $($represented by the bar chart$)$ and average age on the secondary axis $($represented by the line chart$).$ Properly label the chart with a title.

$2\mathrm{.}3.$ Draw a pie chart to show the percentages of points scored by each position $($Note: Five positions in total are in the data, i$.$e$.,$ C$,$ PF$,$ PG$,$ SF$,$ and SG$).$ Properly label the chart with a title.

$2\mathrm{.}4.$ Draw a heatmap for the five teams shown below based on the total PTS $($for each combination of team and player position$).$

$2\mathrm{.}5.$ Suppose you are the general manager $($GM$)$ of a team and would like to create a Gantt chart to track player recruitment activities with the data given below. Fill in the $$Days Completed$$ and $$Remaining Days$$ in the table and create a Gantt chart based on that.