CODEWITHSUNDEEP
javascriptexcelforecasting
Cyril N.
Cyril N.

Reputation: 39879

Forecast formula from Excel in JavaScript

I'm trying to make a Forecast function in JavaScript based on the code from Excel, explained at https://support.office.com/en-US/article/FORECAST-function-50CA49C9-7B40-4892-94E4-7AD38BBEDA99

But I don't understand what is the x with a trait on top (also y) from the formula and so I don't know how to translate it in JavaScript. How can I achieve this?

Upvotes: 3

Views: 2566

Answers (1)

Karpak
Karpak

Reputation: 1927

x with a trait on top is the mean of x (i.e. the average of all xs). the same is with y. if x values are 20,28,31,38,40 the x with the trait on top is 31.4

function forecast(x, ky, kx){
   var i=0, nr=0, dr=0,ax=0,ay=0,a=0,b=0;
   function average(ar) {
          var r=0;
      for (i=0;i<ar.length;i++){
         r = r+ar[i];
      }
      return r/ar.length;
   }
   ax=average(kx);
   ay=average(ky);
   for (i=0;i<kx.length;i++){
      nr = nr + ((kx[i]-ax) * (ky[i]-ay));
      dr = dr + ((kx[i]-ax)*(kx[i]-ax))
   }
  b=nr/dr;
  a=ay-b*ax;
  return (a+b*x);
}

The above script gives you the forecast without error handling.

You can call this using the below method

forecast(30,[6,7,9,15,21],[20,28,31,38,40]);

Upvotes: 8

Related Questions