Hello people,
i need help in figuring a way to analyze this excel data, my goal is to get a trend,forecast for different segments and conduct a sensitivity analysis on the inflow/income.*the data has three columns,i just copied the some of them to the side for better viewing. i will appreciate any assistance.
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>
i need help in figuring a way to analyze this excel data, my goal is to get a trend,forecast for different segments and conduct a sensitivity analysis on the inflow/income.*the data has three columns,i just copied the some of them to the side for better viewing. i will appreciate any assistance.
| SEGMENTS | MONTH AND YEAR | AMOUNT | |||||||||
| TRANSPORTATION | Sep-2017 | 2100 | MISSIONS | Nov-2017 | 11000 | TRANSPORTATION | Jan-2018 | 2900 | |||
| TRANSPORTATION | Sep-2017 | 1200 | VEHICLE SPARE PART | Nov-2017 | 5000 | TRANSPORTATION | Jan-2018 | 2500 | |||
| TRANSPORTATION | Sep-2017 | 1000 | VEHICLE SPARE PART | Nov-2017 | 6000 | TRANSPORTATION | Jan-2018 | 300 | |||
| TRANSPORTATION | Sep-2017 | 1000 | OTHER EXPENSES | Nov-2017 | 10000 | TRANSPORTATION | Jan-2018 | 1200 | |||
| TRANSPORTATION | Sep-2017 | 2000 | INFLOW | Nov-2017 | 1031900 | TRANSPORTATION | Jan-2018 | 900 | |||
| TRANSPORTATION | Sep-2017 | 400 | TRANSPORTATION | Nov-2017 | 1900 | TRANSPORTATION | Jan-2018 | 1000 | |||
| TRANSPORTATION | Sep-2017 | 1000 | TRANSPORTATION | Nov-2017 | 1800 | TRANSPORTATION | Jan-2018 | 200 | |||
| TRANSPORTATION | Sep-2017 | 500 | TRANSPORTATION | Nov-2017 | 1350 | TRANSPORTATION | Jan-2018 | 4000 | |||
| ADMINISTRATIVE EXPENSES | Sep-2017 | 8500 | TRANSPORTATION | Nov-2017 | 1300 | TRANSPORTATION | Jan-2018 | 3000 | |||
| VEHICLE SPARE PART | Sep-2017 | 6000 | TRANSPORTATION | Nov-2017 | 750 | TRANSPORTATION | Jan-2018 | 3000 | |||
| ELECTRICITY | Sep-2017 | 20000 | TRANSPORTATION | Nov-2017 | 750 | TRANSPORTATION | Jan-2018 | 3000 | |||
| TRANSPORTATION | Sep-2017 | 2000 | TRANSPORTATION | Nov-2017 | 1450 | TRANSPORTATION | Jan-2018 | 3000 | |||
| TRANSPORTATION | Sep-2017 | 1150 | TRANSPORTATION | Nov-2017 | 1000 | ELECTRICITY | Jan-2018 | 10000 | |||
| TRANSPORTATION | Sep-2017 | 300 | TRANSPORTATION | Nov-2017 | 500 | ADMINISTRATIVE EXPENSES | Jan-2018 | 100000 | |||
| TRANSPORTATION | Sep-2017 | 4500 | TRANSPORTATION | Nov-2017 | 1000 | MISSIONS | Jan-2018 | 900 | |||
| TRANSPORTATION | Sep-2017 | 4500 | VEHICLE SPARE PART | Nov-2017 | 22000 | ADMINISTRATIVE EXPENSES | Jan-2018 | 258000 | |||
| TRANSPORTATION | Sep-2017 | 4500 | ESCORTS | Nov-2017 | 2600 | FUEL | Jan-2018 | 50000 | |||
| TRANSPORTATION | Sep-2017 | 4500 | MISSIONS | Nov-2017 | 150 | MISSIONS | Jan-2018 | 15000 | |||
| TRANSPORTATION | Sep-2017 | 4500 | LISENCE/REGISTRATION FEE | Nov-2017 | 48600 | ADMINISTRATIVE EXPENSES | Jan-2018 | 4500 | |||
| TRANSPORTATION | Sep-2017 | 6000 | TRANSPORTATION | Nov-2017 | 1000 | TRANSPORTATION | Jan-2018 | 2700 | |||
| TRANSPORTATION | Sep-2017 | 400 | SALARY | Nov-2017 | 18900 | TRANSPORTATION | Jan-2018 | 1800 | |||
| TRANSPORTATION | Sep-2017 | 900 | ADMINISTRATIVE EXPENSES | Nov-2017 | 100000 | TRANSPORTATION | Jan-2018 | 500 | |||
| VEHICLE SPARE PART | Sep-2017 | 10000 | MISSIONS | Nov-2017 | 150 | TRANSPORTATION | Jan-2018 | 1200 | |||
| VEHICLE SPARE PART | Sep-2017 | 3600 | VEHICLE SPARE PART | Nov-2017 | 4000 | TRANSPORTATION | Jan-2018 | 1000 | |||
| WORKSHOP | Sep-2017 | 60000 | TRANSPORTATION | Nov-2017 | 300 | TRANSPORTATION | Jan-2018 | 1200 | |||
| VEHICLE SPARE PART | Sep-2017 | 24000 | TRANSPORTATION | Nov-2017 | 1300 | TRANSPORTATION | Jan-2018 | 2000 | |||
| OTHER EXPENSES | Sep-2017 | 5000 | TRANSPORTATION | Nov-2017 | 1700 | VEHICLE SPARE PART | Jan-2018 | 2000 |
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>
