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.
--
Gary's Student


"Jeanie" wrote:

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 the ratio formula, you might use:

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

A bit more complex, but more accurate.

HTH,
Elkar


"Gary''s Student" wrote:

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.
--
Gary's Student


"Jeanie" wrote:

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