Log in
RegisterDo not trust in computers [Bioanalytics]
posted by Helmut 
– Vienna, Austria, 2009-01-21 14:00 (5573 d 07:09 ago) – Posting: # 3091
Views: 24,947
Dear DLabes!
Yeah, I like that!
Definitely. If one has to use it for any reasons, he/she should follow the Ohlbe's suggestions.
BTW, even in M$-Excel it's possible to get the correct answer (if
gives
There are even better speadsheets around. OpenOffice Calc returns
❝ flame warin' a little bit with you.
Yeah, I like that!
❝ By the way, M$-Excel is an extraordinary software in this way.
Definitely. If one has to use it for any reasons, he/she should follow the Ohlbe's suggestions.
BTW, even in M$-Excel it's possible to get the correct answer (if
STDEV() is avoided): | A | B
+---------------+-----------------------------
1 | 90000001 | =(A1-A$4)^2
2 | 90000002 | =(A2-A$4)^2
3 | 90000003 | =(A3-A$4)^2
4 | =MEAN(A1:A3) | =SUM(B1:B3)
5 | =STDEV(A1:A3) | =SQRT(1/(COUNT(A1:A3)-1)*B4)gives
| A | B
+---------------+-----------------------------
1 | 90000001 | 1
2 | 90000002 | 0
3 | 90000003 | 1
4 | 90000002 | 2
5 | 0 | 1There are even better speadsheets around. OpenOffice Calc returns
1 if STDEV() is used, even with the oldest version I have on one of my machines, namely v2.0 from 2005.—
Dif-tor heh smusma 🖖🏼 Довге життя Україна!![[image]](https://static.bebac.at/pics/Blue_and_yellow_ribbon_UA.png)
Helmut Schütz
![[image]](https://static.bebac.at/img/CC by.png)
The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes
Dif-tor heh smusma 🖖🏼 Довге життя Україна!
Helmut Schütz
The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes
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 computersHelmut 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 computersHelmut 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