** File: TPSheet5.hlp
** Index: 25

** Sheet View's Data Menu Commands


Û  Data menu

    This menu contains commands that
relate to sheet data creation and
manipulation.


Û  Fill Selection

    This menu contains five fill data
methods.  They all fill the selected
data block with appropriate
automatically generated numbers.


Û  Random

    This command fills the selection
  with uniform random numbers between
  the minimum and maximum range.

Û  Algebraic Sequence

    This command fills the selection
  with an algebraic sequence.

Û  Geometric Sequence

    This command fills the selection
  with a geometric sequence.

Û  Gaussian Distribution

    This command fills the selection
  with a normal distribution whose mean
  and variance are specified in the
  dialog box.

Û  User-Defined Function

    This command displays the User Defined
  Function dialog box which lets you
  specify the range of selection and a
  function formula, then TechPlot will
  generate data using the function you
  defined to calculate data that fill the
  range you selected.



Û  Sort

    The Data | Sort command lets you sort
one or more columns in order.


Û  Descriptive Statistics

    This command appears in the Data Menu
as Des. Stats.  It shows the descriptive
statistics results of the columns in a file
viewer.


Û  T-Test

    The Data | T-Test command lets you
perform the student t-test for two columns.


Û  F-Test

    This command perform the F-test which
tests the hypothesis that two samples have
different variances by trying to reject
the null hypothesis that their variances
are actually consistent.  The F-value is
the ratio of the larger variance over the
smaller one.


Û  Analysis of Variance (ANOVA)

    This command appears in the Data Menu
as ANOVA.  It performs both one-way and
two-way analyses of variance.

    One-way analysis of variance tests the
null hypothesis that the mean of 3 or more
samples are all equal.  Two-way analysis of
variance tests both row means and column
means.


Û  Linear Regression

    This command performs the linear
regression which calculates the slope (a)
and intercept (b) for the equation y=a*x+b
where x is the independent variable and y
is the dependent variable.


Û  Non-Parametric Statistics

    This command performs the Chi-Squared
test and the sign test.

    The Chi-Squared test tests the null
hypothesis that a contingency table of
observed values do not differ from expected
values (i.e. that there is no association
between row and column variables).

    The sign test tests the null hypothesis
that a set of sample values, or the
differences between paired sample values,
are randomly distributed about zero (i.e.
that their median equals to zero).
