RE: Chart Point Analysis

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It looks like you are using Shewhart rules for this. I've never seen Excel
used to determine if any of the tests fail. I've used other software
packages for it. I'm sure someone else can answer your question, I'm
wondering if you'd want to see if the rule failed for the last n points, or
do you want the chart to display every time the rule fails.

Jon Peltier's Dynamic control chart may help you.

http://www.peltiertech.com/Excel/Charts/statscharts.html#CtrlCht

1. 7 points or more in a row on one side (above or below) the average
> 2. 7 points in a row that are constantly decreasing no matter where they
> fall in
> relation to the average.
> 3. 7 points in a row that are constantly increasing no matter where they
> fall in
> relation to the average.
> 4. Do 2/3rds of the points lie within the middle 1/3rd of the graph

"Neil" wrote:

> Does anyone know of a method for analysing points on a line chart that I have
> created?
>
> I have a chart with 30point on its, and a line plotted along the middle
> which is the average of the 30 readings.
>
> I have to use the following rules to check the chart, looking for the
> following conditions.
>
> 1. 7 points or more in a row on one side (above or below) the average
> 2. 7 points in a row that are constantly decreasing no matter where they
> fall in
> relation to the average.
> 3. 7 points in a row that are constantly increasing no matter where they
> fall in
> relation to the average.
> 4. Do 2/3rds of the points lie within the middle 1/3rd of the graph
>
> I'm not sure if any of this can be re-created automatically maybe using VBA?
> But if anyone has any suggestions as to how I can automate this analysis, so
> that I can give the Workbook to unskilled operators and let it tell them when
> one of the rules is broken, then your suggestions will be very welcome
>
> Thanks in advance
>
> Ian
>
>
>
>
.

Relevant Pages

  • Chart Point Analysis
    ... Does anyone know of a method for analysing points on a line chart that I have ... 7 points in a row that are constantly decreasing no matter where they ...
    (microsoft.public.excel.charting)
  • Re: Child needs glasses?
    ... But I do know that no matter what the "real" refraction is, +.50 O.U. is going to do absolutely nothing for anything. ... You don't have the chart in front of you, you don't have the VA, ... We do know that the poster doesn't trust the ... and that the poster is seeking medical advice from the ...
    (sci.med.vision)
  • What Is Hidden In The Secret Code Of The Markets Daily Movements
    ... any market for that matter. ... so anything you shove on a chart can ... randomly give you correct signals but this was happening a little too ... This new method was just nailing the market! ...
    (misc.invest.stocks)
  • Re: paste excel chart into adobe illustrator
    ... matter of something being Added/Replaced. ... graphics effects for your Excel charts... ... save the chart as a graphic file format Illy can import, ...
    (microsoft.public.mac.office.excel)
  • Re: Chart Point Analysis
    ... These rules can be built into Excel formulas or VBA routines; I did it some time ago using simplified versions of these rules. ... I would want it to test the entire chart as soon as a new set of data is entered, and as all the data is already held in various cells I'm beginning to wonder if I can run the test in VBA code on the data retrieved from the cells, rather than on the chart. ... 7 points in a row that are constantly increasing no matter where they fall in relation to the average. ...
    (microsoft.public.excel.charting)