![]() Y= SomeTypeOfEvaluationFunction (“2.6667*x + 11. Y= SomeTypeOfEvaluationFunction (TrendlineEquation) ![]() Can I evaluate this directly using some type of string evaluation function, and if so how? Or do I have to use the laborious string functions to extract the coefficients and recreate the function using variables? That is, I have can obtain the equation of a trendline as a string. Step 1: Create the Data First, let’s create a fake dataset to work with: Step 2: Create a Scatterplot Next, let’s create a scatterplot to visualize the data. ![]() Fortunately this is fairly easy to do and the following step-by-step example shows how to do so. Is there a method of evaluating this equation directly in VBA rather than using string manipulation functions to extract the numerical values in order to create a new function? Often you may want to find the slope of a trendline in Excel. However, can I evaluate this formula directly using some cool VBA function (see text from another posting)? Or do I need to use the laborious string functions? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |