Hi all,
I have some questions that I would like cleared up rather than problems to solve.
I am working with time values (minutes,seconds) in excel. Large quantities of them.
I was interested to see which time value occurs more often therefore I used the MODE function but it keeps turning up 00:00:00.
I have values that range from 00:00:00 to 00:20:00 (with 00:00:15 steps between them) but MODE keeps returning 0's. I DO know that 0 is not the most common value but I can't figure out what is wrong.
Also, working with standard deviation I chose the STDEV function. So, in my case I have something like a 00:02:44 average value of all my records and the STDEV function returns a 00:03:12. If I understand right this means that 68% of all values fall within a 3min,12sec limit around my average value (i.e from 00:02:44 - 00:03:12 to 00:02:44 + 00:03:12). Just need to verify this.
Finally, I tried to work with the Confidence Interval but I get a huge number as a result and I suspect it's just because I'm using time values as data.
Anyone had this issue before? any ideas on how to work around it?
Regards,
Kostas
p.s some of my time values are blank or 00:00:00, could that affect my calculations in returning weird results?
Is there a good/easy formula to use when trying to find the mean, median and mode for a column? If so, can someone post it? I'd like to make it as easy as possible (obviously!).
Thanks
Hi
How to find Median,Mode in a excel sheet which contains more than 255 rows of data?
[HtmlMaker 2.42]
******** LANGUAGE="JavaScript" ************************************************************************>
Microsoft Excel - Statement Template.xlt
___Running: xl2002 XP : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
B2
B3
=
A
B
C
D
2
1
6
3
1
3
4
1
5
2
6
2
7
2
8
2
9
3
10
3
11
3
12
3
13
3
14
6
15
6
16
6
17
6
18
6
19
6
Statement
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003
Code mods by Ivan F Moala - 15th May 2003
How do you calculate the mean? Mean() doesn't work
Cells in a column calculate the difference between two test scores . When the test scores are empty the formula cell contains a zero. I want to calculate the median and mode for that column without counting zero.
Any ideas?
ie:7.5 8.5 1
8.0 12.0 4
7.5 8.0 .5
0
0
Median-1
Help!
Thanks for your help in advance.
As per my previous question, I have a single column that has positive and negative values, this time, percentages (to two decimal places).
No two percentages, when using 2 decimal places, are identical out of a list of hundreds in that column.
How can I find out the median and mode of this entire data set (positive and negative combined), and seperately the median and mode of positive and negative data sets, if I were to simply round the percentages to the nearest whole number in the formula, which would produce many identical numbers.
I can't come up with the correct formulas for this scenario.
Thank you!
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
