8
Both columns A and B have been formatted as Date, see above.
When you enter a date in the spreadsheet with a year less than 100, MedCalc will interpret this year as a year in the 20th
century: 20.12.88 = 20.12.1988. When you enter 0 as the year number, MedCalc will interpret this as the year 1900: 20.12.00
= 20.12.1900. So when you want to enter a date situated in the 19th or 21st century, enter the year using 4 digits.
Dates
The integer portion of the serial date-time number, ddddd, represents the number of days since 1801-Jan-1, with 1801-Jan-1
begin the first day. For example, the date 5-Jul-2011 is stored as 76887.
• Date strings, for example "5.12.72" or "5.7.1956" can be converted to serial date numbers using the DATEVALUE function
(see Date and time functions, p. 321).
• A serial date number can be back-transformed to a date string using the DATE function.
Times
The fractional portion of the serial date-time number, tttttt, represents the fractional portion of a 24-hour day. For example, 6:00
AM is stored as 0.25, or 25% of a 24-hour day. Similarly, 6PM is stored at 0.75, or 75% percent of a 24-hour day.
• Time strings, for example "14:30" can be converted to serial time numbers using the TIMEVALUE function.
• A serial time number can be back-transformed to a time string using the TIME function.
Missing values
The data for all variables of one case (patient, sample) are entered on one row in the spreadsheet. When for one variable you
do not know the value (or entry) for the case, you leave the corresponding cell blank and do not enter any data in this cell.
As a rule, the program will ignore an entry for a numeric variable when it is unable to interpret this entry as a number.
When text is entered in a cell for a numeric variable, the program will not take this case into account for calculations (it will not
substitute the text value by a zero).
The following are recognized as numbers:
5.4
LOG(36.5)
HEIGHT/WEIGHT (when ‘Height’ and ‘Weight’ are correctly defined variables)
HEIGHT/100
The following are not recognized as numbers and are ignored for calculations:
5,8
‘4.6
LOG(CONC) (when ‘CONC’ is not a correctly defined variable or in case the variable ‘CONC’ has a zero, negative
or missing value)
SQRT(-9) (error!)
1/ HEIGHT (when ‘HEIGHT’ is not a correctly defined variable or in case ‘HEIGHT equals zero)
剩余353页未读，继续阅读
chenwei0930
- 粉丝: 0
- 资源: 1
我的内容管理
展开
最新资源
- 最优条件下三次B样条小波边缘检测算子研究
- 深入解析：wav文件格式结构
- JIRA系统配置指南：代理与SSL设置
- 入门必备：电阻电容识别全解析
- U盘制作启动盘：详细教程解决无光驱装系统难题
- Eclipse快捷键大全：提升开发效率的必备秘籍
- C++ Primer Plus中文版：深入学习C++编程必备
- Eclipse常用快捷键汇总与操作指南
- JavaScript作用域解析与面向对象基础
- 软通动力Java笔试题解析
- 自定义标签配置与使用指南
- Android Intent深度解析：组件通信与广播机制
- 增强MyEclipse代码提示功能设置教程
- x86下VMware环境中Openwrt编译与LuCI集成指南
- S3C2440A嵌入式终端电源管理系统设计探讨
- Intel DTCP-IP技术在数字家庭中的内容保护
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
