Hello,
I am in the process of trying to create an equation for a report I put out daily. My report entails comparing current production runs v. an aggregate average of the fiscal year. I have plotted the data on an x,y chart and found that the logrithmic equation fits the data the best.
Is there a way to extract the equation from the chart? The problem is that each day, more entries are added to my data and the equation changes. I believe there is a way to do this without having to plot the graphs but i do not know how. Any help is appreciated!
Thanks!
Let me know if you need more info.
I am in the process of trying to create an equation for a report I put out daily. My report entails comparing current production runs v. an aggregate average of the fiscal year. I have plotted the data on an x,y chart and found that the logrithmic equation fits the data the best.
Is there a way to extract the equation from the chart? The problem is that each day, more entries are added to my data and the equation changes. I believe there is a way to do this without having to plot the graphs but i do not know how. Any help is appreciated!
Thanks!
Let me know if you need more info.