Load worldrecord.csv and answer the
following?
worldrecord <- read.csv(file.choose(), header=TRUE)
- How many different types of events (e.g.
“Mens 100m”, “Womens shotput” etc) are
represented in the dataset
names(worldrecord)
[1] "Event" "Type" "Record" "Athlete"
[5] "Nationality" "Location" "Year"
- In what year did Usain Bolt first break the
world record for the Men’s 100m?
2008
- Which variable tells us the record setting time
or distance? The variable name in the data set is? What type of the variable is this?
“Record”, numerical
- Create a subset of the dataset that contains
only the world record cases for men’s shotput and women’s shotput
- Create a scatter plot of the year and record shotput distance one for men and one for
women.
plot(subset(worldrecord, Event == "Mens Shotput",select = c("Year", "Record")))


- Find the average/mean time for each event. How many athletes have time more than
average in each event.
mean(worldrecord$Record)
[1] 69.60396
- Select the athlete who took most time in men’s
100m and women’s event.
worldrecord_sub2<-worldrecord[c(2:18),c(3,4), ]
worldrecord_sub2
worldrecord_sub3<-worldrecord[c(19:28),c(3,4), ]
worldrecord_sub3
- Which country won maximum times of men’s
100m event?
worldrecord_sub2<-worldrecord[c(19:28),c(5), ]
worldrecord_sub2
[1] \xe6East Germany \xe6West Germany \xe6West Germany
[4] \xe6East Germany \xe6East Germany \xe6East Germany
[7] \xe6United States \xe6United States \xe6United States
[10] USA
44 Levels: \xe6Algeria \xe6Australia ... YUG
- How many athletes are there in each event?
tally(~Athlete, data=worldecord, margins = TRUE)
Error in tally(~Athlete, data = worldecord, margins = TRUE) :
could not find function "tally"
- Which country has maximum wins?
LS0tCnRpdGxlOiAnQXNzaWdubWVudCAjNCcKb3V0cHV0OgogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQKICBwZGZfZG9jdW1lbnQ6IGRlZmF1bHQKICB3b3JkX2RvY3VtZW50OiBkZWZhdWx0Ci0tLQpMb2FkCSB3b3JsZHJlY29yZC5jc3YJIGFuZAkgYW5zd2VyCSB0aGUJCmZvbGxvd2luZz8KYGBge3J9CndvcmxkcmVjb3JkIDwtIHJlYWQuY3N2KGZpbGUuY2hvb3NlKCksIGhlYWRlcj1UUlVFKQpgYGAKCjEuIEhvdwkgbWFueQkgZGlmZmVyZW50CSB0eXBlcwkgb2YJIGV2ZW50cwkgKGUuZy4JCuKAnE1lbnMJIDEwMG3igJ0sCSDigJxXb21lbnMJIHNob3RwdXTigJ0JIGV0YykJIGFyZQkKcmVwcmVzZW50ZWQJaW4JdGhlCWRhdGFzZXQKCmBgYHtyfQpuYW1lcyh3b3JsZHJlY29yZCkKYGBgCgoyLiBJbgkgd2hhdAkgeWVhcgkgZGlkCSBVc2FpbgkgQm9sdAkgZmlyc3QJIGJyZWFrCSB0aGUJCndvcmxkCXJlY29yZAlmb3IJdGhlCU1lbuKAmXMJMTAwbT8KCjIwMDgKCjMuIFdoaWNoCXZhcmlhYmxlCXRlbGxzCXVzCXRoZQlyZWNvcmQJc2V0dGluZwl0aW1lCQpvcglkaXN0YW5jZT8JVGhlCXZhcmlhYmxlCW5hbWUJaW4JdGhlCWRhdGEJc2V0CQppcz8JV2hhdAl0eXBlCW9mCXRoZQl2YXJpYWJsZQlpcwl0aGlzPwoKIlJlY29yZCIsIG51bWVyaWNhbAoKNC4gQ3JlYXRlCSBhCSBzdWJzZXQJIG9mCSB0aGUJIGRhdGFzZXQJIHRoYXQJIGNvbnRhaW5zCQpvbmx5CXRoZQl3b3JsZAlyZWNvcmQJY2FzZXMJZm9yCW1lbuKAmXMJc2hvdHB1dAkKYW5kCXdvbWVu4oCZcwlzaG90cHV0CgpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViPC13b3JsZHJlY29yZFtjKDIwNzoyODYpLGMoMyw3KSBdIAp3b3JsZHJlY29yZF9zdWIKYGBgCgo1LiBDcmVhdGUJIGEJIHNjYXR0ZXIJIHBsb3QJIG9mCSB0aGUJIHllYXIJIGFuZAkgcmVjb3JkCQpzaG90cHV0CSBkaXN0YW5jZQkgb25lCSBmb3IJIG1lbgkgYW5kCSBvbmUJIGZvcgkKd29tZW4uCmBgYHtyfQpwbG90KHN1YnNldCh3b3JsZHJlY29yZCwgRXZlbnQgPT0gIk1lbnMgU2hvdHB1dCIsc2VsZWN0ID0gYygiWWVhciIsICJSZWNvcmQiKSkpCgpgYGAKYGBge3J9CnBsb3Qoc3Vic2V0KHdvcmxkcmVjb3JkLCBFdmVudCA9PSAiV29tZW5zIFNob3RwdXQiLHNlbGVjdCA9IGMoIlllYXIiLCAiUmVjb3JkIikpKQoKYGBgCjYuIEZpbmQJIHRoZQkgYXZlcmFnZS9tZWFuCSAJIHRpbWUJIGZvcgkgZWFjaAkgZXZlbnQuCQpIb3cJIG1hbnkJIGF0aGxldGVzCSBoYXZlCSB0aW1lCSBtb3JlCSB0aGFuCQphdmVyYWdlCWluCWVhY2gJZXZlbnQuCgpgYGB7cn0KbWVhbih3b3JsZHJlY29yZCRSZWNvcmQpCmBgYAoKNy4gU2VsZWN0CXRoZQlhdGhsZXRlCXdobwl0b29rCW1vc3QJdGltZQlpbgltZW7igJlzCQoxMDBtCQlhbmQJd29tZW7igJlzCWV2ZW50LgpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViMjwtd29ybGRyZWNvcmRbYygyOjE4KSxjKDMsNCksIF0gCndvcmxkcmVjb3JkX3N1YjIKYGBgCmBgYHtyfQp3b3JsZHJlY29yZF9zdWIzPC13b3JsZHJlY29yZFtjKDE5OjI4KSxjKDMsNCksIF0gCndvcmxkcmVjb3JkX3N1YjMKYGBgCgoKOC4gV2hpY2gJIGNvdW50cnkJd29uCW1heGltdW0JIHRpbWVzCSBvZgltZW7igJlzCQoxMDBtCWV2ZW50PwpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViMjwtd29ybGRyZWNvcmRbYygxOToyOCksYyg1KSwgXSAKd29ybGRyZWNvcmRfc3ViMgpgYGAKCgo5LiBIb3cJbWFueQlhdGhsZXRlcwlhcmUJdGhlcmUJaW4JZWFjaAlldmVudD8KYGBge3J9CnRhbGx5KH5BdGhsZXRlLCBkYXRhPXdvcmxkZWNvcmQsIG1hcmdpbnMgPSBUUlVFKQpgYGAKCgoxMC4gV2hpY2gJY291bnRyeQloYXMJbWF4aW11bQl3aW5zPwpgYGB7cn0KCmBgYAoK