Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to generate a trendline equation without drawing a graph?

I have a column that is missing about 30 data points, I'd like to fill the blanks based on a trendline of the existing data

share|improve this question
up vote 3 down vote accepted

Excel's functions "FOR3ECAST" or "TREND" (using array-formulae) will get you what you want assuming the trend is linear.

By futzing with the data, you may be able to get a polynomial curve fitting .

This taken from Excel Help:

FORECAST

FORECAST(x,known_y's,known_x's)

Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.


TREND

TREND(known_y's,known_x's,new_x's,const)

*Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Returns the y-values along that line for the array of new_x's that you specify.*

share|improve this answer
    
Any way to calculate the missing values if the trend is not linear? – clabacchio Nov 28 '13 at 14:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .