![]() Y= SomeTypeOfEvaluationFunction (“2.6667*x + 11. Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left. TREND returns the y-values along that line for the array of newx's that you specify. It fits a straight line (using the method of least squares) to the array's knowny's and knownx's. Y= SomeTypeOfEvaluationFunction (“2.6667*x + 11.44”) The TREND function returns values along a linear trend. Y= SomeTypeOfEvaluationFunction (TrendlineEquation) Step 3: Create Equation from Data Points. ![]() ![]() 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? The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line. That is, I have can obtain the equation of a trendline as a string. Returns the slope of the linear regression line through data points in knownys and knownxs. ![]() 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? 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 |