完了

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.

Example1:

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

スキル: 数学, MySQL, PHP, 統計分析, 統計

さらに表示: 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, hide different excel rows based different values, predict software numbers, predict lottery numbers, excel predict random numbers, predict next numbers series, predict series numbers, can predict random numbers

採用者について:
( 24件のレビュー ) Bischofsheim, Germany

プロジェクトID: #15677312

アワード:

player4zone

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 0日以内
(15レビュー)
3.5

4人のフリーランサーが、このジョブに平均$21で入札しています

$25 USD 1日以内
(9件のレビュー)
3.4
$25 USD 1日以内
(4件のレビュー)
1.8
$25 USD 1日以内
(0件のレビュー)
0.0