How do I graph the data and make a trend line for the graphs?

[msismyfavo]

Good evening,

I already have the data setup in Excel

1.png

Now it's asking questions for these 3 parts, a,b and c

3.1.jpg

[msismyfavo]

Attachment 769722

I tried to make a graph well scatter plot for part a and the trend line for part b

Part C is a bit confusing.

[MrShorty]

This should help with the basics of creating a chart (I would expect a scatter chart for this) https://support.microsoft.com/en-us/...rs=en-us&ad=us

This should help with adding a trendline to a chart: https://support.microsoft.com/en-us/...rs=en-us&ad=us

It appears that the part about determining the type of metal tested is about knowing which part of the regression/trendline analysis is the modulus of elasticity.

The problem statement assumes that the analysis wants to use a chart and trendline for the analysis. I would note that I rarely use a chart trendline for regression related analyses, preferring instead to perform the regression analyses using other tools (like the LINEST() function). As an educational exercise, it can be nice to learn how to work with charts and trendlines. If you don't need the educational exercise, I would be inclined to learn LINEST() and other regression related functions and skip the chart stuff.