Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Boxplots with outliers
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Boxplots with outliers
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." wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Boxplots | Charts and Charting in Excel | |||
Probability plot / boxplots | Charts and Charting in Excel | |||
Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
How do I calculate outliers in Excel? | Excel Discussion (Misc queries) | |||
how to exclude data outliers from formula or chart without deleti. | Excel Discussion (Misc queries) |