Open the data analysis tool (see instructions above) Install the add-in in Excel (see instructions on the website) How to open the data analysis tool when in add-in mode How to open the data analysis tool when in spreadsheed mode

Automated inclusion of data unit of measure.

Configurable data frequency distribution including:.

Automated basic statistical analysis of a user-defined sample including:.

This allows to perform the data analysis on every spreadsheet by just clicking on a button. The settings are stored for next use.Įxcel data analysis is available as a ready-to-use spreadsheet and as an add-in. Using an options menu the user can define which data to print. Thanks to that, the spreadsheet is interactive and automatically updates the results if the data is modified. The spreadsheet can also automatically print charts:Īll these values are calculated using Excel built-in functions.

Relative standard deviation (RSD and 3RSD).

The spreadsheet can automatically calculate: After inputting the data unit of measure, the results are ready to be printed. After activating the interface, the user selects the data and the place where to position the results. The procedure to analyse the data in Excel is not particularly difficult, but needs some time to setup the spreadsheet, gather the data, write the formulas, create the charts and format the whole page to make it nice to present.Įxcel data analysis spreadsheet and add-in were created to simplify this procedure.

This allows to summarise the findings before presenting them to my colleagues. After performing a series of doses (normally between 1) I have to analyse some basic statistical data like average, standard deviation, relative standard deviation, etc. Most of the times this is done to verify the accuracy of a filling equipment. Why I created the Excel data analysis toolĭuring my day to day job I sometimes need to perform testing on a sample, analyse the data and summarise the results.

Excel data analysis add in excel 2016