Log in
Registerdo not use excel ? [Bioanalytics]
Dear martin and chbs,
Use of Excel has been previously discussed on the forum, for instance here.
Even though it is certainly not the correct tool to use for complex (or even intermediate) stats, I would not be shocked to see it used for descriptive stats (mean, SD, CV), where it is easier to use than a stats package for the basic user (using SAS or R to calculate the mean of 6 values would be like using a sledgehammer to kill a mosquito, and would seriously reduce the number of possible users). However this requires some precautions: validate your spreadsheet by comparing the results with those obtained with another software (or even manually), and then lock and password-protect your spreadsheet, only leaving unlocked the cells in which you will enter your data.
Upgrade to a new version of Excel (or any version change) will require a re-validation.
Regards
Ohlbe
❝ never never never never use excel for any statistical calculations
Use of Excel has been previously discussed on the forum, for instance here.
Even though it is certainly not the correct tool to use for complex (or even intermediate) stats, I would not be shocked to see it used for descriptive stats (mean, SD, CV), where it is easier to use than a stats package for the basic user (using SAS or R to calculate the mean of 6 values would be like using a sledgehammer to kill a mosquito, and would seriously reduce the number of possible users). However this requires some precautions: validate your spreadsheet by comparing the results with those obtained with another software (or even manually), and then lock and password-protect your spreadsheet, only leaving unlocked the cells in which you will enter your data.
Upgrade to a new version of Excel (or any version change) will require a re-validation.
Regards
Ohlbe
Complete thread:
- Excel sheet usage in bioanalytical calculations chbs 2009-01-19 10:35 [Bioanalytics]
![[Mix]](https://static.bebac.at/img/mix.png "open in Mix view")
- do not use excel martin 2009-01-19 11:52
- do not use excel ?Ohlbe 2009-01-19 23:54
- Never martin 2009-01-20 14:52
- Mathematical wizard Helmut 2009-01-20 17:03
- Do not trust in computers d_labes 2009-01-21 11:00
- Do not trust in computers Helmut 2009-01-21 13:00
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in Excelence d_labes 2009-01-21 15:42
- Do not trust in computers Helmut 2009-01-22 02:49
- Do not trust in computers Ohlbe 2009-01-22 10:33
- Even my calculator... Ohlbe 2009-01-22 22:06
- Even my calculator... Helmut 2009-01-22 23:26
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Ohlbe 2009-01-24 19:44
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Helmut 2009-01-22 23:26
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in computers Helmut 2009-01-21 13:00
- data exchange format martin 2009-01-21 12:16
- Raw data (paper vs. electronic) Helmut 2009-01-21 12:31
- Mathematical wizard - use WinNonlin Tools menu instead SDavis 2009-01-22 11:56
- Do not trust in computers d_labes 2009-01-21 11:00
- Mathematical wizard Helmut 2009-01-20 17:03
- Why not use R? Helmut 2009-01-21 01:02
- Why not use R? ElMaestro 2009-01-22 19:32
- Why not use R? ElMaestro 2009-01-23 22:45
- Why not use R? Aceto81 2009-01-26 16:15
- Why not use R? d_labes 2009-01-26 16:35
- Why not use R? Aceto81 2009-01-26 16:15
- Never martin 2009-01-20 14:52
- do not use excel ?Ohlbe 2009-01-19 23:54
- do not use excel martin 2009-01-19 11:52
Ing. Helmut Schütz