Page 1 of 2 12 LastLast
Results 1 to 15 of 25

Thread: Variance (2002)

  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Variance (2002)

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

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #6
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #7
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #9
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #10
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

    Thanks for your help

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Variance (2002)

    So your problem is solved?

  12. #12
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #13
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Again, thanks for your help.

  14. #14
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #15
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variance (2002)

    Yes, that is a 534345% increase.
    Legare Coleman

Page 1 of 2 12 LastLast

Posting Permissions

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