I created the box plots for occupancyrate and lotcod, 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 LotCode columns, construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose.

Are all parking lots experience approximately equal occupancy rates? Are some parking lots more frequented than others? Is this what you expected?