ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to display graph if only mean, SD & median values available? (https://www.excelbanter.com/charts-charting-excel/117351-how-display-graph-if-only-mean-sd-median-values-available.html)

A Renshaw

How to display graph if only mean, SD & median values available?
 
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.

Andy Pope

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

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

Cheers
Andy

A Renshaw wrote:
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.


A Renshaw

How to display graph if only mean, SD & median values availabl
 
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?


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com