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:-

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.