Basic Data Analysis – Operations
Budget: $10 – $30 USD
Instructions
Make a copy of this speadsheet and fill in all the necesary information so we can see the comments & formulas.
Needed output:
1) Ride Concentration: Build a Pivot Table using the given week's data and highlight the hour with lowest concentration of Finished Rides. Please keep Pivot Table details in a separate sheet.
2) Supply Hours: Your task is to find a quick way and fill in the highlighted cells by using Excel formulas.
3) Driver Lead Value and Lifetime Value: Calculate in the highlighted cells by using Excel formulas how much can we invest per driver applicant to be profitable in 12 months.
4) Problematic Drivers: Which 10 drivers have the worst usage of Bolt? Why are they outliers? Highlight them and explain why.
5) Campaign Results: We offered 50% of our drivers monetary bonuses to increase their activity. Compare the results with the control group and explain if the campaign was successful and whether we should do it again or not.
Make a copy of this speadsheet and fill in all the necesary information so we can see the comments & formulas.
Needed output:
1) Ride Concentration: Build a Pivot Table using the given week's data and highlight the hour with lowest concentration of Finished Rides. Please keep Pivot Table details in a separate sheet.
2) Supply Hours: Your task is to find a quick way and fill in the highlighted cells by using Excel formulas.
3) Driver Lead Value and Lifetime Value: Calculate in the highlighted cells by using Excel formulas how much can we invest per driver applicant to be profitable in 12 months.
4) Problematic Drivers: Which 10 drivers have the worst usage of Bolt? Why are they outliers? Highlight them and explain why.
5) Campaign Results: We offered 50% of our drivers monetary bonuses to increase their activity. Compare the results with the control group and explain if the campaign was successful and whether we should do it again or not.