This Excel tutorial explains how to use the Excel FORECAST function with syntax and examples.

Description

The Microsoft Excel FORECAST function returns a prediction of a future value based on existing values provided.

The FORECAST function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the FORECAST function can be entered as part of a formula in a cell of a worksheet.

Syntax

TreePlan ® Decision Tree Add-in for Excel For Mac Excel 2016-2019-365 and Windows Excel 2010-2013-2016-2019-365. TreePlan helps you build a decision tree diagram in an Excel worksheet using dialog boxes. Decision trees are useful for analyzing sequential decision problems under uncertainty. If you are running Excel 2007 or later on a PC or Excel 2016 on a Mac then a tab will be added to your Excel tabs. The tab will be named either Excel OM or Excel QM depending on the textbook you are using. Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public ('vizzes') can be embeded into webpages and blogs, they can be shared via social media or email, and they can be made available for download to other users.

The syntax for the FORECAST function in Microsoft Excel is:

Parameters or Arguments

x-value

The x-value used to predict the y-value.

known_y_values

The known y-values used to predict the y-value.

known_x_values

The known x-values used to predict the y-value.

Returns

Excel Qm For Mac

The FORECAST function returns a numeric value.
If x-value is not a numeric value, the FORECAST function will return the #VALUE! error.
If known_y_values and known_x_values contain different numbers of elements, the FORECAST function will return the #N/A error.

Applies To

• Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Example (as Worksheet Function)

Let's look at some Excel FORECAST function examples and explore how to use the FORECAST function as a worksheet function in Microsoft Excel:

Based on the Excel spreadsheet above, the following FORECAST examples would return:

Excel Om/qm For Mac

Overview

Excel QM is a Shareware software in the category Web Development developed by Excel QM.

It was checked for updates 31 times by the users of our client application UpdateStar during the last month.

The latest version of Excel QM is currently unknown. It was initially added to our database on 05/22/2008.

Excel QM runs on the following operating systems: Windows/Mac.

Excel QM has not been rated by our users yet.

Write a review for Excel QM!

• » tải phần mềm excel qm
• » excel qm add in free download
• » ejemplos de qm excel
• » excel qm 64
• » excel qm a
• » what is excel qm add in
• » excel qm v4 download
• » canciones de la nueva qm
• » excel qm free
• » download excel for qm