Hi, I need to find the average of the times below (displayed as a time e.g. 8:15 meaning 8 hours 15 minutes not a decimal e.g. 8.25) I know the formula to find the average of a number is:
Mean = sum of elements / number of elements
The times I need to find the average for are:
9:30
8:45
8:30
8:15
8:00
8:00 Because there are 12 pieces of data the mean should lie between this number (8:00)
7:45 and this number (7:45). I think this is a rule but I could be wrong.
7:30
7:00
6:30
6:00
6:00
added together = 90.25
90.25 / 12 = 7.520833333
I tried the formula above and got 7.52083333 does this answer mean that the average time is 7 hours and 52 minutes? Any help is appreciated. If I have missed anything or my question is unclear let me know and ill do my best to clarify.
I think I see what you are doing, so by converting the minutes into their decimal equivalents ( 15 minutes as 0.25) you can then add all of the times together and divide by 12 to get the average as a decimal (7.64583333) and then you can convert 0.64583333 into minutes add 7 (for the hours) and the answer is the average, is that right?
I found a calculator online to convert decimal hours into a time and I got 7 hours and 38 minutes 45 seconds (7:39 rounded) is this the average of the times? Thanks for your help so far.
Sorry I forgot to ask this yesterday, the answer (7:39) doesn't sit between 8:00 and 7:45 like I thought it was going to, did I get that rule wrong? I just want to make sure 7 hours 39 minutes is the correct average of the times listed in the first post.
First that means 7 hours and .52083333 of an hour. One hour is 60 minutes so that is 7 houjrs and .52083333 of 60 minutes. "of" here means "multiply" (1/2 "of" 60, for example, is (1/2)(60)= 30 minutes) so .52083333 of 60= (.52083333*60)= 31.2499998. 7.52083333 hours is 7 hours and 31.2499998 minutes. If you want to go further, 0.2499998 of a minute is 0.2499998 of 60 seconds: (.2499998)(60)= 14.999988 seconds so you could reasonably say that "7.52083333 hours" is "7 hours, 31 minutes, and 15 seconds".