Part 3 - Data Analysis: Data from the two weather stations discussed in the prev

Question

Part 3 - Data Analysis: Data from the two weather stations discussed in the previous section are available on this course’s Blackboard page.

Step 1: Download the file titled NYC-UHI-Data.xlsx from Blackboard and open it in MS Excel.

Step 2: Compute hourly UHI intensity for each hour (UHI = urban-rural) and complete the following:

1. Create a table showing the average hourly temperature for each station and the hourly UHI intensity. The first column should list the time, and the next 3 columns should list urban temp, rural temp, and UHI intensity. Print this table and attach it to your lab. (5 points)

Greenwich, CT Data:

Central Park Data;

1 Time EDT Temperatu Dew Point F Humidity Sea Level P VisibilityMF Wind Direc Wind Speer Gust Speed Precipitatio Events Conditions WindDirDe DateUTC 2 12:56 AM 79 73 82 29.88 10 West 4.6 N/A clear 280 8/13/16 4:56 3 1:56 AM 78.1 73 84 29.87 10 calm Calm N/A Clear o 8/13/16 5:56 4 2:56 AM 80.1 73.9 81 29.87 10 calm calm NIA Clear o 8/13/16 (6:56 5 3:56 AM 79 73.9 84 29.87 10 calm calm NIA Clear o 8/13/16 7:56 6 4:56 AM 77 73.9 90 29.88 10 calm calm NIA Clear o 8/13/16 8:56 7 5:56 AM 75.9 73.9 94 29.88 9 calm calm NIA clear o 8/13/16 9:56 8 6:56 AM 78.1 75 90 29.9 10 calm calm N/A Partly cloul 8/13/16 10:56 9 7:56 AM 81 75.9 85 29.91 10 West 3.5 NIA 260 8/13/16 11:56 Clear 10 8:56 AM 84 75.9 76 29.91 10 West 6.9 NIA Clear 270 8/13/16 12:56 11 9:56 AM 87.1 75 67 29.9 10 calm calm NIA Clear o 8/13/16 13:56 12 10:56 AM 89.1 75 63 29.91 10 Variable 3.5 NIA Clear 0 8/13/16 14:56 13 11:56 AM 91.9 73 54 29.9 10 variable 46 N/A Partly cloul o 8/13/16 15:56 L4 12:56 PM 93.9 73.9 52 29.88 10 ssw 6.9 N/A Scattered C 210 8/13/16 16:56 15 1:56 PM 93 73 52 29.86 10 calm calm NIA 0 8/13/16 17:56 Scattered C 16 2:56 PM 93 75.9 57 29.85 10 South 9.2 NIA Scattered c 170 8/13/16 18:56 17 3:56 PM 93 75.9 57 29.83 10 South 8.1 NIA Scattered C 190 8/13/16 19:56 18 4:56 PM 91 77 63 29.83 10 South 127 23 NIA 170 8/13/16 20:56 Scattered C 19 5:56 PM 90 77 65 29.83 10 South 115 NIA Partly clou 170 8/13/16 21:56 20 6:56 PM 88 77 70 29.82 10 South 9.2 N/A Partly clour 170 8/13/16 22:56 21 7:56 PM 84.9 77 77 29.84 10 South 3.5 NIA 180 8/13/16 23:56 Scattered C 22 8:05 PM 84.9 78.1 80 29.87 9 South 3.5 o Rain-Thund Light Thund 180 8/14/16 0:05 23 8:56 PM 80.1 73 79 29.88 9 South 11.5 NIA Rain-Thund Light Thund 170 8/14/16 0:56 24 9:56 PM 80.1 75 85 29.89 10 West 3.5 NIA 260 8/14/16 1:56 Scattered C 25 10:56 PM 77 75 94 29.89 7 calm calm NIA Partly cloul o 8/14/16 2:56 Thunderstc Thunderstc 280 8/14/16 3:56 Central Park Greenwich CT

Explanation / Answer

Greenwich Time/ Central park time Greenwich Temperature Greenwich Humidity Central park temperature Central Park Humidity 12:56Am/12:51Am 79 82 82.9 72 1:56Am/1:51AM 78.4 84 82 74 2:56AM/2:51AM 80.1 81 82 76 3:56AM/3:51AM 79 84 82 79 4:56AM/4:51AM 77 90 82 79 5:56AM/5:51AM 75.9 94 81 85 6:56AM/6:51AM 78.1 90 82 82 7:56AM/7:51AM 81 85 82 82 8:56AM/8:51AM 84 76 84 76 9:56AM/9:51AM 87.1 67 87.1 69 10:56AM/10:51AM 89.1 63 89.1 67 11:56AM/11:51AM 91.9 54 91.9 59 12:56PM/12:51PM 93.9 52 93.9 54 1:56PM/1:51PM 93 52 96.1 52 2:56PM/2:51PM 93 57 93.9 60 3:56PM/3:51PM 93 57 91.9 62 4:56PM/4:51PM 91 63 91.9 62 5:56PM/5:51PM 90 65 91.9 59 6:56PM/6:51PM 88 70 91.9 58 7:56PM/7:51PM 84.9 77 91 57 8:56PM/8:51PM 84.9 80 90 59 9:56PM/9:51PM 80.1 85 90 59 10:56PM/10:51PM 77 94 88 55 11:56PM/11:51PM 80.1 79 86 57

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.