Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get first row number in range in Excel
  • How to get address of named range in Excel
  • How to get address of first cell in range in Excel
  • How to get address of last cell in range in Excel
  • How to get relative column numbers in a range in Excel

Data Analysis Examples

  • How To Compare Two Lists in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How to perform a t-Test in Excel
  • How to add Trendline to a chart in Excel
  • How to create running total in an Excel Table

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation date in specific year
  • Excel Data validation no punctuation
  • Excel Data validation date in next 30 days
  • Excel Data validation only dates between

FORECAST function: Description, Usage, Syntax, Examples and Explanation

by

What is FORECAST function in Excel?

FORECAST function is one of Statistical functions in Microsoft Excel that calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.
Worked Example:   Forecast vs Trend Function in Excel

Syntax of FORECAST function

FORECAST(x, known_y’s, known_x’s)

The FORECAST function syntax has the following arguments:

  • X    Required. The data point for which you want to predict a value.
  • Known_y’s    Required. The dependent array or range of data.
  • Known_x’s    Required. The independent array or range of data.

FORECAST formula explanation

  • If x is nonnumeric, FORECAST returns the #VALUE! error value.
  • If known_y’s and known_x’s are empty or contain a different number of data points, FORECAST returns the #N/A error value.
  • If the variance of known_x’s equals zero, then FORECAST returns the #DIV/0! error value.
  • The equation for FORECAST is a+bx, where:Equationand:

    Equation

    and where x and y are the sample means AVERAGE(known_x’s) and AVERAGE(known y’s).

Example of FORECAST function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Known Y Known X
6 20
7 28
9 31
15 38
21 40
Formula Description Result
=FORECAST(30,A2:A6,B2:B6) Predicts a value for y given an x value of 30 10.607253

Post navigation

Previous Post:

FISHERINV function: Description, Usage, Syntax, Examples and Explanation

Next Post:

FREQUENCY function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to check if cell contains number in Excel
  • How to check if cell contains all of many things in Excel
  • How to check if cell contains one of many things in Excel
  • How to translate letters to numbers in Excel
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • Extract date from a date and time in Excel
  • How to determine year is a leap year in Excel
  • How to Calculate Age in Excel
  • Get last weekday in month in Excel
  • How to get Holiday Date from Year in Excel
  • Calculate loan interest in given year in Excel
  • COUPNCD function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • Tax rate calculation with fixed base in Excel
  • Calculate payment for a loan in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles