Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages of counts
I have several thousand records of traveling to work times in minutes. I
want percentages of the total amount of times. For example: there are 5 occurances of 30 minutes, 7 occurances of 20 minutes, 11 occurances of 15 minutes....etc. So for the total 23 occurances, approximately 50% of trips take 15 min, 34% of trips take 20 minutes and 21% of trips take 30 min....etc. I have subtotaled the number of times, how do I get the percentages of those totals of the grand total. I am new to Excel and am not finding the manual very helpful. -- SP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages of counts
Have a look at FREQUENCY
Then tell us how you data is set out so we can be more helpful best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "shahnaz" wrote in message ... I have several thousand records of traveling to work times in minutes. I want percentages of the total amount of times. For example: there are 5 occurances of 30 minutes, 7 occurances of 20 minutes, 11 occurances of 15 minutes....etc. So for the total 23 occurances, approximately 50% of trips take 15 min, 34% of trips take 20 minutes and 21% of trips take 30 min....etc. I have subtotaled the number of times, how do I get the percentages of those totals of the grand total. I am new to Excel and am not finding the manual very helpful. -- SP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Tab Counts | Excel Discussion (Misc queries) | |||
Column Counts | Excel Discussion (Misc queries) | |||
counts of dates | New Users to Excel | |||
getting several hundred n-counts | Excel Discussion (Misc queries) | |||
floating counts | Excel Discussion (Misc queries) |