How to display graph if only mean, SD & median values available?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

A Renshaw - 03 Nov 2006 11:29 GMT

I have a series of discrete items of data comprising mean, SD and median
values (no range or actual data series available).

I am trying to display each discrete data point graphically (mean, SD and
median) but am struggling to do this. I am using latest version of Excel but
can also access SPSS. If anyone can help it would be very much appreciated.

Reply to this Message

Andy Pope - 03 Nov 2006 13:53 GMT

Hi,

Does Jon's page help?
http://peltiertech.com/Excel/Charts/RunChtLines.html

Cheers
Andy

> I have a series of discrete items of data comprising mean, SD and median
> values (no range or actual data series available).
>
> I am trying to display each discrete data point graphically (mean, SD and
> median) but am struggling to do this. I am using latest version of Excel but
> can also access SPSS. If anyone can help it would be very much appreciated.

Reply to this Message

A Renshaw - 03 Nov 2006 17:24 GMT

Thanks Andy. My problem is that I don't have a normally-distributed data
series for example, just mean values, SD and median values. I need to plot
the mean with SD bars, and a median value within it.

Quite simple if I only had the data set, but my research method can only
given me those three values (mean, SD and median). Any other ideas?

Reply to this Message