How to analyze trends with TREND function in WPS Office Excel
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
o Principle of the TREND function
The TREND function predicts the linear increasing amount based on the current data (y=mx+b).
o Syntax of the TREND function
TREND([known_y's], [known_x's], [new_x's], [logical values])
o 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.
1. Select the cell I3, head to the Formulas tab, and click Insert Function.
2. Input “TREND” in the search box and select it.
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.
4. Then we can repeat the above steps to predict the sales in Shanghai.
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.