linest - cubic looking for MSE Mean Square Error
 

I have fwg tabel
Mol% Counts
0.00225 836.95
0.00225 834.69
0.00225 835.18
0.00967 3515.53
0.00967 3513.75
0.00967 3516.45
0.01883 6837.86
0.01883 6834.00
0.01883 6829.18
0.04595 16645.62
0.04595 16658.36
0.04595 16634.59
0.05791 20938.43
0.05791 20939.91
0.05791 20919.43
0.07558 27318.70
0.07558 27337.69
0.07558 27348.80
0.09317 33587.92
0.09317 33598.91
0.09317 33586.73

I enter the linest function as follow to get the third order line
{=LINEST(D2:D22,E2:E22^{1,2,3},,TRUE)}
Excel returns:
3.20132E-17 -1.06333E-12 2.77498E-06 -7.54106E-05 #N/A
1.25454E-17 6.72512E-13 9.69992E-09 3.00599E-05 #N/A
0.999998275 4.6705E-05 #N/A #N/A #N/A
3284344.441 17 #N/A #N/A #N/A
0.021492985 3.70831E-08 #N/A #N/A #N/A

The first row gives the coefficients and the intercept.
The fifth row first column gives the s2SSR (sum of squares regression). So
far I understand OK.

What I am looking for is the sMSE. This figure should be 2.18136*10^-9
(according to an example analytical method).
Where can I find this in the above table that Exel returned? Do I need to do
some more calculations? Or enter another function altogether?

The analytical method I refer to is ISO 6974 part 2 ( analyses of natural gas)

Divide the ssresid by the dfresid.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
I have fwg tabel
Mol% Counts
0.00225 836.95
0.00225 834.69
0.00225 835.18
0.00967 3515.53
0.00967 3513.75
0.00967 3516.45
0.01883 6837.86
0.01883 6834.00
0.01883 6829.18
0.04595 16645.62
0.04595 16658.36
0.04595 16634.59
0.05791 20938.43
0.05791 20939.91
0.05791 20919.43
0.07558 27318.70
0.07558 27337.69
0.07558 27348.80
0.09317 33587.92
0.09317 33598.91
0.09317 33586.73

I enter the linest function as follow to get the third order line
{=LINEST(D2:D22,E2:E22^{1,2,3},,TRUE)}
Excel returns:
3.20132E-17 -1.06333E-12 2.77498E-06 -7.54106E-05 #N/A
1.25454E-17 6.72512E-13 9.69992E-09 3.00599E-05 #N/A
0.999998275 4.6705E-05 #N/A #N/A #N/A
3284344.441 17 #N/A #N/A #N/A
0.021492985 3.70831E-08 #N/A #N/A #N/A

The first row gives the coefficients and the intercept.
The fifth row first column gives the s2SSR (sum of squares regression). So
far I understand OK.

What I am looking for is the sMSE. This figure should be 2.18136*10^-9
(according to an example analytical method).
Where can I find this in the above table that Exel returned? Do I need to
do
some more calculations? Or enter another function altogether?

The analytical method I refer to is ISO 6974 part 2 ( analyses of natural
gas)

Thanks Conrad
That was fast... it took me four months headache and I still didnot get the
right answer..
Thanks !! This is indeed the solution..

"Conrad Carlberg" wrote:

Divide the ssresid by the dfresid.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
I have fwg tabel
Mol% Counts
0.00225 836.95
0.00225 834.69
0.00225 835.18
0.00967 3515.53
0.00967 3513.75
0.00967 3516.45
0.01883 6837.86
0.01883 6834.00
0.01883 6829.18
0.04595 16645.62
0.04595 16658.36
0.04595 16634.59
0.05791 20938.43
0.05791 20939.91
0.05791 20919.43
0.07558 27318.70
0.07558 27337.69
0.07558 27348.80
0.09317 33587.92
0.09317 33598.91
0.09317 33586.73

I enter the linest function as follow to get the third order line
{=LINEST(D2:D22,E2:E22^{1,2,3},,TRUE)}
Excel returns:
3.20132E-17 -1.06333E-12 2.77498E-06 -7.54106E-05 #N/A
1.25454E-17 6.72512E-13 9.69992E-09 3.00599E-05 #N/A
0.999998275 4.6705E-05 #N/A #N/A #N/A
3284344.441 17 #N/A #N/A #N/A
0.021492985 3.70831E-08 #N/A #N/A #N/A

The first row gives the coefficients and the intercept.
The fifth row first column gives the s2SSR (sum of squares regression). So
far I understand OK.

What I am looking for is the sMSE. This figure should be 2.18136*10^-9
(according to an example analytical method).
Where can I find this in the above table that Exel returned? Do I need to
do
some more calculations? Or enter another function altogether?

The analytical method I refer to is ISO 6974 part 2 ( analyses of natural
gas)

Sure, Streep. Don't wait so long next time, if there is a next time.
Headaches are awful, and there are several people around here who could have
given you the pointer.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
Thanks Conrad
That was fast... it took me four months headache and I still didnot get
the
right answer..
Thanks !! This is indeed the solution..

"Conrad Carlberg" wrote:

Divide the ssresid by the dfresid.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
I have fwg tabel
Mol% Counts
0.00225 836.95
0.00225 834.69
0.00225 835.18
0.00967 3515.53
0.00967 3513.75
0.00967 3516.45
0.01883 6837.86
0.01883 6834.00
0.01883 6829.18
0.04595 16645.62
0.04595 16658.36
0.04595 16634.59
0.05791 20938.43
0.05791 20939.91
0.05791 20919.43
0.07558 27318.70
0.07558 27337.69
0.07558 27348.80
0.09317 33587.92
0.09317 33598.91
0.09317 33586.73

I enter the linest function as follow to get the third order line
{=LINEST(D2:D22,E2:E22^{1,2,3},,TRUE)}
Excel returns:
3.20132E-17 -1.06333E-12 2.77498E-06 -7.54106E-05 #N/A
1.25454E-17 6.72512E-13 9.69992E-09 3.00599E-05 #N/A
0.999998275 4.6705E-05 #N/A #N/A #N/A
3284344.441 17 #N/A #N/A #N/A
0.021492985 3.70831E-08 #N/A #N/A #N/A

The first row gives the coefficients and the intercept.
The fifth row first column gives the s2SSR (sum of squares
regression). So
far I understand OK.

What I am looking for is the sMSE. This figure should be
2.18136*10^-9
(according to an example analytical method).
Where can I find this in the above table that Exel returned? Do I need
to
do
some more calculations? Or enter another function altogether?

The analytical method I refer to is ISO 6974 part 2 ( analyses of
natural
gas)

I should also say that you helped to answer your own question by describing
the problem specifically and crisply. That makes a huge difference.
Questions that require newsgroup participants to guess at the poster's
situation take everyone's time to no good purpose. Some participants can
even get a little testy. (g)

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
Thanks Conrad
That was fast... it took me four months headache and I still didnot get
the
right answer..
Thanks !! This is indeed the solution..

"Conrad Carlberg" wrote:

Divide the ssresid by the dfresid.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Streep" wrote in message
...
I have fwg tabel
Mol% Counts
0.00225 836.95
0.00225 834.69
0.00225 835.18
0.00967 3515.53
0.00967 3513.75
0.00967 3516.45
0.01883 6837.86
0.01883 6834.00
0.01883 6829.18
0.04595 16645.62
0.04595 16658.36
0.04595 16634.59
0.05791 20938.43
0.05791 20939.91
0.05791 20919.43
0.07558 27318.70
0.07558 27337.69
0.07558 27348.80
0.09317 33587.92
0.09317 33598.91
0.09317 33586.73

I enter the linest function as follow to get the third order line
{=LINEST(D2:D22,E2:E22^{1,2,3},,TRUE)}
Excel returns:
3.20132E-17 -1.06333E-12 2.77498E-06 -7.54106E-05 #N/A
1.25454E-17 6.72512E-13 9.69992E-09 3.00599E-05 #N/A
0.999998275 4.6705E-05 #N/A #N/A #N/A
3284344.441 17 #N/A #N/A #N/A
0.021492985 3.70831E-08 #N/A #N/A #N/A

The first row gives the coefficients and the intercept.
The fifth row first column gives the s2SSR (sum of squares
regression). So
far I understand OK.

What I am looking for is the sMSE. This figure should be
2.18136*10^-9
(according to an example analytical method).
Where can I find this in the above table that Exel returned? Do I need
to
do
some more calculations? Or enter another function altogether?

The analytical method I refer to is ISO 6974 part 2 ( analyses of
natural
gas)