Home
Using Forecast function in excel to predict or calculate a future value along a linear trend by using existing values
Tags:, , , , , , , , , , , ,

Using Forecast function in excel to predict or calculate a future value along a linear trend by using existing values

April 29, 2014 No Comments beginner, excel, Office, tricks

This is one of my favourite useful tips in Excel. Sometime, you have a less-accurate data set with a lower resolution. However, partial data cannot be fit into the program. You will need to do the interpolation. And you can use the forecast function in excel to accomplish this. The syntax for this function (take C/C++ for example) is:

1

double forecast(double x, double *ys, double *xs);
double forecast(double x, double *ys, double *xs);

The forecast will return a predicted future value given on the existing series y’ = f(x’) the series is assumed linear trend. Given a input x the value will be interpolated.

excel-forcast-linear Using Forecast function in excel to predict or calculate a future value along a linear trend by using existing values beginner excel Office tricks

Excel Forcast

You can drag and drop the cells in excel to auto-complete the formulas for an area of cells.

–EOF (The Ultimate Computing & Technology Blog) —

GD Star Rating
loading...
208 words
Last Post: Timeout Utility in Windows Command Shell
Next Post: C/C++ function to Convert Hex String to Decimal Number

The Permanent URL is: Using Forecast function in excel to predict or calculate a future value along a linear trend by using existing values

Related posts:

  1. Gaming Adaptations for Different Platforms One of the trickiest challenges facing any software developer is figuring out how their coding...
  2. How to Fix a Slow/Incorrect Clock on Windows? I have been using HP Z800 Server for a couple of years and lately, the...
  3. Teaching Kids Programming – Closest Binary Search Tree Value (Recursion + Inorder Traversal + Binary Search Algorithm) Teaching Kids Programming: Videos on Data Structures and Algorithms Given the root of a binary...
  4. C++ Function to Compute Numerical Integral Using Function Pointers In this tutorial, we know how to define a general-purpose function to compute the numerical...
  5. Trick: Count the Number of API in COM Delphi is a handy tool to develop the COM (Component Object Model) DLL. A *_TLB.pas...
  6. 3 Ways to Protect Your Website from Negative SEO Search Engine Optimization (SEO) techniques are set to make your website appear on top of...
  7. Integration Tests Using PHPUnit to Ensure Your Website is Working with Static and Dynamic Contents You must want to make sure your website is configured properly to work with the...
  8. Adding Clipboard Support to Chrome Extension: Show My IP Addresses (External and Local) Show My IP Addresses is a Chrome Extension that displays both Local and External IP...

Leave a Reply