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:
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.
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.