Intercept and Linest functions.

**Thorxes** · 11-29-2008, 01:49 PM

So I have an array of data and want to use it as my Y values.

However I want to use an incremental time counter for my X's; 1,2,3...etc.

What's the command for the incremental time counter?

I think I'll also need this for another column. I'm using these 2 functions to calculate the slope and intercept of an array. I will then be using them to make another array that starts off at: The Intercept + x*slope, where x increments down the array.

**shg** · 11-29-2008, 02:12 PM

If 1 is in A1, in A2 and copy down, =A1+1

**Thorxes** · 11-29-2008, 02:23 PM

Yeah the problem with that is that I have to print these worksheets for company reports and I didn't want there the be a column with just numbers being printed off.

I think to get around it I'll just make the font color: white for that column.

**shg** · 11-29-2008, 02:33 PM

You don't need to provide x values for LINEST or TREND; they default to categories (i.e., {1,2,3,...}) if omitted.

**Thorxes** · 11-29-2008, 02:35 PM

well my later problem is that, through these functions, I'm calculating slope and intercept.

I then need to have a column next the the Y values, that is: Intercept+ x*slope. Where x would be the increment counter. In this case, I still need that column with incremented numbers to do this.