Analyze Data

How do I average the range?

"Bernard Liengme" wrote:

> Use COUNTIF to count the number of 1s, 2s etc
> You need a chart for this?
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "tokentrinkit" <tokentrinkit@discussions.microsoft.com> wrote in message
> news:512CEB35-C631-4318-90EC-1527419ECBD1@microsoft.com...
> >I am trying to anayze the data from a survey that was handed out to 20
> >people
> > and was ranked 1 - 5. Number 1 as being the least need for improvement and
> > 5
> > being the most need for improvement. How do I come up with a chart that
> > will
> > analyze this data?
>
>
>

=AVERAGE(range)
--
Brevity is the soul of wit.


"tokentrinkit" wrote:

> How do I average the range?
>
> "Bernard Liengme" wrote:
>
> > Use COUNTIF to count the number of 1s, 2s etc
> > You need a chart for this?
> > best wishes
> > --
> > Bernard V Liengme
> > www.stfx.ca/people/bliengme
> > remove caps from email
> >
> > "tokentrinkit" <tokentrinkit@discussions.microsoft.com> wrote in message
> > news:512CEB35-C631-4318-90EC-1527419ECBD1@microsoft.com...
> > >I am trying to anayze the data from a survey that was handed out to 20
> > >people
> > > and was ranked 1 - 5. Number 1 as being the least need for improvement and
> > > 5
> > > being the most need for improvement. How do I come up with a chart that
> > > will
> > > analyze this data?
> >
> >
> >