ExStat …...

is an Excel® COM-Add-In developed under VSTO2010 and tested under Office 12.0 (2007) and higher

is installed via a Windows installer file (.msi) and automatically loads/unloads when Excel® fires up/shuts down. It will add a Command Button to the Add-Ins menu through which the ExStat tools can be selected

extends the capability within the Excel® environment to do statistical calculations and generate multiple graphs in an easy way

contains statistical tools as Descriptive Statistics, Control Charts, Life Data Analysis and Probability Distributions. Focus is on graphical analysis and data visualisation

is useful for Excel user with some statistical background who are used to work with Excel, store data sets in Excel® sheets and do simple analysis with it



Data organization

As usual: variables in columns and observations in rows. So, e.g. a data set with 3 variables and 20 observations each is stored in a 3 (columns) by 20 (rows) field somewhere in a spread sheet. Although ExStat contains a few plausibility checks it is up to the user to have the data arranged in a clear layout and pay attention to what data ranges are selected for analysis. Data need to be arranged in columns adjacent to each other. Data can be stored anywhere in the spreadsheet. Selected ranges must not contain empty columns. Formulas are allowed in selected data ranges. If the first row in the selected data range contains variable names, make sure to check the corresponding check box in the menus. If the first row in the selected data range does not contain variable names, make sure to not check the corresponding check box in the menus.



Selecting a data range

differs from the standard Excel®-way (RefEdit not available with COM-Add-Ins). In Excel you click onto the data text field (in the menu) first and then select the data range in the spread sheet. With ExStat you select the data range first and then click onto the corresponding text field (usually named “Data Range”) in the menu. The Mouse down click copies the address (incl. workbook name) of the selected range into the clicked text field. The user needs to make sure to have the correct range selected before clicking the Data Range text field. For entering/changing the data address in the text field of the userform via keyboard the user should enter the text field via keyboard (tab key). ExStat only uses data of visible rows (In case some rows of the data range are filtered).



Sheet name conventions

ExStat generates new work/chart sheets to store tables of results or graphs. The following names are in use: Descriptive Statistics: Ds, Da, Db, D1, D2, D3,… Control Charts: CC Life Data Analysis: LaI, LaC, LaS, L1, L2, L3,… Probability Distributions: PD

In order to avoid an "overflow" of worksheets when repeatedly executing the analysis tools, Exstat will delete sheets with the above listed names (w/o notification) before opening a new one with the same name. So, for sheets which should not be deleted the user needs to choose names that differ from the ones listed above and change the name of sheets to be kept.



Charts


Generated by Exstat are not linked to ranges in work sheets! Instead, data displayed in the charts are stored in string arrays which can not be accessed/changed if longer than 200 values.