Question: Use excel EXCEL PROBLEMS 1) T he followin g tabulated data represent stress-strain data from an experiment on an unknown sample of white metal (modulus
EXCEL PROBLEMS 1) T he followin g tabulated data represent stress-strain data from an experiment on an unknown sample of white metal (modulus of elasticity values for various white metals are listed). Using. Excel: a) Graph the stress-strain data. If the data includes values outside the elastic-stretch b) Use a linear trendline to compute the modulus of elasticity for the sample. Display your c) Using the table below, what type of metal was tested? region, discard those values. equation and the R2 value on the graph. Modulus of Elasticity (GPa) 45 70 Strain Stress Material Mg (Magnesium) Alloy Al (Aluminum) Alloy Ag (Silver) Ti (Titanium) Alloy Pt (Platinum) SS (Stainless Steel) (mm/mm) (MPa) 0.0000 0.0015 0.0030 0.0045 0.0060 162 324 486 550 2 71 110 170 200
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
