Question

Please use Excel for calculations:

Find out the maximum stress and out unconfined compression strength and cohesion of soil

then Draw Mohr Circle (Use graph and drawing compass NOT FREE HAND DRAWING)

Diameter=	7.29 cm
Height of Sample=	14.78 cm

Deformation Dial: 1 unit = 0.10mm;

Proving Ring No: 24691; Load Dial: 1 unit = 0.3154 lb

Deformation Dial Reading	Load Dial Reading
0	0
20	4
40	9
60	12
80	19
100	21
120	24
140	26
160	29
180	33
200	36
250	45
300	54
350	64
400	74
450	84
500	93
550	102
600	112
650	120
700	129
750	138
800	144
850	152
900	160
950	166
1000	171
1100	182
1200	192
1300	202
1400	209
1500	217
1600	223
1700	229
1800	234
1900	240
2000	243
2200	250
2400	253
2600	255
2800	256
3000	254

Answer 1

Deformation Dial reading	Load dial reading	Deformation =Deformation Dial reading *0.1*.0393 in	Strain	Load=Load dial reading*.3154 lb	area = 3.14/4*diameter^2	stress psi
		in		lb	in^2	psi
0	0	0.000	0.000	0.00	6.47	0.00
20	4	0.016	2.711	1.26	6.47	0.20
40	9	0.035	6.100	2.84	6.47	0.44
60	12	0.047	8.134	3.78	6.47	0.59
80	19	0.075	12.878	5.99	6.47	0.93
100	21	0.083	14.234	6.62	6.47	1.02
120	24	0.094	16.267	7.57	6.47	1.17
140	26	0.102	17.623	8.20	6.47	1.27
160	29	0.114	19.656	9.15	6.47	1.41
180	33	0.130	22.367	10.41	6.47	1.61
200	36	0.142	24.401	11.35	6.47	1.76
250	45	0.177	30.501	14.19	6.47	2.19
300	54	0.213	36.601	17.03	6.47	2.63
350	64	0.252	43.379	20.19	6.47	3.12
400	74	0.291	50.157	23.34	6.47	3.61
450	84	0.331	56.935	26.49	6.47	4.10
500	93	0.366	63.035	29.33	6.47	4.53
550	102	0.402	69.135	32.17	6.47	4.97
600	112	0.441	75.913	35.32	6.47	5.46
650	120	0.472	81.335	37.85	6.47	5.85
700	129	0.508	87.436	40.69	6.47	6.29
750	138	0.543	93.536	43.53	6.47	6.73
800	144	0.567	97.602	45.42	6.47	7.02
850	152	0.598	103.025	47.94	6.47	7.41
900	160	0.630	108.447	50.46	6.47	7.80
950	166	0.654	112.514	52.36	6.47	8.09
1000	171	0.673	115.903	53.93	6.47	8.34
1100	182	0.717	123.359	57.40	6.47	8.87
1200	192	0.756	130.137	60.56	6.47	9.36
1300	202	0.795	136.915	63.71	6.47	9.85
1400	209	0.823	141.659	65.92	6.47	10.19
1500	217	0.854	147.082	68.44	6.47	10.58
1600	223	0.878	151.148	70.33	6.47	10.87
1700	229	0.902	155.215	72.23	6.47	11.16
1800	234	0.921	158.604	73.80	6.47	11.41
1900	240	0.945	162.671	75.70	6.47	11.70
2000	243	0.957	164.704	76.64	6.47	11.85
2200	250	0.984	169.449	78.85	6.47	12.19
2400	Ally Wells Next > < Previous Related Solutions Describe the essential features of Consolidated-Undrained, Unconfined-Undrained, and Unconfined-Compression tests. Feel free to use sketches. Describe the essential features of Consolidated-Undrained, Unconfined-Undrained, and Unconfined-Compression tests. Feel free to use sketches. Shear strength measurements derived from unconfined compression tests for two types of soils gave the results... Shear strength measurements derived from unconfined compression tests for two types of soils gave the results shown in the following table (measured in tons per square foot). Soil Type 1 Soil Type 2 n1 = 31 n2 = 35 x1 = 1.56 x2 = 1.47 s1 = 0.24 s2 = 0.21 (a) Do the soils appear to differ with respect to mean shear strength? Use the critical value method at the 5% significance level. (b) Create a 95% confidence interval... 3. Shear strength measurements derived from unconfined compression tests for two types of soils gave the... 3. Shear strength measurements derived from unconfined compression tests for two types of soils gave the results shown in the following table (measured in tons per square foot). Soil Type 1 -n1 = 31 -x1 = 1.56 -s1 = 0.24 Soil Type 2 - n2 = 35 - x2 = 1.47 -s2 = 0.21 (a) Do the soils appear to differ with respect to mean shear strength? Use the critical value method at the 5% significance level. (b) Create a... USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for... USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for... Please complete all work in excel. Use excel to make the calculations (cells can be clicked... Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. A firm has 82 units of a product on hand. Forecasts of demand are 30 units per week. An MPS quantity of 100 units is planned to arrive in period 3. Customer orders are 32 for period 1, 28 for period 2, and 25 for period 3. What is... Please complete all work in excel. Use excel to make the calculations (cells can be clicked... Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. The manager of QuikStop (open 365 days a year) sells 40 cases of water each day. Order costs are $30 per order, and water costs $0.10 per bottle (each case of water contains 24 bottles). Daily holding costs are equal to 3 percent of the cost of the water.... Please complete all work in excel. Use excel to make the calculations (cells can be clicked... Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Activity Immediate Predecessor Activity Time (wks) Total Budgeted Cost A - 4 24,000 B - 5 15,000 C A 2 16,000 D B 8 40,000 E C 3 30,000 F D, E 5 55,000 G F 3 21,000 H D 7 21,000 I F 5 10,000 J G, H... Please complete all work in excel. Use excel to make the calculations (cells can be clicked... Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. There are four jobs to be done and four employees to do them. Each resource will take a specific time, translated to salaries, to do each job, as shown in the following table: Employee Job A B C D 1 $20 23 21 17 2 18 18 22 19... Please use excel and show calculations You are a Manager at Percolated Fiber, which is considering... Please use excel and show calculations You are a Manager at Percolated Fiber, which is considering expanding its operations in synthetic fiber manufacturing. With your Group team accompanying you, your Boss, Mr. Moneypockets, asks you to come to his office, where he gives you a consultant's report and complains, "We owe these consultants $1 million for this report, and I am not sure their analysis makes sense. Before we spend the $25 million on new equipment needed for this project,... Should I use the maximum value for the bending moment in the negative area for compression... Should I use the maximum value for the bending moment in the negative area for compression stress and maximum bending moment in the positive are for tension stress? ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Contribute Wiki on the topic: Role of information technology to communicate effectively in modern business. Last month Empire Company had a $40,850 profit on sales of $301,000. Fixed costs are $88,580... "The Myth of Sisyphus" Please respond to the following: Explain what Camus means by stating that... Write a program in C++ to find the number of comparisons using binarySearch and the sequential... Case Study Read the case then answer the three questions below: Frank became chief financial officer... Engine Cycles a. Write a description of an 'engine cycle'. Use figures, grabs and/or image to... orley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these... ADVERTISEMENT About @ 2020 WizEdu