LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Regression Significance or P factor

Hi,

I have two arrays of data that I need to run a regression on. I can use the
"Slope" formula to get the line slope, or x factor coefficient from the
regression statistics. But what formula can I use to get the P- factor, Eg.
0.05, or the significance at 0.05?

If I can crack that, I can do the vba to get it retuned from the number of
spreadsheets I have to analyse.

--

Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Please tell us your ppt version, and get back to us here
Remove spaces from signature
Posted to news://msnews.microsoft.com


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i put an asterisk on a bar chart to show significance L Charts and Charting in Excel 3 April 2nd 23 07:04 PM
Is there an easy way to denote significance on charts jpaderi Charts and Charting in Excel 2 August 5th 09 07:01 AM
Significance of _- in custom format dee Excel Discussion (Misc queries) 2 March 29th 07 07:50 PM
How do I insert symbol to indicate significance on a bar graph? Hans Coetzee Charts and Charting in Excel 1 November 5th 05 03:34 AM
= sign has no significance. Gary Adamson Excel Worksheet Functions 1 December 9th 04 06:19 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"