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 and Significance tests.
Descriptions and examples of the commands can be found by clicking on items in the table 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 | Loada 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 c2 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 the custom variables.