Please submit the Matlab code that would perform the following steps 1-12 for only the countries in group member 4. These would include Columbia, Mexico, Bolivia, and Venezuela. The picture of the excel file is pictured so that you know which cells to reference in Matlab when performing each step using the xlsread feature.

Share of GDP (%) Local Currency (2018) Current USD (2018) 5 e Colombia Data Type Mexico Data TypeBolivia Data Type Venezuela Data Type Switzerland D 862.37 981.91 1096.55 1196.25 737.87 3276.16 3082.04 4056.41 4016.76 889.98 1327.24 137.07 2000.06 2327.31 2888.82 1712.92 2063.97 2394.15 2480.94 2908.14 3323.12 3540.23 3479.51 3245.34 992.93 1287.95 939.68 1198.81 733.20 1541.03 1450.96 1408.06 1788.32 R10 1102.36 11 1529.43 R12 2005.12 13 2619.34 14 4318.55 15 2988.71 16 3389.81 17 3247.30 18 3027.92 19 3264.44 20 3347.52 21 3278.37 22 4056.90 23 4914.19 245326.66 25 6775.76 R26 9051 . 1 3 R279033.20 28 10422.05 29 10306.58 30 11706.27 R31 12503.81 3211845.96 339127.17 R348675.98 359713.82 109.90 3899.28 4645.36 4239.45 3498.22 3494.25 180.20 228.68 1071.36 987.89 1448.72 2665.39 3630.09 4351.56 5660.46 4055.38 3000.00 3577.53 2800.15 2763.66 2882.70 3270.34 3503.82 3484.64 3328.97 3524.75 4098.46 4055.54 4115.41 4973.86 4592.17 5032.88 4612.78 4521.08 4571.35 4630.43 ! 160.44 3621.52 4082.50 4779.84 4939.67 5897.20 6471.39 6978.78 7837.61 8663.38 7739.52 221.28 327.19 345.78 327.41 403.57 499.87 564.41 625.89 575.52 552.38 656.75 6199.70 1554.73 320.54 5781.44 Current USD (2018) Bolivia Data TypeVenezuela Data Type 258000000000 331000000000 447000000000 577000000000 837000000000 1320000000000 1694000000000 2391000000000 4477000000000 410000000000 4834000000000 5703000000000 6322000000000 7507000000000 8383000000000 9434000000000 10664000000000 12411405000000000 12577000000000 4082000000000 27 17810000000000 19496000000000 2919787000000000 19048000000000 21035000000000 F32 23367000000000 23713000000000 3425025600000000 F35 26527877000000 28632900000000 2232000000 2839000000 3733000000 4828000000 190000000 218377136 434859677 468720000 9750100000 10996000000 15685000000 18958000000 22666000000 27803000000 1422000000 33074000000 33598000000 5014000000 35314000000 39467000000 44496000000 52235000000 54977000000 65615000000 74517000000 80396000000 91907000000 100102000000 115158000000 122658000000 112403000000 109351000000 138000000 675700000 745780000 946820000 306000000 753000000 94500000PR 852900000 1027310000 1071270000 1383200000R 1243800000 1587500000 2740000000 5570000000 1150340000 1328340000 1340290000 1365280000 1438290000 1737330000 2368340000 2427360000 2297350000 2799539000 3454102000 3900072000 4324866000 3976500000 3818043000 4555274000 9342800000 2153000000 8706900000 10305504535 15345106238 21939113666 37495528541 56721006697 107844325932 969863777579 Add Category Insert Table Chart View Zoom Share of GDP (%) Local Currency (2018) Current USD (2018) Per Capita 5be Colombia Data Type Mexico Data TypeBolivia Data Type Venezuela Data TypeswitzerlandData Type 22% 22% 1.9% 1.9% 0.5% 0.5% 0.5% 0.5% 2.8% 1.5% 22% 2.8% 2.7% 25% 1.9% 2.3% 1.5% 0.6% 25% 25% 2.8% 0.6% 0.6% 0.6% 2.8% 23% 1.1% 0.6% 0.6% 1.5% 23% 0% 3.3% 1.2% 0.5% 0.5% R20 05% 05% 3.5% 1.3% 3.5% 3.3% 7% R22 R23 R24 R25 R26 R27 R28 R29 R30 R31 R32 R33 R34 R35 0.4% 0.4% 0.5% 0.8% 2 1.9% 0.5% 0.6% 0.6% 0.6% 39% 0.7% 1.7% 1.7% 1.1% 1.3% 1.7% 0.7% 3.2% 3.3% 3.1% 3.1% 00% 0.5% 0.5% 0.7% 0.7% 0.6% 0.5% 100% View Zoom Add Category Insert Table Chart Per Capita Share of GDP (%) Local Currency (2018) Current USD (2018) Colombia 26.2 25.7 26.0 26.1 y 5 Data TypeMexicoData Type Bolivia Data Type Venezuela Data Type Switzerland Data Type 58.0 13.8 10.5 20.0 20.5 48.4 47.7 60.6 43.3 22.5 25.7 23.2 25.7 27.4 29.9 27.0 25.6 42.3 12 70.0 14 113.5 15 77.3 86.4 32.4 66.7 22.9 28.5 29.0 32.7 58.6 73.0 76.6 23.1 18 74.9 79.6 20 80.5 20.8 33.3 30.7 29.2 33.4 18.5 38.2 55.0 99.5 133.3 157.1 201.1 29.4 39.0 53.8 52.2 21 22 95.0 23 113.5 24 121.5 25 152.7 26 201.6 27 198.9 28 227.0 29 222.1 30 249.7 31 264.1 32 247.9 33 189.2 34 178.3 35 198.0 18.8 42.7 23.4 57.5 42.0 50.3 35.4 33.0 40.0 48.8 137.5 121.4 84.8 87.0 57.8 204.5 50.6 67.7 62.8 55.7 59.3 53.7 50.7 59.4 69.7 47.2 44.8 63.3 11 - Determine the standard deviation of the military expenditure per share of GDP for each of the countries assigned to you. Display the values in the command window in table like the one shown below. Countr STD (S/GDP) 12 - Select one of the countries assigned to you. Pick a year of interest in the data and do research to determine possible explanations for the increase/decrease or other characterizes of the spending that year. Plot the military spending in per Capita vs. year for the country you examined. Label the year you selected with a one sentence note about what could have influenced the spending that year. Note: Your background section of the technical report should include substantial background research in military expenditures, historical military expenditure trends, societal, global, and political issues that impact military expenditures, expenditure modeling, and other topics related to this project. 7- You will notice, in the excel file, that some of the data is highlighted in either black, blue or red. The black indicates the country provided the data, blue represents SIPRI estimates and red is highly uncertain data. Create a plot for each country assigned to you of the Military Spending per share of GDP vs. year, however, use different markers representing the black, blue and red data. For example. If the data is black, use diamonds as markers, if its red use asterisks, if its blue use squares. Keep the line color consistent. Represent all 4 plots in a 2x2 subplot and fully format each plot and include a legend 8 - Find the Maximum and minimum expenditure values in US Dollars and the year that maximum and minimum occurred for each of the four countries assigned to you. Display the values in the command window in table like the one shown below. Country Max Expenditure (USD) Year of Max Min Expenditure (USD) Year of Min 9 - Find the average military expenditure per capita for each of the countries assigned to you and display that information in the command window in a table like the one shown below. CountrAverage 10 -Determine the country assigned to you with the highest and also the country with the lowest total military expenditures from 1988 -2017 Use the fprintf command to display a sentence that is formatted as follows ("When comparing COUNTRY 1, COUNTRY 2, COUNTRY 3, and COUNTRY 4, CQUTNRY X had the highest total expenditure of XXXX, and COUNTRY X had the lowest total expenditure of XXXX") You will be assigned teams of 4. Each team member will be responsible for analyzing4 different countries. The assignments are shown in the table below Country Assignments Aigeria Tunisia China South Korea Team Member 1 Team Member 2 lsrael Taiwan Egypt Japan Colombia Mexico USA Team Member 3 Team Member4 Poland Bolivia Venezuela Perform the following analysis in a single MATLAB script file. 1 - Import Military Expenditure Data into MATLAB 2 - Assign each column of Excel data to a variable name in MATLAB 3 - Make a single plot of the Military Spending Per Capita versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 4- Make a single plot of the Military Spending in US Dollars versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 5- Make a single plot of the Military Spending in Local Currency versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 6- Make a single plot of the Military Spending per share of Gross Domestic Product versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. Share of GDP (%) Local Currency (2018) Current USD (2018) 5 e Colombia Data Type Mexico Data TypeBolivia Data Type Venezuela Data Type Switzerland D 862.37 981.91 1096.55 1196.25 737.87 3276.16 3082.04 4056.41 4016.76 889.98 1327.24 137.07 2000.06 2327.31 2888.82 1712.92 2063.97 2394.15 2480.94 2908.14 3323.12 3540.23 3479.51 3245.34 992.93 1287.95 939.68 1198.81 733.20 1541.03 1450.96 1408.06 1788.32 R10 1102.36 11 1529.43 R12 2005.12 13 2619.34 14 4318.55 15 2988.71 16 3389.81 17 3247.30 18 3027.92 19 3264.44 20 3347.52 21 3278.37 22 4056.90 23 4914.19 245326.66 25 6775.76 R26 9051 . 1 3 R279033.20 28 10422.05 29 10306.58 30 11706.27 R31 12503.81 3211845.96 339127.17 R348675.98 359713.82 109.90 3899.28 4645.36 4239.45 3498.22 3494.25 180.20 228.68 1071.36 987.89 1448.72 2665.39 3630.09 4351.56 5660.46 4055.38 3000.00 3577.53 2800.15 2763.66 2882.70 3270.34 3503.82 3484.64 3328.97 3524.75 4098.46 4055.54 4115.41 4973.86 4592.17 5032.88 4612.78 4521.08 4571.35 4630.43 ! 160.44 3621.52 4082.50 4779.84 4939.67 5897.20 6471.39 6978.78 7837.61 8663.38 7739.52 221.28 327.19 345.78 327.41 403.57 499.87 564.41 625.89 575.52 552.38 656.75 6199.70 1554.73 320.54 5781.44 Current USD (2018) Bolivia Data TypeVenezuela Data Type 258000000000 331000000000 447000000000 577000000000 837000000000 1320000000000 1694000000000 2391000000000 4477000000000 410000000000 4834000000000 5703000000000 6322000000000 7507000000000 8383000000000 9434000000000 10664000000000 12411405000000000 12577000000000 4082000000000 27 17810000000000 19496000000000 2919787000000000 19048000000000 21035000000000 F32 23367000000000 23713000000000 3425025600000000 F35 26527877000000 28632900000000 2232000000 2839000000 3733000000 4828000000 190000000 218377136 434859677 468720000 9750100000 10996000000 15685000000 18958000000 22666000000 27803000000 1422000000 33074000000 33598000000 5014000000 35314000000 39467000000 44496000000 52235000000 54977000000 65615000000 74517000000 80396000000 91907000000 100102000000 115158000000 122658000000 112403000000 109351000000 138000000 675700000 745780000 946820000 306000000 753000000 94500000PR 852900000 1027310000 1071270000 1383200000R 1243800000 1587500000 2740000000 5570000000 1150340000 1328340000 1340290000 1365280000 1438290000 1737330000 2368340000 2427360000 2297350000 2799539000 3454102000 3900072000 4324866000 3976500000 3818043000 4555274000 9342800000 2153000000 8706900000 10305504535 15345106238 21939113666 37495528541 56721006697 107844325932 969863777579 Add Category Insert Table Chart View Zoom Share of GDP (%) Local Currency (2018) Current USD (2018) Per Capita 5be Colombia Data Type Mexico Data TypeBolivia Data Type Venezuela Data TypeswitzerlandData Type 22% 22% 1.9% 1.9% 0.5% 0.5% 0.5% 0.5% 2.8% 1.5% 22% 2.8% 2.7% 25% 1.9% 2.3% 1.5% 0.6% 25% 25% 2.8% 0.6% 0.6% 0.6% 2.8% 23% 1.1% 0.6% 0.6% 1.5% 23% 0% 3.3% 1.2% 0.5% 0.5% R20 05% 05% 3.5% 1.3% 3.5% 3.3% 7% R22 R23 R24 R25 R26 R27 R28 R29 R30 R31 R32 R33 R34 R35 0.4% 0.4% 0.5% 0.8% 2 1.9% 0.5% 0.6% 0.6% 0.6% 39% 0.7% 1.7% 1.7% 1.1% 1.3% 1.7% 0.7% 3.2% 3.3% 3.1% 3.1% 00% 0.5% 0.5% 0.7% 0.7% 0.6% 0.5% 100% View Zoom Add Category Insert Table Chart Per Capita Share of GDP (%) Local Currency (2018) Current USD (2018) Colombia 26.2 25.7 26.0 26.1 y 5 Data TypeMexicoData Type Bolivia Data Type Venezuela Data Type Switzerland Data Type 58.0 13.8 10.5 20.0 20.5 48.4 47.7 60.6 43.3 22.5 25.7 23.2 25.7 27.4 29.9 27.0 25.6 42.3 12 70.0 14 113.5 15 77.3 86.4 32.4 66.7 22.9 28.5 29.0 32.7 58.6 73.0 76.6 23.1 18 74.9 79.6 20 80.5 20.8 33.3 30.7 29.2 33.4 18.5 38.2 55.0 99.5 133.3 157.1 201.1 29.4 39.0 53.8 52.2 21 22 95.0 23 113.5 24 121.5 25 152.7 26 201.6 27 198.9 28 227.0 29 222.1 30 249.7 31 264.1 32 247.9 33 189.2 34 178.3 35 198.0 18.8 42.7 23.4 57.5 42.0 50.3 35.4 33.0 40.0 48.8 137.5 121.4 84.8 87.0 57.8 204.5 50.6 67.7 62.8 55.7 59.3 53.7 50.7 59.4 69.7 47.2 44.8 63.3 11 - Determine the standard deviation of the military expenditure per share of GDP for each of the countries assigned to you. Display the values in the command window in table like the one shown below. Countr STD (S/GDP) 12 - Select one of the countries assigned to you. Pick a year of interest in the data and do research to determine possible explanations for the increase/decrease or other characterizes of the spending that year. Plot the military spending in per Capita vs. year for the country you examined. Label the year you selected with a one sentence note about what could have influenced the spending that year. Note: Your background section of the technical report should include substantial background research in military expenditures, historical military expenditure trends, societal, global, and political issues that impact military expenditures, expenditure modeling, and other topics related to this project. 7- You will notice, in the excel file, that some of the data is highlighted in either black, blue or red. The black indicates the country provided the data, blue represents SIPRI estimates and red is highly uncertain data. Create a plot for each country assigned to you of the Military Spending per share of GDP vs. year, however, use different markers representing the black, blue and red data. For example. If the data is black, use diamonds as markers, if its red use asterisks, if its blue use squares. Keep the line color consistent. Represent all 4 plots in a 2x2 subplot and fully format each plot and include a legend 8 - Find the Maximum and minimum expenditure values in US Dollars and the year that maximum and minimum occurred for each of the four countries assigned to you. Display the values in the command window in table like the one shown below. Country Max Expenditure (USD) Year of Max Min Expenditure (USD) Year of Min 9 - Find the average military expenditure per capita for each of the countries assigned to you and display that information in the command window in a table like the one shown below. CountrAverage 10 -Determine the country assigned to you with the highest and also the country with the lowest total military expenditures from 1988 -2017 Use the fprintf command to display a sentence that is formatted as follows ("When comparing COUNTRY 1, COUNTRY 2, COUNTRY 3, and COUNTRY 4, CQUTNRY X had the highest total expenditure of XXXX, and COUNTRY X had the lowest total expenditure of XXXX") You will be assigned teams of 4. Each team member will be responsible for analyzing4 different countries. The assignments are shown in the table below Country Assignments Aigeria Tunisia China South Korea Team Member 1 Team Member 2 lsrael Taiwan Egypt Japan Colombia Mexico USA Team Member 3 Team Member4 Poland Bolivia Venezuela Perform the following analysis in a single MATLAB script file. 1 - Import Military Expenditure Data into MATLAB 2 - Assign each column of Excel data to a variable name in MATLAB 3 - Make a single plot of the Military Spending Per Capita versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 4- Make a single plot of the Military Spending in US Dollars versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 5- Make a single plot of the Military Spending in Local Currency versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend. 6- Make a single plot of the Military Spending per share of Gross Domestic Product versus year that includes all four of the countries assigned to you. Be sure to completely format the plot and include a legend