In: Statistics and Probability
Billed Charge | Visit Time (Minutes) |
$ 13,924.00 | 220 |
$ 4,956.00 | 180 |
$ 8,496.00 | 165 |
$ 12,036.00 | 200 |
$ 4,956.00 | 173 |
$ 10,384.00 | 235 |
$ 12,980.00 | 231 |
$ 10,148.00 | 215 |
$ 8,024.00 | 170 |
$ 12,508.00 | 295 |
$ 11,328.00 | 198 |
$ 9,440.00 | 145 |
$ 13,452.00 | 216 |
$ 10,620.00 | 199 |
$ 10,384.00 | 240 |
$ 5,664.00 | 124 |
$ 7,316.00 | 200 |
$ 10,148.00 | 215 |
$ 5,900.00 | 184 |
$ 7,788.00 | 165 |
SLOPE | |
Now that you have determined the answer, it is time to provide a 1 or 2 sentence | |
write up of your answer. In statistics, it is important that you not only get the correct | |
mathematical answer, but that you become comfortable writing up your results in | |
a manner that is easily understood by the reader/audience. |
X variable = Visit Time (Minutes) (Independent variable)
Y variable = Billed Charge (dependent variable)
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.657849676 | |||||||
R Square | 0.432766196 | |||||||
Adjusted R Square | 0.401253206 | |||||||
Standard Error | 2171.472165 | |||||||
Observations | 20 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 64754844.28 | 64754844.28 | 13.73294656 | 0.001617631 | |||
Residual | 18 | 84875244.52 | 4715291.362 | |||||
Total | 19 | 149630088.8 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -124.9793602 | 2648.267097 | -0.047192883 | 0.962879171 | -5688.782072 | 5438.823351 | -5688.782072 | 5438.823351 |
Visit Time (Minutes) | 48.60241491 | 13.11523219 | 3.705799044 | 0.001617631 | 21.04833454 | 76.15649528 | 21.04833454 | 76.15649528 |
Billed Charge = -124.9794 + 48.6024 * Visit Time (Minutes)
Y Intercept = -124.9794
Slope = 48.6024
If you increase Visit Time by 1 Unit(minute), Billed Charge is increases by 48.6024 units