# 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

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

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