software for data presentation, statistical analysis, marketing and prediction.
(selfextracting winzip file)
Popular statistics and data analysis
LeoStatistic permits to do data manipulation very easy, often just by on or two
Best way to think about data in LeoStatistic is consider them as several
tables with different number of rows but equal number of columns. One column in
one table presents one parameter. One table itself is represents a data series.
All corresponding parameters in different series play the same roles in
statistical schemes. Other way of presenting parameters in one series is like
p1 = F1(p3,p4); p2=F2(p3,p4); p5,p6 - out of game. p1 and p2 are Values
here; p3 and p4 - Arguments; p5 and p6 - Inactive; F1 and F2 - same functions or
way of presentation. Each Value by itself can be presented by color,
size of markers on the chart.
Most of data manipulations are begun or
can be fully completed in the "Data" tab of the control panel:
Click on the name of parameter. Type new and press "Enter".
Change status of the parameter..
Click on the cell with desirable status near the active (where the name of the
Make all parameters inactive.
Press button "Make all inactive" in "Data" tab of controls
panel. This option
could be very helpful to save time in case of necessity to change status of many parameters
with large number of records. Best strategy here in saving time is to avoid
unnecessary calculations is at first make all parameters inactive. Then set
status for all arguments
and at very last to set values.
Edit presentation of value.
Check up a corresponding parameter in column "Selection". A
group of controls permitting to modify shape, color and size of the markers of
the value parameter will appear. Modify them as you want.
Check up a corresponding parameter in column "Selection". Press button
in "Data series" group of controls. If there are more then one series of data
all corresponding parameters will be eliminated from every series.
Check up a corresponding series in column "Selection". Press button
"Data series" group of controls.
Delete all data.
Press button "Delete all" in "Data series" group of controls.
Modify data of a parameter.
Check up a corresponding parameter in column "Selection". Press button
"Modify" in "Data series" group of controls. The dialog with
available options for modifications of parameter will appear:
It gives opportunity to perform one of the standard action from built in
- delete all records when selected parameter is more (less) then given
- delete all records when selected parameter is in (out) of the given
interval of values.
- normalize the values of the parameter that means that program will
recalculate elements of the parameter by formula:
p*i = (pi - pmin)*(Nmax - Nmin)/(pmax
- pmin) ,
p*i - new value; pi - old value;
, Nmin and pmax
, pmin - new and old values of minimum and maximum borders of
array of p - parameter. This operation could be very useful for
correct implementing of some statistical schemes like for example a near
neighbors estimation. But we always are staying short to give generalizing
recommendation applicable for all situations these could be too disperse for
- recalculate by the user programmed formula. The valid syntax of the formula is quite intuitive:
- Names of the parameters is the data series a represent them for the
- Names with square brackets with integer number inside are represent
value shifted ahead or back from the current record.
- The capital letter "N" is reserved for represented a current index of processing
- Supported operations include +,-,*,/ and ^(power. 2^4 is equivalent 2*2*2*2).
functions with standard meaning: ln, exp, sin, cos, tan, asin, acos, atan,
log10, sqrt, abs, pow10 are supported as well the reserved word pi=3.141592653. Two function are producing random numbers:
monotone distributed in interval from 0 to x; gauss(x) - normally
distributed around 0 with standard deviation equal to argument. Function int(x)
round the value to closest down integer.
Insert a parameter..
This operation can be performed only for first series or when no series open in
yet. Click in button "Insert" in "Data" tab of control panel.
The "Insert" dialog will appear.
Choose or type attributes of the parameter you want to
insert such as its name, state (Value, Argument or
Inactive). For very first
parameter you can set a number of the the records.
There are following options to calculate a
records o the parameter:
- Arithmetic progression.
- User defined formula with the syntax as described above in "Modify
- Current statistical scheme used for approximation of existing data. This
option is limited only for one data series and one, the last, value. In
simple words it will set a values exact on theoretical curve.
- Correlation scores (from 0 to 100) that produces reflected probability for given
existed parameter to be large then arbitrary set number. This statistical
scheme have direct relation to the marketing and in much more details are
described in page marketing
Click "Insert". The new parameters will be inserted. (If
will be chosen additional actions will be needed to perform.
In "Data" tab of control
panel click on the "Show data" button if the spreadsheet like window
is not shown yet it will
appear like this:
Following operations with data are supported:
- Edit content selected of cell.
- Add new roe of records. Fill up the row the next after
last included into row and press "Enter" when last cell at the record is active.
- Delete records - select records by
clicking on its id in "Counter" column and click "Delete" button.
- Paste records from clipboard. Copy an area
with the same number of columns as in active data series of LeoStatistic for
example in MS Excel. Select the row after with the content
of clipboard will be placed and click on "Paste" button.
- Copy records. Select one or several
records in clipboard memory and click "Copy" button. select records by
clicking on its id in "Counter" column and click "Copy" button.
Note that selection of the record be performed only for
visible part of data. After navigation along data all selections are
- Copy all records. By clicking on the button
"Copy all" all content of the series will be copied into clipboard memory
and later on can be paste in other applications or other place on
LeoStatistic. Warning - for very large
set of data this operation can take forbiddingly large computation time.
- Save as text file. Click on "Save as"
button and chose the file to create that will contain data in ANSI text
format with space delimited cells that easy later on open on such
applications as MS Excel.
Tip: Any change in data control initiates a recalculation of
the data presentation and statistical evaluation. For not too large number of
the records it's not a matter but for large it could be. To avoid this effect
make all parameters inactive during editing of the data.
Screenshots of the LeoStatistic software:
click on picture to enlarge
Distribution of two variables.
(constructor style interface).
Near neighbors method.
Fit with free format formula.
Curve fit of crystal growth rate.
Get data from image file.