INSTRUCTIONS For Case Study Assignment 6.1, you will create 3 figures (charts) in MS Excel. Similar to previous case study assignments, you will use the data from the Fall 2019 National College Health Assessment. In the recorded lecture below, an example is provided on how to do this with an example of 100 responses. This is the spreadsheet Download spreadsheetthat was used in the lecture with the examples. Duration: 11:15 Citation: Kindratt TB. 2023. Case Study Assignment 6.1: Figures. Available via Canvas. Follow the instructions below to create figures using 580 observations from the National College Health Assessment for your assignment. Please follow the steps to complete the template Download template. Create a scatter plot for participants' age (Variable: N3Q69) Create a pie chart for percent of participants who used e-cigarettes in the last 3 months (Variable: ECIG_3M) Create a bar chart for frequency of participants by self-reported overall health status (Variable: N3Q1) Please download and enter the responses directly into the Excel database, save it, and upload the file on Canvas