# 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:

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:

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:

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

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:

Click OK to begin the analysis:

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

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:

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:

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:

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

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:

Clicking on Histogram will open the Histogram configuration window:

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:

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

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:

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

StatTools will infer the dataset boundaries, asking for confirmation:

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

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:

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:

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:

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

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

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: