Homework Help is Here – Start Your Trial Now!
Engineering
Mechanical Engineering
to Excel. • The Nominal Carbon column specifies the carbon content of a given grade of Steel. • Fatigue is given in Stress after 1 million cycles • Yield and Ultimate Strength are given in MPa (Mega Pascal) • Hardness is measured using the Brinell hardness test Generate 4 graphs (use X-Y Scatter graph type) and add a linear trend line to each graph Fatigue strength vs Carbon content • Yield Strength vs Carbon content • Ultimate Strength vs Carbon content • Brinell Hardness vs Carbon content ●

to Excel. • The Nominal Carbon column specifies the carbon content of a given grade of Steel. • Fatigue is given in Stress after 1 million cycles • Yield and Ultimate Strength are given in MPa (Mega Pascal) • Hardness is measured using the Brinell hardness test Generate 4 graphs (use X-Y Scatter graph type) and add a linear trend line to each graph Fatigue strength vs Carbon content • Yield Strength vs Carbon content • Ultimate Strength vs Carbon content • Brinell Hardness vs Carbon content ●

Elements Of Electromagnetics
Elements Of Electromagnetics
7th Edition
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Sadiku, Matthew N. O.
ChapterMA: Math Assessment
Section: Chapter Questions
Problem 1.1MA
See similar textbooks
icon
Related questions
Question
to Excel. • The Nominal Carbon column specifies the carbon content of a given grade of Steel. Fatigue is given in Stress after 1 million cycles • Yield and Ultimate Strength are given in MPa (Mega Pascal) • Hardness is measured using the Brinell hardness test Generate 4 graphs (use X-Y Scatter graph type) and add a linear trend line to each graph • Fatigue strength vs Carbon content • Yield Strength vs Carbon content • Ultimate Strength vs Carbon content • Brinell Hardness vs Carbon content ●
Transcribed Image Text:to Excel. • The Nominal Carbon column specifies the carbon content of a given grade of Steel. Fatigue is given in Stress after 1 million cycles • Yield and Ultimate Strength are given in MPa (Mega Pascal) • Hardness is measured using the Brinell hardness test Generate 4 graphs (use X-Y Scatter graph type) and add a linear trend line to each graph • Fatigue strength vs Carbon content • Yield Strength vs Carbon content • Ultimate Strength vs Carbon content • Brinell Hardness vs Carbon content ●
Steel Grad Nominal Ca Fatigue 9254 0.54 1070 0.7 8620 0.8 8695 0.95 8695 0.95 6150 0.5 1552 0.52 845 533 458 401 509 307 257 Yield 2270 1950 920 780 847 1878 933 Ultimate Hardness 584 613 583 539 539 555 601 2450 2069 1202 1496 979 2343 933
Transcribed Image Text:Steel Grad Nominal Ca Fatigue 9254 0.54 1070 0.7 8620 0.8 8695 0.95 8695 0.95 6150 0.5 1552 0.52 845 533 458 401 509 307 257 Yield 2270 1950 920 780 847 1878 933 Ultimate Hardness 584 613 583 539 539 555 601 2450 2069 1202 1496 979 2343 933
Expert Solution
Step 1: Fatigue and yield

For this problem, open excel book and create the given table as it is in the excel. Now, select the two respective columns based on your analysis requirement from the table and create a x-y scatter graph by selecting formatting as graph. After this you can include a trendline by selecting it in the analysis.

The following are the respective graphs along with the linear trendline and its respective equation.


Fatigue strength vs Carbon content 

Mechanical Engineering homework question answer, step 1, image 1


Yield Strength vs Carbon content

Mechanical Engineering homework question answer, step 1, image 2

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Dimensional Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Elements Of Electromagnetics
Elements Of Electromagnetics
Mechanical Engineering
ISBN:
9780190698614
Author:
Sadiku, Matthew N. O.
Publisher:
Oxford University Press
Mechanics of Materials (10th Edition)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:
9780134319650
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Thermodynamics: An Engineering Approach
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:
9781259822674
Author:
Yunus A. Cengel Dr., Michael A. Boles
Publisher:
McGraw-Hill Education
Control Systems Engineering
Control Systems Engineering
Mechanical Engineering
ISBN:
9781118170519
Author:
Norman S. Nise
Publisher:
WILEY
Mechanics of Materials (MindTap Course List)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:
9781337093347
Author:
Barry J. Goodno, James M. Gere
Publisher:
Cengage Learning
Engineering Mechanics: Statics
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:
9781118807330
Author:
James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:
WILEY
SEE MORE TEXTBOOKS