question on stat significance

S

scottwilsonx

Hello everyone. Not sure if this is possible.....let me know what yo
think.

I have calculated a number of values, based on a YES / NO answer t
certain questions.

The following data is ranged in A3:C10 with the headers in row3.
Each value represents the number of respondents who answered yes befor
and after a change to the 7 questions.

Ques Before After
1 81 100 (sample size 32)
2 76 97 (sample size 32)
3 84 94 (sample size 32)
4 69 100 (sample size 31)
5 44 97 (sample size 31)
6 37 97 (sample size 31)
7 33 100. (sample size 31)

I want to be able to calculate if the after result is statisiticall
significant based on the % of respondents who answered yes.
Ie: is the change from 81 to 100 statisitcally significant based on
sample size of 32.

If anyone can help with this, it would be gratefully received.

Thanks

Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stats question 1
statistical significance 1
statisitical significance 5
VLOOKUP 2
Excel Formula question 0
Stats question 0
help 1
Get Past the 7 Nested IF limit 2

Top