| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Cochran's Critical Values
Hi,
I'm trying to do some data analysis using Cochran's test for outlying variances. I have 4 replicate numbers from each of 20 laboratories. I calculate the variance of each set of data. I can work out the Cochran's test value by dividing the maximum variance by the sum of all the variances. Then I need to compare this with the Cochran critical values, which are available from tables, but these have gaps, so I'd like to be able to calculate them. Does anyone know of a formula to calculate these? Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Critical requirement. | Excel Worksheet Functions | |||
| Time calculation - Critical | Excel Discussion (Misc queries) | |||
| Critical graph | Excel Discussion (Misc queries) | |||
| Why did I get an unexpected critical error? | Excel Discussion (Misc queries) | |||
| Critical thinking puzzle | Excel Discussion (Misc queries) | |||
![Dave Curtis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
