How calculate P value for Linearity and Bias using Excel

[mode62930]

Hi everybody,

I want to create the same report than minitab for linearity and bias study. As showed in picture attached.You could also find my excel file.

As you can see, I am blocked with calculation of P-value for biais and linearity.

Thank you for your help.
Simon

 

[reynald]

I noticed that you already visited and posted to another thread.
Have you tried this one yet:
https://elsmar.com/Forums/showthread.php?t=1009&highlight=linearity&page=2

and also Miner's blog:
https://elsmar.com/Forums/blog.php?b=131

 

[mode62930]

Thank you Reynald, but unfortunately there is no P-value calculate in MSA 4rd edition or I didn't see it.
Is somebody know how to calculate these p-value for Biais and linearity ?

Thanks in advance.

 

[reynald]

I haven't tried it in Excel as I have relied on Minitab.
This link may help though, it has a discussion on how to compute the p-values
https://reliawiki.org/index.php/Linearity_and_Bias_Study_Example

 

[Statistical Steven]

Hi everybody,

I want to create the same report than minitab for linearity and bias study. As showed in picture attached.You could also find my excel file.

As you can see, I am blocked with calculation of P-value for biais and linearity.

Thank you for your help.
Simon

The linearity part is just using the regression analysis found in the Data Analysis Add-in

The bias part is just a one-sample t-test against the hypothesis that bias = 0.

Can you do this Excel?

 

[mode62930]

Thank you so much Reynald and Statistical Seven.

I succed for linearity, but I am steel struggling with calculation of 4td column in the example you post Reynald. You could find attached the excel file where I re-do the example.

How can I calculate the 4td column (column I in my excel)

After I will get this value, I will calculate the p value with:
= Tdist( t , Count(count sample of each reference) -1)
Am I right ?

Thank you for your help again.

 

[reynald]

I did try to replicate the sample and was successful except for the average's mean std.
Let's wait for others help, meanwhile this might keep you going.

 

[Miner]

Try using the pooled standard deviation for the average row.

 

[mode62930]

Woow thank you guys !

It is progressing a lot ! I compared Minitab and Excel sheet I have slight difference on P-value. Do you know why ?

Thanks again.