Use the dataset represented below in csv format containing vehicle traffic information at a manual toll plaza. Since it is a time series, we only have the dependent variable which is the monthly traffic, and the independent variable is time. A prediction model must be developed based on artificial neural networks using Knime, which allows predicting the vehicle traffic through the toll plaza. The seed to be used is 12345616 and the csv is as follows   "Id","Agno","Mes","Mes_Agno","Tráfico"1,"03","ene","ene-03",5821322,"03","feb","feb-03",5504013,"03","mar","mar-03",4024454,"03","abr","abr-03",3885135,"03","may","may-03",3723126,"03","jun","jun-03",3473017,"03","jul","jul-03",3935818,"03","ago","ago-03",4049039,"03","sep","sep-03",39199710,"03","oct","oct-03",39567111,"03","nov","nov-03",41857112,"03","dic","dic-03",47741713,"04","ene","ene-04",59000414,"04","feb","feb-04",54346515,"04","mar","mar-04",40182716,"04","abr","abr-04",39210117,"04","may","may-04",37203518,"04","jun","jun-04",37861719,"04","jul","jul-04",39172420,"04","ago","ago-04",36386021,"04","sep","sep-04",40281722,"04","oct","oct-04",41640323,"04","nov","nov-04",40314224,"04","dic","dic-04",46610425,"05","ene","ene-05",57750026,"05","feb","feb-05",51630127,"05","mar","mar-05",42624928,"05","abr","abr-05",36559429,"05","may","may-05",39690330,"05","jun","jun-05",36309531,"05","jul","jul-05",43038432,"05","ago","ago-05",39062233,"05","sep","sep-05",41523834,"05","oct","oct-05",45858435,"05","nov","nov-05",43099236,"05","dic","dic-05",51067037,"06","ene","ene-06",65338338,"06","feb","feb-06",61212139,"06","mar","mar-06",46619940,"06","abr","abr-06",462547 41,"06","may","may-06",41024642,"06","jun","jun-06",41080343,"06","jul","jul-06",44109044,"06","ago","ago-06",42678645,"06","sep","sep-06",48775746,"06","oct","oct-06",48698747,"06","nov","nov-06",47555748,"06","dic","dic-06",56557349,"07","ene","ene-07",70317750,"07","feb","feb-07",65454651,"07","mar","mar-07",51644652,"07","abr","abr-07",50970853,"07","may","may-07",47736154,"07","jun","jun-07",43271355,"07","jul","jul-07",51925656,"07","ago","ago-07",45635257,"07","sep","sep-07",53444958,"07","oct","oct-07",52237859,"07","nov","nov-07",53679560,"07","dic","dic-07",607391

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter24: Forecasting Models
Section24.8: Multiple Regression
Problem 9P
icon
Related questions
Question

Use the dataset represented below in csv format containing vehicle traffic information at a manual toll plaza. Since it is a time series, we only have the dependent variable which is the monthly traffic, and the independent variable is time.

A prediction model must be developed based on artificial neural networks using Knime, which allows predicting the vehicle traffic through the toll plaza. The seed to be used is 12345616 and the csv is as follows

 

"Id","Agno","Mes","Mes_Agno","Tráfico"
1,"03","ene","ene-03",582132
2,"03","feb","feb-03",550401
3,"03","mar","mar-03",402445
4,"03","abr","abr-03",388513
5,"03","may","may-03",372312
6,"03","jun","jun-03",347301
7,"03","jul","jul-03",393581
8,"03","ago","ago-03",404903
9,"03","sep","sep-03",391997
10,"03","oct","oct-03",395671
11,"03","nov","nov-03",418571
12,"03","dic","dic-03",477417
13,"04","ene","ene-04",590004
14,"04","feb","feb-04",543465
15,"04","mar","mar-04",401827
16,"04","abr","abr-04",392101
17,"04","may","may-04",372035
18,"04","jun","jun-04",378617
19,"04","jul","jul-04",391724
20,"04","ago","ago-04",363860
21,"04","sep","sep-04",402817
22,"04","oct","oct-04",416403
23,"04","nov","nov-04",403142
24,"04","dic","dic-04",466104
25,"05","ene","ene-05",577500
26,"05","feb","feb-05",516301
27,"05","mar","mar-05",426249
28,"05","abr","abr-05",365594
29,"05","may","may-05",396903
30,"05","jun","jun-05",363095
31,"05","jul","jul-05",430384
32,"05","ago","ago-05",390622
33,"05","sep","sep-05",415238
34,"05","oct","oct-05",458584
35,"05","nov","nov-05",430992
36,"05","dic","dic-05",510670
37,"06","ene","ene-06",653383
38,"06","feb","feb-06",612121
39,"06","mar","mar-06",466199
40,"06","abr","abr-06",462547

41,"06","may","may-06",410246
42,"06","jun","jun-06",410803
43,"06","jul","jul-06",441090
44,"06","ago","ago-06",426786
45,"06","sep","sep-06",487757
46,"06","oct","oct-06",486987
47,"06","nov","nov-06",475557
48,"06","dic","dic-06",565573
49,"07","ene","ene-07",703177
50,"07","feb","feb-07",654546
51,"07","mar","mar-07",516446
52,"07","abr","abr-07",509708
53,"07","may","may-07",477361
54,"07","jun","jun-07",432713
55,"07","jul","jul-07",519256
56,"07","ago","ago-07",456352
57,"07","sep","sep-07",534449
58,"07","oct","oct-07",522378
59,"07","nov","nov-07",536795
60,"07","dic","dic-07",607391

 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Uncertainty Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole