Forum Discussion

Abduraxim98886's avatar
Abduraxim98886
Copper Contributor
Dec 11, 2023

Analyze graph

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

excel

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Dec 11, 2023
    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.

Resources