R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

library(readxl)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
Medicare_data_cleaned1 <- read_excel("Medicare_data_cleaned1.xls")
## New names:
## • `` -> `...1`
dataset<- Medicare_data_cleaned1

##RACE COMPARED VIA ANOVA
q1r<-dataset%>%filter(Question=="Acute myocardial infarction (heart attack) hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q1r$Data_Value~q1r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q1r$Data_Value and q1r$Break_Out
## F = 46.94, num df = 5, denom df = 1866, p-value < 2.2e-16
q2r<-dataset%>%filter(Question=="Cerebrovascular disease (stroke) hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q2r$Data_Value~q2r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q2r$Data_Value and q2r$Break_Out
## F = 258.2, num df = 5, denom df = 1866, p-value < 2.2e-16
q3r<-dataset%>%filter(Question=="Coronary heart disease hospitalization rate among Medicare beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q3r$Data_Value~q3r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q3r$Data_Value and q3r$Break_Out
## F = 52.42, num df = 5, denom df = 1866, p-value < 2.2e-16
q4r<-dataset%>%filter(Question=="Diseases of the heart (heart disease) hospitalization rate among Medicare beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q4r$Data_Value~q4r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q4r$Data_Value and q4r$Break_Out
## F = 348.33, num df = 5, denom df = 1866, p-value < 2.2e-16
q5r<-dataset%>%filter(Question=="Heart failure hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q5r$Data_Value~q5r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q5r$Data_Value and q5r$Break_Out
## F = 24.771, num df = 5, denom df = 1866, p-value < 2.2e-16
q6r<-dataset%>%filter(Question=="Major cardiovascular disease hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q6r$Data_Value~q6r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q6r$Data_Value and q6r$Break_Out
## F = 467.63, num df = 5, denom df = 1866, p-value < 2.2e-16
q11r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among acute myocardial infarction (heart attack) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q11r$Data_Value~q11r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q11r$Data_Value and q11r$Break_Out
## F = 12.335, num df = 5, denom df = 1822, p-value = 8.696e-12
q22r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among cerebrovascular disease (stroke) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q22r$Data_Value~q22r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q22r$Data_Value and q22r$Break_Out
## F = 7.9773, num df = 5, denom df = 1844, p-value = 1.889e-07
q33r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among coronary heart disease hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q33r$Data_Value~q33r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q33r$Data_Value and q33r$Break_Out
## F = 11.899, num df = 5, denom df = 1831, p-value = 2.368e-11
q44r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among diseases of the heart (heart disease) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q44r$Data_Value~q44r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q44r$Data_Value and q44r$Break_Out
## F = 26.883, num df = 5, denom df = 1858, p-value < 2.2e-16
q55r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among heart failure hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q55r$Data_Value~q55r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q55r$Data_Value and q55r$Break_Out
## F = 1.8092, num df = 5, denom df = 1663, p-value = 0.1079
q66r<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among major cardiovascular disease hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Race")
oneway.test(q66r$Data_Value~q66r$Break_Out, var.equal = TRUE)
## 
##  One-way analysis of means
## 
## data:  q66r$Data_Value and q66r$Break_Out
## F = 35.345, num df = 5, denom df = 1864, p-value < 2.2e-16
##GENDER COMPARED VIA INDEPENDENT T-TESTS
q1g<-dataset%>%filter(Question=="Acute myocardial infarction (heart attack) hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q1g$Data_Value~q1g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q1g$Data_Value by q1g$Break_Out
## t = -27.529, df = 622, p-value < 2.2e-16
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -305.4084 -264.7364
## sample estimates:
## mean in group Female   mean in group Male 
##             496.8446             781.9170
q2g<-dataset%>%filter(Question=="Cerebrovascular disease (stroke) hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q2g$Data_Value~q2g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q2g$Data_Value by q2g$Break_Out
## t = -7.2563, df = 622, p-value = 1.19e-12
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -114.90106  -65.95535
## sample estimates:
## mean in group Female   mean in group Male 
##             910.6083            1001.0365
q3g<-dataset%>%filter(Question=="Coronary heart disease hospitalization rate among Medicare beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q3g$Data_Value~q3g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q3g$Data_Value by q3g$Break_Out
## t = -31.425, df = 622, p-value < 2.2e-16
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -584.8062 -516.0136
## sample estimates:
## mean in group Female   mean in group Male 
##             692.9673            1243.3772
q4g<-dataset%>%filter(Question=="Diseases of the heart (heart disease) hospitalization rate among Medicare beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q4g$Data_Value~q4g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q4g$Data_Value by q4g$Break_Out
## t = -16.869, df = 622, p-value < 2.2e-16
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -889.6248 -704.0919
## sample estimates:
## mean in group Female   mean in group Male 
##             2904.996             3701.854
q5g<-dataset%>%filter(Question=="Heart failure hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q5g$Data_Value~q5g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q5g$Data_Value by q5g$Break_Out
## t = -1.3187, df = 622, p-value = 0.1878
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -88.82980  17.45865
## sample estimates:
## mean in group Female   mean in group Male 
##             313.1929             348.8785
q6g<-dataset%>%filter(Question=="Major cardiovascular disease hospitalization rate among Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q6g$Data_Value~q6g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q6g$Data_Value by q6g$Break_Out
## t = -15.81, df = 622, p-value < 2.2e-16
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -1075.6114  -837.9213
## sample estimates:
## mean in group Female   mean in group Male 
##             4004.837             4961.603
q11g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among acute myocardial infarction (heart attack) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q11g$Data_Value~q11g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q11g$Data_Value by q11g$Break_Out
## t = 5.4716, df = 622, p-value = 6.471e-08
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  0.3517808 0.7456551
## sample estimates:
## mean in group Female   mean in group Male 
##             7.323077             6.774359
q22g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among cerebrovascular disease (stroke) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q22g$Data_Value~q22g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q22g$Data_Value by q22g$Break_Out
## t = 4.6047, df = 622, p-value = 5.011e-06
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  0.3545928 0.8819457
## sample estimates:
## mean in group Female   mean in group Male 
##             6.882692             6.264423
q33g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among coronary heart disease hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q33g$Data_Value~q33g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q33g$Data_Value by q33g$Break_Out
## t = 11.678, df = 622, p-value < 2.2e-16
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  0.7694554 1.0805446
## sample estimates:
## mean in group Female   mean in group Male 
##              5.79391              4.86891
q44g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among diseases of the heart (heart disease) hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q44g$Data_Value~q44g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q44g$Data_Value by q44g$Break_Out
## t = -4.3434, df = 622, p-value = 1.638e-05
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -0.3783907 -0.1427632
## sample estimates:
## mean in group Female   mean in group Male 
##             4.424038             4.684615
q55g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among heart failure hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q55g$Data_Value~q55g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q55g$Data_Value by q55g$Break_Out
## t = -3.4935, df = 622, p-value = 0.0005106
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -0.7770576 -0.2178142
## sample estimates:
## mean in group Female   mean in group Male 
##             4.209936             4.707372
q66g<-dataset%>%filter(Question=="Prevalence of in-hospital mortality among major cardiovascular disease hospitalizations, Medicare Fee-For-Service beneficiaries (65+); CMS Medicare")%>%filter(Break_Out_Category=="Gender")
t.test(q66g$Data_Value~q66g$Break_Out, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  q66g$Data_Value by q66g$Break_Out
## t = 0.25808, df = 622, p-value = 0.7964
## alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
## 95 percent confidence interval:
##  -0.1186246  0.1545221
## sample estimates:
## mean in group Female   mean in group Male 
##             5.053205             5.035256