Question about Microsoft Excel for PC
I have column A showing months 1 to 12, and column B is 12 values. In column C I have the formula "{=TREND(C3:C14,A3:A14)}". I have use F2 and CTRL+SHIFT+ENTER to create the array but only get a result in one cell. I have even used the example in Excel "Help" but has not helped.
Cheers
Let's say you have a criterion in column A that must be true; any true record should be included in the trend estimate for your unknown X value "5", with X's in column B and Y's in column A, as follows:
A B C
TRUE 1 2
TRUE 2 4
FALSE 3 0
TRUE 4 8
The formula is
=TREND(IF(A1:A4,C1:C4,AVERAGE(C1:C4)),IF(A1:A4,B1:B4,AVERAGE(B1:B4)),5)
This is the only way to do it, because TREND doesn't like falses in the array, and you can't use any other number except for the average, else it will mess with the trend results. Try it for yourself - it works!
Posted on Aug 05, 2009
Hi Griffnz,
Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.
Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.
The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.
Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'
However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)
If this doesn't make sense, let me know.
Posted on Oct 01, 2008
Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!
Posted on Jan 02, 2017
Jan 19, 2016 | Computers & Internet
Oct 13, 2015 | Microsoft Excel for PC
Mar 06, 2015 | Microsoft Excel 2010
Jun 11, 2009 | Microsoft Excel for PC
Apr 27, 2009 | Microsoft Excel for PC
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Dec 21, 2008 | Microsoft Excel for PC
Nov 02, 2008 | Microsoft Computers & Internet
Jul 08, 2008 | Microsoft Computers & Internet
Feb 03, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
655 people viewed this question
Usually answered in minutes!
In the mentioned example the formula reads:
"{=TREND(B3:B14,A3:A14)}".
Cheers
Excel shows that trend of current data is possible (see excel TREND example). However, this is not consistent. In D3 I typed "=TREND(C3:C6, B3:B6)" followed by F2, CTRL+SHIFT+ENTER and got:
ColB ColC ColD
1
$133,890
133842
2
$135,000
134944
3
$135,790
136046
4
$137,300
137148
When I typed the same thing again in the same cell I got
1
$133,890
133842
2
$135,000
3
$135,790
4
$137,300
Very strange. However, TRENDLINE solved the problem but it would be nice to know why the formula didn't.
×