How To Find The Significance Of Groups Using Excel

[rovaniemi]

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?

[Excel Fox]

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?