Calculating best fit trends

To calculate the rate of weight loss or gain and the calorie shortfall or excess responsible for it from the moving average trend line, the Excel spreadsheet finds the straight line trend that best fits the curve traced out by the moving average by the method of least squares. The process of finding a line that accurately represents the trend of a collection of data points is called linear regression, and the least squares method is the most frequently used approach to the problem.

Any non-vertical straight line (you'd be in a fine pickle if your weight trend line were vertical, wouldn't you?) can be expressed in the form:

Y = ml + b where m is the slope, giving the change in the Y axis value for each unit change along the X axis, and b is the intercept, the point at which the line crosses the Y axis when X is zero.

To find m and b for the line that best fits a collection of data points D\, Di,..., Dn we calculate:

h = (E"=i A-)(DLi - (E"=i 0(E"=i m " «E5L i<2-(E?=i02

Since we're only interested in the rate of change, we only need the slope, m, which gives the daily rate of change in the line that best fits the moving average trend curve. From the slope, the average weight change per week is just seven times the daily change,

7 m and the average daily calorie deficit (if negative) or excess (if positive) is:


101 Everyday Tips for Losing 10 Pounds

101 Everyday Tips for Losing 10 Pounds

Studies show obesity may soon overtake tobacco as the leading cause of death in world. Who Else Could Use 101 'Everyday' Ways to Lose 10 Pounds or more and Keep it Off! You've been putting it off too long. Hey, everyone needs to lose weight from time to time. You're no different!

Get My Free Ebook

Post a comment