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 n2 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 n2 df. Test statistic ofO SLOPE PARAMETER B IN EXCEL Data AnalysisRegression Specify Input x range Input y range Returns R squared Coefficients T stat P value...
View
Full
Document
This note was uploaded on 11/21/2010 for the course INDE 2333 taught by Professor Staff during the Fall '08 term at University of Houston.
 Fall '08
 Staff

Click to edit the document details