WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How does FORECAST function work in excel

July 31, 2023
7.1K Views

The forecast function in WPS Spreadsheet is not as difficult as you might think. After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet.

· What is the FORECAST function in WPS Spreadsheet?

This function can be used to calculate or predict a future value by using existing values. Its Syntax is: =(X, Known_y's, Known_x's)

X is the data point for which you want to predict the value and must be a numeric value.

Known_y's is the set of y-values you already know in the relationship y=mx+b.

Known_x's is a range or array of x-values you already know in the relationship y=mx+b.

· Example of the FORECAST function in WPS Spreadsheet

In todays case, we will use the FOURCAST function to predict future house prices.

1. Select cell B8, and then enter the following formula:

=FORECAST(A8,B3:B7,A3:A7)

Explanation:

A8, the X argument in the FORECAST function, is the value we want to predict.

B3:B7, the Known_y's argument in the FORECAST function, is the set of y-values we already know.

A3:A7, the Known_x's argument in the FORECAST function, is a range or array of x-values we already know.

This is how FORECAST works. By doing so, we can get $424,970.00 as the predicted house prices in 2025, and this calculation is based on the past results.

2. Drag cell B8 and pull it all the way down to cell B10, and then we can get the predicted house prices in the years 2030 and 2035.

Today we have learned how the forecast function works in excel, and you are welcome to WPS Academy to explore more!

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.