The honored science and education member of the RANS,
corresponding-member of the IAS of HS, Dr.S. (eng.). Professor, Pil E.A. Russia, Saint-Petersburg,
Saint-Petersburg State Marine Technical University
BUILDING LIMITS OF EXISTENCE AREA OF A
HEALTHY OR A DISEASED BODY WITH USE OF THE MS EXCEL PROGRAM
Every medical book
always mentions a healthy and a diseased body, but there is no specific mention
of the limits within which a healthy body exists. The limits are understood as
any specific numeric values of one or several parameters according to which we
can make a respective conclusion. This article deals with the issue of
calculation of existence limits of both a healthy and a diseased body with the
use of the MS Excel program and is based on the analysis of results of
experimental research done in the cancer biophysics laboratory where the
researchers studied the effect of different actions (Table 1) on 32
factors.
Table 1. Types
of actions on study groups
|
¹ |
Type of action |
|
1. |
Control (without tumor) with no action |
|
2. |
Injection of a chemotherapeutic agent intramuscularly (i.m.) |
|
3. |
Injection of a chemotherapeutic agent (i.m.) + adrenalin |
|
4. |
Injection of a chemotherapeutic agent into the lymph node (into ln) |
|
5. |
Injection of a chemotherapeutic agent (into ln) + magnetic field |
|
6. |
Injection of a chemotherapeutic agent intramuscularly (i.m.) |
|
7. |
Control + normal saline solution (to group 2) |
|
8. |
Control + adrenalin (to group 3) |
|
9. |
Control + magnetic field (to groups 5 and 6) |
|
10. |
Control (tumor without action) (to groups 2 to 9) |
|
11. |
Control (without tumor) + chemotherapeutic agent (i.m.) |
Out of these 32 factors
we took 24 presented in Table 2 based on which we built the existence areas of
a healthy and a diseased body in relation to variable Õ15, NADP of cortex (as
it has a relatively big difference between the maximum and the minimum values
of the correlation coefficient) with the use of the REGRESSION program [1, 2].
Table 2. Factors
studied
|
¹ |
Variables |
Title |
|
1. |
Õ15 |
NADP of cortex |
|
2. |
Õ3 |
Weight of thymus per 100 g of animal mass |
|
3.
|
Õ4 |
Average surface of adrenal cortex |
|
4.
|
Õ5 |
Average surface of adrenal medulla |
|
5.
|
Õ6 |
Total cells in the standard surface of cortex |
|
6.
|
Õ7 |
Percentage of small lymphocytes in the standard surface of cortex |
|
7.
|
Õ8 |
Percentage of middle lymphocytes in the standard surface of cortex |
|
8.
|
Õ9 |
Number of macrophages in cortex |
|
9.
|
Õ10 |
Total cells in the standard surface of adrenal medulla |
|
10.
|
Õ11 |
Percentage of small lymphocytes of adrenal medulla |
|
11.
|
Õ12 |
Percentage of middle lymphocytes of adrenal medulla |
|
12.
|
Õ13 |
RNA/DNA of thymus of cortex |
|
13.
|
Õ14 |
NAD of cortex |
|
14.
|
Õ16 |
NADPH+ of cortex |
|
15.
|
Õ17 |
NADP of cortex |
|
16.
|
Õ18 |
Succinate dehydrogenase of cortex |
|
17.
|
Õ19 |
Lactate dehydrogenase of cortex |
|
18.
|
Õ20 |
Volume of cores of cortex thymocytes |
|
19.
|
Õ21 |
Volume of adrenal medulla thymocytes |
|
20.
|
Õ23 |
RNA/DNA of adrenal medulla |
|
21.
|
Õ24 |
NADPH+ of adrenal medulla |
|
22.
|
Õ25 |
NADP of adrenal medulla |
|
23.
|
Õ26 |
Succinate dehydrogenase of adrenal medulla |
|
24.
|
Õ27 |
Lactate dehydrogenase of adrenal medulla |
Table 3 below shows resulting correlation coefficients
R2 placed in a way that from number 1 to 12 they ascend, and from 13
to 23 descend. On the basis of these data there was built a curve 1 (dashed
line) presented in Fig. 1 and Fig. 2. The next Table 4 shows the maximum and
minimum deviations of correlation coefficients R2 from a healthy
body for a group of a chemotherapeutic agent. The tables created this way had a
number of unfilled cells which is due to these values being absent. In such
cases where there was only one value for +R2 or -R2 it was inserted into cell +R2min
or -R2max. That said, there may be points and
even areas where curves of a diseased body are tangent to the curve of a
healthy body by one or several factors, i.e. when for certain reasons we cannot
deduce the limits of a diseased body. These areas were given the name of “areactive
zones” in medicine.
Table
3. Correlation coefficients R2t for variable Õ15 in ascending and descending order for thymus
|
¹ |
Variables |
R2a |
¹ |
Variables |
R2a |
|
1 |
Õ7 |
0,203 |
13 |
X5 |
0,796 |
|
2 |
X16 |
0,367 |
14 |
X11 |
0,747 |
|
3 |
X19 |
0,391 |
15 |
X20 |
0,716 |
|
4 |
X21 |
0,435 |
16 |
X27 |
0,665 |
|
5 |
X26 |
0,524 |
17 |
X25 |
0,630 |
|
6 |
X14 |
0,614 |
18 |
X4 |
0,624 |
|
7 |
X18 |
0,625 |
19 |
X13 |
0,524 |
|
8 |
X8 |
0,658 |
20 |
X17 |
0,493 |
|
9 |
X24 |
0,680 |
21 |
X23 |
0,404 |
|
10 |
X12 |
0,742 |
22 |
X10 |
0,367 |
|
11 |
X3 |
0,747 |
23 |
X6 |
0,259 |
|
12 |
X9 |
0,898 |
|
|
|

Fig. 1. Dependence R2 = f(Xi) for thymus during
chemotherapy
Here:
·
+R2max - the maximum value of the correlation coefficient of a
diseased body R2d differing from that of a healthy body R2h
upwards;
·
+R22min - the minimum value of
the correlation coefficient of a diseased body R2d differing from
that of a healthy body R2h upwards;
·
-R2max - the maximum value of
the correlation coefficient of a diseased body R2d differing from
that of a healthy body R2h downwards;
·
-R2min - the minimum value of the correlation coefficient of a
diseased body R2d differing from that of a healthy body R2h
downwards.
In other words, all +R2max and
+R2min values are placed above curve 1 while all -R2max
and -R2min values are placed below curve 1.
On the basis of Table
4 we built Fig. 1 which shows that the whole zone can be divided into the
following five areas: Ssu and Ssl are the upper and the lower areas where even
a diseased body cannot exist; Sdu and Sdl are the upper and the lower areas of
a diseased body (in Fig. 1 and Fig. 2 they are marked in grey); Shu is the
existence area of a healthy body placed above curve 1; Shl is the existence
area of a healthy body placed below curve 1.
Thus, we can note down the following
formula (1)
Stl = Ssu + Sdu +Shu + Shl + Sdl + Ssl. (1)
However, as the upper
part of a diseased body Sdu consists of 4 parts, i.e. Sdu1, Sdu2, Sdu3, Sdu4, hence
it can be represented by the following formula (2) (ref. Fig. 1)
Sdu = Sdu1 + Sdu2 + Sdu3 + Sdu4. (2)
Similarly to the upper part Sdu, the lower
part of a diseased body Sdl is calculated according to the formula (3)
Sdl = Sdl1 + Sdl2 + Sdl3 + Sdl4 + Sdl5 +
Sdl6 + Sdl7. (3)
Fig. 2. Dependence for thymus for control
Calculations
completed for these areas showed that they have the following surface values:
Ssu = 3,109 unit2, (14,132%); Sdu
= 3,967 unit2, (18,032%); Shu
= 2,009 unit2, (9,716%); Shl
= 2,138 unit2, (9,716%); Sdl
= 3,048 unit2, (13,85%); Ssl
= 7,73 unit2, (35,13%). As we see from the calculations presented, a
healthy body can have the surface of Sh = 7,73 unit2, (35,13%), a
diseased body has the surface of Sd =
7,015 unit2, (31,89%), and the area where neither a healthy, nor a
diseased body can exist (Ssu + Ssl) makes 10,839
unit2, (49,266%).
Similar calculations were made for the group of a
healthy body for control + a chemotherapeutic agent. The data received are
presented in Table 5 and on the basis of these data we built Fig. 2. Here we
deduced the following values of the surfaces: Ssu = 6,057 unit2, (27,53%);
Sdu = 1,781 unit2, (8,095%); Shu
= 1,248 unit2, (5,67%); Shl = 1,884 unit2, (8,564%);
Sdl = 2,864 unit2, (13,02%); Ssl = 8,167 unit2, (37,12%%).
That said, a healthy body has
the surface of Sh = 3,132 unit2, (14,234%), a diseased body has the surface
of Sd = 4,645 unit2, (21,114%), and the area where neither a healthy, nor a diseased body can exist
(Ssu + Ssl) makes 14,224 unit2, (64,652%) [3].
Table 4. Maximum and minimum deviations of the correlation coefficient R2
from a healthy body for the group of a chemotherapeutic agent
|
¹ |
Variables |
R2a |
+R2max |
+R2min |
-R2max |
-R2min |
|
1 |
Õ7 |
0,203 |
0,679 |
0,467 |
0,180 |
- |
|
2 |
X16 |
0,367 |
0,644 |
0,543 |
0,245 |
0,113 |
|
3 |
X19 |
0,391 |
0,968 |
0,488 |
0,284 |
- |
|
4 |
X21 |
0,435 |
0,900 |
0,455 |
0,162 |
- |
|
5 |
X26 |
0,524 |
0,849 |
0,528 |
0,448 |
0,312 |
|
6 |
X14 |
0,614 |
0,942 |
0,791 |
0,450 |
- |
|
7 |
X18 |
0,625 |
0,943 |
0,632 |
0,615 |
0,324 |
|
8 |
X8 |
0,658 |
0,956 |
0,805 |
0,502 |
0,468 |
|
9 |
X24 |
0,680 |
0,832 |
0,691 |
0,650 |
0,383 |
|
10 |
X12 |
0,742 |
0,898 |
0,754 |
0,646 |
0,318 |
|
11 |
X3 |
0,747 |
0,848 |
0,803 |
0,770 |
0,623 |
|
12 |
X9 |
0,898 |
- |
0,954 |
0,777 |
0,611 |
|
13 |
X5 |
0,796 |
0,909 |
0,838 |
0,729 |
0,540 |
|
14 |
X11 |
0,747 |
0,823 |
0,799 |
0,633 |
0,354 |
|
15 |
X20 |
0,716 |
0,882 |
0,746 |
0,675 |
0,575 |
|
16 |
X27 |
0,665 |
- |
0,869 |
0,657 |
0,213 |
|
17 |
X25 |
0,630 |
0,929 |
0,640 |
- |
- |
|
18 |
X4 |
0,624 |
0,873 |
0,641 |
0,597 |
0,329 |
|
19 |
X13 |
0,524 |
- |
0,829 |
0,416 |
0,169 |
|
20 |
X17 |
0,493 |
0,718 |
0,551 |
0,276 |
- |
|
21 |
X23 |
0,404 |
0,934 |
0,586 |
0,168 |
- |
|
22 |
X10 |
0,367 |
0,756 |
0,611 |
0,351 |
0,284 |
|
23 |
X6 |
0,259 |
0,591 |
0,273 |
0,213 |
0,107 |
Table 5. Maximum and minimum deviations of
the correlation coefficient R2 from a healthy body for control + a
chemotherapeutic agent
|
¹ |
Variables |
R2a |
+R2max |
+R2min |
-R2max |
-R2min |
|
1.
|
Õ7 |
0,203 |
0,551 |
0,299 |
- |
- |
|
2.
|
X16 |
0,367 |
0,806 |
0,398 |
0,254 |
- |
|
3.
|
X19 |
0,391 |
0,769 |
0,452 |
0,384 |
- |
|
4.
|
X21 |
0,435 |
0,810 |
0,479 |
- |
- |
|
5.
|
X26 |
0,524 |
0,922 |
0,662 |
0,338 |
- |
|
6.
|
X14 |
0,614 |
- |
0,665 |
0,439 |
0,432 |
|
7.
|
Õ18 |
0,625 |
- |
0,638 |
0,169 |
- |
|
8.
|
Õ8 |
0,658 |
- |
0,722 |
0,635 |
- |
|
9.
|
Õ24 |
0,680 |
- |
0,768 |
0,665 |
0,437 |
|
10.
|
Õ12 |
0,742 |
- |
0,845 |
0,734 |
0,452 |
|
11.
|
Õ3 |
0,784 |
- |
0,793 |
0,771 |
0,469 |
|
12.
|
Õ9 |
0,898 |
- |
- |
0,877 |
0,344 |
|
13.
|
Õ5 |
0,796 |
- |
0,878 |
0,762 |
0,499 |
|
14.
|
Õ11 |
0,747 |
- |
- |
0,729 |
0,321 |
|
15.
|
Õ20 |
0,716 |
- |
0,843 |
0,712 |
0,425 |
|
16.
|
Õ27 |
0,665 |
0,773 |
0,735 |
0,336 |
- |
|
17.
|
Õ25 |
0,630 |
- |
0,711 |
0,542 |
0,346 |
|
18.
|
Õ4 |
0,624 |
0,784 |
0,693 |
0,340 |
- |
|
19.
|
Õ13 |
0,524 |
- |
- |
0,475 |
0,220 |
|
20.
|
Õ17 |
0,493 |
0,749 |
0,539 |
0,486 |
0,410 |
|
21.
|
Õ23 |
0,404 |
- |
0,462 |
- |
- |
|
22.
|
Õ10 |
0,367 |
- |
0,368 |
0,317 |
0,312 |
|
23.
|
Õ6 |
0,259 |
- |
0,386 |
0,251 |
0,207 |
Note:
1. All experiments were made by Professor
E.A. Sheyko, Rostov-on-Don, Russia.
2. All calculations were made by Professor
E.A. Pil, St.-Petersburg, Russia.
BIBLIOGRAPHY
1. E.A. Pil, E.A. Sheyko. Analysis of Regression Dependences Found While
Studying the Parameters of Blood and Thymus / Saint Petersburg Institute of
Fine Mechanics and Optics. – 16 p., illustrated. – References: 1 title – Rus.
Dep. in VINITI 07.12.93. N3037–Â93
2. E.A. Pil, E.A. Sheyko. Use of a Personal
Computer in Experimental Oncology / Oncology Problems. – 1993. – N3. – pp. 92–94
3. E.A. Pil, E.A. Sheyko. Defining the
Existence Limits of a Healthy and a Diseased Body Based on the Analysis of
their Correlation Coefficients, Saint Petersburg, REMO&Ñî, Saint Petersburg, 1997. – 19 p., illustrated.