compute a percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do a compute a simple percentage and how do i form a ratio. I am taking a
statistics class and this is the first time I have ever used excel and my
practice assignment says to compute the percentage of women and men enrolled
each year.

Then it says form a ration of female to male.

Appreciate any help.

Jeanie
 
For a single year:

In A1 enter the female enrollment
In B1 enter the male enrollment
In C1 enter:
=A1/C1 and format as percentage for percent female
In D1 enter:
=B1/C1 and format as percentage for percent male
In E1 enter:
=A1/B1 for ratio of females to males


Make a similiar row for each year you need.
 
For the ratio formula, you might use:

=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)

A bit more complex, but more accurate.

HTH,
Elkar
 
Back
Top