Question
I created the box plots for occupancyrate/day of the week, which i posted below. I need help answering the questions below, Please!! Thank you for
I created the box plots for occupancyrate/day of the week, which i posted below. I need help answering the questions below, Please!! Thank you for your help. The questions are in bold below.
Scenario A city's administration isn't driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time-consuming and contribute to congestion. Some cities have rolled out data-driven parking space management in an effort to reduce congestion and make traffic more fluid. You're a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether or not it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app motorists can access to find parking space availability in different parking lots throughout the city.
Part 1: Data Manipulation Download the Parking Lot Use data set. The data set has the following columns: LotCode: a unique code that identifies the parking lot LotCapacity: a number with the respective parking lot capacity LotOccupancy: a number with the current number of cars in the parking lot TimeStamp: a day/time combination indicating the moment when occupancy was measured Day: the day of the week corresponding to the TimeStamp Insert a new column, OccupancyRate, recording occupancy rate as a percentage with 1 decimal.
Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose.
Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?V