home *** CD-ROM | disk | FTP | other *** search
- ** 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).
-