How to analyze trends with TREND function in WPS Office Excel

February 18, 2022
498 Views 0

In this article, you will know how to analyze trends with TREND function in WPS Office Excel with simple steps as following:

 

· Know about the TREND function in WPS Spreadsheet

Principle of the TREND function

The TREND function predicts the linear increasing amount based on the current data (y=mx+b).

Syntax of the TREND function

TREND([known_y's], [known_x's], [new_x's], [logical values])

How to analyze trends with TREND function in WPS Office Excel1.png 

Explanation of the TREND function

Known_y's (required): the set of y-values you already know in the relationship y=mx+b.

Known_x's (optional): an optional range or array of x-values that you know in the relationship y=mx+b, an array the same size as Know_y’s.

New_x's (optional): a range or array of new x-values for which you want TREND to return corresponding to y-values.

It must have the same number of columns or rows as known_x's.

If omitted, it is assumed to be equal to known_x's.

Logical values(optional): Not force the coefficient to be 0 is a logical value.

The constant b is calculated normally if Const=TRUE or omitted; b set equal to 0 if Const=FALSE.

 

· Use the TREND function to analyze trends in a real case

Here we take a sales table as an example. Suppose we want to predict the sales in Beijing and Shanghai in August.

How to analyze trends with TREND function in WPS Office Excel2.png 

1. Select the cell I3, head to the Formulas tab, and click Insert Function.

2. Input “TREND” in the search box and select it.

How to analyze trends with TREND function in WPS Office Excel3.gif 

3. In this example, select the cell range of B3:H3 at Known_y's, B2:H2 at Known_x's, and I2 at New_x's. We omit Not force the coefficient to be 0 here. Then click OK to return the result.

How to analyze trends with TREND function in WPS Office Excel4.gif 

4. Then we can repeat the above steps to predict the sales in Shanghai.

How to analyze trends with TREND function in WPS Office Excel5.gif 


With these simple steps, you are able to analyze trends with the TREND function quickly and freely. Did you get it?

 

· What is WPS Spreadsheet?

WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal basic version is free to use and it also provides abundant functions and unique features for you to explore.

 

Learn more advanced skills about function in WPS Spreadsheet:

Efficient statistics with statistical functions | WPS Academy Free Office Courses

Elementary arithmetic functions | WPS Academy Free Office Courses

 

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large-scale business process. 

Was this helpful?