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
> >
> >