• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

DStDev

Hi all,

I was wondering if there was a way to do this function on the contents of a row vs a column?  For example

Sample  Data1 Data2 Data3...
sample1   1        2       3

What I would like to do is get the DStDev on the fields Data1...Data3 for sample1 only?

Thanks for any help...

0
Mithrinder
Asked:
Mithrinder
  • 4
1 Solution
 
GRayLCommented:
Do it in Excel - not Access. You can do stats on columns in access tables. you cannot do rows. Import your access data into excel and go from there.
0
 
MithrinderAuthor Commented:
Any other Access only solutions?  There must be an easier way to do this in Access I need to do the StDev on the fields many many times and Excel is not a solution.  Maybe read all the samples I need into a temporary 1 column table and then preform the StDev on the field?  Am I missing something simpler here?

0
 
GRayLCommented:
You could generate a function StdDev in VB code, using a formula of your liking.

Call the code from a query:

Select Fld1, Fld2, Fld3, ..., Fldn, StdDev(Fld1, Fld2, Fld3, ...,Fldn) As SDev From tblData where Sample = 'sample1';

If you did not want to see the individual values only insert the StdDev() function in the select statement. In Fldn, n represents the maximum no of values. If there are variations in the number of elements you want to measure SD, you will have to enter commas to make up n entries and your code will have to deal with nulls properly. This would be fairly straightforward for 25 or so entries, but more than that you are into "tedious" coding. I think it is tedious with even less entries because you're trying to get a silk purse out of the sow's ear!

If the data were stored:
Samples
======
Spl1 Spl2 Spl3
  1      2     5
  3      3     3

     ........

  4     5      4

At least then you could DStDev("Spl3","Samples")

I still say you should do it in Excel. But these are two ways you may want to consider.

0
 
GRayLCommented:
Sorry, I shouldn't say of your liking, as there is only one way to calculate SD?  -  I mean you have to provide yourself with the formula as even among statiticians, they have their preferred ways of doing stat calcs.
0
 
GRayLCommented:
Thanks, glad I could help.

Ray
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now