1. ## Variance (2002)

Is anyone able to assist with the following.
I have numerous spreadsheets in a workbook. (the amount always varies, but usually between 40 and 50). I need to check the variance of the contents of B2( 47.2) against C2 (132.2).

I can post a small sample if needed. Hoping someone is able to assist me with this assignment

2. ## Re: Variance (2002)

You mean the variance of all C2's in your book against all B2's?

=VAR('FirstSheetsName:LastSheetsName'!B2)

should give you the variance of B2 of all sheets.

3. ## Re: Variance (2002)

No, each worksheet is for a different Dept. so they will be on their own. In Sheet1, I have the disk space used for Aug. 2003 (B2) in Gigabytes and for Aug. 2004 (C2). I want to know how to the Variance between the two in "D2".

Later I want to test it on a monthly basis. June 2004 with July 2004 for each Customer (Jan to Feb, Feb to March, march to April etc.

4. ## Re: Variance (2002)

Variance is a measure for one variable. What exactly do you mean by variance between variables?

5. ## Re: Variance (2002)

Perhaps you could use the concept of an "individuals control chart" and calculate the moving range as an estimate of the variance.

The average of the moving range at any time would be an estimate of the customer variation.

It makes more sense to me to plot and compare month to month not year to year to look for trends and shifts in the values.

Steve

6. ## Re: Variance (2002)

Not realy sure what I am talking about. I was given the spreadsheet I attached earlier and told to figure out the variance between them. I realy don't have an idea of what I/Mangement wants or what I am talking about. But, then that is nothing new here.

7. ## Re: Variance (2002)

LOL... Sorry but I have absolutly no idea of what I am trying to do. This "individuals control chart" looks interesting and I am going to give it a try. Lets see if this is something they want.

8. ## Re: Variance (2002)

Variance is a property that refers to a distribution of values (of one variable as Hans says). It doesn't make much sense if there are only two values in the distribution (Aug 2003 and Aug 2004). I wonder if the request is really just to calculate the changes in the values (increases or decreases)?

Alan

9. ## Re: Variance (2002)

The Dept. manager will be here in a few hours so I guess I will have a meeting to see what he really wants.

10. ## Re: Variance (2002)

Will a got my answer. Attached is what they want to do and it doesn't use a Variance formual. Just simple Subtract and Div.

12. ## Re: Variance (2002)

Hmmm <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>... rather poor terminology there IMO. Perhaps "Variation" might be a better choice, or simply "Change". It sounds to me like a case of trying to make something sound fancier than it really is, and having it backfire from not knowing the real meaning of the more impressive-sounding term. Management tend to do that kind of thing though <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

Alan

13. ## Re: Variance (2002)

Yes, I got them to give me all the information that I needed. I had to call in our Asst. Manager and have him explaine what the Manager wanted. Now the only thing to do is change the total to a percent.

As for Management...... Can't touch that.

14. ## Re: Variance (2002)

In Aug. we used 885.0 kb of disk space, and then in Sept. we jump up to 4,729,825.0 of megabytes or is this gigabytes? I need to fine the difference in percentage. I tried it this way by my boss say's it is wrong.
These are the numbers I am working with:
Aug. - 885.0
Sept. - 4,729,825.0
Difference - 4,728,950.00
What is the Percentage ??? - 534345%

Sept.

15. ## Re: Variance (2002)

Yes, that is a 534345% increase.

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•