![]() ![]() ![]() ![]() If your target weight is 160 lbs., you could use the following formula: After getting about 10 days or so of measurements, you can use these data pairs to forecast when you will hit your target weight. Every day you enter the date into column A and the weight for that day in column B. The Yrange and Xrange parameters are sets of know Y and X values.Īs and example, let's say that you are going on a diet, and you decide to keep track of your weight each day. In this usage, X is the X value for which you want FORCAST to return a Y value. The FORECAST function uses the following syntax: The new x-value can have any value and is not restricted to be larger than the existing x-values. Excel performs a linear regression based on the existing values and then inserts the x-values into the expression for the regression which gives you an y-value. The FORECAST function can be used whenever you have an existing set of data pairs (x-values and y-values) and you want to calculate an estimated y-value to a new x-value. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |