Hi all,
I've been working to try and derive equations of a non-linear data set in excel (trying to derive equation of dashed line). I've researched tons of methods using linest equations for log, hyperbolic, natural log, polynomial, etc, but I just can't get a line fit. To be more precise, I don't exactly need to derive the equation of the dashed line, I really just need to derive the x-intercept of the dashed line.
I won't have full data sets of the solids lines to work with though. I am able to calculate the items that I've drawn onto the photo in blue. If anyone can help or direct me to help, that would be fantastic! I could attach an excel file with data, but I can't figure out how, lol.
Thanks!
I've been working to try and derive equations of a non-linear data set in excel (trying to derive equation of dashed line). I've researched tons of methods using linest equations for log, hyperbolic, natural log, polynomial, etc, but I just can't get a line fit. To be more precise, I don't exactly need to derive the equation of the dashed line, I really just need to derive the x-intercept of the dashed line.
I won't have full data sets of the solids lines to work with though. I am able to calculate the items that I've drawn onto the photo in blue. If anyone can help or direct me to help, that would be fantastic! I could attach an excel file with data, but I can't figure out how, lol.
Thanks!