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? At first I asked this question because I was simply doing it with excel all the time and couldnt figure out how it computed the result. Decide at which value of your predictive. So to predict blood pressure, you would choose salt intake as the predictive variable you assign a number to. You will assign a number value to the other, predictive, variable. Decide which of the two variables you want to predict. That is, I have can obtain the equation of a trendline as a string. EDIT: 'In excel it is done automatically but how to manually calculate a linear trendline over a set of points' was originally the question. Your equation would look like this: Blood Pressure m Salt Intake + b. 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 |