Quickly relaunch a pre-configured analysis on modified data

This tutorial will show you how to quickly obtain the precise dialog box configuration that lead to a specific XLSTAT result report and to launch the analysis on modified data.

Dataset to quickly relaunch a pre-configured analysis on modified data

An Excel sheet with both the data and results can be downloaded by clicking here.
The data have been obtained in Lewis T. and Taylor L.R. (1967). Introduction to Experimental Ecology, New York: Academic Press, Inc.. Rows correspond to 237 children described by their gender, age in months, height in inches (1 inch = 2.54 cm), and weight in pounds (1 pound = 0.45 kg). 

Goal of this tutorial

We will run a simple linear regression with Weight as a dependent variable and Height as an explanatory variable. Then we will modify a value in the dataset and see how it is possible to quickly re-launch the pre-configured regression on the modified dataset in XLSTAT. We will use the re-launch buttonXLSTAT relaunch buttonthat appears at the top of the results report.

Setting up a simple linear regression in XLSTAT

After opening XLSTAT, select the XLSTAT / Modeling data / linear Regression command, or click on the corresponding button of the Modeling Data toolbar (see below).
xlstat modeling data linear regression

Once you've clicked on the button, the Linear Regression dialog box will appear.
Select the data on the Excel sheet. In our case; the Dependent variable is Weight. The quantitative explanatory variable is Height.
xlstat linear regression dialog box
Click on OK to display the results.

Simple linear regression in XLSTAT: quick interpretation

According to the model parameters table, the intercept estimate equals -133 while the slope estimate is positive (3.818). Both estimates are statistically significant at 0.05 (p-value < 0.0001).

XLSTAT simple linear regression in excel output model parameters
For further interpretations, please refer to the simple linear regression tutorial.

Modifying the data and launching the same pre-configured analysis

Imagine you need to modify your data. For example, you might want to eliminate a gender in the dataset quickly re-run the analysis on the other gender, or you might want to correct a mistake in the dataset and run the statistical feature on the corrected dataset without wasting time. The quick re-launch button in XLSTAT result reportsXLSTAT relaunch button allows you to open the dialog box with exactly the same configuration as the configuration that lead to the report in question.

In cell D4 of the data spreadsheet we consider that the 94.2 value is a mistake. Enter 110 instead.
In the previous linear regression result, click on the quick relaunch button. The pre-configured linear regression dialog box appears. Click on OK to launch the computations on the modified dataset.
According to the model parameters table, we notice a slight change in the estimates. For example the new slope estimate is 3.821.

XLSTAT simple linear regression outpus model parameters (2)

Notice that you may also use this shortcut to re-launch an analysis on the same data, but with modified options. For example, you may be interested in displaying the Type I & III analysis of variance tables. All you need to do is click on the shortcut, activate the option in the outputs tab, and click onOK.

 

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