week-four-data.xlsx
Syphilis
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.0653833117 |
| R Square | 0.0042749775 |
| Adjusted R Square | -0.0160459414 |
| Standard Error | 3.580595888 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 2.6971251876 | 2.6971251876 | 0.2103732361 | 0.6485030257 |
| Residual | 49 | 628.2126787339 | 12.8206669129 |
| Total | 50 | 630.9098039216 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 6.4242165041 | 3.0778497178 | 2.0872417737 | 0.0420894147 | 0.2390459277 | 12.6093870806 | 0.2390459277 | 12.6093870806 |
| Medium Income | -0.0000252219 | 0.0000549898 | -0.4586646227 | 0.6485030257 | -0.0001357281 | 0.0000852843 | -0.0001357281 | 0.0000852843 |
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.0653833117 |
| R Square | 0.0042749775 |
| Adjusted R Square | -0.0160459414 |
| Standard Error | 9282.0635084161 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 18125064.4176736 | 18125064.4176736 | 0.2103732361 | 0.6485030257 |
| Residual | 49 | 4221678445.73919 | 86156702.9742692 |
| Total | 50 | 4239803510.15686 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 56076.3988606556 | 2268.5480469472 | 24.7190703922 | 2.5185530847056E-29 | 51517.5808812726 | 60635.2168400387 | 51517.5808812726 | 60635.2168400387 |
| Syphilis | -169.494707301 | 369.5395260789 | -0.4586646227 | 0.6485030257 | -912.1121880497 | 573.1227734477 | -912.1121880497 | 573.1227734477 |
Gonorrhea
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.2729277983 |
| R Square | 0.0744895831 |
| Adjusted R Square | 0.0556016154 |
| Standard Error | 51.5484025902 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 10479.5041920386 | 10479.5041920386 | 3.9437584977 | 0.0526551876 |
| Residual | 49 | 130204.652670706 | 2657.2378096062 |
| Total | 50 | 140684.156862745 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 188.212656176 | 44.310567662 | 4.24757944 | 0.0000962157 | 99.1672366593 | 277.2580756927 | 99.1672366593 | 277.2580756927 |
| Medium Income | -0.0015721628 | 0.0007916666 | -1.9858898503 | 0.0526551876 | -0.0031630764 | 0.0000187509 | -0.0031630764 | 0.0000187509 |
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.2729277983 |
| R Square | 0.0744895831 |
| Adjusted R Square | 0.0556016154 |
| Standard Error | 8948.813984013 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 315821195.854034 | 315821195.854034 | 3.9437584977 | 0.0526551876 |
| Residual | 49 | 3923982314.30283 | 80081271.7204659 |
| Total | 50 | 4239803510.15686 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 60027.6012470989 | 2724.3510469298 | 22.0337248075 | 4.46718454175176E-27 | 54552.8128459416 | 65502.3896482562 | 54552.8128459416 | 65502.3896482562 |
| Gonorrhea | -47.3803255854 | 23.8584861981 | -1.9858898503 | 0.0526551876 | -95.3257486445 | 0.5650974737 | -95.3257486445 | 0.5650974737 |
Chlamydia
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.1807559384 |
| R Square | 0.0326727093 |
| Adjusted R Square | 0.012931336 |
| Standard Error | 113.4333751435 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 21295.5811660517 | 21295.5811660517 | 1.6550373066 | 0.2043199665 |
| Residual | 49 | 630489.399226105 | 12867.1305964511 |
| Total | 50 | 651784.980392157 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 574.7842697096 | 97.5063627942 | 5.8948385853 | 0.0000003397 | 378.8378975758 | 770.7306418434 | 378.8378975758 | 770.7306418434 |
| Medium Income | -0.0022411549 | 0.0017420796 | -1.2864825326 | 0.2043199665 | -0.0057419949 | 0.001259685 | -0.0057419949 | 0.001259685 |
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.1807559384 |
| R Square | 0.0326727093 |
| Adjusted R Square | 0.012931336 |
| Standard Error | 9148.7454729799 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 138525867.417704 | 138525867.417704 | 1.6550373066 | 0.2043199665 |
| Residual | 49 | 4101277642.73916 | 83699543.7293706 |
| Total | 50 | 4239803510.15686 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 61798.8036115242 | 5269.0945876231 | 11.728543222 | 7.80959188872935E-16 | 51210.1616061451 | 72387.4456169034 | 51210.1616061451 | 72387.4456169034 |
| Chlamydia | -14.5785142243 | 11.3320731959 | -1.2864825326 | 0.2043199665 | -37.3511679041 | 8.1941394555 | -37.3511679041 | 8.1941394555 |
Descriptive Statistics
| Medium Income |
| Mean | 55223.6078431373 |
| Standard Error | 1289.4448585336 |
| Median | 54916 |
| Mode | ERROR:#N/A |
| Standard Deviation | 9208.4781697704 |
| Sample Variance | 84796070.2031372 |
| Kurtosis | -0.4097397246 |
| Skewness | 0.2013360879 |
| Range | 40644 |
| Minimum | 35521 |
| Maximum | 76165 |
| Sum | 2816404 |
| Count | 51 |
| Largest(1) | 76165 |
| Smallest(1) | 35521 |
| Confidence Level(95.0%) | 2589.9262201592 |
Correlation-C
| | Medium Income | Chlamydia |
| Medium Income | 1 |
| Chlamydia | -0.1807559384 | 1 |
Multiple Regression
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.3602181794 |
| R Square | 0.1297571368 |
| Adjusted R Square | 0.07420972 |
| Standard Error | 8860.2131789781 |
| Observations | 51 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 3 | 550144764.040851 | 183381588.013617 | 2.3359706763 | 0.0857906427 |
| Residual | 47 | 3689658746.11601 | 78503377.5769364 |
| Total | 50 | 4239803510.15686 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 50766.044912431 | 7213.4597846861 | 7.0376832238 | 0.0000000072 | 36254.4356194175 | 65277.6542054445 | 36254.4356194175 | 65277.6542054445 |
| Chlamydia | 35.1022539466 | 26.2019396041 | 1.3396815074 | 0.1867908672 | -17.6092494933 | 87.8137573865 | -17.6092494933 | 87.8137573865 |
| Gonorrhea | -142.3157428599 | 62.6231952376 | -2.2725723643 | 0.0276678268 | -268.2973618186 | -16.3341239012 | -268.2973618186 | -16.3341239012 |
| Syphilis | 607.2812568761 | 471.1364534424 | 1.2889710665 | 0.2037163999 | -340.523034009 | 1555.0855477612 | -340.523034009 | 1555.0855477612 |
Data
| State | Medium Income | Chlamydia | Gonorrhea | Syphilis |
| Alabama | 42278 | 600 | 159 | 3.3 |
| Alaska | 67629 | 788 | 182 | 2 |
| Arizona | 49254 | 489 | 117 | 8.7 |
| Arkansas | 44922 | 527 | 153 | 4.1 |
| California | 60487 | 460 | 119 | 10 |
| Colorado | 60940 | 415 | 60 | 3.5 |
| Connecticut | 70161 | 372 | 65 | 2.4 |
| Delaware | 57522 | 483 | 138 | 5.1 |
| District of Columbia | 68277 | 819 | 291 | 17.9 |
| Florida | 46140 | 431 | 107 | 8.9 |
| Georgia | 49555 | 520 | 138 | 12.3 |
| Hawaii | 71223 | 457 | 73 | 4.8 |
| Idaho | 53438 | 338 | 28 | 0.7 |
| Illinois | 54916 | 517 | 124 | 6.7 |
| Indiana | 48060 | 434 | 111 | 2.6 |
| Iowa | 57810 | 382 | 53 | 2.3 |
| Kansas | 53444 | 384 | 89 | 2.1 |
| Kentucky | 42786 | 402 | 99 | 3.6 |
| Louisiana | 42406 | 626 | 195 | 12.4 |
| Maine | 51710 | 266 | 18 | 1.2 |
| Maryland | 76165 | 463 | 103 | 7.6 |
| Massachusetts | 63151 | 318 | 57 | 4.5 |
| Michigan | 52005 | 447 | 98 | 4.3 |
| Minnesota | 67244 | 367 | 75 | 4.7 |
| Mississippi | 35521 | 655 | 188 | 6.3 |
| Missouri | 56630 | 463 | 122 | 5.8 |
| Montana | 51102 | 413 | 43 | 0.8 |
| Nebraska | 56870 | 401 | 78 | 2.7 |
| Nevada | 49875 | 424 | 114 | 12.8 |
| New Hampshire | 73397 | 271 | 17 | 2.7 |
| New Jersey | 65243 | 336 | 75 | 3.3 |
| New Mexico | 46686 | 554 | 108 | 6 |
| New York | 54310 | 503 | 106 | 8.8 |
| North Carolina | 46784 | 479 | 146 | 7.4 |
| North Dakota | 60730 | 477 | 96 | 1.8 |
| Ohio | 49644 | 474 | 140 | 4.9 |
| Oklahoma | 47199 | 537 | 159 | 3.9 |
| Oregon | 58875 | 395 | 59 | 6.9 |
| Pennsylvania | 55173 | 396 | 100 | 4.2 |
| Rhode Island | 58633 | 414 | 56 | 6.8 |
| South Carolina | 44929 | 588 | 173 | 5.2 |
| South Dakota | 53053 | 493 | 106 | 6.3 |
| Tennessee | 43716 | 474 | 111 | 3.6 |
| Texas | 53875 | 496 | 134 | 6.2 |
| Utah | 63383 | 284 | 50 | 1.6 |
| Vermont | 60708 | 357 | 13 | 0.8 |
| Virginia | 66155 | 436 | 100 | 3.5 |
| Washington | 59068 | 381 | 89 | 4.9 |
| West Virginia | 39552 | 255 | 45 | 1.5 |
| Wisconsin | 58080 | 403 | 71 | 1.5 |
| Wyoming | 55690 | 338 | 20 | 0.7 |
Jambo
