Hey guys. I am doing a self change project on changing my sleep behavior and I need help with how to find the average times of two different sets of groups. There are the baseline times and intervention times. Both groups have three subtopics: Time Fell Asleep, Woke Up, and Duration (how many hours I slept). I am not sure how to find the average of each subtopic. Here are the times....
Baseline times:
Intervention Times:
Someone please help! If you can do it thanks, but show me how to as well.
Baseline times:
Fell Asleep | Woke Up | Duration |
2:30 AM | 10:00 AM | 7:30 hrs |
4:30 AM | 12:30 PM | 8:00 hrs |
3:30 AM | 11:00 AM | 7:30 hrs |
5:00 AM | 1:00 PM | 8:00 hrs |
3:00 AM | 7:00 AM | 4:00 hrs |
2:00 AM | 9:00 AM | 7:00 hrs |
2:00 AM | 10:00 AM | 8:00 hrs |
12:00 AM | 10:30 AM | 10:30 hrs |
3:00 AM | 12:00 PM | 9:00 hrs |
3:30 AM | 12:00 PM | 8:30 hrs |
3:00 AM | 11:00 AM | 8:00 hrs |
5:00 AM | 11:00 AM | 6:00 hrs |
12:00 AM | 10:30 AM | 10:30 hrs |
4:30 AM | 11:30 AM | 7:00 hrs |
2:00 AM | 11:30 AM | 9:30 hrs |
3:30 AM | 12:00 PM | 8:30 hrs |
1:30 AM | 10:30 AM | 9:00 hrs |
3:00 AM | 12:00 PM | 9:00 hrs |
1:00 AM | 11:30 AM | 10:30 hrs |
2:00 AM | 12:00 PM | 10:00 hrs |
4:00 AM | 10:30 AM | 6:30 hrs |
Intervention Times:
Fell Asleep | Woke Up | Duration |
3:00 AM | 11:00 AM | 8:00 hrs |
4:00 AM | 12:00 PM | 8:00 hrs |
1:30 AM | 10:00 AM | 8:30 hrs |
2:00 AM | 10:30 AM | 8:30 hrs |
12:30 AM | 11:00 AM | 10:30 hrs |
11:30 PM | 10:00 AM | 10:30 hrs |
4:00 AM | 12:00 PM | 8:00 hrs |
1:00 AM | 9:30 AM | 8:30 hrs |
1:30 AM | 9:30 AM | 8:00 hrs |
2:00 AM | 12:00 PM | 10:00 hrs |
3:30 AM | 8:30 AM | 5:00 hrs |
1:00 AM | 12:00 PM | 11:00 hrs |
2:30 AM | 9:30 AM | 7:00 hrs |
11:00 PM | 7:30 AM | 8:30 hrs |
2:30 AM | 11:30 AM | 9:00 hrs |
4:30 AM | 12:30 PM | 8:00 hrs |
1:30 AM | 9:00 AM | 7:30 hrs |
2:00 AM | 10:30 AM | 8:30 hrs |
11:00 PM | 9:00 AM | 10:00 hrs |
1:00 AM | 5:30 AM | 4:30 hrs |
12:30 AM | 11:00 AM | 10:30 hrs |