The purpose of this project is to introduce you to the basic concepts of data analysis through descriptive statistics and data visualization. The provided dataset includes variables which may potentially lead to the death of the patient. You will use Microsoft Excel to calculate descriptive statistics and create visual representations of the provided data. Then, you will summarize your analysis in a written report in Microsoft Word. To prepare for this assignment, you should: Download and review the associated Excel file Download and review the report template Watch the video guide for this project found in the Blackboard content folder. Instructions for Completing this Assignment Follow the instructions below to complete calculations and create visual representations of data within the Heart Health Excel file. You will use that information to write a report that includes your thoughts, calculations, and graphs that you create. Within your report, you will insert charts and tables from your Excel file where appropriate to support your conclusions. Part 1: Data Analysis 1. Download, save, and open the Excel data file. When completing your analysis, follow these guidelines: Numeric-continuous variables should be represented using histograms. Numeric-discrete variables should be represented with a bar chart on the count or relative frequency. Categorical variables should be represented with a bar chart on the count or relative frequency. Numeric variables, both continuous and discrete, can use box and whisker plot to display the five number summary, distribution, and outliers. Every chart should always have labels on each axis and should have a chart title that clearly explains to the audience what the chart is representing. Description of Data Set 2. Determine whether each variable in the Heart Health Excel file is numericdiscrete, numeric-continuous, or categorical. 3. For numeric variables, create a table displaying the mean, standard deviation, and five-number summary. MTH 315 - Project 1 Assignment Instructions 2 4. For categorical variables, create a table displaying the count and relative frequency for each outcome. Visual Representation of Data - Platelets 5. Create the appropriate type of chart to display the platelets variable. Visual Representation of Data - Diabetes 6. Create the appropriate type of chart to display the relative frequency of the diabetes variable. On your chart, display labels for each outcome that show the exact relative frequency. Visual Representation of Data - Quantity of Visits to Hospital 7. Create the appropriate type of chart to display the quantity of visits to hospital variable. Visual Representation of Data - Creatine Phosphokinase 8. Create the appropriate type of chart to display potential outliers for the creatine phosphokinase variable. Create the corresponding histogram for the creatine phosphokinase variable. Comparison of Death Occurrence and High Blood Pressure Occurrence 9. Create two charts to show 1) the number of individuals who died along with the number who had high blood pressure and 2) the overall percentage of individuals with high blood pressure from the entire sample. These are meant to help answer the questions: What percentage of the individuals who died also had high blood pressure? How does this percentage compare to the overall percentage of individuals with high blood pressure from the entire sample? 10.Create two charts to show 1) the number of individuals who had blood pressure who also died and 2) the overall percentage of individuals who died from the entire sample. These are meant to help answer the questions: What percentage of the individuals who had high blood pressure also died? How does this percentage compare to the overall percentage of individuals who died from the entire sample? Random Sample and Smoker Comparison 11.Create a random sample of ten patients by using the rand() function. MTH 315 - Project 1 Assignment Instructions 3 Follow-Up Question 12.What other question could you ask about this data? Create a chart to attempt to provide insight toward answering this question. Part 2: Written Report 1. Download, save, and open the report template in Word. 2. Beginning on the title page, replace bracketed text with your information and work. The brackets themselves should also be removed from your final report. 3. Read the prompts carefully to ensure you are addressing all discussion and analysis points. 4. Write in complete sentences, and be sure to follow the writing mechanics guidelines below. 5. Follow the prompts in the report template to discuss your analysis