CMPSO 200 Embu Eszteron InputOutput Spring 2021 Problem Description We have requested historical weather data from the National Centers for Environmental Information (NCE) for the Erie Airport. Specifically, we have weather data for 1/1/1926 through 2/1/2021. Your goal is to write an m-file script Lab06.m that reads in the provided weather data, isolates and analyzes the temperature data, splits the yearly data into separate cav output files, and prints a text file ListofContents.txt that summarizes the output files. Your script will also create some plots of the data and provide a summary of the 5-year temperature averages in Temperature5Year Averagee, txt. Instructions 1. Download the Excel data file NOAA_Erie_Weather_1926010120210201.xlsx from Canvas to your folder for Lab 06. 2. Create a new script called Lab06.m and save it in the same directory as the Excel file. Your script should begin with initial comments and opening script commands Your Name, CNPSC 200, Section 1. Lab 06. Date 3. Similar to Lab 63. input the data from the Excel file and store it in a table wrishte by using the built-in readtable function mylablevar = readtabletten Use the dottor o bolate both maximum and minimum daily temperatures THAX A THIN columns, respectively on the taste Baxt - myTableVar THAX; sin myTablevar THIN Let the responding alates (DATE come cuch dara paint and store these the protest alata calle sattesptable with includes cadenes or dates sint 10 ptai Crater til at tempatan sent to the lite avgi Appendala com apacitatea to hist Temp Table wing det Hit Rater to come on the Mathias temat dot wc pen for bapta minute daily tapet datat intercov dituen artiglie following the ra whYYYY in the team fri 1026 2021 Hint Find the ban on month tombol min a month attention De which UMESC 200 070 keputup spomez After MATLAB executes your for loop. your working directory should contain a list of 90 csv files, each containing the temperature data for a single year. Fach file should have four columna listing the date, mas temperature, min temperature, and average temperature 9. (10 pts) Since there are so many files in the working directory, it is helpful to have a table of contents file summarizing the contents of the directory. In your MATLAB script, include commands to create a file called ListofContenta.txt and store the annual file names as strings If working correctly, the contents of the text file should be a listing of the newly created .cav files, as follows: NOAA_Erie_Temperature_1926.csv NOAA_Erie Temperature 1927.csv NOAA_Erie_Temperature_1928.csv NOAA_Erie Temperature_2021.cev 10. (5 pts) To visualize the data, it may be helpful to create some plotaPlot the temper ature data by copying the following commands into your actipt Tigure(1) plot (dates, makt, dates, mint legend.Constantials Instruct the poulting plots. In the Figue 1 mintapete Voce check the tifying glass mat the top of the scroll three year plot dates, hittemplate.avgt. label Ten 1210) Toner lotterin trennis met starta tout the actuations Create me the late nature on 1920 202019 in the tutto 126 123 12:31 19:36 222 MAT:15 Den Sindh CDA ds/lab-06-input-output.pdf + 69 D Page view A Read aloud | V Draw CMPSC 200 Lab 6 External Input/Output Spring 2021 13. (5 pts) Plot the 5-year averages as Figure 3 using similar commands is in Step 10. For the axis, use the ending year of the 5-year range, Le., 1930:5:2020. 11 (10 pts) Create a file called Tenperature5Year Averages.txt that contains the follow ing output. Format the temperature data to display 2 decimal place. Year Range Avg T.max Avg Tunin 1926-1930 XX.XX XXXX 1931-1935 XX.XX 2016-2020 XXXX 16 (10) Finishing Touch Tom will also be graded on programming style Cude that runs without etter and return expected result Explanator comments throughout Menningful valable name Formatting for ability with parts and billetten oncol code Suppring intermediate takulatione um displaying in the Command Wim Eiland the file for iptally the script lile lutarch CMPSO 200 Embu Eszteron InputOutput Spring 2021 Problem Description We have requested historical weather data from the National Centers for Environmental Information (NCE) for the Erie Airport. Specifically, we have weather data for 1/1/1926 through 2/1/2021. Your goal is to write an m-file script Lab06.m that reads in the provided weather data, isolates and analyzes the temperature data, splits the yearly data into separate cav output files, and prints a text file ListofContents.txt that summarizes the output files. Your script will also create some plots of the data and provide a summary of the 5-year temperature averages in Temperature5Year Averagee, txt. Instructions 1. Download the Excel data file NOAA_Erie_Weather_1926010120210201.xlsx from Canvas to your folder for Lab 06. 2. Create a new script called Lab06.m and save it in the same directory as the Excel file. Your script should begin with initial comments and opening script commands Your Name, CNPSC 200, Section 1. Lab 06. Date 3. Similar to Lab 63. input the data from the Excel file and store it in a table wrishte by using the built-in readtable function mylablevar = readtabletten Use the dottor o bolate both maximum and minimum daily temperatures THAX A THIN columns, respectively on the taste Baxt - myTableVar THAX; sin myTablevar THIN Let the responding alates (DATE come cuch dara paint and store these the protest alata calle sattesptable with includes cadenes or dates sint 10 ptai Crater til at tempatan sent to the lite avgi Appendala com apacitatea to hist Temp Table wing det Hit Rater to come on the Mathias temat dot wc pen for bapta minute daily tapet datat intercov dituen artiglie following the ra whYYYY in the team fri 1026 2021 Hint Find the ban on month tombol min a month attention De which UMESC 200 070 keputup spomez After MATLAB executes your for loop. your working directory should contain a list of 90 csv files, each containing the temperature data for a single year. Fach file should have four columna listing the date, mas temperature, min temperature, and average temperature 9. (10 pts) Since there are so many files in the working directory, it is helpful to have a table of contents file summarizing the contents of the directory. In your MATLAB script, include commands to create a file called ListofContenta.txt and store the annual file names as strings If working correctly, the contents of the text file should be a listing of the newly created .cav files, as follows: NOAA_Erie_Temperature_1926.csv NOAA_Erie Temperature 1927.csv NOAA_Erie_Temperature_1928.csv NOAA_Erie Temperature_2021.cev 10. (5 pts) To visualize the data, it may be helpful to create some plotaPlot the temper ature data by copying the following commands into your actipt Tigure(1) plot (dates, makt, dates, mint legend.Constantials Instruct the poulting plots. In the Figue 1 mintapete Voce check the tifying glass mat the top of the scroll three year plot dates, hittemplate.avgt. label Ten 1210) Toner lotterin trennis met starta tout the actuations Create me the late nature on 1920 202019 in the tutto 126 123 12:31 19:36 222 MAT:15 Den Sindh CDA ds/lab-06-input-output.pdf + 69 D Page view A Read aloud | V Draw CMPSC 200 Lab 6 External Input/Output Spring 2021 13. (5 pts) Plot the 5-year averages as Figure 3 using similar commands is in Step 10. For the axis, use the ending year of the 5-year range, Le., 1930:5:2020. 11 (10 pts) Create a file called Tenperature5Year Averages.txt that contains the follow ing output. Format the temperature data to display 2 decimal place. Year Range Avg T.max Avg Tunin 1926-1930 XX.XX XXXX 1931-1935 XX.XX 2016-2020 XXXX 16 (10) Finishing Touch Tom will also be graded on programming style Cude that runs without etter and return expected result Explanator comments throughout Menningful valable name Formatting for ability with parts and billetten oncol code Suppring intermediate takulatione um displaying in the Command Wim Eiland the file for iptally the script lile lutarch