Each week the spot electricity prices are reported for every hour. Assume that data is unsorted and build a model that identifies top five and bottom five

prices and the corresponding date/time values. Please note that empty cells may be provided as input.

All "Date and Time" cells in columns A and G must be custom-formatted: YYYY-MM-DD HH:MM:SS (e.g. 2020-01-01 12:24:23)

Date and TimePrice Top five prices and date/time PriceDate and Time You can make up the airfares for the purpose of developing the model 1 Postpone deleting input data from orange cells until you have completed P4 2 3 NOTE: You may NOT change the structure of the worksheet (e.g. by adding columns) 4 Therefore, VLOOKUP will not work here. 5 Bottom five prices and date/time PriceDate and Time 1 2 3 4 5