Skip to main content
T
TN_96763581-Visitor
1-Visitor
October 21, 2020
Question

Sum of square

  • October 21, 2020
  • 2 replies
  • 4094 views

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

2 replies

L
LucMeekes23-Emerald IV
23-Emerald IV
October 21, 2020

Certainly Mathcad can do the sum of squares.

Make sure your data is in a vector like:

LucMeekes_0-1603272026193.png

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

LucMeekes_1-1603272055998.png

For an arbitrary length vector you write is as follows:

LucMeekes_2-1603272088313.png

Success!
Luc

 

 

    T
    TN_96763581-VisitorAuthor
    1-Visitor
    October 21, 2020

    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

    W
    Werner_E25-Diamond I
    25-Diamond I
    October 21, 2020

    Looking for something like this?

    Werner_E_0-1603276056435.png

     

      T
      TN_96763581-VisitorAuthor
      1-Visitor
      October 21, 2020

      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

      L
      LucMeekes23-Emerald IV
      23-Emerald IV
      October 21, 2020

      Ah, you want a fitting function...

      How about genfit() ?

       

      Success!

      Luc

      Terms & ConditionsCookie settingsAccessibility statement