| Simple Linear Regression |
| Copy or re-type x and y variables into correct columns |
| | | Independent (x) | Dependent (y) |
| | 1 | | | | Slope (β1) | ERROR:#DIV/0! |
| | 2 | | | | y-Intercept (β0) | ERROR:#DIV/0! |
| | 3 | | | | Correlation Coefficient (r) | ERROR:#DIV/0! |
| | 4 | | | | Coefficient of Determination (r2) | ERROR:#DIV/0! |
| | 5 | | | | Standard Error | ERROR:#DIV/0! |
| | 6 |
| | 7 |
| | 8 |
| | 9 | | | | Test of Slope of Linear Regression |
| | 10 | | | | n | 0 |
| | 11 | | | | Correlation Coefficient (r) | ERROR:#DIV/0! |
| | 12 | | | | Standard Error of x, sx | ERROR:#DIV/0! |
| | 13 | | | | Standard Error of y, sy | ERROR:#DIV/0! |
| | 14 | | | | Slope (β1) | ERROR:#DIV/0! |
| | 15 | | | | Standard Error (standard deviation) | ERROR:#DIV/0! |
| | 16 | | | | Standard Error of the slope, sb | ERROR:#DIV/0! |
| | 17 | | | | Test Statistic, t | ERROR:#DIV/0! |
| | 18 | | | | Degrees of Freedom | -2 |
| | 19 | | | | Two-Sided p-value | ERROR:#DIV/0! |
| | 20 | | | | One-Sided p-value | ERROR:#DIV/0! |
| | 21 | | | | ALPHA FOR CRITICAL VALUES |
| | 22 | | | | Left-Sided t Critical Value | ERROR:#NUM! |
| | 23 | | | | Right-Sided t Critical Value | ERROR:#NUM! |
| | 24 | | | | Two-Sided Critical Value (+/-) | ERROR:#NUM! |
| | 25 |
| | 26 | | | | Confidence Interval For Slope |
| | 27 | | | | Lower Limit | ERROR:#DIV/0! |
| | 28 | | | | Upper Limit | ERROR:#DIV/0! |
| | 29 |
| | 30 | | | | Enter x-value |
| | 31 | | | | CONFIDENCE LEVEL FOR ALL INTERVALS |
| | 32 | | | | Mean (x) | ERROR:#DIV/0! |
| | 33 | | | | y estimate for entered x value | ERROR:#DIV/0! |
| | 34 | | | | SSx | ERROR:#NUM! |
| | 35 | | | | Standard Error Confidence Interval | ERROR:#DIV/0! |
| | 36 | | | | Standard Error Prediction Interval | ERROR:#DIV/0! |
| | 37 |
| | 38 | | | | Confidence Interval for Given x |
| | 39 | | | | Lower Limit | ERROR:#DIV/0! |
| | 40 | | | | Upper Limit | ERROR:#DIV/0! |
| | 41 |
| | 42 | | | | Prediction Interval for Given x |
| | 43 | | | | Lower Limit | ERROR:#DIV/0! |
| | 44 | | | | Upper Limit | ERROR:#DIV/0! |
| | 45 |
| | 46 |
| | 47 |
| | 48 |
| | 49 |
| | 50 |
| | 51 |
| | 52 |
| | 53 |
| | 54 |
| | 55 |
| | 56 |
| | 57 |
| | 58 |
| | 59 |
| | 60 |
| | 61 |
| | 62 |
| | 63 |
| | 64 |
| | 65 |
| | 66 |
| | 67 |
| | 68 |
| | 69 |
| | 70 |
| | 71 |
| | 72 |
| | 73 |
| | 74 |
| | 75 |
| | 76 |
| | 77 |
| | 78 |
| | 79 |
| | 80 |
| | 81 |
| | 82 |
| | 83 |
| | 84 |
| | 85 |
| | 86 |
| | 87 |
| | 88 |
| | 89 |
| | 90 |
| | 91 |
| | 92 |
| | 93 |
| | 94 |
| | 95 |
| | 96 |
| | 97 |
| | 98 |
| | 99 |
| | 100 |
| | 101 |
| | 102 |
| | 103 |
| | 104 |
| | 105 |
| | 106 |
| | 107 |
| | 108 |
| | 109 |
| | 110 |
| | 111 |
| | 112 |
| | 113 |
| | 114 |
| | 115 |
| | 116 |
| | 117 |
| | 118 |
| | 119 |
| | 120 |
| | 121 |
| | 122 |
| | 123 |
| | 124 |
| | 125 |
mygoogle2
Week_6_Simple_Linear_Regression_Calculator_08292020.xlsx
