Variable Name Variable Label/ Description Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4-Senior) Gender (0=Male, 1=Female) Athlete Status 0 = Non-athlete, 1 = Athlete Height Height (inches) Weight Weight (pounds Smoking Status (Does student smoke?) 0 = Nonsmoker, 1 = Past smoker, 2 = Current smoker Sprint Time 35-meter sprint time (seconds) Mile Run Time Mile run time (minutes) English Score Score on English placement test (out of 100 points) Reading Score Score on Reading placement test (out of 100 points) Math Score Score on Math placement test (out of 100 points) Writing Score Score on Writing placement test (out of 100 points) Sleep Time Hours of sleep per night Study Time Hours per week of study time The data set of the data collected is provided in the Excel Worksheet attached. Required:- Using Microsoft Excel conduct the following: 1. Perform descriptive statistics on the following variables and write a brief interpretation of the output: . Sleep Time . Study Time . Sprint Time . English Score . Math Score2. Determine the frequency distribution of the following variables: Smoking Status . Gender (0=Male, 1=Female) . Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4-Senior) (W 3. Create a pie-chart to show the proportion of students based on Year in College. 4. Create a bar chart to show the distribution of students based on Smoking Status and write a brief interpretation of the output. 5. Make a scatter plot with Weight on the x-axis and Sprint Time on the y-axis. What do you conclude? 6. Make a scatter plot with Study Time on the x-axis and Math Score on the y-axis. What do you conclude? 7. Is there a relationship between Study Time and the Math Score? If so, what is the nature of the relationship? What is the Pearson correlation coefficient? Is the relationship strong, medium or weak? Interpret the result. Was it what you expected? 8. Is there a relationship between Sleep Time and the Mile Run Time? If so, what is the nature of the relationship? What is the Pearson correlation coefficient? Is the relationship strong, medium or weak? Interpret the result. Was it what you expected? 9. Create Pivot Table to show to show Average Math Score (column) by Gender (Row) a) Use an appropriate chart to visualize the results in the pivot table.10. Create Pivot Table to show to show Average Weight (column) based on Smoking Status (Row) a) Use an appropriate chart to visualize the results in the pivot table. b) How do you interpret the results of this pivot table? 11. Create Pivot Table to show the average of Math Score (Column) by Year in College (Row) and Gender (Row). a) Use an appropriate chart to visualize the results in the pivot table. b) In which Year in College do males show the highest average Math Score? c) In which Year in College do females show the highest average Math Score? 12. Create Pivot Table to show the average of English Score(Column) by Year in College(Row) and Gender(Row). a) Use an appropriate chart to visualize the results in the pivot table.a) Use an appropriate chart to visualize the results in the pivot table. b) In which Year in College do males show the highest average Math Score? c) In which Year in College do females show the highest average Math Score? 12. Create Pivot Table to show the average of English Score(Column) by Year in College(Row) and Gender(Row). a) Use an appropriate chart to visualize the results in the pivot table. b) In which Year in College do males show the highest average English Score? c) In which Year in College do females show the highest average English Score? 13. Create Pivot Table to show the average of English Score(Column), average Study Time (Column)and Sleep Time (Column) by Year in College(Row). a) How do you interpret the results of this pivot table? 14. Create Pivot Table to show the average Sprint Time(Column), and average Sleep Time(column) by Smoking Status(Row). a) Use an appropriate chart to visualize the results in the pivot table. b) How do you interpret the results of this pivot table? Note: For questions with pivot tables, please place variables marked with "(Column)" as columns of the pivot table and variables marked with "(Row)" as rows of the pivot table. Please also remove "Blank" values from the pivot tables and charts