Forecast

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numbers in A1:A40 (single digit),B1:B40 (between 10-35),C1:C40 (between 20-45),D1:D40 (between 30-50), E1:E40 (between 1-50

I'm looking for 5 different number. 1 for A another for B another for C, etc. in chronological order. But these numbers that are generated need to be based on its associated column.1st number from A column, 2nd number from B column, etc. for a marketing sheet.
 
What is the criteria for selecting each number?...........You might consider
the RANDBETWEEN worksheet function, maybe using it five times and then
Concatenating them?

hth
Vaya con Dios,
Chuck, CABGx3


Troy said:
I have numbers in A1:A40 (single digit),B1:B40 (between 10-35),C1:C40
Click to expand...
(between 20-45),D1:D40 (between 30-50), E1:E40 (between 1-50)
I'm looking for 5 different number. 1 for A another for B another for C,
Click to expand...
etc. in chronological order. But these numbers that are generated need to be
based on its associated column.1st number from A column, 2nd number from B
column, etc. for a marketing sheet.
 
I don't want a Random number between 2 numbers, I need a number based upon the range of numbers entered. (The next number forecasted based upon given data)
 
Hi
not sure how you want to create your next numbers (what's the
algoritzhmn).
Best would be to give an example and describe the desired values based
on this example
 
A B C D
1 8 16 23 47 2
2 3 24 36 40 4
3 6 19 29 37 1


Here is an example of my actual values.
 
I would like a forecast (prediction) based on its associated column
In column A I have 40 different values and I would like excel to forecast the next expected value based on the values in column A. Not just any random number.
 
Hi
sorry but without more information from your side it is impossible to
provide a solution for you. e.g. tell us the following:
- what is the meaning of the columns
- HOW do you want to predict the next numbers (That is what kind of
algorithmn do you want to use: e.g. running average, etc.)
- how do the other column values determine the forecast value (and what
do they represent)

In addition: you gave us an example. Based on this example HOW would
you manually calculate the forecast value
 
I would like a forecast (prediction) based on its associated column.
In column A I have 40 different values and I would like excel to forecast
the next expected value based on the values in column A. Not just any
random number.
Click to expand...

Your sample information from an earlier posting,

____A____B____C____D____E
1___8___16___23___47___29
2___3___24___36___40___49
3___6___19___29___37___17

And from your original posting,

"I have numbers in A1:A40 (single digit),B1:B40 (between 10-35),C1:C40
(between 20-45),D1:D40 (between 30-50), E1:E40 (between 1-50)

I'm looking for 5 different number. 1 for A another for B another for C,
etc. in chronological order. But these numbers that are generated need
to be based on its associated column.1st number from A column, 2nd
number from B column, etc. for a marketing sheet."


There's no obvious relation or sequence between the numbers in your sample data.
If your next row of numbers should be a function of the values from all columns
in the preceding columns, you should have some notion of how they'd be related.
If the next row of numbers would have values in each column independent of all
the other columns but possessing some form of serial correlation within their
own column, then again you should have some notion of how each column on its own
in the next row would be correlated with the preceding row. If you don't, then
you're asking us to guess what your next row should be based on an inadequate
preceding sample of only 3 rows. Can't be done (even if marketing people believe
it should be able to do so).

Please don't live down to a Dilbert-level stereotype of a marketing person. If
you have more information on what you want, provide it. If you don't, say so
(and the rest of us will give up trying to solve a problem that can't be
solved).
 
Back
Top