Programming Iterative Curve Fitting

Forum|Forum|12 years ago
April 21, 2014
2 replies
3855 views

Greetings!

I am a novice Prime 3 user of programming functionality. The attached file contains two tables with multiple arrays of varying length. My objective is to derive best curve fits for each pair of array columns, T₀, P₀ , in this example (366 pairs total), and output the fit parameters into another table. As a means of checking each curve fit, I will examine each graphically. This task would appear to be reasonably simple using programming but setting up the iteration and output is a tall hurdle at the moment. Thanks!

Tom

1_T_RI_p-mcdx.zip

Statistics_Analysis

Best answer by Werner_E

A pity you didn't adapt the READEXCEL calls in your sheet.

Anyway, see if the attached file helps.

BTW - what does the data represent?

W

Werner_E

25-Diamond I

You might consider posting the data file (or at least a simplified data file) as well.

BTW, why do you want all the 366 triples of fit parameters in one array? You wouldn't be able to examine all at once anyway.

G

Gabbro19

Author

1-Visitor

Thank you for your response Werner. The attached file contains abbreviated arrays at the bottom of the page as an example.

Output of the fit parameter triplets (as three arrays) in another table will enable me to perform manipulations in another application. I intend to graphically examine each array pair to assess the fit (I know, manually intensive but necessary).

Tom

1_T_RI_p-mcdx.zip