Working on data for a project.
I have a column that can have 1 of four values. The values are words. For example sake:
a row can either have Alpha, Beta, Delta, or Gamma in this column.
I need to be able to tell what percentage of each value there is for a given set of rows. (I need to do this on about 50 chunks of similar data, but I need the percentages for each chunk)
Any help appreciated.
I suggest you post a sample data set to your question as I can't really follow what you want.
Post an example of the data layout AND a mocked up version of how you want the solution to look. You don't need to make the solution functional, just give us an idea of what you want.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Can you post some sample data and and the results you want to see...based on the sample?
ID Student College Grd Crs ID Sec Teacher Name
1 Alpha 10 1171 03C 1
2 Beta 10 1171 03C 1
3 Beta 10 1171 03C 1
4 Beta 10 1171 03C 1
5 Beta 10 1171 03C 1
6 Beta 10 1171 03C 1
7 Beta 10 1171 03C 1
8 Beta 10 1171 03C 1
9 Beta 10 1171 03C 1
10 Beta 10 1171 03C 1
11 Beta 10 1171 03C 1
12 Beta 10 1171 03C 1
13 Beta 10 1171 03C 1
14 Beta 10 1171 03C 1
15 Beta 10 1171 03C 1
16 Beta 10 1171 03C 1
17 Beta 10 1171 03C 1
18 Beta 10 1171 03C 1
19 Beta 10 1171 03C 1
20 Beta 10 1171 03C 1
21 Delta 10 1171 03C 1
22 Gamma10 1171 03C 1
4% Alapha
87 % Beta
4% Delta
4% Gamma
Try
=COUNTIF($B$2:$B$23,"Alpha")/COUNTA($B$2:$B$23)
You could let a pivot table do the heavy lifting for you...
• Select the data area
• Create a new pivot table...(I can't remember the XL2003 commands...Maybe: Data.PivotTable?)
...Row Labels: Drag Student here
...Values: Drag Student here ...(it will display as Count of Student )
...Right-click on the Count of Student area
...Select Value Field settings....Show_values_as tab
......Select: % of Total
You'll see the values you're looking for.
Is that something you can work with?
Jon's solution will work for me. I'm using this to select sub groups for further data analysis. Dividing groups by percentages of purity for Alpha, Beta, Delta, Gamma to draw correlations on effectiveness based on another colum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks