turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Formula of std err Prediction

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 29, 2013 7:37 AM
(1100 views)

I want to know how to transfer the formula of STD ERR OF Prediction of my linear model in Excel. ( std err Pred Formula)

I dont understand it....what is Vec quadratic ?

Formula is: Sqrt(Vec Quadratic([0.615106074605487 -0.05018339188381, -0.05018339188381 0.00428784520440499], [1] || :T20) * 194.153863605514)

T20 is my variable (temperature at 20 cm under surface)

Thank you very much for your answer!

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Dec 2, 2013 1:20 PM
(923 views)

Hi Valerie,

Computing the std err of prediction involves some matrix computations that don't have a direct equivalent in Excel.

In this case Vec Quadratic(S, X) returns the diagonal elements of X * S * Transpose(X).

It appears that Excel could do the matrix multiplication using the MMULT() function and the transposition using the TRANSPOSE() function.

I can't find an Excel function which returns the diagonal elements of a matrix.

-Jeff

-Jeff