compute a percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeanie - 25 May 2006 17:04 GMT

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

Reply to this Message

Gary''s Student - 25 May 2006 19:10 GMT

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.

Signature

Gary's Student

> 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
[quoted text clipped - 6 lines]
>
> Jeanie

Reply to this Message

Elkar - 25 May 2006 19:36 GMT

For the ratio formula, you might use:

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

A bit more complex, but more accurate.

HTH,
Elkar

> For a single year:
>
[quoted text clipped - 19 lines]
> >
> > Jeanie

Reply to this Message