Assignment: Project #$1-$ Impacts on Cardiac$-$Related Deaths

Purpose and Preparation

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

Writing Mechanics

$$ Use a $12-$point font and double$-$spaced text.

$$ Follow APA writing guidelines.

$$ Proofread and correct all errors