Real Statistics Box’s Test Support

The Real Statistics Resource Pack’s implementation of Box’s Test supports two types of data formats:

Covariance Matrix Format: The data range R1 consists of an m × 2 range where m = the number of samples (i.e. the number of covariance matrices). Each row in R1 consists of the cell in the upper left corner of one of the covariance matrices being compared in column 1 and the sample size corresponding to that covariance matrix in column 2. See Figure 1 and 2 for examples of data in Covariance Matrix Format.

Standard Format (without column headings): The data range R1 is an m × n range where the first column consists of the identification codes/names of the groups (i.e. independent variables) under consideration. These identification codes/names can be written in any order and repetitions are common (in fact, the sample size for each group is equal to the number of times that group identification is repeated). The remaining cells in R1 consist of data corresponding to the row identifiers. See Figure 1 of Manova Basic Concepts for an example of data in standard format.

Real Statistics Functions: The Real Statistics Resource Pack contains the following supplemental functions, where R1 is in standard formal if k = 0 (or is omitted) and R1 is in covariance matrix format if k > 0 where k = the number of dependent variables (i.e. all the covariance matrices are k × k).

BOXTEST(R1, k) = p-value           
BOXM(R1, k) = M statistic          
BOXF(R1, k) = F statistic
BOXdf1(R1, k) = df1                       
BOXdf2(R1, k) = df2

We also have the array function BOX(R1, k) which outputs a 5 × 1 range consisting of the enteries BOXM(R1, k), BOXdf1(R1, k), BOXdf2(R1, k), BOXF(R1, k) and BOXTEST(R1, k) in that order.

Additionally, BOXTEST takes an optional third parameter b which defaults to True (as described above). When b is False then the chi-square test is performed instead of the F test, i.e. BOXTEST(R1, k, False) = p-value for the chi-square test. For Example 1 this corresponds to cell N17 in Figure 1.

Finally, the Real Statistics Resource Pack contains the following supplemental array function

COVPooled(R1, k) = pooled covariance matrix

Example 1: Perform Box’s Test for the three covariance matrices shown in Figure 1 of Box’s Test Basic Concepts using the BOX function, based on three samples of size 7 each.

The key here is to create the appropriate input matrix R1 (range Y5:Z7 in Figure 1). Since there are three covariance matrices (one per each of the three samples), we need a 3 × 2 input matrix. The values in the second column will all be 7 since this is the size of all three samples.

Box's test Real Statistics

Figure 1 – Box’s Test using the BOX supplemental function

To create the values in the first column simply click on the cell in the upper left corner of each of the covariance matrices, which for Example 1 of Box’s Test Basic Concepts are A5, A13 and G5 from Figure 1 of Box’s Test Basic Concepts. Note that the values of these cells are what you see in column Y of Figure 1.

We next highlight a 5 × 1 range (range AC4:AC8 of Figure 1), enter =BOX(Y5:Z7,5) and Ctrl-Shft-Enter to obtain the output shown in Figure 1.

Example 2: Perform Box’s Test for the two covariance matrices shown in Figure 4 of Hotelling’s T-square for Two Independent Samples using the supplemental functions.

This time the sizes of the two samples are not equal, but are 20 and 18. We create the input matrix (E5:F6). To create the values in the first column simply click on the cell in the upper left corner of each of the covariance matrices, which for Example 2 are A5 and A11 from Figure 4 of Hotelling’s T-square for Two Independent Samples. Note that the value of these cells are what you see in column E of Figure 2.

box-test-hotelling-excel

Figure 2 – Box’s Test using supplemental functions

In Figure 2 we see both the chi-square version of the Box Test as well as the F version. E.g. the p-value using the chi-square test (cell I7) is calculated by the formula =BOXTEST(E5:F6,F8,FALSE) and the p-value using the F test (cell L9) is calculated by the formula =BOXTEST(E5:F6,F8).

Note that the pooled covariance matrix (H12:J14) is calculated by the array function =COVPooled(E5:F6,F8).

Example 3: Perform Box’s Test for the data in Example 1 of Manova Basic Concepts using the BOX function.

Referring to Figure 1 of Manova Basic Concepts, we highlight the range J3:J7 in Figure 3, enter =BOX(A4:D35) and press Ctrl-Shft-Enter. of  The result is shown in Figure 3. Note that the column headings (range A3:D3) are not included in the input range.

Box's test Manova Excel

Figure 3 – Box’s Test for MANOVA using the BOX supplement function

Real Statistics Data Analysis Tool: As described in Real Statistics Manova Support, the Box option of the MANOVA data analysis tool will also perform the box test for data in standard form.

10 Responses to Real Statistics Box’s Test Support

  1. Colin says:

    Sir
    Boxtest function doesn’t work in RealStats_3.2.1

    Colin

    • Charles says:

      Colin,
      I just tried using the BOXTEST function for Example 1 and 3 on the referenced webpage and it worked just fine. The answers iven are the same ones that appear on the webpage. I am using Release 3.2.1 on Excel 2010 in Windows 7. Which version of Excel and Windows are you now using?
      Charles

      • Colin says:

        Sir

        I am using Office 2010 in Windows 7

        Colin

        • Charles says:

          Colin,

          This is very strange since you are using the same configuration as me and the BOXTEST function works as before on my computer. I plan to issue a new minor release in a day or so. Let’s see if this problem goes away.

          Does the BOX array function work properly? Are you able to use the Box’s test option on the MANOVA data analysis tool?

          Charles

  2. ahmed says:

    thx charles

  3. ahmed says:

    how we can calculate it(box’s m )for equality of correlation I cant find it
    ?

  4. Edu says:

    The functions BOXTEST, BOXM not work!!!. I try again and again and nothing. Can you review them, please?

    • Charles says:

      Edu,
      I just checked all the Box functions and they work fine on my computer. Do other functions from the Real Statistics Resource Pack work properly? If you send me the worksheet with the data that you are using and the formulas that don’t work properly, I will try to figure out what went wrong.
      Charles

Leave a Reply

Your email address will not be published. Required fields are marked *