Count how often a value occurs?
- Thread starter snow
- Start date
SirJB7
Excel Rōnin
Hi, snow!
Supposing you have that data in cells A2:B11 with titles in A1:B1, you can type this formulaes:
For sum: =SUM(B2:B11)
For mode: =MODE.ONE(B2:B11)
About sum I've got no doubt, but about mode... I use Excel 2010 and I don't have any more the function MODE (MODA in spanish), it's been replaced by two functions: MODA.UNO (just one value) or MODA.VARIOS (an array of values). If you have 2010 version, try what I typed; other versions, just try without the ".ONE", that's to say "MODE".
Hope it works.
Regards!
Supposing you have that data in cells A2:B11 with titles in A1:B1, you can type this formulaes:
For sum: =SUM(B2:B11)
For mode: =MODE.ONE(B2:B11)
About sum I've got no doubt, but about mode... I use Excel 2010 and I don't have any more the function MODE (MODA in spanish), it's been replaced by two functions: MODA.UNO (just one value) or MODA.VARIOS (an array of values). If you have 2010 version, try what I typed; other versions, just try without the ".ONE", that's to say "MODE".
Hope it works.
Regards!
Thank you, Sir JB7. Actually, these data are the only info. showed for this example and I do not understand what the column Sample mean? Are they the number of students? How come? Also, the explanation says it can be easily counted OR use the EXCEL function.
And now besides using the functions,I still wanna know how to count according to the figure!
Is it possible that the figure is not completed for the EX?
And now besides using the functions,I still wanna know how to count according to the figure!
Is it possible that the figure is not completed for the EX?
SirJB7
Excel Rōnin
Hi, snow!
I think that the column Sample is a consecutive order for assigning numbers from 1 in advance. For "count" you mean the sum of column B? If it's that, just look at the formulaes I wrote in the previous post. Otherwise check with the author, if it's available.
Regards!
I think that the column Sample is a consecutive order for assigning numbers from 1 in advance. For "count" you mean the sum of column B? If it's that, just look at the formulaes I wrote in the previous post. Otherwise check with the author, if it's available.
Regards!
Hi,SirJB7!
For "count" I mean how to count the number of this sample from this figure,i.e.the number of 33 students since there are only 10 rows in total. Also, from this figure there is no visable data showing the observation occurs most frequently either. So based on this figure, the function still cannot figure out the actual central tendency, right?
Thanks!
For "count" I mean how to count the number of this sample from this figure,i.e.the number of 33 students since there are only 10 rows in total. Also, from this figure there is no visable data showing the observation occurs most frequently either. So based on this figure, the function still cannot figure out the actual central tendency, right?
Thanks!
SirJB7
Excel Rōnin
Hi, snow!
From my point of view, the count issue is clearly solved with the SUM function, and for showing the most frequently value doesn't the MODE.ONE/MODE function do the job?
The rest of the considerations become abstract if it's not you who build the data set. You have to work with the data you've available, otherwise you should change the source, if available.
Regards!
From my point of view, the count issue is clearly solved with the SUM function, and for showing the most frequently value doesn't the MODE.ONE/MODE function do the job?
The rest of the considerations become abstract if it's not you who build the data set. You have to work with the data you've available, otherwise you should change the source, if available.
Regards!