Use chapter 8 dataset to prepare visualizations to answer the following questions. Use separate sheet for each question.

Question-1 : Create a scatter plot to encode the 4 variables as shown in the following figure [Chapter 8].  Make sure to add the background image.

Question-2 : Create a stack bar chart to visualize the Rate of Point Production as shown in the following figure [Chapter 8 – Figure 8-13]

Question-3 : Apply the linear regression on the data and generate the following visualization. [Chapter 8 – Figure 8-16]

What is the most important observation you can have from the visualization? 

Question-4 : Create a quadrant chart to visualize shots vs. goals as shown in the following figure[Chapter 8 – Figure 8-22]

Use chapter 9 dataset to prepare visualizations to answer the following questions. Use separate sheet for each question.

Question-5 : Dual-axis line chart: recreate the visualization illustrated in Figure 9-8.

Question-6 : Connected scatterplot: recreate the visualization illustrated in Figure 9-13.

Question-7 : Forecasting: recreate the visualization illustrated in Figure 9-17. 

Question-8 : Timeline: recreate the visualization illustrated in Figure 9-25. 

Question-9 : Slopegraph: recreate the visualization illustrated in Figure 9-25.