Calculate P-value for multiple regression stats

[jeffreybrown]

I know you can use the Data Analysis ToolPak and generate regression statistics, but can anybody lend a hand in the department of the P-value.

Using the attached workbook, can this information be used to generate the P-value as seen in column E?

[Glenn Kennedy]

Yes. I have this somewhere... for a former life as an analytical chemist in regulatory enforcement...

[Glenn Kennedy]

See G32 in this pared back monster sheet...

[MrShorty]

In a previous thread, I made the observation that the p-value (assuming the same p-value that is part of the regression output) is calculated from the t distribution. https://www.excelforum.com/excel-gen...ml#post4350280 In the examples given here, we used the coefficients and the standard error from the LINEST() function to get the t-score for each coefficient, then used TDIST() to get the corresponding p score.

[jeffreybrown]

Thank you Glenn & MrShorty. This did it.