# MedCalc manual - contents

## Introduction

- Program installation
- Auto-update
- Regional settings support
- Selection of display language
- The MedCalc menu bar
- The spreadsheet data window
- How to enter data
- How to enter dates
- Missing values
- Data checking
- How to save data
- Statistics
- Variables
- Filters
- Graphs
- Add graphical objects
- Reference lines
- Recall dialog
- Notes editor

## File menu

## Edit menu

## View menu

## Format menu

- Font
- Increase font size
- Decrease font size
- Spreadsheet
- Format graph
- Graph legend
- Reset graph titles and options

## Tools menu

- Sort rows
- Exclude & Include
- Fill column
- Stack columns
- Generate random sample
- Create groups...
- Rank cases
- Percentile ranks
- z-scores
- Power transformation
- Case-Control matching
- Edit variables list
- Edit filters list
- Select variable for case identification
- Enter key moves cell pointer
- Options

## Statistics menu

## Statistics menu (continued)

## Graphs menu

- Data comparison graphs
- Multiple comparison graphs
- Clustered multiple comparison graphs
- Multiple variables graphs
- Clustered multiple variables graphs
- Multiple line graph
- Control chart
- Youden plot
- Polar plot
- Forest plot
- Function plot

## Tests menu

- Test for one mean
- Test for one proportion
- Chi-squared test
- Fisher's exact test for a 2x2 table
- McNemar test on paired proportions
- Comparison of means (t-test)
- Comparison of standard deviations (F-test)
- Comparison of correlation coefficients
- Comparison of two proportions
- Comparison of areas under independent ROC curves
- Confidence interval for a rate
- Comparison of two rates
- Relative risk
- Odds ratio
- Inter-rater agreement
- Diagnostic test
- Likelihood ratios (2xk table)

## Sample size menu

- Sample size calculation: Introduction
- Single mean
- Single proportion
- Comparison of two means
- Paired samples t-test
- Comparison of two proportions
- McNemar test
- Correlation coefficient
- Survival analysis (logrank test)
- Bland-Altman plot
- Area under ROC curve
- Comparison of two ROC curves
- Confidence interval estimation & Precision ...

## Window menu

## Help menu

- MedCalc help
- What's new
- MedCalc on the Web
- Register
- Unegister MedCalc
- How to cite MedCalc
- About MedCalc

## Spreadsheet overview

- Introduction
- Operators
- Relative and absolute cell addresses
- Complex numbers
- Mathematical functions
- Trigonometric functions
- Hyperbolic functions
- Engineering functions
- Complex number functions
- Gamma function and related functions
- Statistical functions
- Statistical functions on variables
- Statistical test functions
- Probability distribution functions
- Date and time functions
- Logical functions
- String functions
- Miscellaneous functions

## Appendices

- Control keys
- Notation and symbols
- Computational notes
- Accuracy and Precision
- Tests for Normal distribution
- Independent samples t-test
- Relative risk and Odds ratio
- Logarithmic transformation
- Skewness and Kurtosis
- Heteroscedasticity
- Bootstrapping
- Calculation of Trimmed Mean, SE and confidence interval
- A note on Passing-Bablok regression
- A note on BC
_{a}bootstrap confidence intervals

- Statistical tables ...
- Miscellaneous tables ...
- Tips and tricks
- How to export your results to Microsoft Word
- How to define and use labels for the categories of a variable
- How to reorder a categorical variable
- Transforming data to normality
- Auto-complete function
- Auto-values
- Exclude outliers
- Data point identification in graphs
- Save and recall graphs and statistics
- Statistical info in graph windows
- Controlling the movement of the cellpointer
- Locking the cellpointer in a selected area

- References