FriendsEAT New York

FriendsEat

Category

How do you use the FORECAST function in MS Excel?


In Microsoft Excel how do you use the function FORECAST?

add to favorite add to favorite In: Technology

Answer the Question

Answers (1)


         FORECAST(x_val, known_y_vals, known_x_vals) essentially performs a linear regression on the known_y_vals and known_x_values and "predicts" the y_val for the input x_val.

For example, lets say we had known_x_vals = {1, 2, 3, 4} and known_y_vals = {2, 4, 6, 8}. It is pretty obvious that for an x_val of 5, we should have a y_val of 10.

This is what FORECAST does, except it can handle more than just linear regressions.

420 days ago

How do you use the FORECAST function in MS Excel Images

Daniel calculated in his mind <b>how</b>

Related Links
Powered by Google

This article describes the FORECAST function in Microsoft Excel. ... With the...
support.microsoft.com
When you use the FORECAST, STEYX, SLOPE or INTERCEPT functions in a...
support.microsoft.com
This tip explains how to use the function. (This tip works with Microsoft...
excel.tips.net
Excel tips and Excel help from the MrExcel Message Board regarding FORECAST...
www.mrexcel.com
How to Use Excel's FORECAST Function. Microsoft has built a wealth of powerful...
www.ehow.com
How to Use MS Excel Forecast Formula. Microsoft Excel is a powerful tool for...
www.ehow.com
Jul 24, 2009 ... How to Use Excel's FORECAST Function | eHow.com. How to Use...
ask.friendseat.com
You can use the forecast function in Excel to predict future sales, inventory...
www.familycomputerclub.com

Related Blogs

... Debt Ratio Where to find financial leading indicators How to edit the Cashflow How to...
http://www.camelbay.com/
Software is in Microsoft Excel format and Excel is required for use. All software...
http://www.inteldirect.co.za/
All programs work together better than ever before, and all integrate completely with...
http://worldforfree.net/
Orbisoft's top-rated Task Manager 2007 is a new, easy to use program designed especially...
http://www.inteldirect.co.za/
mingali mingali is offline. Forum Contributor. Join Date: 24 Jul 2009. Location: Singapore....
http://www.excelforum.com/members/peterjones0001.html
Import data from Excel, Quicken, Microsoft Office Accounting & prior QuickBooks...
http://www.bizxa.com/
For doing that, you can make use of VBA to manage how others interrelate with the...
http://excelvbabook.com/
Candidate should be a graduate with at least 12 years of experience in administrative...
http://hps.maktoobblog.com/

Related News

You can see additional rationale for our iPad unit forecast here. You can also modify our iPad forecast below to see how it impacts the $267 Trefis price ...
Trefis
Microsoft's (NASDAQ:MSFT) Office Suite is a group of desktop applications used primarily for word processing (Word), spreadsheet preparation (Excel), ...
Trefis
Microsoft's Office Suite is a group of desktop applications used primarily for word processing (Word), spreadsheet preparation (Excel), ...
Trefis
86400 IN, ms office license, NS ns2. Excel 2007 windows 7 price is a more robust version and it really tries to make it very hard to recover the lost ...
The NarcoSphere
It can import data from old Windows releases of Quicken, as well as Microsoft's now-abandoned Money. And the application itself no longer looks like a ...
Washington Post (blog)
Shares of STEC Inc. (STEC) plummeted 24% to $10.19 after the memory product maker forecast first-quarter earnings and revenue well below analysts' estimates ...
Wall Street Journal
Enterprise Search--the "Google-style" search function that lets users search against structured and unstructured data residing in their Lawson systems and ...
IT Jungle
Tenet also forecast current-year earnings below analysts' estimates. The company led the hospital sector lower as investors worried about what the company's ...
Wall Street Journal

Related Videos

BusinessPlanWorld.com - Tutorial Topics: Navigating the MS Excel Tabs About What will be covered in this tutorial: Navigating the MS Excel Tabs ...
BusinessPlanWorld.com - Tutorial Topics: Best part of the business plan Why BusinessPlanWorld.com Exists Executive Summary Info about the ...
Youth Centre Mentor Profile: Our mentor has been involved with the arcade amusement industry for about 8 years. During that time he built up his ...
www.ExcelisHell.com How to add a trendline to a graph or chart in excel. You can add multiple trendlines and forecast into the future. Includes ...
Restaurant Business Plan Mentor Profile: Our mentor has over 14 years experience in the restaurant and hospitality industry. He gained experience ...
to find financial leading indicators How to edit the Cashflow How to use Paste Link in MS Excel The Cashflow and Income Statement relationship How ...
Confectionery/Convenience Store Mentor Profile: Shaun Gillis owner/operator of Gillis Convenience, has been involved in the Retail Sector since ...
www.lynda.com Numbers and financial data drives todays business world and Excel 2007: Financial Analysis can help decode this information. The ...

Ask a Question


110 characters left
Ask a Question

Copyright 2006 - 2009. Binary Bits, LLC.