PC Review


Reply
Thread Tools Rate Thread

Boxplots with outliers

 
 
=?Utf-8?B?Q29uZnV6emxlZC4=?=
Guest
Posts: n/a
 
      16th Mar 2006
Hi,

I'm doing this assignment for Maths and I need to do parallel boxplots. I
know how to do them on Excel, but one of the boxplots has outliers and I MUST
plot them in, but I have no idea how to do that. I was hoping that someone
would be able to tell or show me how to do that.

I'd appreciate it.
Thanks.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      17th Mar 2006
After doing the boxplots
(http://peltiertech.com/Excel/Charts/BoxWhiskerV.html) I would collect the
outlying data into a single range, one column for X and one for Y, where X
is the order of the category corresponding to the outlier. Add this data to
the chart, and plot it as an XY series with markers (using the star marker)
and no lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Confuzzled." <Confuzzled.@discussions.microsoft.com> wrote in message
news:868B51E1-EA57-4136-9134-(E-Mail Removed)...
> Hi,
>
> I'm doing this assignment for Maths and I need to do parallel boxplots. I
> know how to do them on Excel, but one of the boxplots has outliers and I
> MUST
> plot them in, but I have no idea how to do that. I was hoping that someone
> would be able to tell or show me how to do that.
>
> I'd appreciate it.
> Thanks.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to make BOXPLOTs in excel? =?Utf-8?B?QW5nZWxv?= Microsoft Access 1 2nd Nov 2006 12:52 AM
Boxplots? =?Utf-8?B?UGhpbGlw?= Microsoft Access 2 23rd Apr 2006 10:45 AM
Boxplots =?Utf-8?B?UGhpbGlw?= Microsoft Excel Charting 3 14th Apr 2006 03:14 PM
Probability plot / boxplots =?Utf-8?B?TWljaGVsIEIu?= Microsoft Excel Charting 3 10th Mar 2006 08:12 PM
How do I form boxplots =?Utf-8?B?VUR1ZGU=?= Microsoft Excel Misc 1 21st Mar 2005 11:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:45 AM.