This Statistical Dashboard is an Excel-based analytical tool, which allows you to conduct comprehensive statistical analysis of your data, including:
- Descriptive statistics
- Outlier detection
- Correlation and covariance tables
- Data visualisation
- Regression analysis
The workbook contains 8 pages – “Read me”, “Dashboard”, “Data”, “Backup”, “Correlation and Covariance”, “Charts”, “Regression analysis” and “Forecasting”. These pages provide you a wide range of analytical options, tailored to your needs.
Using the file is as easy as 1. copy-and-paste your data and 2. click a couple of buttons. It does not require advance knowledge of Excel, its formulas or Visual Basic editor (macros). It is flexible and can be used unlimited number of times by a single user.