ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get gender, race, age percentages from my spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/118912-how-do-i-get-gender-race-age-percentages-my-spreadsheet.html)

pms

How do I get gender, race, age percentages from my spreadsheet?
 
I have a spreadsheet for a large group of students. It contains many pieces
of data, such as age, race, gender, family members, etc. How can I get the
data sorted by percentages? For example, what % of students are Hispanic?
what % of students are male? I can do this all by hand, but is there a
function key? Should I try this in another program (not Excel)?

Gary''s Student

How do I get gender, race, age percentages from my spreadsheet?
 
Consider using Pivot Tables
--
Gary's Student


"pms" wrote:

I have a spreadsheet for a large group of students. It contains many pieces
of data, such as age, race, gender, family members, etc. How can I get the
data sorted by percentages? For example, what % of students are Hispanic?
what % of students are male? I can do this all by hand, but is there a
function key? Should I try this in another program (not Excel)?



All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com