Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.