View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scottwilsonx[_31_] scottwilsonx[_31_] is offline
external usenet poster
 
Posts: 1
Default statisitical significance

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

--
Message posted from http://www.ExcelForum.com