View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJ RJ is offline
external usenet poster
 
Posts: 40
Default Deriving P-Value through LINEST Function

Hi all,

I was wondering if anybody knew how to derive the P-Values using =LINEST()
that are calculated using the Regressions option for the Data Analysis
Tool-Pak. I am not sure what the calculation is.

I can get the t-stats via =Mn/SEn from the LINEST array, but can not find
the P-value calculation anywhere.

Any help is greatly appreciated.
Thanks!


Best,
RJ