Calculating Variance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone;

Is there anyway to calculate variance for a product between two years, in an
access report? Any help would be greatly appreciated.

Thank You.
 
The VarP function returns the variance for a population the Var function
returns the variance for a population sample. Look up Var in the Help file.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Hi Everyone;

Is there anyway to calculate variance for a product between two years, in an
access report? Any help would be greatly appreciated.

Thank You.
Click to expand...

Are you wanting to obtain variance on a calculated field (such as a
percent) for which you need the true calculated average (instead of an
average of percents)?

For instance:

Sold Opportunities To Sale Closing Percent
10 100 10%
6 120 5%
8 24 33%

If you attempt to calculate variance/stdev using the "Closing Percent"
column, it will calculate an "Average of Closing Percent" for use
within the canned function. What you need in fact would be the percent
taken from the column totals of sales and opportunities.

So, this may mean nothing to you (if you aren't using a calculated
field) but if you are, I'll post some code which will work nicely in
queries.

-Kris
 
Back
Top