I have the below values on an excel scatter plot graph. I can draw a linear trendline through the values by right clicking on a value, hitting “Add Trendline” and hitting “Linear”. What I would prefer is to have the values of the linear trendline written on my spreadsheet as at the times of each entry. (ie fill in below “Linear Trendline Value” row).
Does anyone know if this can be done? If not, can anyone suggest an alternative method that would give approximately what I am looking for? Does anyone have any alternative suggestions?
All help will be greatly appreciated, no matter how small. Thanks in Advance for all responses.
You can calculate the values under the liner trand line by using the SLOPE and INTERCEPT functions in Excel. This will enable you to calculate the linear trend line value of Value for each Time observation.