MedCalc
®
easy-to-use statistical software
Menu
Home
Features
Download
Order
Contact
FAQ
Manual
Manual
»
Spreadsheet overview
»
Matrix functions
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
New
Open
Save
Save as
Add file
Export
Page setup
Print
Properties
Exit
Edit menu
Undo
Cut
Copy
Paste
Delete
Select all
Find
Find & replace
Go to cell
Fill
Insert - Remove
Transpose
View menu
Spreadsheet
Show formulas
Show gridlines
Contents bar
Toolbars
Status bar
Full screen
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
Create groups form quantiles
Create random groups
Create user-defined 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
Summary statistics
Outlier detection
Distribution plots
Histogram
Cumulative frequency distribution
Normal plot
Dot plot
Box-and-whisker plot
Correlation
Correlation coefficient
Partial correlation
Rank correlation
Scatter diagram
Regression
Regression
Scatter diagram & regression line
Multiple regression
Logistic regression
Probit regression (Dose-Response analysis)
Nonlinear regression
T-tests
One sample t-test
Independent samples t-test
Paired samples t-test
Rank sum tests
Signed rank sum test (one sample)
Mann-Whitney test (independent samples)
Wilcoxon test (paired samples)
Variance ratio test (F-test)
ANOVA
One-way analysis of variance
Two-way analysis of variance
Analysis of covariance
Repeated measures analysis of variance
Kruskal-Wallis test
Friedman test
Crosstabs
Chi-squared test
Fisher's exact test
McNemar test
Cochran's Q test
Relative risk & Odds ratio
Frequencies bar charts
Survival analysis
Kaplan-Meier survival analysis
Cox proportional-hazards regression
Meta-analysis
Introduction
Continuous measure
Correlation
Proportion
Relative risk
Risk difference
Odds ratio
Area under ROC curve
Generic inverse variance method
Serial measurements
Reference intervals
Reference interval
Age-related reference interval
Method comparison & evaluation
Bland & Altman plot
Bland-Altman plot with multiple measurements per subject
Comparison of multiple methods
Mountain plot
Deming regression
Passing & Bablok regression
Coefficient of variation from duplicate measurements
Agreement & responsiveness
Intraclass correlation coefficient
Concordance correlation coefficient
Inter-rater agreement (kappa)
Cronbach's alpha
Responsiveness
ROC curve analysis
ROC curve analysis in MedCalc
Interactive dot diagram
Plot versus criterion values
Plot versus prevalence
Predictive values
Interval likelihood ratios
Comparison of ROC curves
Comparison of independent ROC curves
Create tables
Summary statistics table
Correlation table
Comparison of independent samples
Comparison of paired samples
Multiple frequency tables
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 coefficients of variation
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
Single mean
Single proportion
Difference between means
Mean difference between paired samples
Difference between proportions
Difference between paired proportions
Coefficient of Variation from duplicate measurements
Regression-based reference limits
Window menu
Cascade
Tile
Arrange icons
Split window - remove split
Close all
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
Matrices
Mathematical functions
Trigonometric functions
Hyperbolic functions
Gamma function and related functions
Engineering functions
Complex number functions
Matrix 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
Statistical tables
Values of the Normal distribution
Values of the t-distribution
Values of the Chi-squared distribution
Values of the F-distribution
Logit transformation
Miscellaneous tables
ISO language codes
Greek alphabet
ANSI character set
SI units
Multiples and submultiples of SI units
Tips and tricks
How to export your results to Microsoft Word
How to define and use labels
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
How to reorder a categorical variable
References
MSUM matrix function
Description
MSUM(
A
) Returns the sum of all of the elements in the matrix
A
.
Calculator
MSUM(
)
See also
Matrices
Matrix functions
Mathematical functions
Privacy & cookies
Contact
Site map