LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i put an asterisk on a bar chart to show significance L Charts and Charting in Excel 3 April 2nd 23 07:04 PM
Significance of _- in custom format dee Excel Discussion (Misc queries) 2 March 29th 07 07:50 PM
How do I insert symbol to indicate significance on a bar graph? Hans Coetzee Charts and Charting in Excel 1 November 5th 05 03:34 AM
= sign has no significance. Gary Adamson Excel Worksheet Functions 1 December 9th 04 06:19 PM
Regression Significance or P factor Glen Millar Excel Programming 4 September 10th 04 12:52 PM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"