Analyzing for trend, forecasting and conducting sensitivity analysis

dozic

New Member
Joined
Mar 19, 2018
Messages
3
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.

SEGMENTSMONTH AND YEARAMOUNT
TRANSPORTATIONSep-20172100MISSIONSNov-201711000TRANSPORTATIONJan-20182900
TRANSPORTATIONSep-20171200VEHICLE SPARE PARTNov-20175000TRANSPORTATIONJan-20182500
TRANSPORTATIONSep-20171000VEHICLE SPARE PARTNov-20176000TRANSPORTATIONJan-2018300
TRANSPORTATIONSep-20171000OTHER EXPENSESNov-201710000TRANSPORTATIONJan-20181200
TRANSPORTATIONSep-20172000INFLOWNov-20171031900TRANSPORTATIONJan-2018900
TRANSPORTATIONSep-2017400TRANSPORTATIONNov-20171900TRANSPORTATIONJan-20181000
TRANSPORTATIONSep-20171000TRANSPORTATIONNov-20171800TRANSPORTATIONJan-2018200
TRANSPORTATIONSep-2017500TRANSPORTATIONNov-20171350TRANSPORTATIONJan-20184000
ADMINISTRATIVE EXPENSESSep-20178500TRANSPORTATIONNov-20171300TRANSPORTATIONJan-20183000
VEHICLE SPARE PARTSep-20176000TRANSPORTATIONNov-2017750TRANSPORTATIONJan-20183000
ELECTRICITYSep-201720000TRANSPORTATIONNov-2017750TRANSPORTATIONJan-20183000
TRANSPORTATIONSep-20172000TRANSPORTATIONNov-20171450TRANSPORTATIONJan-20183000
TRANSPORTATIONSep-20171150TRANSPORTATIONNov-20171000ELECTRICITYJan-201810000
TRANSPORTATIONSep-2017300TRANSPORTATIONNov-2017500ADMINISTRATIVE EXPENSESJan-2018100000
TRANSPORTATIONSep-20174500TRANSPORTATIONNov-20171000MISSIONSJan-2018900
TRANSPORTATIONSep-20174500VEHICLE SPARE PARTNov-201722000ADMINISTRATIVE EXPENSESJan-2018258000
TRANSPORTATIONSep-20174500ESCORTSNov-20172600FUELJan-201850000
TRANSPORTATIONSep-20174500MISSIONSNov-2017150MISSIONSJan-201815000
TRANSPORTATIONSep-20174500LISENCE/REGISTRATION FEENov-201748600ADMINISTRATIVE EXPENSESJan-20184500
TRANSPORTATIONSep-20176000TRANSPORTATIONNov-20171000TRANSPORTATIONJan-20182700
TRANSPORTATIONSep-2017400SALARYNov-201718900TRANSPORTATIONJan-20181800
TRANSPORTATIONSep-2017900ADMINISTRATIVE EXPENSESNov-2017100000TRANSPORTATIONJan-2018500
VEHICLE SPARE PARTSep-201710000MISSIONSNov-2017150TRANSPORTATIONJan-20181200
VEHICLE SPARE PARTSep-20173600VEHICLE SPARE PARTNov-20174000TRANSPORTATIONJan-20181000
WORKSHOPSep-201760000TRANSPORTATIONNov-2017300TRANSPORTATIONJan-20181200
VEHICLE SPARE PARTSep-201724000TRANSPORTATIONNov-20171300TRANSPORTATIONJan-20182000
OTHER EXPENSESSep-20175000TRANSPORTATIONNov-20171700VEHICLE SPARE PARTJan-20182000

<colgroup><col><col><col span="2"><col><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,176,502
Messages
5,903,425
Members
435,029
Latest member
excelvbanoob420

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top