this fatigue lab test in material science .can you send it as excel file please
Submission Date: Next LabExperiment: Fatigue TestProblem 1The fatigue data for a brass alloy are given as follows (each question carry 1 marks):Stress amp,S(MPa)170148130114978074Cycle tofailure (N]3.7×1041.0x1053.0x1051.0x1051.0x10’1.0×1051.0x10″a) Make an S-N plot of the data.b) Plot in 5 vs /n N and report your observations. Determine the material constants A and B byfitting this plot to the equation S- AN .c) Determine the fatigue life for 120 MPa.d) Determine the Endurance limit or Fatigue strength whichever is applicable for this metal.Problem 2The fatigue data for a steel alloy are given as follows.Stress amp,S(MPa)470440390350300290290290Cycle tofailure (N)1.0×10*3.0×101.0x1053.0x101.0x1053.0x1061.0x101.0x108e) Make an S-N plot of the data.f) Plot In 5 vs In N and report your observations. Determine the material constants A and B byfitting this plot to the equation S=AN”. Is A and B the same as in problem 1? Why or whynot?g) Determine the Endurance limit or Fatigue strength whichever is applicable for this metal.h) Estimate fatigue strength at 2.0x 10* and 6.0×10″ cycles.If you run a component made of this steel alloy at stress amplitude of 470 MPa and suchthat you stop using it at 1.0 x 10′ cycles, determines the factor of safety on life.j) If you run a component made of this steel alloy for 1.0 x 10# cycles but at 250 MPa, what isthe safety factor on stress?
