Adegoke Musa Olatunji

GROUP ONE WEEK 4/8 MENTORSHIP SLEEP HEALTH AND LIFESTYLE ADEGOKE Musa Olatunji ANIEKWENSI Ebube DAVID Anunobi BAMGBOSE Lateefat ETI-IMAN Akpan TOMIWA Ariyo learnwithwida @G1-WK4/8 DATA ANALYSIS PROCESS Data Source Cleaning Processing Analysis Conclusion Recommendation learnwithwida @G1-WK4/8 Data Source www.kaggle .com Healthcare Data Excel SLEEP HEALTH AND LIFESTYLE learnwithwida @G1-WK4/8 Data Cleaning ❖ Check for duplicates in the ID column. ❖ Round the sleep duration and quality column to whole numbers. ❖ Left and Right function to separate the systolic & diastolic. ❖ Create a BP classification column using conditional functions. ❖ Use the Len function to crosscheck numerical columns for accuracy. ❖ Perform age classification learnwithwida @G1-WK4/8 Data Processing Age Categorization from continuous data =IFS(AND… AGE_CATEGORIES Adult Older Adult Youth learnwithwida @G1-WK4/8 BP Categorization from continuous Data Processing “cont’d” =IFS( OR… BP_CATEGORIES Elevated Stage 1 Normal Stage 2 learnwithwida @G1-WK4/8 • What is the distribution of the respondents based on • (1) Gender • (2) Occupation • (3) BMI • (4) Sleep Disorder Data Analysis “cont’d” =COUNTIF(range, criteria) learnwithwida @G1-WK4/8 Average: Age, Sleep duration, Physical Activity level per Day, Stress Level, Heart Rate Daily Step Data Analysis “cont’d” Variables AGE =AVERAGE(number1,[number… Mean 40 years Sleep Duration 8 hours Physical Activity 65 steps Stress Level 6 of 10 Heart Rate 76 Daily Step 11077 Data Analysis “cont’d” =CONCATENATE([@[Generic_ Name]],"-",[@[Person ID]]) Data Analysis “cont’d” PERSONAL_ID Gender 56 Female SLEEP_DISORDER BMI_category None Underweight =VLOOKUP(AC7,Table2,4) Data Analysis “cont’d” IDENTIFYER RESP-3 AGE CLASSIFICATION Adult OCCUPATION BLOOD PRESSURE BP CATEGORY Retired 122/70 Elevated =XLOOKUP(AC4,Table2[IDENTIFYER],Table2[BP Category])