CAN PLEASE DO THIS WORK IN A EXCEL SPREADSHEET

Instructions: Work with the provided Excel database. This database 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 one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).
• 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?
• 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. 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 one, prepare a scatter plot showing the occupancy rate against TimeStamp for the week 11/20/2016 11/26/2016. Are occupancy rates time-dependent? If so, which times seem to experience the highest occupancy rates? Is this what you expected?

AutoSave CH H2 DAT565 v3 Wk6 Data File (2) - Excel O Scarch bailciscollections@gmail.com File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 200 Calibri AutoSum - ~AA w 11 == == PM 29 Wrap Text General 27 o Fah) X Out [Copy Paste Format Painter Clipboard Insert Delete Forma A. BIU-- Merge & Center $ -% -% Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Analyze Data Font Alignmen Number Colls Analysis 14127 F H J K L M N o P O R S B 720 720 720 720 720 720 720 720 C 451 394 201 209 232 258 272 308 0 325 358 379 720 720 720 720 720 720 A 4120 Lot09 4121 Loto 4122 LOLDE 4123 Lot09 4124 Lot09 4125 Lot09 4126 Lot09 4127 | LOLD 4128 Lot09 4129 Lot09 4130 Lot09 4131 Lot09 4132 Lot09 4133 Lot09 4134 Lot09 4135 1t09 4136 Loto 4137 Lot09 4138 Loto9 4139 Lot09 4140 4141 4112 4143 4144 4145 4146 4147 4148 D 12/16/2016 16:03 12/16/2016 16:30 12/17/2016 7:59 12/17/2016 8:19 12/17/2016 9:00 12/17/2016 9:26 12/17/2016 9:59 12/17/2016 10:33 12/17/2016 11:00 12/17/2016 11:33 12/17/2016 12:00 12/17/2016 12:26 12/17/2016 13:00 12/17/2016 13:27 12/17/2016 14:00 12/17/2016 14:30 12/17/2016 15:03 12/17/2016 15:30 12/17/2016 15:57 12/17/2016 16:30 E Friday Friday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday 409 453 465 471 479 474 720 720 720 720 720 720 166 444 399 Parking LotUtilization Reacy 1009 AutoSave CH H2 DAT565 v3 Wk6 Data File (2) - Excel O Scarch bailciscollections@gmail.com File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 200 Calibri AutoSum - ~AA w 11 == == PM 29 Wrap Text General 27 o Fah) X Out [Copy Paste Format Painter Clipboard Insert Delete Forma A. BIU-- Merge & Center $ -% -% Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Analyze Data Font Alignmen Number Colls Analysis 14127 F H J K L M N o P O R S B 720 720 720 720 720 720 720 720 C 451 394 201 209 232 258 272 308 0 325 358 379 720 720 720 720 720 720 A 4120 Lot09 4121 Loto 4122 LOLDE 4123 Lot09 4124 Lot09 4125 Lot09 4126 Lot09 4127 | LOLD 4128 Lot09 4129 Lot09 4130 Lot09 4131 Lot09 4132 Lot09 4133 Lot09 4134 Lot09 4135 1t09 4136 Loto 4137 Lot09 4138 Loto9 4139 Lot09 4140 4141 4112 4143 4144 4145 4146 4147 4148 D 12/16/2016 16:03 12/16/2016 16:30 12/17/2016 7:59 12/17/2016 8:19 12/17/2016 9:00 12/17/2016 9:26 12/17/2016 9:59 12/17/2016 10:33 12/17/2016 11:00 12/17/2016 11:33 12/17/2016 12:00 12/17/2016 12:26 12/17/2016 13:00 12/17/2016 13:27 12/17/2016 14:00 12/17/2016 14:30 12/17/2016 15:03 12/17/2016 15:30 12/17/2016 15:57 12/17/2016 16:30 E Friday Friday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday 409 453 465 471 479 474 720 720 720 720 720 720 166 444 399 Parking LotUtilization Reacy 1009