5) Creating Time Series Analysis in StatTools.

This Blog entry is from the Basic Statistics section in Learn Palisade.

Start by opening the spreadsheet containing the dataset loaded into the StatTools realm:

1.png

The Time Series Analysis is available in the StatTools ribbon towards the centre, titled Time Series and Forecasting, thereafter in the sub menu Time Series Graph:

2.png

Clicking on the sub menu item Time Series Graph will open a window to configure a line chart showing the prices, in our example Interval_Close, plotted over time:

3.png

If not already selected, select the value Time Series (with Label) from the drop down towards the top right hand side of the window:

4.png

By selecting a label, the process will use a date order without requiring the dataset to be ordered prior (the example is ordered new to old).

Both the label, being the Interim_Buffer_Date, and the target of the analyses, being the Interval_Close, need to be checked under the columns Lbl and Val respectively:

5.png

Click OK to begin the analysis:

6.png

The analysis is output in the form of a line chart showing the oldest records plotted towards the axis, with the newest records plotted away from the axis.  Overall the analysis is intended to visually cue trend and provide some directional insight to the summary statistics.

4) Calculating a Z-Score in Excel.

This Blog entry is from the Basic Statistics section in Learn Palisade.

The measure of how many standard deviations from the mean a value may be, would be calculated via the following formula:

= (Test Value – Mean) / Standard Deviation.

The values Mean and Standard Deviation would be taken from the StatTools output.   The Mean value is contained in cell B9 and the Standard Deviation is Contained in the cell B11.

Start by selecting any cell in the output, in this case D9, then type the formula:

= (1.0000 – B9) / B11

1.png

The hardcoded value of 1.0000 would be the prevailing price and thus a variable.  It would therefore be possible to replace the value 1.0000 with a cell reference, a technique that will be used extensively in the abstraction process, especially in creating Behavioral Analytics and Abstraction Deviations.

3) Creating Summary Statistics in Palisade StatTools.

This Blog entry is from the Basic Statistics section in Learn Palisade.

On the StatTools ribbon, select the menu item Summary Statistics to the centre left of the ribbon, an action that will yield sub menu items, of which one item will be One Way Variable Summary:

1.png

Clicking on the sub menu item One-Variable Summary will open a window to specify the summary statistics to be performed and the variable to perform summary statistics upon:

2.png

Computationally the calculation of the summary statistics is immaterial, thus it is suggested that the default options, which specify all, remain selected. 

Select a check box next to the target variable, in this case, Interval_Close:

3.png

Clicking OK will initiate the calculation of the summary statistics for the selected variable:

4.png

For each summary statistic, there is a single numeric value that represents that calculation of a particular summary statistic.

2) Creating a Histogram in StatTools.

This Blog entry is from the Basic Statistics section in Learn Palisade.

On the StatTools ribbon in Excel, click on the menu item towards the centre left which is titled Summary Graphs.  In the drop down menu there is a sub menu item titled Histogram:

1.png

Clicking on Histogram will open the Histogram configuration window:

2.png

For the purposes of this example create a histogram based on just one variable, in this case Interval_Close, while allowing StatTools to infer the most appropriate number of bins. 

To select the variable, simply check the checkbox next to the variable name:

3.png

Clicking the OK button will create the Histogram in a new Excel workbook:

4.png

Two outputs are created, the tabular representation of the Histogram which includes the probability density, and a bar chart providing a visualisation for the distribution.

1) Configure a Dataset in Palisade StatTools.

This Blog entry is from the Summary Statistics section in Learn Palisade.

To begin using Palisade StatTools, or indeed most Palisade products which rely upon datasets, the dataset needs to be configured.  StatTools does a very good job at inferring the dataset and then loading that dataset into the StatTools realm, making it a trivial matter or procedure.

Click anywhere in the dataset, although in this example, click on cell A1:

1.png

On the StatTools ribbon, click on the icon Dataset Manager towards the left hand side of the ribbon:

2.png

StatTools will infer the dataset boundaries, asking for confirmation:

3.png

Click Yes, an action that will load the Dataset Manager window based on the inferred Dataset:

4.png

The default, inferred, dataset is almost always acceptable.  Notice that the Apply Cell Formatting check box is set.  Cell formatting is a useful feature to determine if a Dataset has been loaded into the StatTools realm after completing the process.

Click OK based on the default, inferred, settings:

5.png

When the formatting of the cells changes colour, with the grid being emphasised and the header text having a blue background, the Dataset can be taken to exist in the StatTools realm and is eligible for further analysis.

All subsequent StatTools Blog entries rely upon the Dataset being loaded into StatTools in the above manner.

Introduction to Summary Statistics

This Blog entry is from the Summary Statistics section in Learn Palisade.

Palisade StatTools is a statistics package that is an Excel Add-in, thus allowing the native and intuitive use of Datasets.  To start Palisdae StatTools, firstly navigate via the Start menu to All Programs…Palisade Decision Tools…..StatTools:

1.png

Then click on the StatTools Icon to load the product, itself prompting Excel to load.  It is also possible to search for the application by typing StatTools in the Start menu search functionality:

2.png

As StatTools loads, a variety of introduction screens will be shown, click in the affirmative when prompted:

3.png

Upon the acceptance or closure of the introduction screens, StatTools will be loaded into Excel as a Ribbon titled StatTools:

4.png

StatTools at this stage is loaded and ready for use.  For this example, load a file into Excel from the following location \Training\Data\FX\EURUSD.csv:

5.png