In my previous blog post, https://analyticswithamruha.hashnode.dev/analysis-of-sleep-health-and-lifestyle-using-sql-part-1 , I performed the following operations on the data stored in 'sleeptable' :
data cleaning
analysis of the Sleep Duration attribute
analysis of the Sleep Disorder attribute
analysis of the Quality of Sleep attribute
In this blog post, I will be concentrating on the analysis of stress level, physical activity level and daily steps attributes.
Analysing the Stress Level Attribute:
The stress level attribute accepts values on a scale of 1 to 10, where 1 indicates the lowest stress level and 10 indicates the highest stress level.
Discerning the average stress level of all individuals under consideration:
select avg(Stress_Level) from sleeptable;
The result is :
5.73
The stress levels of all individuals under consideration tends towards higher stress level by a small margin.
Checking the average stress level for each occupation:
select Occupation,avg(Stress_Level) from sleeptable group by Occupation order by avg(Stress_Level) asc;
The result is :
Accountant|4.12903225806452
Engineer|4.30769230769231
Teacher|5.0625
Lawyer|5.06382978723404
Nurse|6.0
Software Engineer|6.0
Salesperson|7.0
Scientist|7.0
Doctor|7.01538461538462
Sales Representative|8.0
The average stress level for accountants and engineers is the least and it is highest for doctors and sales representatives.
Determining the average stress level for each gender:
select Gender,avg(Stress_Level) from sleeptable group by Gender order by avg(Stress_Level) desc;
The result is:
Male|6.11643835616438
Female|4.68518518518519
The male individuals under consideration have a higher average stress level as compared to females.
Checking the average stress level for each age:
select Age,avg(Stress_Level) from sleeptable group by Age order by avg(Stress_Level) desc;
The result is:
34|8.0
28|8.0
33|7.69230769230769
29|7.15384615384615
32|6.94117647058824
31|6.22222222222222
43|6.21428571428571
30|6.15384615384615
27|6.0
42|5.66666666666667
40|5.5
41|5.25
39|4.93333333333333
38|4.6
36|4.5
35|4.41666666666667
37|4.25
People aged 34 and 28 years have the highest average stress levels and people aged 37 have the lowest average stress levels.
Determining the average stress level for each quality of sleep rating:
select Quality_of_Sleep,avg(Stress_Level) from sleeptable group by Quality_of_Sleep order by avg(Stress_Level) desc;
The result is:
4|8.0
6|7.56862745098039
5|7.0
7|5.76190476190476
8|4.54838709677419
9|3.0
Individuals having the worst quality of sleep of 4 out of 10 have the highest amount of average stress levels whereas individuals having the best quality sleep of 9 out of 10 have the least amount of stress on average.
Checking the average stress level for each BMI category:
select BMI_Category,avg(Stress_Level) from sleeptable group by BMI_Category order by avg(Stress_Level);
The output is:
Normal|5.56969696969697
Obese|6.48571428571429
Obese people have a higher stress level on average as compared to normal people.
Analysing the Physical Activity Level attribute:
The physical activity level attribute keeps track of the number of minutes devoted by an individual to physical activity each day.
Checking the average Physical Activity Level of all individuals under consideration:
select avg(Physical_Activity_Level) from sleeptable;
The result is:
57.215 (minutes per day)
Determining the Physical Activity Level for each occupation:
select Occupation,avg(Physical_Activity_Level) from sleeptable group by Occupation order by avg(Physical_Activity_Level) desc;
The result is:
Lawyer|70.4255319148936
Engineer|60.7692307692308
Accountant|60.6451612903226
Doctor|53.0769230769231
Teacher|48.4375
Software Engineer|48.0
Nurse|46.7142857142857
Salesperson|45.0
Scientist|41.0
Sales Representative|30.0
Lawyers have the highest average Physical Activity Level of 70.4 minutes each day whereas sales representatives have the least average Physical Activity Level of 30 minutes each day.
Discerning the average Physical Activity Level for each stress level:
select Stress_Level,avg(Physical_Activity_Level) from sleeptable group by Stress_Level order by avg(Physical_Activity_Level) desc;
The output is :
5|70.2040816326531
6|69.1627906976744
3|62.5
4|59.7777777777778
7|42.1428571428571
8|31.6842105263158
People with a stress level of 8 out of 10 have the least amount of average physical activity level of 31.68 minutes each day whereas people having a stress level of 5 out of 10 have the highest average physical activity level of 70.24 minutes each day.
Checking the average Physical Activity Level for each gender:
select Gender,avg(Physical_Activity_Level) from sleeptable group by Gender order by avg(Physical_Activity_Level) desc;
The output is :
Male|57.7191780821918
Female|55.8518518518519
The average physical activity level for men and women is comparatively the same.
Determining the average Physical Activity Level for each BMI Category:
select BMI_Category,avg(Physical_Activity_Level) from sleeptable group by BMI_Category order by avg(Physical_Activity_Level) desc;
The result is:
Normal|60.1515151515151
Obese|43.3714285714286
Normal people devote more time to physical activity every day than obese people.
Discerning the average Physical Activity Level for each Quality of Sleep rating:
select Quality_of_Sleep, avg(Physical_Activity_Level) from sleeptable group by Quality_of_Sleep order by avg(Physical_Activity_Level) asc;
The result is:
4|30.8
6|36.4509803921569
5|37.1428571428571
8|65.752688172043
7|68.9285714285714
9|80.0
People having the lowest quality of sleep i.e. 4 out of 10 have the least amount of average physical activity. People with the best quality of sleep(9 out of 10) have the highest average physical activity level. The better the sleep quality, the higher the physical activity level.
Analysing the Daily Steps attribute:
The daily steps attribute contains the number of steps taken by an individual each day.
Checking the ID of the individuals taking the maximum number of steps each day :
select Person_ID from sleeptable where Daily_Steps=(select max(Daily_Steps) from sleeptable);
The result is :
2
3
Determining the average number of steps taken by people every day:
select avg(Daily_Steps) from sleeptable;
The output is:
6760.0
Finding the daily steps on average for each occupation type:
select Occupation,avg(Daily_Steps) from sleeptable group by Occupation order by avg(Daily_Steps) desc ;
The result is:
Lawyer|7661.70212765957
Accountant|7051.61290322581
Doctor|6907.69230769231
Engineer|6015.38461538462
Salesperson|6000.0
Teacher|5893.75
Software Engineer|5800.0
Scientist|5350.0
Nurse|5028.57142857143
Sales Representative|3000.0
Lawyers take the highest steps every day on average whereas sales representatives take the least steps.
Checking the daily steps on average taken by people with different stress levels:
select Stress_Level,avg(Daily_Steps) from sleeptable group by Stress_Level order by avg(Daily_Steps) asc;
The output is:
7|5204.7619047619
8|5589.47368421053
4|6684.44444444444
6|7458.13953488372
5|7710.20408163265
3|7750.0
People with a stress level of 7 out of 10 take the least amount of steps every day on average whereas people with the lowest stress level of 3 out of 10 take the most amount of steps.
Determining the daily steps on average for each gender:
select Gender,avg(Daily_Steps) from sleeptable group by Gender order by avg(Daily_Steps) ;
The result is:
Female|6425.92592592593
Male|6883.56164383562
Males take a higher number of steps daily on average as compared to females.
Finding the daily steps on average for each quality of sleep rating:
select Quality_of_Sleep,avg(Daily_Steps) from sleeptable group by Quality_of_Sleep order by avg(Daily_Steps) desc;
The output is:
9|7500.0
8|7382.79569892473
7|7364.28571428571
6|5723.52941176471
5|4257.14285714286
4|3880.0
People with the best quality of sleep take the most number of steps each day on average as compared to the people with the worst quality of sleep.
Found this article interesting? Give it a like and share it with your friends !!
#datascience #data #dataanalysis #datanalytics #sleep #health #lifestyle #sleephealth #sql #datacleaning #insight #insights