If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deming Regression for labs
Does anyone know of a excel add-on or FREE software that includes the
Deming regression? My hospital lab is part of a multi-hospital system, but they do not want to buy software for each lab. Our lab director thinks there is only one person that has the software (EP Evaluator) to do all the calculations for lot to lot, normal range verification, etc.. at the flagship hospital lab. We should not have to wait 2-3 weeks for them to do our statistics when it could be done in an hour or so. I do not want to use my money to buy Analyse-it or EP Evaluator if I can avoid it. I know EP has an online version, but then again it costs $1 dollar per page. I can pretty much do everything I need in excel except for the Deming regression. I have searched the internet for a free add-on to no avail. Any help would be appreciated. |
#2
|
|||
|
|||
Deming Regression for labs
Here is a chapter from a book with a simple Excel macro that calculates
Deming slope and intercept. http://books.google.com/books?id=5i1...age&q=&f=false - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ MI wrote: Does anyone know of a excel add-on or FREE software that includes the Deming regression? My hospital lab is part of a multi-hospital system, but they do not want to buy software for each lab. Our lab director thinks there is only one person that has the software (EP Evaluator) to do all the calculations for lot to lot, normal range verification, etc.. at the flagship hospital lab. We should not have to wait 2-3 weeks for them to do our statistics when it could be done in an hour or so. I do not want to use my money to buy Analyse-it or EP Evaluator if I can avoid it. I know EP has an online version, but then again it costs $1 dollar per page. I can pretty much do everything I need in excel except for the Deming regression. I have searched the internet for a free add-on to no avail. Any help would be appreciated. |
#3
|
|||
|
|||
Deming Regression for labs
|
#4
|
|||
|
|||
Deming Regression for labs
Here is a blog post I just wrote about Deming Regression:
Deming Regression | PTS Blog http://peltiertech.com/WordPress/deming-regression/ This post with a simple utility should be online shortly: Deming Regression Utility | PTS Blog http://peltiertech.com/WordPress/dem...ssion-utility/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Jon Peltier wrote: Here is a chapter from a book with a simple Excel macro that calculates Deming slope and intercept. http://books.google.com/books?id=5i1...age&q=&f=false - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ MI wrote: Does anyone know of a excel add-on or FREE software that includes the Deming regression? My hospital lab is part of a multi-hospital system, but they do not want to buy software for each lab. Our lab director thinks there is only one person that has the software (EP Evaluator) to do all the calculations for lot to lot, normal range verification, etc.. at the flagship hospital lab. We should not have to wait 2-3 weeks for them to do our statistics when it could be done in an hour or so. I do not want to use my money to buy Analyse-it or EP Evaluator if I can avoid it. I know EP has an online version, but then again it costs $1 dollar per page. I can pretty much do everything I need in excel except for the Deming regression. I have searched the internet for a free add-on to no avail. Any help would be appreciated. |
Thread Tools | |
Display Modes | |
|
|