LeoDataAnalysis permits seamlessly editing data like adding additional parameter, arithmetic progression or by formula, filter outside range and so on, often just by few mouse clicks.LeoDataAnalysis permits to edit data seamlessly, often just by few clicks.

Best way to think
about data
structure inside LeoDataAnalysis is consider them as several
tables with different number of rows but equal number and functionality 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
this:

p1 = F1(p3,p4); p2=F2(p3,p4); p5,p6 - out of game. p1 and p2 are **V**alues
here; p3 and p4 - **A**rguments; p5 and p6 - **I**nactive; F1 and F2 - same functions or
way of presentation. Each **V**alue by itself can be presented by **color**,
**shape** and
**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:

How to:

Rename parameter.

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
parameter is).

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.

Delete parameter.

Check up a corresponding parameter in column **"Selection"**. Press button
**"Delete"**
in **"Data series"** group of controls. If there are more then one series of data
all corresponding parameters will be eliminated from every series.

Delete series.

Check up a corresponding series in column **"Selection"**. Press button
**"Delete"** in
**"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 operations:

- delete all records when selected parameter is more (less) then given value.
- 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 }= (p_{i }- p_{min})*(N_{max}- N_{min})/(p_{max}- p_{min}) ,

where**p**^{*}_{i }- new value;**p**- old value;_{i }**N**,_{max}**N**and_{min}**p**,_{max}**p**- new and old values of minimum and maximum borders of array of_{min}**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 it. - 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 current record.
- 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 (current) record. - Supported operations include
**+,-,*,/**and**^**(power. 2^4 is equivalent 2*2*2*2).

Also 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:**rand(x)**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
the LeoDataAnalysis 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 (**V**alue, **A**rgument or **
I**nactive). 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 parameter" section.
- 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 building a model of customer behavior for optimizing marketing campaign.

Click **"Insert"**. The new parameters will be inserted. (If
**"Scores"** scheme
will be chosen additional actions will be needed to perform.

Edit records.

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 row 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 LeoDataAnalysis 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
- 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 LeoDataAnalysis. 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.

Note that selection of the record be performed only for visible part of data. After navigation along data all selections are canceled..

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.

Comments: