Selecting data with XLSTAT

Dataset XLS101 KB

Tutorial video

  • Pro Core statistical software

  • System configuration

    • Windows:
      • Versions: 9x/Me/NT/2000/XP/Vista/Win 7
      • Excel: 97 and later
      • Processor: 32 or 64 bits
      • Hard disk: 150 Mb
    • Mac OS X:
      • OS: OS X
      • Excel: X, 2004 and 2011
      • Hard disk: 150Mb.

Benefits

  • Easy and user-friendly
    Easy and user-friendly XLSTAT is flawlessly integrated with Microsoft Excel which is the most popular spreadsheet worldwide. This integration makes it one of the simplest available tools to work with as it utilizes the same philosophy as Microsoft Excel. The program is accessible in a dedicated XLSTAT tab. The analyses are grouped into functional menus. The dialog boxes are user-friendly and setting up an analysis is straightforward.
  • Data and results shared seamlessly
    Data and results shared seamlessly One of the greatest advantages of XLSTAT is the way you can share data and results seamlessly. As the results are stored in Microsoft Excel, anyone can access them. There is no need for the receiver to have an XLSTAT license or any additional viewer which makes your team-work easier and more affordable. In addition, results are easily integrable into other Microsoft Office software such as PowerPoint, so that you can create striking presentation in minutes.
  • Modular
    Modular XLSTAT is a modular product. XLSTAT-Pro is a core statistical module of XLSTAT which includes all the mainstream functionalities in statistics and multivariate analysis. More advanced features contained in add-on modules can be added for specific applications. This way you can adapt the software to your needs making the software more cost-efficient.
  • Didactic
    Didactic The results of XLSTAT are organized by analysis and are easy to navigate. Moreover useful information is provided along with the results to assist you in your interpretation.
  • Affordable
    Affordable XLSTAT is a complete and modular analytical solution that can suit any analytical business needs. It is very reasonably priced so that the return of your investment is almost immediate. Any XLSTAT license comes with top level support and assistance.
  • Accessible - Available in many languages
    Accessible - Available in many languages We have ensured XLSTAT is accessible to everyone by making the program available in many languages, including Chinese, English, French, German, Italian, Japanese, Polish, Portuguese and Spanish.
  • Automatable and customizable
    Automatable and customizable Most of the statistical functions available in XLSTAT can be called directly from the Visual Basic window of Microsoft Excel. They can be modified and integrated to more code to fit to the specificity of your domain. Adding tables and plots as well as modifying existing outputs becomes easy. Furthermore, XLSTAT includes some special tools on the dialog boxes to generate automatically the VBA code in order to reproduce your analysis using the VBA editor or to simply load pre-set settings. This effortless automation of routine analysis will be a huge time saver on your part.

Although the data selection with XLSTAT is very intuitive for MS Excel users, some of you who have been using other statistical software packages might not feel immediately at ease, because you need to realize how simple it is to work with XLSTAT. The following examples should help you save time and temper. The Excel workbook that has been used to build the following videos can be downloaded by clicking here.

Case 1: Column selection

The column selection is possible only if your dataset starts from the first row of the Excel sheet. It does not matter if the column or variable labels are stored on the first row, as the Labels included option displayed in most of the XLSTAT dialog boxes, allows you to specify it.

The following video allows you to view an example of a column selection with the "Regression" dialog box. At the end of the video you will be able see that the charts generated by XLSTAT can be modified as any other Excel charts. To quickly select a column, just click on the name of the column, as you would do with Excel. XLSTAT automatically detects the end of the dataset: for each selected column: it won't take the whole column into account, but just the rows where your data are stored.

Note that multiple range selections are also possible. You will find more details on that subject in Case 3.

Case 2: Range selection

Use the range selection mode when your data do not start on the first row. Select the data with the mouse.

The following video allows you to view an example of a range selection with the Comparing two samples dialog box. A Student't test and a Fisher's test are computed to compare the mean and the variance of two samples. The two samples are selected separately with the mouse.

Note that multiple range selections are also possible. You will find more details on that subject in Case 3.

Case 3: Multiple range selection

Use multiple range selection when you want to remove some data - column(s) or row(s) - from the original dataset. Mutliple selection applies to the column selection and the range selection modes. The example below has been recorded on the same dataset as the one used for the column selection mode tutorial. To do a multiple range selection, you need to press the Ctrl key of your keyboard while selecting the data with the mouse.

The following video allows you to view an example of a multiple range selection in the Quick column selection mode with the Regression dialog box. The X3 variable is not selected: we first selected the X1 and X2 variables by selecting columns B and C, then pressed the Ctrl key, and then clicked on the E column to add variable X4 to the selection.

Case 4: Keyboard shortcuts

For an unknown reason, the possibility to use the keyboard to select data in not available with the versions 2000 and 2002 of MS Excel. With Excel 97, you can very quickly select data, using the cursor keys (up, down, left, right) and the Ctrl and Shift keys. For example, to select a table for a Principal component analysis, all you need to do, is click with the mouse button on the cell at the top left corner of the table (or move to it with the cursor keys) then click on the Shift and Ctrl keys, then do one click on the right cursor, then one click on the down cursor, and you are done.

Note: With all Excel versions, you can use the Tab key to navigate in the dialog box and switch from one element to the other. After the installation of recent updates of Excel 2000 and 2002 and the installation of XLSTAT, it is possible to use the keyboard shortcuts on these Excel versions.