Forcast ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1551961%22%20slang%3D%22en-US%22%3EForcast%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551961%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20a%20complete%20beginner%20with%20Excel.%20Can%20someone%20tell%20me%20if%20I%20can%20do%20this%20%3A%26nbsp%3B%26nbsp%3B%20I%20want%20to%20insert%20a%20sequence%20of%20single%20digit%20numbers%20ranging%20from%200-9%20into%20cells%20and%20one%20for%20each%20cell%20and%20they%20are%20selected%20randomly%20from%20a%20number%20generator%2C%20let's%20say%20about%20a%20hundred%20and%20thirty%20numbers.%20Can%20I%20have%20Excel%20%22forcast%22%20or%20guess%20the%20next%20number%20in%20the%20sequence%20based%20on%20the%20previous%20history%20of%20the%20digits%20pattern%3F%20Or%20would%20I%20have%20to%20have%20someone%20write%20a%20formula%20for%20me%20to%20do%20this%3F%26nbsp%3B%20Thanks%20for%20any%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1551961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552031%22%20slang%3D%22en-US%22%3ERe%3A%20Forcast%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552031%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742985%22%20target%3D%22_blank%22%3E%40beb1959%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eby%20definition%2C%20random%20numbers%20are%20random.%20If%20you%20fill%20130%20cells%20with%20random%20numbers%20between%201%20and%209%2C%20there%20will%20be%20no%20pattern%20to%20establish%20which%20number%20comes%20next.%20The%20odds%20for%20each%20of%20the%209%20digits%20are%20exactly%20equal.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20does%20have%20a%20forecasting%20functionality%20on%20the%20Data%20ribbon%2C%20but%20if%20the%20data%20source%20is%20random%20numbers%2C%20that%20will%20not%20be%20able%20to%20provide%20much%20insight.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm a complete beginner with Excel. Can someone tell me if I can do this :   I want to insert a sequence of single digit numbers ranging from 0-9 into cells and one for each cell and they are selected randomly from a number generator, let's say about a hundred and thirty numbers. Can I have Excel "forcast" or guess the next number in the sequence based on the previous history of the digits pattern? Or would I have to have someone write a formula for me to do this?  Thanks for any help. 

1 Reply

Hello @beb1959 ,

 

by definition, random numbers are random. If you fill 130 cells with random numbers between 1 and 9, there will be no pattern to establish which number comes next. The odds for each of the 9 digits are exactly equal. 

 

Excel does have a forecasting functionality on the Data ribbon, but if the data source is random numbers, that will not be able to provide much insight.