Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Catalog
How does FORECAST function work in excel
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 today’s 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.
Also Read:
- 1. 10 beautiful excel budget forecast templates
- 2. 10 Amazing Forecast Excel Templates That Will Help You to Design
- 3. 10 beautiful excel budget forecast templates
- 4. Top 10 daily cash flow forecast template Excel download 2024
- 5. Top 10 sales forecast template excel free download 2022
- 6. 12 Month Sales Forecast Excel Template Sheets for Download