analyzing survey date

I am trying to find out how to get frequencies for answers to survey
questions. For example, how many people said yes to question 3.

If you have a few frequencies to determine, look a the Countif function. If you
have many, you're probably better off creating a pivot table. Post back if
you're having trouble with either of these.

--
Regards,
Fred


"bren" <bren@discussions.microsoft.com> wrote in message
news:CA0B24A6-9A6A-44BD-BE27-01A21DA4DC80@microsoft.com...
>I am trying to find out how to get frequencies for answers to survey
> questions. For example, how many people said yes to question 3.

Fred has the right idea. Pivot tables are the best way to summarize this
type of data. They can summarize with several different functions and the
results can easily be converted to percentages or percentiles
--
Gary's Student


"Fred Smith" wrote:

> If you have a few frequencies to determine, look a the Countif function. If you
> have many, you're probably better off creating a pivot table. Post back if
> you're having trouble with either of these.
>
> --
> Regards,
> Fred
>
>
> "bren" <bren@discussions.microsoft.com> wrote in message
> news:CA0B24A6-9A6A-44BD-BE27-01A21DA4DC80@microsoft.com...
> >I am trying to find out how to get frequencies for answers to survey
> > questions. For example, how many people said yes to question 3.
>
>
>

Fred has the right idea. Pivot tables are the best way to summarize this
type of data. They can summarize with several different functions and the
results can easily be converted to percentages or percentiles
--
Gary's Student


"Fred Smith" wrote:

> If you have a few frequencies to determine, look a the Countif function. If you
> have many, you're probably better off creating a pivot table. Post back if
> you're having trouble with either of these.
>
> --
> Regards,
> Fred
>
>
> "bren" <bren@discussions.microsoft.com> wrote in message
> news:CA0B24A6-9A6A-44BD-BE27-01A21DA4DC80@microsoft.com...
> >I am trying to find out how to get frequencies for answers to survey
> > questions. For example, how many people said yes to question 3.
>
>
>

If you have a few frequencies to determine, look a the Countif function. If you
have many, you're probably better off creating a pivot table. Post back if
you're having trouble with either of these.

--
Regards,
Fred


"bren" <bren@discussions.microsoft.com> wrote in message
news:CA0B24A6-9A6A-44BD-BE27-01A21DA4DC80@microsoft.com...
>I am trying to find out how to get frequencies for answers to survey
> questions. For example, how many people said yes to question 3.