STATS commands 

The command syntax requires that NO SPACES are used within a command. A list of abbreviated commands can be added to the display by right-clicking the text above the command window.

Where there are commands whose only difference is that one operates on a block of data whilst the other processes a column, the command is prefaced by 'b' or 'c' to indicate which is which.

e.g.'b_range' finds the ranges across the rows of a block of data whilst 'c_range' finds the range of the data within the specified column.

The commands are shown with the command in bold and the required parameters in italics. This is followed by a description of the command and an illustrative example.

Some commands require a variable name as a parameter to return the result of an operation.

The commands are grouped as:-

 Clearing data   Storing data   Data production   Data output 

 Arithmetic operations   Significance tests 

Descriptions and examples of the commands can be found by clicking on items in the list below.

tr>
 CLEARING DATA 
clear_all Clears all of the data.
b_clear Clears a block of data.
 DATA STORAGE 
save_data Saves a block of data.
load_data Load a stored block of data or data from Access or Excel files.
 DATA PRODUCTION 
enter_data Enter data from the keyboard.
seq Generate a sequence of values.
fib Generate a Fibonacci like sequence of values.
function Generate pairs of values from a specified function.
concat Concatenate two columns of data.
random_i Generate a set of random integers.
random_r Generate a set of random real numbers.
random_n Generate a set of random reals with a specified Standard Deviation and mean.
random_be Generate a set of random ones and zeroes with a Bernoulli distribution.
random_bi Generates a set of random integers with a Binomial distribution.
random_p Generate a set of random integers with a Poisson's distribution.
random_x Generate a set of random integers with an exponential distribution.
 DATA OUTPUT 
display Displays a block of data.
value Displays the current value of a program variable.
histogram Displays histogram or other bar chart.
point_plot Displays scattergrams of data.
graph Displays graphs of data.
best_line Draws the best line through a set of data.
find_line Draws a set of 'best-fit' lines through a set of data.
 ARITHMETIC OPERATIONS 
b_sum Adds the values in the rows of a block of data.
c_sum Adds the values in a column of data.
diff Subtracts one column from another.
inc Adds a constant to the values in a column of data.
scale Multiplies a column by a constant.
b_min_max Finds the maximum and minimum values in a block of data.
c_min_max Finds the maximum and minimum values in a column of data.
b_range Finds range of values across the rows of a block of data.
c_range Finds range of values in a column of data.
b_mean Finds the mean value of the rows in a block of data.
c_mean Finds the mean value of a column of data.
parsum Finds the partial sums of a column of data.
sigma Finds the sum of the products of two columns of data.
replace Replaces specified values in a column of data.
s_d Finds the Standard Deviation of a column of data.
dist Finds the dustribution of the data of a column.
sort Sorts a column of data.
regress Allows regression values onto a 'best line' to be found.
round Rounds a column of data to a specified number of decimal places or significant figures.
 SIGNIFICANCE TESTS 
correlate Finds the product-moment correlation coefficient.
chi_test Carries out a χ² test.
t_test Carries out the 'Student's' T-test.
m_w_test Carries out a Mann-Whitney test.

The interpretation of the commands and the evaluation of expressions make use of the Microsoft document, Q86688, which has been expanded to deal with more user variables.