DAT 565 Using Data to Analyze Performance C3

Scenario:A city’s administration isn’t driven by the goal of maximizingrevenues or profits but instead looks at improving the quality of life of itsresidents. Many American cities are confronted with high traffic andcongestion. Finding parking spaces, whether in the street or a parking lot, canbe time consuming and contribute to congestion. Some cities have rolled outdata-driven parking space management to reduce congestion and make traffic morefluid.You’re a data analyst working for a mid-size city that hasanticipated significant increments in population and car traffic. The city is evaluatingwhether it makes sense to invest in infrastructure to count and report thenumber of parking spaces available at the different parking lots downtown. Thisdata would be collected and processed in real-time, feeding an app thatmotorists can access to find parking space availability in different parkinglots throughout the city.LotCode: a unique code that identifies the parking lotLotCapacity: a number with the respective parking lot capacityLotOccupancy: a number with the current number of cars in theparking lotTimeStamp: a day/time combination indicating the moment whenoccupancy was measuredDay: the day of the week corresponding to the TimeStampInsert a new column, OccupancyRate,recording occupancy rate as a percentage with 1 decimal. For instance, if thecurrent LotOccupancy is 61 and LotCapacity is577, then the OccupancyRate would be reported as 10.6 (or10.6%).Using theOccupancyRate and Day columns, construct box plots for eachday of the week. You can use Insert > Insert Statistic Chart >Box andWhisker for this purpose. Is the median occupancy rate approximately the samethroughout the week? If not, which days have lower median occupancy rates?Which days have higher median occupancy rates? Is this what you expected?Using the OccupancyRateand LotCode columns, construct box plots for each parking lot.You can use Insert > Insert Statistic Chart >Box and Whisker for thispurpose. Do all parking lots experience approximately equal occupancy rates?Are some parking lots more frequented than others? Is this what you expected?Select any 2 parking lots. For each ofthem, prepare a scatter plot showing occupancy rateagainst TimeStamp for the week 11/20/2016 – 11/26/2016. Areoccupancy rates time dependent? If so, which times seem to experience thehighest occupancy rates? Is this what you expected?Prepare a 12- to 16-slide presentation withdetailed speaker notes and audio, graphs, and tables.Your audience is thecity council, which is responsible for deciding whether the city investsresources to set in motion the smart parking space app.Complete the following in your presentation:Outline the rationale and goalsof the projectUtilize box plots showing theoccupancy rates for each day of the week. Include your interpretation ofresults.Utilize box plots showing theoccupancy rates for each parking lot. Include your interpretation ofresultsProvide scatter plots showingoccupancy rate against the time of day of your selected 2 parking lots.Include your interpretation of resultsMake a recommendation aboutcontinuing with the implementation of this project.Include speakernotes that convey the details you would give if you were presenting. You willrecord your speaker notes.Ensure that theslides contain only essential information and as little text as possible.