0 like 0 dislike
I have minimum, average and maximum values of something in columns. I have, for example, 24 values (I have a lot more). I am making a graph in Excel (funcional dependance) from minimum values and average values and from maximum values and average values. The graphs are plotted as Scatters and on the Scatters I am adding chart element Trendline (Polynomial with Order 6). From that Trendline I can get the functions (average function is the same). I have 2 functions for a case: 1. Case Minimum and Averages average function: y=0.0012x^6-0.0291x^5-0.1902x^4+10.253x^3-94.323x^2+315.61x-144.16 R^2=0.5326 minimum function: y=0.0024x^6-0.0846x^5+0.895x^4-0.425x^3-42.315x^2+210.33x-153.26 R^2=0.4506 2. Case Maximum and Averages average function: y=0.0012x^6-0.0291x^5-0.1902x^4+10.253x^3-94.323x^2+315.61x-144.16 R^2=0.5326 maximum function: y=0.0092x^6-0.4147x^5+7.0073x^4-55.137x^3+204.17x^2-312.59x+401.71 R^2=0.6944 My problem here is that for the same function I want to write one value for minimum and one for maximum and to get the graph for that values in the same graph form as now. It is somehow a prediction, I want to see for the same function if I got different minimum and maximum values what will I get. How can I do this in Excel? Thank you in advance. I will appreciate your answers.
by

Please log in or register to answer this question.

0 like 0 dislike
AngleWyrm said: Could you share a toy example in google sheets? I suspect the problem could be reconfigured, but need a concrete example to work on. Click to expand... Maybe e-mail ? I am not sure how this forum works
by
0 like 0 dislike
Could you share a toy example in google sheets? I suspect the problem could be reconfigured, but need a concrete example to work on.
by
Welcome to AskTheTask.com, where understudies, educators and math devotees can ask and respond to any number related inquiry. Find support and replies to any numerical statement including variable based math, geometry, calculation, analytics, geometry, divisions, settling articulation, improving on articulations from there, the sky is the limit. Find solutions to numerical problems. Help is consistently 100 percent free!

Questions

No related questions found