Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I suppress values from appearing in a graph? Kim Excel Discussion (Misc queries) 0 October 27th 06 01:07 AM
How do I add % of values to stacked graph in Excel? kataamy Charts and Charting in Excel 1 October 19th 06 02:36 PM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 05:00 AM
count and display unique values joe Excel Worksheet Functions 2 December 19th 05 02:11 AM
overcoming zero values in line graph marika1981 Charts and Charting in Excel 3 March 11th 05 03:09 AM


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"