473,320 Members | 1,883 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Stumped on Standard deviations

Hello,

I am trying to figure out how to create a sdev field on a report or in
a query that is based on a claculation of 2 fields.

I have these fields:
Number of samples--this is a calcualted field in query (counts samples
grouped by a "week" and "group" fields)
Sum of Volume--this is a calcualted field in a query (grouped by week
and group)
Avg volume--- (volume\number of samples)-calculated in a query
I am trying to get the SDev for the volume by group and week--have
tried

sdev (volume\number of samples)

but it is not working. I have alos tried to use the Sdev function on
the avg vbolume field in the query and that is not working either. I
must be missing something--can anyone help me figure this out?

Thanks
bob

If you need more info pleae let me know
Mar 24 '06 #1
2 1272
Hi Bob. If you need the std of the values of "volume" falling "within"
each group, according to your description, this should simply be
sdev(volume). Why do you feel you need to divide by the number of
observations in the group?

If it is not this, you have to clarify what std are you actually
interested in (are you, for instance, talking about std "between"
groups?)

-t

al*****@cox.net ha scritto:
Hello,

I am trying to figure out how to create a sdev field on a report or in
a query that is based on a claculation of 2 fields.

I have these fields:
Number of samples--this is a calcualted field in query (counts samples
grouped by a "week" and "group" fields)
Sum of Volume--this is a calcualted field in a query (grouped by week
and group)
Avg volume--- (volume\number of samples)-calculated in a query
I am trying to get the SDev for the volume by group and week--have
tried

sdev (volume\number of samples)

but it is not working. I have alos tried to use the Sdev function on
the avg vbolume field in the query and that is not working either. I
must be missing something--can anyone help me figure this out?

Thanks
bob

If you need more info pleae let me know


Mar 25 '06 #2
HI--and thanks-you are totally right! I had a serious case of brain
lock. Needed to split my query into 2 queries-- one that performs
operations at the "sample" level, and one that performs taht at the
group level. Thanks for helping me to sift throught the grayness!

Bob

On 25 Mar 2006 10:41:05 -0800, to**************@uniroma1.it wrote:
Hi Bob. If you need the std of the values of "volume" falling "within"
each group, according to your description, this should simply be
sdev(volume). Why do you feel you need to divide by the number of
observations in the group?

If it is not this, you have to clarify what std are you actually
interested in (are you, for instance, talking about std "between"
groups?)

-t

al*****@cox.net ha scritto:
Hello,

I am trying to figure out how to create a sdev field on a report or in
a query that is based on a claculation of 2 fields.

I have these fields:
Number of samples--this is a calcualted field in query (counts samples
grouped by a "week" and "group" fields)
Sum of Volume--this is a calcualted field in a query (grouped by week
and group)
Avg volume--- (volume\number of samples)-calculated in a query
I am trying to get the SDev for the volume by group and week--have
tried

sdev (volume\number of samples)

but it is not working. I have alos tried to use the Sdev function on
the avg vbolume field in the query and that is not working either. I
must be missing something--can anyone help me figure this out?

Thanks
bob

If you need more info pleae let me know


Mar 28 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Manny | last post by:
I have a web form "Page1.asp" and it reads data from a database, does some calculations, and displays the records in pages. Works fine. I have a button that displays on the page, defined as...
1
by: Sharron | last post by:
This problem has me completely stumped...everyone on the net seems to have this problem but I don't understand what they are talking about. I know my code is correct it compiles fine but when I try...
0
by: Sharron | last post by:
Hello, This problem has me completely stumped...everyone on the net seems to have this problem but I don't understand what they are talking about. I know my code is correct it compiles fine but...
3
by: Chris | last post by:
I have yet to understand or get a response on the issue I'm having. I'm taking an asp web application and migrating it from Windows 2K to 2003. I have the new website location (2003) settings...
1
by: Kent Wolf | last post by:
I have some code that worked just fine in Access 97 with Word 97 in Windows NT 4.0. We upgraded one of our OS's to Windows XP. Now, the code won't work. I got an error that said something...
6
by: BBM | last post by:
Hi, I'm having trouble getting control data binding to work. As I understand it, the simplest form of databinding requires three things: 1) A control (say a textbox) on a form or user...
3
by: Dave | last post by:
So I'm trying to write a CSS preprocessor. I want to add the ability to append a selector onto other selectors. So, given the following code: ========================================= #selector...
1
by: slamtart | last post by:
Hi everyone, Stumped for awhile with this one. Not sure what to do next. Basically, I have a laptop computer which I use for work. Prior to around May of this year, there's no trick to...
9
by: lajohn63 | last post by:
I'm trying to calculate a standard deviation for each record in a database...the record has 12 fields which contain consumption for each month of the year. I want to calculate the standard deviation...
3
by: Chevron Boyde | last post by:
Hi All I have just installed studio 2008 and created a new winforms app. I have added a sql express db to the project with 1 table called LogEntries containing 2 columns: LogEntryID (int, auto...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.