NYSC Member Transportation Cost analysis
Published: 2022-07-27 16:51:50



There are no free means of transportation for Nigerian serving corps members and some have complained that the daily cost of transportation greatly affects the Monthly paid allowance of ₦33,000.00 from the federal government.
 
This Data Analysis is was carried out in Nigerians' two largest cities , namely Abuja and Lagos and will answer some of the following question. 

### ASKED QUESTIONS

- What is the highest means of transportation in both states?
- What means of Transportation cost more?
- Is the Monthly paid allowance enough for corps members? 
- Do corps members who work more days get paid more?
- Between both cities which has the highest cost of transportation

### TOOLS AND DATASETS
You can download  The [Dataset Gathered](https://github.com/FunnyDigital/NYSC-PROJECT/tree/main/Nysc%20project) Here
1. SQL- MySQL(DBeaverIDE)
2. MS-Excel
3. Vitalizations-Tableau 

## What is the highest means of transportation in both states?



![Lagos Highest means of Transportation](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/884wzzprxmofi9xqiqxz.png)



![abuja](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3liw5slm9qv346v3f6y3.png)



Lagos and Abuja Both have Buses as the Highest means of transport
While Uber/Bolt services are the least means of transport for Lagos and Motorcycle is the least means of transport for Abuja.


##What means of Transportation cost more?



![both](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5dxefdqzg3xj4zs0k6o7.png)

From the analyses; Buses are Expensive for daily travel because corps members tend to use 2 to 4 different buses to get to their place of primary assignment (PPA). From the table, we see that the highest amount spent on transport in a day is ₦2000 and the lowest of ₦500 

 
##Is the Monthly paid allowance enough for corps members?


![pie chart](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ehj678pspygecyhwg8h7.png)

4.27% are satisfied with the Monthly Paid allowance, although it is relatively smaller than the number of people who are not comfortable with the amount, which is 27.35% the larger percentage(60.68%) of corps members say it is not enough.


## Do corps member's who work more days get paid more?


![bar](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/en0rizxvqppgdut4ig8j.png)

Some corps members are required to work more days which in turn involves more money for transportation. from the bar chart, we see that corps members get paid less than ₦30000 to work extra days including on the weekends.

## Between both cities which has the highest cost of transportation?

![MAP](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9dbkojpo1wroq9i0ccz8.png) 

From the demography, we see that the Cost of transportation in Lagos is greater than in Abuja

## CONCLUSIONS

1. The cost of transportation does affect the Corp member's salary/allowance Mildly  
2. Corp members  Who work extra days should be paid more to cover the cost of transportation.
3. Corp members who don't get paid at all could work remotely or work fewer days to save cost.

`THIS PROJECT WAS CARRIED OUT BY Isolokwu Patrick .C & Chinemerem . K Vincent 2022`