nag_correg_coeffs_pearson_subset_miss_case (g02bh) computes means and standard deviations, sums of squares and cross-products of deviations from means, and Pearson product-moment correlation coefficients for selected variables omitting completely any cases with a missing observation for any variable (either over all variables in the dataset or over only those variables in the selected subset).

Syntax

[xbar, std, ssp, r, ncases, ifail] = g02bh(x, miss, xmiss, mistyp, kvar, 'n', n, 'm', m, 'nvars', nvars)

[xbar, std, ssp, r, ncases, ifail] = nag_correg_coeffs_pearson_subset_miss_case(x, miss, xmiss, mistyp, kvar, 'n', n, 'm', m, 'nvars', nvars)

Note: the interface to this routine has changed since earlier releases of the toolbox:

At Mark 22:

n was made optional; miss and xmiss are no longer output parameters

Description

The input data consists of

n

observations for each of

m

variables, given as an array

[x_{i j}], i = 1, 2, \dots, n (n \geq 2), j = 1, 2, \dots, m (m \geq 2),

where

x_{i j}

is the

i

th observation on the

j

th variable, together with the subset of these variables,

v_{1}, v_{2}, \dots, v_{p}

, for which information is required.

In addition, each of the

m

variables may optionally have associated with it a value which is to be considered as representing a missing observation for that variable; the missing value for the

j

th variable is denoted by

{xm}_{j}

. Missing values need not be specified for all variables. The missing values can be utilized in two slightly different ways; you can indicate which scheme is required.

Firstly, let

w_{i} = 0

if observation

i

contains a missing value for any of those variables in the set

1, 2, \dots, m

for which missing values have been declared, i.e., if

x_{i j} = {xm}_{j}

for any

j

(

j = 1, 2, \dots, m

) for which an

{xm}_{j}

has been assigned (see also Accuracy); and

w_{i} = 1

otherwise, for

i = 1, 2, \dots, n

Secondly, let

w_{i} = 0

if observation

i

contains a missing value for any of those variables in the selected subset

v_{1}, v_{2}, \dots, v_{p}

for which missing values have been declared, i.e., if

x_{i j} = {xm}_{j}

for any

j

(

j = v_{1}, v_{2}, \dots, v_{p}

) for which an

{xm}_{j}

has been assigned (see also Accuracy); and

w_{i} = 1

otherwise, for

i = 1, 2, \dots, n

The quantities calculated are:

(a)

Means:

{\bar{x}}_{j} = \frac{\sum_{i = 1}^{n} w_{i} x_{i j}}{\sum_{i = 1}^{n} w_{i}}, j = v_{1}, v_{2}, \dots, v_{p} .

(b)

Standard deviations:

s_{j} = \sqrt{\frac{\sum_{i = 1}^{n} w_{i} {(x_{i j} - {\bar{x}}_{j})}^{2}}{\sum_{i = 1}^{n} w_{i} - 1}}, j = v_{1}, v_{2}, \dots, v_{p} .

(c)

Sums of squares and cross-products of deviations from means:

S_{j k} = \sum_{i = 1}^{n} w_{i} (x_{i j} - {\bar{x}}_{j}) (x_{i k} - {\bar{x}}_{k}), j, k = v_{1}, v_{2}, \dots, v_{p} .

(d)

Pearson product-moment correlation coefficients:

R_{j k} = \frac{S_{j k}}{\sqrt{S_{j j} S_{k k}}}, j, k = v_{1}, v_{2}, \dots, v_{p} .

S_{j j}

S_{k k}

is zero,

R_{j k}

is set to zero.

References

None.

Parameters

Compulsory Input Parameters

1: $x (ldx, m)$ – double array

ldx, the first dimension of the array, must satisfy the constraint

ldx \geq n

x (i, j)

must be set to

x_{i j}

, the value of the

i

th observation on the

j

th variable, for

i = 1, 2, \dots, n

and

j = 1, 2, \dots, m

2: $miss (m)$ – int64int32nag_int array

miss (j)

must be set equal to

1

if a missing value,

x m_{j}

, is to be specified for the

j

th variable in the array x, or set equal to

0

otherwise. Values of miss must be given for all

m

variables in the array x.

3: $xmiss (m)$ – double array

xmiss (j)

must be set to the missing value,

x m_{j}

, to be associated with the

j

th variable in the array x, for those variables for which missing values are specified by means of the array miss (see Accuracy).

4: $mistyp$ – int64int32nag_int scalar

Indicates the manner in which missing observations are to be treated.

$mistyp = 1$: A case is excluded if it contains a missing value for any of the variables $1, 2, \dots, m$ .
$mistyp = 0$: A case is excluded if it contains a missing value for any of the $p (\leq m)$ variables specified in the array kvar.

5: $kvar (nvars)$ – int64int32nag_int array

kvar (j)

must be set to the column number in x of the

j

th variable for which information is required, for

j = 1, 2, \dots, p

Constraint:

1 \leq kvar (j) \leq m

, for

j = 1, 2, \dots, p

Optional Input Parameters

1: $n$ – int64int32nag_int scalar: Default: the first dimension of the array x.
$n$ , the number of observations or cases.

Constraint: $n \geq 2$ .
2: $m$ – int64int32nag_int scalar: Default: the dimension of the arrays miss, xmiss and the second dimension of the array x. (An error is raised if these dimensions are not equal.)
$m$ , the number of variables.

Constraint: $m \geq 2$ .
3: $nvars$ – int64int32nag_int scalar: Default: the dimension of the array kvar.
$p$ , the number of variables for which information is required.

Constraint: $2 \leq nvars \leq m$ .

Output Parameters

1: $xbar (nvars)$ – double array: The mean value, of ${\bar{x}}_{j}$ , of the variable specified in $kvar (j)$ , for $j = 1, 2, \dots, p$ .
2: $std (nvars)$ – double array: The standard deviation, $s_{j}$ , of the variable specified in $kvar (j)$ , for $j = 1, 2, \dots, p$ .
3: $ssp (ldssp, nvars)$ – double array: $ssp (j, k)$ is the cross-product of deviations, $S_{j k}$ , for the variables specified in $kvar (j)$ and $kvar (k)$ , for $j = 1, 2, \dots, p$ and $k = 1, 2, \dots, p$ .
4: $r (ldr, nvars)$ – double array: $r (j, k)$ is the product-moment correlation coefficient, $R_{j k}$ , between the variables specified in $kvar (j)$ and $kvar (k)$ , for $j = 1, 2, \dots, p$ and $k = 1, 2, \dots, p$ .
5: $ncases$ – int64int32nag_int scalar: The number of cases actually used in the calculations (when cases involving missing values have been eliminated).
6: $ifail$ – int64int32nag_int scalar: $ifail = 0$ unless the function detects an error (see Error Indicators and Warnings).

Error Indicators and Warnings

Errors or warnings detected by the function:

$ifail = 1$

On entry,

n < 2

$ifail = 2$

On entry,	$nvars < 2$ ,
or	$nvars > m$ .

$ifail = 3$

On entry,	$ldx < n$ ,
or	$ldssp < nvars$ ,
or	$ldr < nvars$ .

$ifail = 4$

On entry,	$kvar (j) < 1$ ,
or	$kvar (j) > m$ for some $j = 1, 2, \dots, nvars$ .

$ifail = 5$

On entry,

mistyp \neq 1

0

$ifail = 6$: After observations with missing values were omitted, no cases remained.

$ifail = 7$: After observations with missing values were omitted, only one case remained.

$ifail = - 99$: An unexpected error has been triggered by this routine. Please contact NAG.

$ifail = - 399$: Your licence key may have expired or may not have been installed correctly.

$ifail = - 999$: Dynamic memory allocation failed.

Accuracy

nag_correg_coeffs_pearson_subset_miss_case (g02bh) does not use additional precision arithmetic for the accumulation of scalar products, so there may be a loss of significant figures for large

n

You are warned of the need to exercise extreme care in your selection of missing values. nag_correg_coeffs_pearson_subset_miss_case (g02bh) treats all values in the inclusive range

(1 \pm {0.1}^{(x02be - 2)}) \times {x m}_{j}

, where

{xm}_{j}

is the missing value for variable

j

specified in xmiss.

You must therefore ensure that the missing value chosen for each variable is sufficiently different from all valid values for that variable so that none of the valid values fall within the range indicated above.

Further Comments

The time taken by nag_correg_coeffs_pearson_subset_miss_case (g02bh) depends on

n

and

p

, and the occurrence of missing values.

The function uses a two-pass algorithm.

Example

This example reads in a set of data consisting of five observations on each of four variables. Missing values of

0.0

are declared for the second and fourth variables; no missing values are specified for the first and third variables. The means, standard deviations, sums of squares and cross-products of deviations from means, and Pearson product-moment correlation coefficients for the fourth, first and second variables are then calculated and printed, omitting completely all cases containing missing values for these three selected variables; cases

3

and

4

are therefore eliminated, leaving only three cases in the calculations.

Open in the MATLAB editor: g02bh_example

function g02bh_example


fprintf('g02bh example results\n\n');

x = [ 3,  3,  1,  2;
      6,  4, -1,  4;
      9,  0,  5,  9;
     12,  2,  0,  0;
     -1,  5,  4, 12];
[n,m] = size(x);
fprintf('Number of variables (columns) = %d\n', m);
fprintf('Number of cases     (rows)    = %d\n\n', n);
disp('Data matrix is:-');
disp(x);

miss   = [int64(0); 1; 0; 1];
xmiss  = [        0;  0; 0; 0];
mistyp =  int64(0);
kvar   = [int64(4); 1; 2];
nvar   = size(kvar,1);

[xbar, std, ssp, r, ncases, ifail] = ...
  g02bh( ...
         x, miss, xmiss, mistyp, kvar);

fprintf('Variable   Mean     St. dev.\n');
fprintf('%5d%11.4f%11.4f\n',[double(kvar) xbar(1:nvar) std(1:nvar)]');
fprintf('\nSums of squares and cross-products of deviations\n');
disp(ssp)
fprintf('Correlation coefficients\n');
disp(r);
fprintf('Number of cases actually used  = %d\n', ncases);

g02bh example results

Number of variables (columns) = 4
Number of cases     (rows)    = 5

Data matrix is:-
     3     3     1     2
     6     4    -1     4
     9     0     5     9
    12     2     0     0
    -1     5     4    12

Variable   Mean     St. dev.
    4     6.0000     5.2915
    1     2.6667     3.5119
    2     4.0000     1.0000

Sums of squares and cross-products of deviations
   56.0000  -30.0000   10.0000
  -30.0000   24.6667   -4.0000
   10.0000   -4.0000    2.0000

Correlation coefficients
    1.0000   -0.8072    0.9449
   -0.8072    1.0000   -0.5695
    0.9449   -0.5695    1.0000

Number of cases actually used  = 3

PDF version (NAG web site, 64-bit version, 64-bit version)

Chapter Contents

Chapter Introduction

NAG Toolbox