Results 1 to 2 of 2

Thread: How To Find The Significance Of Groups Using Excel

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    11
    Rep Power
    0

    How To Find The Significance Of Groups Using Excel

    Hi everyone,

    I would like to find out the significance of the different groups shown in the attached excel file.

    Initially what I would want is significance of individual groups.(A1, then A2, then B3, then B4).

    After that I would like to know the significance of multiple group wise, ie: A1 & and A2 as one group - their significance and then B3 & B4 as one group and their significance.

    Experts out there, is this possible? if so could you please help me?
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    I'm not a statistician, but I am guessing this is statistical significance? Can you explain what would be your output, and how you would have deduced that if you were to do this manually?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Calculating Subtotals Within Groups of Data Using UNION
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-24-2013, 11:54 AM
  2. Calculating Ratio Within Groups using Self Join
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-21-2013, 07:52 PM
  3. Email merge unique messages to groups and individuals
    By RagingWahoo in forum Excel Help
    Replies: 3
    Last Post: 10-14-2012, 11:32 PM
  4. Find Quarter Month From Date In Excel
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 15
    Last Post: 04-19-2012, 02:08 PM
  5. Replies: 1
    Last Post: 04-06-2012, 07:43 PM

Posting Permissions

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