Fibonacci numbers refer to such a sequence of 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233,377,610,987,1597,2584,4181,6765,10946,17711,28657,46368
The inventor of the Fibonacci sequence, the Italian mathematician Leonardo's Fibonacci (Leonardo Fibonacci), was born in 1170 and died in 1250, the birthplace of Pisa. He was called "the Leonardo's of Pisa". In 1202, he wrote the Book of Abacus (Liber Abacci). He was the first European to study the theory of Indian and Arab mathematics. His father, who was recruited as a diplomatic consul by a business group in Pisa, was stationed in the Algerian region today, where Leonardo's was able to study mathematics under the guidance of an Arab teacher. He has also studied mathematics in Egypt, Syria, Greece, Sicily and Provence.
Establish a test environment:
CREATE TABLE [dbo].[MATHRESULT1] ( [DateKey] INT NULL , [ Number] INT NULL ) INSERT into [MATHRESULT1] ( [DateKey] , [ Number] ) SELECT 1 , 1 UNION All SELECT 2 , 1 UNION All SELECT 3 , 2 UNION All SELECT 4 , 3 UNION All SELECT 5 , 5 UNION All SELECT 6 , 8 UNION All SELECT 7 , - UNION All SELECT 8 , + UNION All SELECT 9 , the UNION All SELECT Ten , - UNION All SELECT One , the UNION All SELECT A , 144 UNION All SELECT - , 233 UNION All SELECT - , 377 UNION All SELECT the , 610 UNION All SELECT - , 987 UNION All SELECT - , 1597 UNION All SELECT - , 2584 UNION All SELECT + , 4181 UNION All SELECT - , 6765 UNION All SELECT + , 10946 UNION All SELECT A , 17711 UNION All SELECT at , 28657SELECT * from [MATHRESULT1]
Predict future result values based on existing Microsoft time series algorithms
The Fibonacci sequence should be: 46368, but the actual predicted result is: 43517, validation failed.
"Bi Thing" Microsoft time Series algorithm--Verifying the magical Fibonacci sequence