Setting up an analysis in XLSTAT

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

If you are using Microsoft Excel 2007 or 2010 you can select them in the menu bar of the XLSTAT tab. They appear as follows:

data analysis software

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 picking out the data in the Excel spreadsheet with the cursor. 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 as the values are non numerical.

You can also determine the observations/units labels; tick the option Observation labels and click on therange selector to select them.

principal component analysis software

The last thing to do in the General tab is to decide the location of the analytical results. You have three choices:

  • 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 on 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.

Click here for other tutorials.

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414