Predict future values based on past values.

I am having a big database with entries of a player count and a datetime (see [url removed, login to view]) - based on these values, I am drawing a chart ([url removed, login to view]).

I now need a "future drawing" for the chart, which is predicting the potential player count based on the next hours.

The prediction should be made by considering the values of the same time frame of the last 7 days.

As per hour I have more values, example:

7:03pm = 100 players

7:07pm = 89 players

7:19pm = 99 players

7:47pm = 105 players

you should find a proper way to give them a weighed average for the time between 7pm and 8pm and then use these values of each hour of the last 7 days, to give an estimation of the future timeperiod.


Day 1 - 7:00pm = 100 players

Day 2 - 7:00pm = 80 players

Day 3 - 7:00pm = 95 players

Day 4 - 7:00pm = 85 players

Day 5 - 7:00pm = 72 players

Day 6 - 7:00pm = 90 players

Day 7 - 7:00pm = 80 players

Prediction of Day 8 - 7:00 pm should be something like 86, as it would be the average value of the last days at the same time.

The prediction should be made always for the next 6 hours. You dont need to export a chart, just the values and time is fine - Example:

Prediction 8:00pm = 30

Prediction 9:00pm = 28

Prediction 10:00pm = 23

Prediction 11:00pm = 20

Prediction 12:00pm = 15

Prediction 1:00am = 9

If you have any questions, please let me know. I can provide the database entries for you to test.

Screen 2 attached

Kemahiran: Matematik, MySQL, PHP, Analisis Statistik, Statistik

Lihat lagi: hide different excel rows based different values, predict software numbers, predict lottery numbers, extrapolation excel formula, fill the selected range of cells based on a growth trend, how to use forecast function in excel, growth trend extrapolation excel 2013, linear extrapolation excel, how to extrapolate data in excel, growth trend interpolation excel, how to extrapolate in excel 2016, excel predict random numbers, predict next numbers series, predict series numbers, can predict random numbers, predict random numbers excel, model predict number goals scored based past data, excel assign rank value based column values, java redirect based form values, software predict magnum4d numbers

Tentang Majikan:
( 24 ulasan ) Bischofsheim, Germany

ID Projek: #15677312

Dianugerahkan kepada:


I understand that you need predictions in terms of average for each time point. Stay tuned, I'm still working on this proposal.

$10 USD dalam 0 hari
(15 Ulasan)

4 pekerja bebas membida secara purata $21 untuk pekerjaan ini

$25 USD dalam sehari
(9 Ulasan)
$25 USD dalam sehari
(4 Ulasan)
$25 USD dalam sehari
(0 Ulasan)