Standard Deviation

[gnosis13]

I have a report based on a table with several groups of similar fields for quality testing in a factory like diameter1, diameter2, diameter3, width1, width2, width3, etc. They don't always contain values.

In the report I am to dispay all of the records, but summarize at the bottom the Avg, Count, & StDev of all of the samples of each group like:
WIDTH1 WIDTH2 WIDTH3
5
7
6 8
Avg= x, Count=y, StDev=z

Average and count are easy but I can't figure out how to get standard deviation across 3 fields. I would like to keep this simple if possible by just using the control source field for the text boxes....if possible

Any suggestions?

A+, N+, MCP

 

[SteveR77]

For the standard deviation you can use the StDev function.

=StDev([FirstVal]+[SecondVal]+[ThirdVal])


Hope this helps,


Steve

 

[gnosis13]

Actually, That doesn't work mathmatically. You end up with a standard deviation based on the sums of the fields which can be extremely high compared to the individual values.

What I was hoping for was a range that would span multiple fields like StDev([testA]:[testB]). This syntax is incorrect but should illustrate the problem.


A+, N+, MCP

 

[gnosis13]

I have found a solution, but not what I had hoped for. I am going to create a table by looping through the records and combining the data....kinda going from horizontal to verticle. It's ugly but works and keeps the report simple.

A+, N+, MCP