Major cause of cardiovascular disease

Data content

​The data contained informations on the participants such as age, whether the person was smoking or not, whether the participant was an alcoholic or not, glucose level, cholesterol level, age, height, weight, systolic pressure and diastolic pressure and presence of physical activity or not.

​

Data cleaning

The data was placed in google sheets and duplicate data as well as rows with empty cells were removed. The headers were made to be clear and concise. The data consist of 5 numerical columns and 6 categorical columns. Three new columns were created which was the age in years, BMI (Body mass index) column and the weight class columns. The BMI column was created by calculating the weight in kg divided by the square of the height in meter. The age in years was calculated by dividing the age in days by 365 and rounding it to the nearest zero decimal place. The weight class was created by using the IF function which would designate overweight, underweight, normal and obese based on the BMI. Due to the fact that it was a real world data, there was unreasonable data in the BMI, systolic pressure and diastolic pressure column. Efforts were made to remove these unreasonable data.

​

Data Analysis

In order to present the data, tabular computation was done with google spreadsheet. The tabular data computed sought to find relationship between the categorical variables such as smokers or not, alcoholic or not, glucose level and cholesterol level and if the presence of physical activity was a deterrent to higher number of cardiovascular diseases patient

​

Data Visualisation

The data was imported to tableau and this was used to do the visualizations which were used to create a dashboard. The visuals were exported and presented in this report which was then compiled and converted into pdf.

​

Conclusions

In conclusion, it was discovered that higher cholesterol level was the major cause of cardiovascular disease. It was also discovered that presence of physical activity had little or no effect on the presence or absence of cardiovascular disease.

Recommendations

​It was recommended that more focus on seminars about cardiovascular disease should be centered more around diet with low cholesterol level than on increase in physical activity.