| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing for sig. differences between percentages in Excel
In Excel, what is the function that tests for statistically significant
differences between two percentages? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for sig. differences between percentages in Excel
You need a larger sample than 2 to arrive at a statistically significant
difference. To that end you can use Standard Deviation (StdDev) and see which items deviate significantly from the average... -- HTH... Jim Thomlinson " wrote: In Excel, what is the function that tests for statistically significant differences between two percentages? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Testing for sig. differences between percentages in Excel
My apologies, I was not clear. How do I test for differences between two
percentages which are averages? Say, two sets of data, test scores, I want to test the average percentage for test 1 to the average percentage for test 2. So, if I have the averages for the two percentages, and the size of each sample (in this example, the number of test scores for tests 1 and 2, respectively), I should be able to test for sig. differences. How does one do this in Excel? (I've done it in another statistical program.) "Jim Thomlinson" wrote: You need a larger sample than 2 to arrive at a statistically significant difference. To that end you can use Standard Deviation (StdDev) and see which items deviate significantly from the average... -- HTH... Jim Thomlinson " wrote: In Excel, what is the function that tests for statistically significant differences between two percentages? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel 2007 BUG UsedRange/LastCell differences with Excel2003. | Excel Discussion (Misc queries) | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| When subtotaling can Excel also calculate percentages | Excel Worksheet Functions | |||
Linear Mode
