Hi Guys
I am trying to set up a spreadsheet using either Forecast, Logest or Linest to estimate future kit receipt numbers using past data of units sent and units returned and i am having problems, first of all is this possible using the data below with any of these functions in Excel? And secondly, any tips to help me along?
Month .........................Kits Shipped ..................Kits Returned
JAN.............................78000............................31252
FEB ............................100124 ..........................32657
MAR ...........................103012 ...........................41135
APR ............................90560 .............................37122
MAY ...........................92104..............................37498
JUN ............................89281 ..............................40357
JUL..............................86234...............................?????
I am trying to set up a spreadsheet using either Forecast, Logest or Linest to estimate future kit receipt numbers using past data of units sent and units returned and i am having problems, first of all is this possible using the data below with any of these functions in Excel? And secondly, any tips to help me along?
Month .........................Kits Shipped ..................Kits Returned
JAN.............................78000............................31252
FEB ............................100124 ..........................32657
MAR ...........................103012 ...........................41135
APR ............................90560 .............................37122
MAY ...........................92104..............................37498
JUN ............................89281 ..............................40357
JUL..............................86234...............................?????
Last edited: