Analyze graph

Copper Contributor

I performed a granulometric analysis and built a cumulative curve based on this data. Now I want to automatically determine the values of the plotted chart at the point where the value was not specified when plotting the chart, i.e. intermediate values

1 Reply
Use the trendline feature and pick a trend-line which matches your data as closely as possible. Also make sure the trendline equation is plotted on the chart and the r-squared too (to assess how good the fit is). Tip: you can change the number of digits shown in the trendline equation to enhance precision. Second tip: Excel also has functions to calculate the trendline parameters for you in cells.