out your own 3. You must submit your lab quiz file(s) to moodle before 10:00pm, Feb.4, 2019. 4. At the top of each fle introduce your name and student ID. 5. Document your codes/commands well. solutions Questions 1. You are given a simulated data file named 'data.xls' that contains temperature and wind speed for ten cities. Sheet Temp contains temperature T (in degree Fahrenheit) and Sheet Speed' contains wind speed V (in miles per hour). Do the followings: (a) Calculate average temperature and wind speed for each city (b) Find out maximum temperature and minimum wind speed in data file. (c) Write an anonymous function to calculate wind chill factor using array operation when necessary. The wind chill factor is given as follows: WCF 35.7 + 0.67,-35.7(V0.16) + 0437"(Vo,16) (d) Calculate the wind chill factor for city5 from Jan to Dec using the anonymous function in c). Evaluation (a) Correctness of your codes/commands/statements. (b) Documentation of your codes/commands/statements. Del For Ce 44 0 1 2 3 66 9 7 81 12 1 30777 11 3 Fb 219-7432 35 3 30 11 1. 87-31 45 1 27 4. 10 3 15 30 26 30 29521 3 243831 1 El pp 1.1 3776 2 3 20 32 14 22 7 27 8 49 -61 25 nt 760 8.1 324 Ci 1- 23|4|56 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 out your own 3. You must submit your lab quiz file(s) to moodle before 10:00pm, Feb.4, 2019. 4. At the top of each fle introduce your name and student ID. 5. Document your codes/commands well. solutions Questions 1. You are given a simulated data file named 'data.xls' that contains temperature and wind speed for ten cities. Sheet Temp contains temperature T (in degree Fahrenheit) and Sheet Speed' contains wind speed V (in miles per hour). Do the followings: (a) Calculate average temperature and wind speed for each city (b) Find out maximum temperature and minimum wind speed in data file. (c) Write an anonymous function to calculate wind chill factor using array operation when necessary. The wind chill factor is given as follows: WCF 35.7 + 0.67,-35.7(V0.16) + 0437"(Vo,16) (d) Calculate the wind chill factor for city5 from Jan to Dec using the anonymous function in c). Evaluation (a) Correctness of your codes/commands/statements. (b) Documentation of your codes/commands/statements. Del For Ce 44 0 1 2 3 66 9 7 81 12 1 30777 11 3 Fb 219-7432 35 3 30 11 1. 87-31 45 1 27 4. 10 3 15 30 26 30 29521 3 243831 1 El pp 1.1 3776 2 3 20 32 14 22 7 27 8 49 -61 25 nt 760 8.1 324 Ci 1- 23|4|56 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22
