This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: T value for coefficients&amp; R SQUARED Sheet1 Page 2 What percentage of the variation in the data can be accounted for by the equation The closer to 1.0, the better the fit For physical experiments r squared should be &gt; 0.9 For people related experiments r squared should be &gt;0.30 R squared formulaO R SQUARED INTERCEPT PARAMETER Alpha Typically tested against the intercept alpha being 0 Hypotheses test Ho: alpha=0 Ha: alpha &lt; &gt; 0 Two sided critical value based on n-2 df. Test statistic ofO TEST STATISTIC FOR INTERCEPT SLOPE PARAMETER Beta Typically tested against the slope Beta being 0 Hypotheses test Ho: Beta=0 Ha: Beta &lt; &gt; 0 Two sided critical value based on n-2 df. Test statistic ofO SLOPE PARAMETER B IN EXCEL Data Analysis-Regression Specify Input x range Input y range Returns R squared Coefficients T stat P value...
View Full Document
- Fall '08