Based on this data, we want to determine the overall trend in the time series ignoring hills and valleys. In this example, we have the month numbers (independent x-values) in A2:A13 and sales numbers (dependent y-values) in B2:B13. Supposing you are analyzing some data for a sequential period of time and you want to spot a trend or pattern. TREND formula for time series trend analysis in Excel Since the new values are returned as an array, you won't be able to edit or delete them individually.Īt first sight, the syntax of the TREND function might seem excessively complicated, but the following examples will make things a lot easier. If omitted, known_x's is assumed to be the array of serial numbers, which is a visual indication of an array formula.If several x variables are used, known_y's must be a vector (one column or one row).If only one x variable is used, known_y's and known_x's can be ranges of any shape but equal dimension.
Known_x's (optional) - one or more sets of the independent x-values.
Known_y's (required) - a set of the dependent y-values that you already know.
