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 |
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 |
All times are GMT +1. The time now is 08:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com