When you first start keeping your log, the very first day, enter your weight in the ``Trend'' column as well as the ``Weight'' column. Thereafter, calculate the number for the ``Trend'' column as follows:
For example, here's a log for November 1990, You're about to make the entry for November 4th. You've just weighed yourself at 171.5, and entered that number in the weight column. Your log now looks like this:
November 1990 Date Day Weight Trend Rung ---- --- ------ ----- ---- 173.6 1 Thu 172.5 173.5 1 2 Fri 171.5 173.3 1 3 Sat 172 173.2 1 4 Sun 171.5 _____ 1 5 ___ ______ _____ ___ 6 ___ ______ _____ ___
To compute the trend number, subtract yesterday's trend number (173.2) from today's weight (171.5):
171.5 |
- 173.2 |
-1.7 |
Next, shift the decimal point in the difference one position to the left, giving -0.17. This number is rounded to one decimal place by looking at its second decimal place and adding one to the first decimal if it's five or more. Since the second decimal place is 7, we round the number to -0.2. Finally, this number is added to yesterday's trend number (173.2). Since we're adding a negative number, the result is less:
173.2 |
+ -0.2 |
173.0 |
This result, 173.0, is entered as the trend number for the 4th.
When you begin a new log sheet for the next month, copy the trend number for the last day of the previous month to the line right below the ``Trend'' column heading of the new log. When you compute the trend for the first day of the new month, use that entry as the previous day's trend number.
This may seem a lot of trouble at first, but once you get accustomed to it, you can calculate the new trend number in a few seconds.
(Those conversant with mathematics will recognise this as an
``exponentially smoothed moving average with 10% smoothing,''
and the instructions above as the wordy equivalent of the
expression
Tn=Tn-1+0.1(Wn-Tn-1)
where Tn
is the trend
number for day n
and Wn
is the weight number for day n.
If you're using a calculator to compute the trend, use this formula.
Complete mathematical definitions of various forms of moving averages
are given on page . The trick of
avoiding division by choosing a smoothing percentage of 10% and
shifting the decimal place instead has been used for decades by financial
analysts making stock and commodity price charts.)
By John Walker