Practice PT (Data Stories)
Data Visualization
Pivot Table (Summary Table)
Next Day Feelings
|
Average of hours slept last night
|
Bad
|
5
|
Good
|
6.1
|
Great
|
4.83
|
Meh
|
5.8979
|
Terrible
|
4.7
|
Written Response
- The data was originally collected by my teacher. He sent each student a link to a Google Forms survey to fill out every morning from November 9th 2016, through November 22nd 2016. There were six questions for the students to answer. One of them was, “how many hours did you sleep last night?”, another was “how do you feel today?”. After the survey ended, the class had access to the all the responses in the survey.
- To clean the data that was collected, I removed the words from the questions that only required numbers. When the response exceeded 24, the possible number of hours in a day, I deleted the value. After the data had been cleaned to my satisfaction, I made a pivot table (summary table) to find the average number of hour slept and the next day feelings. To create a visualization, I used a bar graph. The computing tools used for the artifact was Google Sheets.
- A pattern visible in my chart, is the lack of accurate correlation between the number of sleep and the next day feelings. In a normal circumstance, having the most hours of sleep recommended would result in a great feeling, however, in the data collected, the greatest average of numbers 6.1 and this was for those who felt good but not great. This trend is shown by comparing the average number of hours slept and the next day feelings on the bar graph.
- This unexpected result might be due to people spending more time relaxing rather than actually sleeping. This can predict how our essentials needs are changing. Many people are going sleep deprived, their body becomes may become accustomed to it and it prefers the less hours instead of the recommended eight hours. Also, the question were open-ended which allows the student to interpret the question differently than their other peers. Perhaps, the students were not being honest with their responses. This is evident because, the data I deleted were quite erroneous.
- I am making the recommendation for the National Sleep Foundation. Instead of just studying the hours people spend sleeping, they can conduct further research to find the correlation between the hours a person spends relaxing and their alertness and feelings the next day.
- The recommendation can lead to discovering the benefits of relaxing more than sleeping. Scientist mainly associate alertness to the sleep a person gets the day before but perhaps the activity done while relaxing and the pleasure from it determines an individual’s feeling the next day.
- My recommendation is supported because the average number of hours slept by the students who felt great was only .17 greater than those who felt terrible. In order to make a stronger recommendation I would need to make a bar graph comparing the feelings and the hours spent relaxing and possibly the activity done while relaxing in order to make a stronger recommendation.