Excel for Conditional Math and Statistical Functions
As against specialist software packages for statistical analysis like SPSS, R, SAS, and Minitab, the reason we often use Excel for statistical analysis is
A) Convenience as it’s already installed on our PCs. It is to be noted that unless the statistical computational needs are highly advanced, for beginners Excel is quite user-friendly and eliminates the need to learn another software. Excel also integrates easily into other Microsoft Office software products, and this can be helpful when preparing reports or presentations.
B) Cost—There is no need to incur license costs of an SPSS, R, SAS, and Minitab.
There are a host of statistical analysis functions for descriptive statistics. ...
Get MS Excel, Second Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
