To have it done, select the range C2:C13, type the below formula and press Ctrl + Shift + Enter to complete it: 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. 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.