Load worldrecord.csv and answer the
following?

worldrecord <- read.csv(file.choose(), header=TRUE)
  1. 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"       
  1. In what year did Usain Bolt first break the
    world record for the Men’s 100m?

2008

  1. 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

  1. Create a subset of the dataset that contains
    only the world record cases for men’s shotput and women’s shotput
  1. 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")))

  1. 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
  1. 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
  1. 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
  1. 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"
  1. Which country has maximum wins?
LS0tCnRpdGxlOiAnQXNzaWdubWVudCAjNCcKb3V0cHV0OgogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQKICBwZGZfZG9jdW1lbnQ6IGRlZmF1bHQKICB3b3JkX2RvY3VtZW50OiBkZWZhdWx0Ci0tLQpMb2FkCSB3b3JsZHJlY29yZC5jc3YJIGFuZAkgYW5zd2VyCSB0aGUJCmZvbGxvd2luZz8KYGBge3J9CndvcmxkcmVjb3JkIDwtIHJlYWQuY3N2KGZpbGUuY2hvb3NlKCksIGhlYWRlcj1UUlVFKQpgYGAKCjEuIEhvdwkgbWFueQkgZGlmZmVyZW50CSB0eXBlcwkgb2YJIGV2ZW50cwkgKGUuZy4JCuKAnE1lbnMJIDEwMG3igJ0sCSDigJxXb21lbnMJIHNob3RwdXTigJ0JIGV0YykJIGFyZQkKcmVwcmVzZW50ZWQJaW4JdGhlCWRhdGFzZXQKCmBgYHtyfQpuYW1lcyh3b3JsZHJlY29yZCkKYGBgCgoyLiBJbgkgd2hhdAkgeWVhcgkgZGlkCSBVc2FpbgkgQm9sdAkgZmlyc3QJIGJyZWFrCSB0aGUJCndvcmxkCXJlY29yZAlmb3IJdGhlCU1lbuKAmXMJMTAwbT8KCjIwMDgKCjMuIFdoaWNoCXZhcmlhYmxlCXRlbGxzCXVzCXRoZQlyZWNvcmQJc2V0dGluZwl0aW1lCQpvcglkaXN0YW5jZT8JVGhlCXZhcmlhYmxlCW5hbWUJaW4JdGhlCWRhdGEJc2V0CQppcz8JV2hhdAl0eXBlCW9mCXRoZQl2YXJpYWJsZQlpcwl0aGlzPwoKIlJlY29yZCIsIG51bWVyaWNhbAoKNC4gQ3JlYXRlCSBhCSBzdWJzZXQJIG9mCSB0aGUJIGRhdGFzZXQJIHRoYXQJIGNvbnRhaW5zCQpvbmx5CXRoZQl3b3JsZAlyZWNvcmQJY2FzZXMJZm9yCW1lbuKAmXMJc2hvdHB1dAkKYW5kCXdvbWVu4oCZcwlzaG90cHV0CgpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViPC13b3JsZHJlY29yZFtjKDIwNzoyODYpLGMoMyw3KSBdIAp3b3JsZHJlY29yZF9zdWIKYGBgCgo1LiBDcmVhdGUJIGEJIHNjYXR0ZXIJIHBsb3QJIG9mCSB0aGUJIHllYXIJIGFuZAkgcmVjb3JkCQpzaG90cHV0CSBkaXN0YW5jZQkgb25lCSBmb3IJIG1lbgkgYW5kCSBvbmUJIGZvcgkKd29tZW4uCmBgYHtyfQpwbG90KHN1YnNldCh3b3JsZHJlY29yZCwgRXZlbnQgPT0gIk1lbnMgU2hvdHB1dCIsc2VsZWN0ID0gYygiWWVhciIsICJSZWNvcmQiKSkpCgpgYGAKYGBge3J9CnBsb3Qoc3Vic2V0KHdvcmxkcmVjb3JkLCBFdmVudCA9PSAiV29tZW5zIFNob3RwdXQiLHNlbGVjdCA9IGMoIlllYXIiLCAiUmVjb3JkIikpKQoKYGBgCjYuIEZpbmQJIHRoZQkgYXZlcmFnZS9tZWFuCSAJIHRpbWUJIGZvcgkgZWFjaAkgZXZlbnQuCQpIb3cJIG1hbnkJIGF0aGxldGVzCSBoYXZlCSB0aW1lCSBtb3JlCSB0aGFuCQphdmVyYWdlCWluCWVhY2gJZXZlbnQuCgpgYGB7cn0KbWVhbih3b3JsZHJlY29yZCRSZWNvcmQpCmBgYAoKNy4gU2VsZWN0CXRoZQlhdGhsZXRlCXdobwl0b29rCW1vc3QJdGltZQlpbgltZW7igJlzCQoxMDBtCQlhbmQJd29tZW7igJlzCWV2ZW50LgpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViMjwtd29ybGRyZWNvcmRbYygyOjE4KSxjKDMsNCksIF0gCndvcmxkcmVjb3JkX3N1YjIKYGBgCmBgYHtyfQp3b3JsZHJlY29yZF9zdWIzPC13b3JsZHJlY29yZFtjKDE5OjI4KSxjKDMsNCksIF0gCndvcmxkcmVjb3JkX3N1YjMKYGBgCgoKOC4gV2hpY2gJIGNvdW50cnkJd29uCW1heGltdW0JIHRpbWVzCSBvZgltZW7igJlzCQoxMDBtCWV2ZW50PwpgYGB7cn0Kd29ybGRyZWNvcmRfc3ViMjwtd29ybGRyZWNvcmRbYygxOToyOCksYyg1KSwgXSAKd29ybGRyZWNvcmRfc3ViMgpgYGAKCgo5LiBIb3cJbWFueQlhdGhsZXRlcwlhcmUJdGhlcmUJaW4JZWFjaAlldmVudD8KYGBge3J9CnRhbGx5KH5BdGhsZXRlLCBkYXRhPXdvcmxkZWNvcmQsIG1hcmdpbnMgPSBUUlVFKQpgYGAKCgoxMC4gV2hpY2gJY291bnRyeQloYXMJbWF4aW11bQl3aW5zPwpgYGB7cn0KCmBgYAoK