Database Reference
In-Depth Information
FIGURE 5.5
Computing the square of each value in column E into column F; Excel. (Notice the
command in the tool bar above.)
Step (2)
Next, ind the sum of each of the rows. The command for row 1 would
be =SUM(A1:B1). We put this arbitrarily in column D. This is done for each row (or
“dragged down” for each row), resulting in
Figure 5.4
.
We now have the column sums and the row sums.
Step (3)
Next, form a new column that is the square of column D, that is, the
square of each of the row sums. For example, for row 1, type the following in
cell E1:
=D1*D1
Then press “enter.” Complete for each row. See the results in
Figure 5.5
.
Step (4)
Now, add up the values in column D and in column E. For column D, we
can write (in cell D12), the command =SUM(D1:D10), and do the same for column
E, in cell E12, with the command =SUM(E1:E10). This is shown in
Figure 5.6
. As a
small aside, we actually knew that the sum of column D would be 11 (=6 + 5).
Step (5)
Now, calculate Q, which involves the values in row 12 and the fact that
there are two tasks. First, we'll give you the components of the formula and then the
formula itself:
•
K = number of columns, here = 2
•
Values in cells A12, B12, D12, and E12
•
T = A12 + B12 (here = 6 + 5 = 11)
TSSQ = A12
2
+ B12
2
(here = 6
2
+ 5
2
= 36 + 25 = 61)
•
Search WWH ::
Custom Search