predict

Good afternoon! I have been poking around trying to find something that might help me and I have tried a few things and I am not having any luck. I would like to create a list for myself to help route deliveries. Each driver will do the same route a little differently based on their own...

Hi. I have a column of monthly total costs & a column of monthly total takings from a vending machine our social fund has. Can anyone suggest a formula that could predict the date of break even? Regards

<tbody> Day Price 1 1.0 2 3 5.0 4 5 10.0 </tbody> Hi I'm trying to calculate a future value based on a trend line calculated off two values. I've tried searching example/tutorials and can only find where the data is fully populated. I'd like to use something like the...

<colgroup><col><col><col></colgroup><tbody> A 1 5 B 0 C 6 2 5 1 4 3 0 3 3 4 2 2 3 5 7 6 9 6 4 2 9 7 9 8 1 8 5 2 3 9 5 7 7 </tbody> 10

hello all if i want to predict the next number which between 1 and 2000 and i already have set of 3 numbers 500 1750 320 ??? is there any way to predict the 4th number ??? thanks in advance

Hi, looking for some assistance here for a systematic way to help predict the next time series number after adding new numbers each day. I have 1,595 lines data that consists of the follow values from 0 to 4; - 0 (694 times - 42.9%) - 1 (649 times - 40.7%) - 2 (226 times - 14.2%) - 3 (31...

Hi There, I am trying to create a dropdown list (data>data validation>Allow List) that auto-predicts the full word I am going to write. For example, if my list consists of Germany Belgium Azores Portugal I would like to be able to write Az and have the rest of the text identified. Can you...

I have a series of numbers that I know the long-term probability for and I would like to predict the next number(s). There are 1320 possible outcomes listed in sheet 2 column e2 to e1321. I have 18370 trials in sheet1 column g2 to g18371, and I would like to predict (or find the most likely)...

Hi, I am having a few issues with the excel autofill function. Here is what I want it to look like: <tbody> A A1 =IF(Sheet2!A1>=4,100,IF(Sheet2!A1=3,75,IF(Sheet2!A1=2, 50, IF(Sheet2!A1=1,25)))) A2 =-A1 A3 =IF(Sheet2!A2>=4,100,IF(Sheet2!A2=3,75,IF(Sheet2!A2=2, 50, IF(Sheet2!A2=1,25))))...

I want to develop a formula that will either predict, forecast, trend, etc. that will provide me with the mostly likely number that will be next in the sequence below (from bottom up) and will display in A1. For example, <tbody> A B 1 2 6 3 3 4 14 5 15 6 1 7 2 8 5...

I have some historical data from year 2009 till now, for each month of the year and for 7 items. What I want is to make a report table (same or different Sheet) to automatically show a simple estimate of data for the future months (based on actual ones), every time I enter data for a month. I'm...

Hello All, I have started trying to do 10 -12 year forecasting model for my business. I tried using some various equations but none of them have given me what I am looking for. Starting in 2013 through 2018 I will be opening 30 new stores. 5 one year and six the next. so 2013 - 5, 2014 -6...

Hello, I'm trying to predict the dollar amount of new loans that my office will book over the next year. I have 10 years of historical data to build from. I started with a trendline forecast which shows what I already know, we're growing positively. Unfortunately, it doesn't accurately...