- B I U At A Format Painter Clipboard Cell Merge Center Alignment Font Conditional Format Formatting As Table Styles 1 (340.94 KiB) Viewed 55 times
- B I U At A Format Painter Clipboard Cell Merge Center Alignment Font Conditional Format Formatting As Table Styles 2 (272.58 KiB) Viewed 55 times
Assignment:
a table of index test. Read it as a data form in R. Use the plasticity.plot function to plot the LL vs PI for the data provided. Use the geotech tool to classify the soils. Upload a screen shot to show the plots and the results. You may upload more than one file.
B I U AT A Format Painter Clipboard Cell Merge & Center> Alignment Font % Conditional Format Formatting as Table Styles Number G Styles Insert Delete Format Cells Clear Editing Sort & Find & Filter Select A1 ,Boring ID,Sample ID, "Sample Depth, ft", Gravel (%),Sand (%) , Fines (%), Silt (%) , Clay (%) 0.005 mm, Natural Moisture (%) ,LL, PL,PI,Spec. Gravity, Organic Content (%) KL M A B D GH 1 N O P Q V Boring ID Sample ID, "Sample Depth, ft",Gravel (%), Sand (%) , Fines (%), Silt (%) , Clay (%) 0.005 mm,Natural Moisture (%) ,LL,PL,PI,Spec. Gravity,Organic Content (%) 2 1,8-2269,SS 1,0-1.5,0,31.3,68.7,26.6,42.1,16.8,42,15,27,3.8 3 2,8-2269,SS 2,3.5-5.0,0,27.3,72.7,27.1,45.6,20.4,50,15,35, 4 3,B-2269,SS 3,6-7.5,0,25.5,74.5,29 2,45.3,22 0,51,16,35,4.3 5 4,B-2269,SS 4,8.5-10,0,12.0,88.0,43.3,44.7,17 0,40,14,26,, 6 5,B-2269,SS 5,11-12.5,0,6.4,93.6,48.6,45.0,18 0,40,15,25,3.1 7 6,B-2269,SS 6,13.5-15,0,3.3,96.7,39.4,57.3,21.1,54,19,35,, 8 7,B-2269,SS 7,20.4-21.9,0,1.5,98.5,13.0,85.5,28.1,77,26,51,6.6 9 8,B-2269,SS 8,25.4-26.9,0,66.2,33.8,7.4,26.4,13.4,25,17,8,2.70, 10 9,B-2269,SS 9,30.4-31.9,0,51.3,48.7,24.3,24.4,15.5,30,14,16,,4.1 11 10,B-2269,SS 10,35.4-36.9,0,46.8,53.2,18.3,34.9,15.0,35,13,22,, 12 11,B-2269,SS 11,40.4-41.9,0,32.2,67.8,23.0,44.8,22.5,41,16,25,,4.5 13 12,B-2269,SS 12,45.4-46.9,0,28.2,71.8,21.7,50.1,20.0,53,17,36, 14 13,8-2269,SS 13,50.4-51.9,0,25.3,74.7,23.7,51.0,20.3,53,16,37,, 15 14,8-2269,SS 14,55.4-56.9,0,7.8,92.2,18.8,73.4,32.1,85,25,60,2.74, 16 15,B-2269,SS 15,60.4-61.9,0.7,38.8,60.5,34.0,26.5,20.9,35,16,19, 17 16,8-2269,SS 16,65.4-66.9,0,6.7,93.3,31.3,62.0,23.3,67,32,35,,0.9 18 17,8-2269,SS 17,70.4-71.9,0,5.3,94.7,6.7,88.0,36.8,69,29,40,, 19 18,B-2269,SS 18,75.4-76.9,0,30.3,69.7,32.8,36.9,19.3,33,12,21,, 20 19,8-2269,SS 19,80.4-81.9,0,53.0,47.0,25.6,21.4,17.4,26,14,12,2.72, 21 20,B-2269,SS 20,85.4-86.9,0,84.7,15.3....... 22 21,8-2269,SS 21,90.4-91.9,0,49.0,51 0,10.6,40.4,28.2,36,16,20,,1.1 23 22,B-2269,SS 22,95.4-96.9,0,61.7,38.3,18.2,20.1,20.1,20,13,7,, 24 23,8-2269,SS 23,100 4-101.9,0,41.6,58.4,35.9,22.5,16.5,22,17,5,, 25 24,B-2269,SS 24,110.4-111.92.67, 26 25,8-2269,SS 25,120.4-1219,0,116,88 4,21,67 4,33.1,62,19,43,, 27 26,B-2269,SS 26,130.4-131.9,0,55.9,44.1,26.3,17.8,21.6,19,14,5,, 28 27 B-2269,SS 27,140.4-141.9,0,85.6,14.4, KIN Index tests Summary Table (1) Ready General 15 720 WIL MTB Σ AutoSum Fill- BIEX EEE 90% ENG 5:05 gn. W
Home Cut En Copy Paste H Insert Format Painter Page Layout Formulas 11 Index tests Summary lable (1) - Microsoft B General Data Review View Σ AutoSum Calibri ✓ P Wrap Text AY A Fill- B I U Merge & Center - % . Cell Conditional Format Formatting as Table Styles Insert Delete Format Cells Sort & Find & Filter Select- Clear - Editing Clipboard Font Alignment Number Styles A1 Boring ID,Sample ID, "Sample Depth, ft", Gravel (%), Sand (%) , Fines (%),Silt (%), Clay (%) 0.005 mm, Natural Moisture (%) ,LL, PL,PI,Spec. Gravity, Organic Content (%) UNDE B с G In Fam H I K N M O V P J R 0 S T U 26 25,B-2269,SS 25,120.4-1219,0,11.6,88.4,21,67 4,33.1,62,19,43,, 27 26,8-2269,SS 26,130.4-131.9,0,559,44.1,26.3,17.8,21.6,19,14,5, 28 27,B-2269,SS 27,140.4-141.9,0,85.6,14.4....... 29 28,8-2269,SS 28,150.4-151.9,0,22.3,77.7,32.8,449,23.1,55,17,38,2.72, 30 29,8-2269,SS 29,161.7-163.2,0,40 7,59.3,24.6,34.7,23.2,41,15,26,4.2 31 30,8-2269,SS 30,171.7-173.2,2.2,85.0,12.8,... 32 31,8-2269,SS 31,181.7-183 2,0,85 4,14.6......... 33 32,8-2269,SS 33,201.7-203.2,0,72.7,27.3,20 2,7.1,27.6,18,12,6,, 34 33,8-2269,SS 34,221.1-223.2,0,72 4,27.6,18.5,9.1,21.1,25,14,11,2.66, 35 34,8-2269,SS 35,241.8-243,0,51 1,489,20.8,28.1,15.9,28,12,16,, 36 35,8-2269,SS 36,261.8-263.3,0,72.7,27.3......0.8 37 36,8-2269,SS 37,281.8-283.3,0,54.7,45.3,34.6,10.7,21.7,29,14,15,, 38 37,B-2269,SS 38,301.8-303.3,0,14.1,85.9,18.0,67.9,29.1,72,23,49,2.71, 39 38,8-2269,SS 39A,321.8-322.6,0,1.5,98.5,25.4,73.1,25.6,73,23,50,, 40 39,B-2269,SS 40,341.8-343.3,0,28.2,71.8,43.6,28.2,22.3,36,13,23,, 41 40,B-2269,SS 41,361.8-363.3,0,34.8,65 2,40.7,24.5,26.7,31,15,16,, 42 41,8-2251,SS 1,0-1.5,0.0,34,66,18.9,47 1,19.8,47,13,34,2.70,5.4 43 42,8-2251,SS 2,2.5-4.0,0.0,25.3,74.7,25.1,49.6,18.4,42,19,23,, 44 43,B-2251,SS 3,6-7.5,0.0,17.3,82.7,29.8,52.9,16.4,37,17,20,,3.3 45 44,8-2251,SS 4,8.5-10,0.0,56.9,43.1,21.1,22,15.4,26,20,6,, 46 45,8-2251,SS 47 46,8-2251,SS 5,11-12.5,0.0,16.1,83.9,42.4,41.5,20.6,36,17,19,3.4 6,13.5-15,0.0,4.3,95.7,41.9,53.8,22.8,44,16,28,, 48 47,B-2251,SS 7,18.5-20,0.0,2.7,97 3,25.8,71.5,30.7,84,28,56,2.75,7.8 49 48,B-2251,SS 8,23.5-25,0.0,15.9,84.1,13.9,70.2,21.9,58,19,39,, 50 49,8-2251,SS 9,28.5-30.0,0.0,27.6,72.4,29.2,43.2,19.3,40,14,26,4.4 51 50,B-2251,SS 10,33.5-35,0.0,55.6,44.4,12.6,31.8,19.1,30,15,15,, 52 51,B-2251,SS 11,38.5-40,0.0,53 3,46.7,12.4,34 3,17.7,36,17,19,2.70,3.7 53 9F 90% Index tests Summary Table (1) Ready 60°F Cloudy f ENG O A 7 )) W 5:07 gn. 01/05/2022 X ✓ +