How do I isolate the mean height of all males vs the mean height off all females

Question

How do I isolate the mean height of all males vs the mean height off all females using R studio from the following dataset so that I can run an independent t-test?

CASE SEX AGE HEIGHT HAIR_COLOUR HAIR_DYE SHOE_SIZE 1 1 Female 22 170 Brown No 9.5 2 2 Female 20 165 Brown Yes 8 3 3 Male 20 168 Brown No 10 4 4 Female 20 170 Brown Yes 8.5 5 5 Male 20 182 Brown No 11 6 6 Male 21 178 Blonde No 9.5 7 7 Female 21 161 Blonde No 9 8 8 Female 20 165 Brown Yes 8 9 9 Female 20 174 Brown Yes 8 10 10 Female 20 152 Brown No 6 11 11 Female 21 175 Brown Yes 8 12 12 Female 20 157 Other Yes 6 13 13 Female 20 167 Red Yes 8 14 14 Female 20 172 Brown No 8 15 15 Female 26 170 Brown No 8.5 16 16 Female 24 160 Brown Yes 7 17 17 Female 20 162 Brown Yes 6 18 18 Female 20 172 Blonde Yes 8 19 19 Female 21 152.4 Blonde No 7.5 20 20 Female 21 165 Red No 9 21 21 Female 20 NA Blonde No 8 22 22 Female 21 170 Brown Yes 9 23 23 Female 21 170 Brown Yes 9 24 24 Female 20 160 Brown No 8 25 25 Female 20 170 Black Yes 8 26 26 Male 24 170 Black No 9 27 27 Female 22 174 Red Yes 11 28 28 Male 28 191 Brown No 11 29 29 Female 20 177.8 Blonde No 11 30 30 Male 20 NA Blonde No 8.5 31 31 Female 20 155 Blonde No 8 32 32 Female 21 151 Brown No 6 33 33 Male 20 164 Black No 8.5 34 34 Female 32 170 Black Yes 9 35 35 Female NA 160 Blonde No 6.5 36 36 Female 25 155 Blonde Yes 7 37 37 Female 19 175 Blonde Yes 7.5 38 38 Female 20 170 Brown No 8.5 39 39 Female 23 152 Blonde No 8 40 40 Female 20 158 Red No 7 41 41 Female 20 155 Brown No 7 42 42 Male 33 185 Brown No 10 43 43 Male 21 183 Brown No 11 44 44 Female 20 NA Brown No 7 45 45 Male 23 180.34 Brown No 10 46 46 Female 21 165 Blonde No 8 47 47 Female 27 160 Other Yes 8 48 48 Male 23 176 Brown No 9 49 49 Female 22 167 Brown No 8 50 50 Female 20 172 Brown No 11.5 51 51 Male 30 180 Brown Yes 13 52 52 Female 20 188 Brown No 9 53 53 Male 21 172 Black No 10.5 54 54 Female 24 170 Red No 8

Explanation / Answer

library(readxl)
Htwtstudents <- read_excel("C:/Htwtstudents.xlsx")
View(Htwtstudents)

library(sqldf)
a <- sqldf("select SEX,count(SEX) as Cnt,avg(HEIGHT) from Htwtstudents group by SEX")
print(a)

output:

SEX Cnt avg(HEIGHT)
1 Female 41 157.4195
2 Male 13 163.7954

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.