Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

mean, median, mode, standard diviation

14 views
Skip to first unread message

Kathi

unread,
Jan 27, 2009, 12:14:05 PM1/27/09
to
Is there a way to display mean, median, mode, standard diviation
automatically on a graph in excel?

Andy Pope

unread,
Jan 27, 2009, 1:01:35 PM1/27/09
to
Hi,

Not automatically but you can construct it.
http://peltiertech.com/Excel/Charts/RunChtLines.html

Cheers
Andy

Kathi wrote:
> Is there a way to display mean, median, mode, standard diviation
> automatically on a graph in excel?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

David Biddulph

unread,
Jan 27, 2009, 1:21:36 PM1/27/09
to
Any values that you calculate on a spreadsheet can be added as new series to
a chart.

If you are asking whether this is one button that will insert all the
calculation formulae into your spreadsheet and add the series to the chart,
the answer is no.
--
David Biddulph

"Kathi" <Ka...@discussions.microsoft.com> wrote in message
news:0D63B627-ED30-4ECA...@microsoft.com...

ashoksharma

unread,
Nov 17, 2009, 4:13:54 AM11/17/09
to
how create a mean charting


Kath wrote:

mean, median, mode, standard diviation

27-Jan-09

Is there a way to display mean, median, mode, standard diviation
automatically on a graph in excel?

Previous Posts In This Thread:

On Tuesday, January 27, 2009 12:14 PM
Kath wrote:

mean, median, mode, standard diviation
Is there a way to display mean, median, mode, standard diviation
automatically on a graph in excel?

On Tuesday, January 27, 2009 1:01 PM
Andy Pope wrote:

Re: mean, median, mode, standard diviation
Hi,

Cheers
Andy

Kathi wrote:

--

On Tuesday, January 27, 2009 1:21 PM
David Biddulph wrote:

Any values that you calculate on a spreadsheet can be added as new series to a
Any values that you calculate on a spreadsheet can be added as new series to
a chart.

If you are asking whether this is one button that will insert all the
calculation formulae into your spreadsheet and add the series to the chart,
the answer is no.
--
David Biddulph

"Kathi" <Ka...@discussions.microsoft.com> wrote in message
news:0D63B627-ED30-4ECA...@microsoft.com...

EggHeadCafe - Software Developer Portal of Choice
Performance Testing .NET Web Apps [MSPRESS]
http://www.eggheadcafe.com/tutorials/aspnet/e993ac90-3171-4984-a4af-00387a2f471e/performance-testing-net.aspx

0 new messages