Microsoft excel work, engineering homework help

Anonymous

Question Description

this is a strain Vs stress lab report work. instruction attached. all is needed here is the excel work no writing of the report.

Unformatted Attachment Preview

Lab Report 1 The data that is needed for this report give below! This data shows the measured stress vs plastic strain for a material with power law: 𝜎 = πΎπœ€ 𝑛 . Based on the Excel applications discussed and worked in the attached results file, similarly: 1. Use Solver to find parameters 𝐾 (strength index) and 𝑛 (strain hardening exponent) 2. Find the same parameters using linear regression by considering log(𝜎) vs log(πœ€) 3. Add some small random noise to the data and repeat steps 1 and 2 strain 0 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.1 stress (Mpa) 0.00 200.00 282.84 346.41 400.00 447.21 489.90 529.15 565.69 600.00 632.46 X 1 3 5 6 7 8 9 5,571429 Y 2 3 4 5 7 8 9 theoretical experimental X^2*Y exp coefficient 5,239025 10,47805 19 141,4537 260 exp coeff 523,9025 692 943,0246 1449 1796,986 1447 2682,381 2246 3819,25 4138 6 -32 -27 773 -455 419 781 SSE Chart Title 712913,9928 7 98 92 369 -611 -826 -236 5000 4000 3000 2000 1000 0 1 2 3 X^2*Y 4 5 exp 6 7 X Y 0 1 2 3 4 5 6 7 8 9 10 exp 3 5 7 9 11 13 15 17 19 21 23 m 1,3 b 4,32 6,76 exp 7,82 m 9,06 b 14,98 R^2 15,38 17,78 18,06 19,32 24,48 2 3 30 2,145818 1,930909 0,97026 25 20 15 10 5 -1,84 -1,44 1,08 -0,12 1,94 1,98 1,34 2 0,36 -1,9 -1,24 Chart Title 0 avg st dev 13 12,66 6,63325 7,225123 0 2 4 Y 6 exp Chart Title 6 exp y = 2,1458x + 1,9309 RΒ² = 0,9703 8 Linear (exp) 10 12 bin 1,3 4,32 6,76 7,82 9,06 14,98 15,38 17,78 18,06 19,32 24,48 5 10 15 20 25 Histogram 5 bin 5 10 15 20 25 More Frequency 2 3 1 4 1 0 Frequency exp 4 3 2 1 0 5 10 15 20 bin Histogram Frequency 25 More ...
Purchase answer to see full attachment

Tutor Answer

bhugraprerna
School: New York University

Attached.

strain
0
0.01
0.02
0.03
0.04
0.05
0.06
0.07
0.08
0.09
0.1

stress (Mpa) K
0
200
282.84
346.41
400
447.21
489.9
529.15
565.69
600
632.46

0.05

408.514545

n
0.49998616
0.5000225
0.50000162
0.49996397
0.50006706
0.49996962
0.50006428
0.49993133
0.50006705

163389.805

Value of k based on solver = 163389.805

Value of n
0.50000818

strain (with nois...

flag Report DMCA
Review

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Thank you! Reasonably priced given the quality

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors