Your data analysis solution

Setting up an analysis in XLSTAT

2018-06-26

This tutorial is a general presentation that explains how you can set up an analysis in XLSTAT.

Selecting your analysis

The first thing you have to do is to open the dialog box of the analysis/function you wish to use.

The analyses are grouped by type:

  • Preparing data
  • Describing data
  • Visualizing data
  • Analyzing data
  • Modeling data
  • Correlation/Association tests
  • Parametric tests
  • Nonparametric tests
  • ...

Set Up an Analysis in XLSTAT

If you are using Microsoft Excel 2003 or an earlier version you may use the tool bars that are available for the selection of functions:

statistical software

Once the dialog box is open you need to select the data to be analyzed. This is done in the first tab named General.

Setting up the general tab

Depending on the type of analysis you may need to do one or several selections. Note that the expected type of variable is defined to either qualitative, or quantitative to make it easier for your use.

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

statistical software

The selection is done by holding down the mouse button while moving the cursor over the data you want to select. You can select either columns or ranges. Note that it is possible to take non-adjacent data.

Moreover it is possible to minimize the range selector box while electing the data so as to have a better view of the data.

In the screenshot below the data that is selected are picked as range as they are not place in the first row. The data are non-adjacent, only the data in the column B, C and E are selected.

partial least square software

Other information in the General tab may be filled in before moving on to the other tabs.

You may need to specify if the variable(s)/sample(s) in the selection have labels - as shown in the example above. In this case simply tick the option Variable labels.

partial least square software

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.

principal component analysis software

The last thing to do in the General tab is to decide where the results should be displayed. You have three possibilities:

  • At a specific place in a spreadsheet, option Range. Here you have to use the range selector to specify the location,
  • In a new sheet, option Sheet,
  • In a new workbook, option Workbook.

principal component analysis software

Setting up the other tabs

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.

Help documentation

Do not hesitate to click the Help button to get information about the different options. Once you have pressed Help, the documentation will open in the chapter of the analysis you were running. Go to the Dialog box section, where all the available options are explained.

data analysis software

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.

statistical software

The following video explains how to set up an analysis in XLSTAT.

 

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9202