Finding the slope of a section of a graph in excel

Click For Summary
SUMMARY

This discussion focuses on finding the slope of the elastic region in a tensile test graph using Excel. Users can utilize specific data ranges, such as B2:B10 for elastic data and B11:B15 for plastic data, to isolate the slope calculation. Three methods are proposed: copying and adjusting data points for plotting, deleting non-relevant data to fit the elastic line, and performing a least-squares fit using Excel functions like SUMSQ and SUMPRODUCT. These methods provide actionable solutions for accurately determining the slope of specific graph sections.

PREREQUISITES
  • Basic knowledge of Excel charting and data manipulation
  • Understanding of tensile testing and elastic vs. plastic deformation
  • Familiarity with Excel functions such as SUMSQ and SUMPRODUCT
  • Ability to interpret linear equations and graph slopes
NEXT STEPS
  • Learn how to create and customize charts in Excel
  • Explore advanced Excel functions for data analysis
  • Study the principles of least-squares fitting in statistical analysis
  • Investigate methods for isolating data points in Excel for specific analyses
USEFUL FOR

Engineers, data analysts, and researchers involved in material testing and analysis, particularly those using Excel for data visualization and slope calculations.

member 392791
Hello,

I have a graph of a tensile test of a metal sample, and I wish to find the slope on the graph of only the elastic region of the graph, meaning of the entire graph, there is only one section of it that I am interested in finding the slope for.

Is there a way in excel to make it such that you only find the slope of certain data points, as opposed to the slope of the entire graph?

Thank you
 
Physics news on Phys.org
I can only suggest a few hacks. I assume your elastic data is in B2:B10, and the plastic in B11:B15.

Option 1. Copy B10 into C10 and move B11:B15 into C11:C15. Plot both lines on the same chart using the same colours and point styles, and fit the elastic line. Hide the legend to conceal the implementation.

Option 2. Delete the plastic data; plot and fit the elastic data in the normal way, making sure to dispaf the equation of the line. Note down the equation, delete the chart and put the plastic data back in. Use the equation to create a column C containing the fit line and plot in the normal way.

Option 3. Do a least-squares fit yourself and plot it in the nomal way. I think Excel has SUMSQ and SUMPRODUCT functions that may prove useful in determining the parameters.
 

Similar threads

MATLAB Computing Sections of a Graph Which Can Be Removed By Removing Two Edges
  • · Replies 7 ·
Replies
7
Views
2K
High School Is Averaging Individual Slopes Equivalent to Linear Regression?
  • · Replies 4 ·
Replies
4
Views
2K
In search of a Graphing Program for Excel data
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Linear Regression, Population, Sample
  • · Replies 4 ·
Replies
4
Views
2K
Inconsistency in a Velocity-Time Graph
  • · Replies 13 ·
Replies
13
Views
4K
Engineering Deflection and Slope of a Simply Supported Beam
  • · Replies 8 ·
Replies
8
Views
3K
Finding the slope of a log-log graph?
  • · Replies 11 ·
Replies
11
Views
6K
Sinking a toy boat with lead pellets
  • · Replies 10 ·
Replies
10
Views
2K
Data analysis by guessing, checking and fixing
  • · Replies 5 ·
Replies
5
Views
4K
High School Calculating 'Typical' Grade of a Hiking Trail
  • · Replies 5 ·
Replies
5
Views
4K