5.9 20
6.4 24
7 28
9 36
9.9 40
10.1 44
10.8 48
12.7 60
13.4 72
14.7 84
15.2 96
15.8 120
Simply, lab values above left charted against age in hours on right. The
resulting plotted graph represents a percentile ranking across the X axis and
below the plotted line of lab values. If this was on a board and pins were
used to identify the location of the points identified by subsequent data, I
would want to flag all those values as either above or below the plotted
graph represented by the above data. Thank You for being patient with my
ignorance. I could not see a way to attach a workbook or worksheet to this
reply.
"Conrad Carlberg" wrote:
Hi Jeff,
Now it does seem that you'll want a chart instead of a simple numeric
comparison. Yes, more detail might be helpful, but in the meantime:
An Excel chart can display more than just one data set (where "data set"
means, in the terminology you're using, a series of age in hours paired with
a percentile ranking). So, a chart could display two data sets. Both data
sets would have the same column for the X axis, but two different columns
for the Y axis.
1. In (say) Column A, age in hours, for the X axis.
2. In (say) Column B, percentile ranking, for the Y axis.
3. In (say) Column C, test value for the new observation, as a percentile,
also on the Y axis.
You would have a value in Column A for each data point. There would be a
value in Column B or Column C, but not both, depending on whether it's an
old, comparison observation, or a new one.
I guess that if you need to compare data sets on a daily basis, while each
observation is made on an hourly basis, that you'll need to update/refresh
the data every 24 hours. In that case, you're probably better off using
Excel rather than Access -- not due to its greater power, but due to its
greater convenience.
If you want to provide more detail, please attach an Excel workbook showing
what you've done so far to a reply to this message.
C^2
Conrad Carlberg
"Jeff C" wrote in message
...
The graph simply plots a numerical test value with an age in hours and the
line graph represents a percentile ranking. I just want to flag each new
data pair as being either above or below the line. I am just too much of
a
math novice to know the correct term that I am looking for in this
description and way too much of a novice to know how to solve the problem.
Thanks for trying to help. I can offer more detail if you would like.
"Conrad Carlberg" wrote:
Hi Jeff,
As I read your post, it seems that the comparison you're after is
entirely
feasible. But how do you want to decide whether new data sets are above
or
below, Less Than or Greater Than a limit that's been set by your graph?
On
the basis of a discrete point comparison? [e.g., Average(OldSet)
Average(NewSet)]? In that case, a chart/graph wouldn't be needed. On
some
other basis? This sounds like an SPC application.
C^2
Conrad Carlberg
"Jeff C" wrote in message
...
I have worked some with MS Access, much less in Excel and really am
not
very
math oriented but I need help. Not much on graphing in the Access
Forum
but
several suggestions to use Excel because it is much more powerful in
this
area. I have numerical test values on the Y axis matched with
numerical
values representing age in hours on the X axis, plotting a line graph
in
Access which represent a limit.
I need to compare new data sets on a daily basis with this line graph
identifying each set as either above or below, Less Than or Greater
Than
the
limit set my this graph. Is there a formula or method available or
that
can
be created or viewed in Excel?
Is this possible? Can someone point me to an example or maybe help
walk
me
through? Thank You.
|