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.

 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.