468,549 Members | 2,070 Online

# I have about 300+ pieces of data representing wood shingle widths from random run-of-the-mill batches... how can I show a bell curve in Access???

This question, I apologize, is more of a math question than it is
an Access question - I'm almost certain.

The bell curve is another name for the normal distribution, which is a
common type of graph that has more or less the shape of a bell. "The
Bell Curve" was also the title of a book, a controversial book back in
1994. It was about intelligence. If you graph scores on an IQ test on
the horizontal axis, and number of people who got that score on the
vertical axis, you get the bell curve shape.

I want to do the same with the wood shake width data, so I do a
crosstab query in Access to count up all the 1" wide pieces, the
2" wide pieces ... 8", 9" etc...

Width Shake Qty
1 1
1.5 7
1.75 2
2 18
2.25 6
2.5 16
2.75 7
3 27
3.25 12
3.5 34
3.75 12
4 26
4.25 17
4.5 21
4.75 7
5 18
5.25 12
5.5 18
5.75 2
6 27
6.25 3
6.5 15
6.75 3
7 10
7.25 4
7.5 6
7.75 1
8 4
8.5 1
8.75 2
9.5 1

Then I plot it & get a normal distribution pattern, but its
ziggy zaggy. What I want is to do what you can do in
Excel & superimpose a trend curve over it. I've done
it there & it really does a good job. But in Access, I don't
know how its done. I have Access 2.0 and Access 97.
What are my options?
Nov 12 '05 #1
2 2110
Why don't you just export the data to an Excel spreadsheet and do it from
there?

Mike Metzger
Nov 12 '05 #2
I did. Just like to stay in Access when I can.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On Fri, 24 Oct 2003 04:05:55 GMT, "Mike Metzger"
<me***************@hotmail.com> wrote:
Why don't you just export the data to an Excel spreadsheet and do it from
there?

Mike Metzger

Nov 12 '05 #3

### This discussion thread is closed

Replies have been disabled for this discussion.