cancel
Showing results for
Search instead for
Did you mean:
cancel
Showing results for
Search instead for
Did you mean:

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

6-Contributor

## Sum of square

hello,

I'm curious if we able to do sum of square in mathcad? I'm thinking to the the sum of square on math cad for the filtered temperature and unfiltered temperature. Scenario 4 & 5.

if it is impossible to do it on mathcad, would you please recommend me the way to download the data to excel?

Thank you so much

8 REPLIES 8
23-Emerald III
(To:TN_9676358)

Certainly Mathcad can do the sum of squares.

Make sure your data is in a vector like:

Now you can easily calculate the sum of the square values:

For an arbitrary length vector you write is as follows:

Success!
Luc

6-Contributor
(To:LucMeekes)

Hello,

Thank you so much for the information. i believed it is SSE of Tsf and Tf. Do you know any function to extract the data to excel?

Thank you so much

24-Ruby V
(To:TN_9676358)

Looking for something like this?

6-Contributor
(To:Werner_E)

Hello,

I will just have to do it seperaly then ratio of SSE of Tsf/ SSE Tf.

i will try it now. Thank you so much

6-Contributor
(To:Werner_E)

I think I forgot to mention that is sum of squared fit (SSE) or residual :(.  I think there is a function call leastsquarefit in Mathcad but im not sure.

Thank you so much everyone

23-Emerald III
(To:TN_9676358)

Ah, you want a fitting function...

How about genfit() ?

Success!

Luc

23-Emerald I
(To:TN_9676358)

I think there is a function call leastsquarefit in Mathcad but im not sure.

You really need to start using the on-line documentation.  There are a number of fitting functions, including genfit (as Luc says) that will find the least square fit to your own function (requires work.)

From the on-line help for Prime Express 4.0:

24-Ruby V
(To:TN_9676358)

@TN_9676358 wrote:

I think I forgot to mention that is sum of squared fit (SSE) or residual :(.  I think there is a function call leastsquarefit in Mathcad but im not sure.

Yes, there is LeastSquaresFit(..), but I am not sure if it does what you intend.

Announcements
Top Tags