4 57%+ 13:05 Wed Feb 23 a myleoonline.tamuc.edu A total of 4 new sub-datasets. Make sure you submit all your newly created sub-datasets appropriately labeled in the Excel document. (Points: 8) Hint: Use the Filter feature of Microsoft Excel to separate the observations corresponding to one variety from the observations corresponding to the other three varieties. That is, select the names of the variables where you want the filter to appear, then click on the Data tab in the menu bar at the top of the window, then click on the Filter button. File Home Insert Page Layout Formulas Data Review View Add-Iny LA @connections 21 2X Y Properties To Be From From Other Existing Access Web Text Sources . Connections All - Edit Linky I1 Sort Get External Data Sort & Filter Al f year G 1 year . loc rep var trt - yield wprice 2 2012 1.00 1,00 1.00 1.00 6191.00 0.2376 3 2012 1.00 1.00 1.00 0.00 $600.77 0.2376 4 2012 1.00 2.00 1.00 1.00 5315.23 0.2390 Then filter the observations. File Home Insert Page Layout Formulas Data Review View Add-Ins LA LO Connections Properties Rea From From From From Other Existing Refresh ! sort Filter Access Web Text Sources . Connections All Edit Links Get External Data Connections Sort & Filter A1 year A D G H 1 year loc rep var trt yield wprice 2 21 Sort Smallest to Largest 1.00 6191.00 0.2376 3 1 Sort Largest to Smallest 0.00 $600.77 3.2376 4 Sort by Color 1.00 $315.23 0.2396 5 0.00 5383.00 Clear Filter From var" 0.2396 6 1.00 6015.65 0.2392 7 Fitter by Color 0.00 $368.85 0.2392 8 Number Filters 1:00 5446.13 0.2412 9 Search 9 0.00 5272.89 0.2412 10 (Select Al) 1.00 5485.26 0.2392 11 1.00 0.00 5494.41 0.2392 12 2.00 1.00 6897.99 0.238 13 3.00 4.00 0.00 $539.34 0.2384 14 1.00 6023.03 0.2445 15 0.00 5012.01 0.2445 16 1.00 4815.97 .2458 17 0.00 5046.91 0.2458 18 1.00 5012.01 0.2458 19 OK 0.00 5003.41 20 Cancel 0.2458 1.00 5885.10 0.2445 21 2012 1.00 4.00 2.00 0.00 5131.88 0.2445