Hi,

I haven't done maths for a while and have a task of creating some confidence levels in excel and displaying them on a graph (which is obviously easy).

So the data I have looks like this:

-32.78% (55-82 vs 48-140)
-7.28% (13-82 vs 12-140)
What this data means:

82 = total population for filter X
55 = total population for filter X, that are of a certain type
140 = total population for filter Y
48 = total population for filter Y, that are of a certain type

The next row is the same but of a different type.

Percentage is obviously the difference between the too filter populations.

The total population is 140 + 82.

Can someone help me get started on how to get the confidence levels for each type? Pretty stuck on how to get started.

Cheers,

Sam