Calculate the temperature of the rising air parcel from the surface to 7000 metres and enter those data in the spreadsheet and in Table 4. Submit the completed Table 4 in your answer document. Table 4.Radiosonde data recording the environmental lapse rate at a location and the air temperatures of a parcel of air rising in altitude at that same location. Altitude (m) 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000 6500 7000 Environmental Temperature (C) 23.0 16.0 11.5 6.5 1.0 -4.0 -7.0 -9.0 -11.0 -13.0 -15.0 -16.0 -17.5 -19.5 -22.0 Air Parcel Temperature (C) 23.0