XLSTAT: How to Set up an Analysis in Excel

 

Selecting your analysis

• Once XLSTAT is opened, you will see the different groups of analyses/functions available for use.

 
In this example, we will set up a simple linear regression.

• Select the XLSTAT / Modeling data / Linear Regression command.

• Once you have clicked on the button, the Linear Regression dialog box appears.

Setting Up the Analysis

• To select the data you need, click on the range selector (you can click anywhere in the blue rectangle).

Depending on the type of analysis, you may need to do one or several selections.

Note that the expected type of variable is defined as either qualitative or quantitative to make it easier for your use.

In this example, the data starts from the first row, so it is quicker and easier to use column selection.

• To quickly select a column, just click on the name of the column, as you would do with Excel.

• Then select the next columns by leaving the mouse button pressed and dragging the mouse cursor over the columns to select.

• You may need to specify if the variable(s)/sample(s) in the selection have labels. In this case, simply tick the option Variable labels.  NOTE: If you do not, you may get an error when proceeding to the calculations if the values are non-numerical.

• You can also define the observations/units/cases labels; tick the Observation labels option and click on the range selector to select them.

The last thing to

• Then you should go through the other tabs and select the desired options. Pay special attention to the tabs Outputs and Charts , as they are used to select which results should be displayed.

Launching the Analysis

• To proceed to the calculations click the OK button.

• After clicking OK a summary will appear. If you realize you need to modify your settings you can go back to the dialog box by clicking on the Back button.