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