X/Y Greška u traci

Use the X or Y Error Bars dialog to display error bars for 2D charts.

If an element of a data series is selected, this command works on that data series only. If no element is selected, this command works on all data series.

To access this command...

Choose Insert - X Error Bars, or Insert - Y Error Bars (Charts)


An error bar is an indicator line that spans over a range from x/y - NegativeErrorValue to x/y + PositiveErrorValue. In this term, x or y is the value of the data point. When "standard deviation" is selected, x or y is the mean value of the data series. NegativeErrorValue and PositiveErrorValue are the amounts calculated by the error bar function or given explicitly.

Note Icon

The Insert - X/Y Error Bars menu command is only available for 2D charts.


Error category

U Error category području,možete izabrati različite načine prikazivanja kategorije greške.

Ništa

Does not show any error bars.

Konstantna vrijednost

Displays constant values that you specify in the Parameters area.

Procenat

Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.

Funkcije

Izaberite funkciju za izračunavanje dijela greške.

Standardna greška: Prikaz standardne greške.

Variance: Displays the variance calculated from the number of data points and respective values.

Standard Deviation: Displays the standard deviation (square root of the variance). Unlike other functions, error bars are centered on the mean.

Error Margin: Displays the highest error margin in percent according to the highest value of the data group. Set the percentage in the Parameters area.

Ćelijski rang

Kliknite ćelijski rang i zatim odredite ćelijski rang iz kojeg uzimate pozitivne i negativne vrijednosti dijela greške.

Iz grafikona tabele podataka

For a chart with its own data, the error bar values can be entered in the chart data table. The Data Table dialog shows additional columns titled Positive X or Y-Error-Bars and Negative X or Y-Error-Bars.

Ista vrijednost za oboje

Enable to use the positive error values also as negative error values. You can only change the value of the "Positive (+)" box. That value gets copied to the "Negative (-)" box automatically.

Error Indicator

Specifies the error indicator.

Pozitivni i negativni

Pokazuje pozitivne i negativne dijelove greške.

Pozitivni

Pokazuje samo pozitivne dijelove greški.

Negativne

Pokazuje samo negativne dijelove grešaka.

Please support us!