stats question

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
 
J

Jerry W. Lewis

Reposting the same question every few minutes does not increase your
chances of getting a meaningful answer. Replying to your own question
reduces your chances of getting an answer because it makes it look like
someone has already answered it.

Your question is unclear; How do you get 100 answers to a question that
is only asked to 32 people? If (contrary to your description) your
posted data are percentages, then how do you get 69%, 44%, 37%, or 33%
with a sample size of 31 (no integers round to those percentages of 31)?

Jerry
 

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

question on stat significance 0
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