Question: 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

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 Analysis1. 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 Set2. Determine whether each variable in the Heart Health Excel file is numeric-discrete, numeric-continuous, or categorical.3. For numeric variables, create a table displaying the mean, standard deviation, and five-number summary.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!