1.Create this data frame.

exam_score = data.frame(
  ID = c(1, 2, 3, 4, 5),
  Name = c("Alice", "Bob", "David", "John", "Jenny"),
  Age = c(20, 25, 30, 22, 18),
  Score = c(100, 78, 90, 55, 81)
)
exam_score

2.Add 2 new rows

new_row1 = c("6","Max","23","85")
new_row2 = c("7","Alex","28","80")
exam_score = rbind(exam_score,new_row1,new_row2)
exam_score

3.Add a new column called “Income”. This column should be numerical.

Income = c("5000","5870","6000","6564","7000","9800","6500")
exam_score = cbind(exam_score, Income)
exam_score

4.Find max, min, median, sum, mean, standard deviation, variance, and quantiles of columns Age, Score, and Income.

max(exam_score$Age)
[1] "30"
min(exam_score$Age)
[1] "18"
median(exam_score$Age)
[1] "23"
exam_score$Age <- as.numeric(as.character(exam_score$Age))
sum(exam_score$Age)
[1] 166
sd(exam_score$Age)
[1] 4.270608
var(exam_score$Age)
[1] 18.2381
quantile(exam_score$Age)
  0%  25%  50%  75% 100% 
18.0 21.0 23.0 26.5 30.0 
max(exam_score$Score)
[1] "90"
min(exam_score$Score)
[1] "100"
median(exam_score$Score)
[1] "80"
exam_score$Score <- as.numeric(as.character(exam_score$Score))
sum(exam_score$Score)
[1] 569
sd(exam_score$Score)
[1] 13.80476
var(exam_score$Score)
[1] 190.5714
quantile(exam_score$Score)
   0%   25%   50%   75%  100% 
 55.0  79.0  81.0  87.5 100.0 
max(exam_score$Income)
[1] 9800
min(exam_score$Income)
[1] 5000
median(exam_score$Income)
[1] 6500
exam_score$Income <- as.numeric(as.character(exam_score$Income))
sum(exam_score$Income)
[1] 46734
sd(exam_score$Income)
[1] 1517.864
var(exam_score$Income)
[1] 2303910
quantile(exam_score$Income)
  0%  25%  50%  75% 100% 
5000 5935 6500 6782 9800 

5.Find correlation between

(a)Age and score

(b)Age and income

(c)Score and income

cor(exam_score$Age,exam_score$Score)
[1] 0.05532898
cor(exam_score$Age,exam_score$Income)
[1] -0.09527187
cor(exam_score$Score,exam_score$Income)
[1] -0.1584965

6.Select rows where the score is greater than or equal to 80

exam_score[exam_score$Score >=80, ]

7.Select rows with the age range of 20 to 30

exam_score[exam_score$Age >=20 & exam_score$Age<=30, ]

8.Select rows with age 22, 25, and 30.

exam_score[exam_score$Age ==22 | exam_score$Age ==25 | exam_score$Age ==30, ]
LS0tDQp0aXRsZTogIkFzc2lnbm1lbnQgMihBZG5hbiBaYWhpZCBSaW9uKSINCm91dHB1dDogaHRtbF9ub3RlYm9vaw0KLS0tDQojIyAxLkNyZWF0ZSB0aGlzIGRhdGEgZnJhbWUuIA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUgPSBkYXRhLmZyYW1lKA0KICBJRCA9IGMoMSwgMiwgMywgNCwgNSksDQogIE5hbWUgPSBjKCJBbGljZSIsICJCb2IiLCAiRGF2aWQiLCAiSm9obiIsICJKZW5ueSIpLA0KICBBZ2UgPSBjKDIwLCAyNSwgMzAsIDIyLCAxOCksDQogIFNjb3JlID0gYygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KKQ0KZXhhbV9zY29yZQ0KYGBgDQoNCiMjIDIuQWRkIDIgbmV3IHJvd3MNCg0KYGBge3J9DQpuZXdfcm93MSA9IGMoIjYiLCJNYXgiLCIyMyIsIjg1IikNCm5ld19yb3cyID0gYygiNyIsIkFsZXgiLCIyOCIsIjgwIikNCmV4YW1fc2NvcmUgPSByYmluZChleGFtX3Njb3JlLG5ld19yb3cxLG5ld19yb3cyKQ0KZXhhbV9zY29yZQ0KYGBgDQoNCiMjIDMuQWRkIGEgbmV3IGNvbHVtbiBjYWxsZWQg4oCcSW5jb21l4oCdLiBUaGlzIGNvbHVtbiBzaG91bGQgYmUgbnVtZXJpY2FsLiANCg0KYGBge3J9DQpJbmNvbWUgPSBjKCI1MDAwIiwiNTg3MCIsIjYwMDAiLCI2NTY0IiwiNzAwMCIsIjk4MDAiLCI2NTAwIikNCmV4YW1fc2NvcmUgPSBjYmluZChleGFtX3Njb3JlLCBJbmNvbWUpDQpleGFtX3Njb3JlDQpgYGANCg0KIyMgNC5GaW5kIG1heCwgbWluLCBtZWRpYW4sIHN1bSwgbWVhbiwgc3RhbmRhcmQgZGV2aWF0aW9uLCB2YXJpYW5jZSwgYW5kIHF1YW50aWxlcyBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUuIA0KDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJEFnZSkNCm1pbihleGFtX3Njb3JlJEFnZSkNCm1lZGlhbihleGFtX3Njb3JlJEFnZSkNCmV4YW1fc2NvcmUkQWdlIDwtIGFzLm51bWVyaWMoYXMuY2hhcmFjdGVyKGV4YW1fc2NvcmUkQWdlKSkNCnN1bShleGFtX3Njb3JlJEFnZSkNCnNkKGV4YW1fc2NvcmUkQWdlKQ0KdmFyKGV4YW1fc2NvcmUkQWdlKQ0KcXVhbnRpbGUoZXhhbV9zY29yZSRBZ2UpDQoNCmBgYA0KDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJFNjb3JlKQ0KbWluKGV4YW1fc2NvcmUkU2NvcmUpDQptZWRpYW4oZXhhbV9zY29yZSRTY29yZSkNCmV4YW1fc2NvcmUkU2NvcmUgPC0gYXMubnVtZXJpYyhhcy5jaGFyYWN0ZXIoZXhhbV9zY29yZSRTY29yZSkpDQpzdW0oZXhhbV9zY29yZSRTY29yZSkNCnNkKGV4YW1fc2NvcmUkU2NvcmUpDQp2YXIoZXhhbV9zY29yZSRTY29yZSkNCnF1YW50aWxlKGV4YW1fc2NvcmUkU2NvcmUpDQpgYGANCg0KYGBge3J9DQptYXgoZXhhbV9zY29yZSRJbmNvbWUpDQptaW4oZXhhbV9zY29yZSRJbmNvbWUpDQptZWRpYW4oZXhhbV9zY29yZSRJbmNvbWUpDQpleGFtX3Njb3JlJEluY29tZSA8LSBhcy5udW1lcmljKGFzLmNoYXJhY3RlcihleGFtX3Njb3JlJEluY29tZSkpDQpzdW0oZXhhbV9zY29yZSRJbmNvbWUpDQpzZChleGFtX3Njb3JlJEluY29tZSkNCnZhcihleGFtX3Njb3JlJEluY29tZSkNCnF1YW50aWxlKGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQoNCiMjIDUuRmluZCBjb3JyZWxhdGlvbiBiZXR3ZWVuIA0KIyMjIChhKUFnZSBhbmQgc2NvcmUgDQojIyMgKGIpQWdlIGFuZCBpbmNvbWUNCiMjIyAoYylTY29yZSBhbmQgaW5jb21lDQoNCmBgYHtyfQ0KY29yKGV4YW1fc2NvcmUkQWdlLGV4YW1fc2NvcmUkU2NvcmUpDQpgYGANCmBgYHtyfQ0KY29yKGV4YW1fc2NvcmUkQWdlLGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQpgYGB7cn0NCmNvcihleGFtX3Njb3JlJFNjb3JlLGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQojIyA2LlNlbGVjdCByb3dzIHdoZXJlIHRoZSBzY29yZSBpcyBncmVhdGVyIHRoYW4gb3IgZXF1YWwgdG8gODANCg0KYGBge3J9DQpleGFtX3Njb3JlW2V4YW1fc2NvcmUkU2NvcmUgPj04MCwgXQ0KYGBgDQojIyA3LlNlbGVjdCByb3dzIHdpdGggdGhlIGFnZSByYW5nZSBvZiAyMCB0byAzMA0KDQpgYGB7cn0NCmV4YW1fc2NvcmVbZXhhbV9zY29yZSRBZ2UgPj0yMCAmIGV4YW1fc2NvcmUkQWdlPD0zMCwgXQ0KYGBgDQojIyA4LlNlbGVjdCByb3dzIHdpdGggYWdlIDIyLCAyNSwgYW5kIDMwLg0KDQpgYGB7cn0NCmV4YW1fc2NvcmVbZXhhbV9zY29yZSRBZ2UgPT0yMiB8IGV4YW1fc2NvcmUkQWdlID09MjUgfCBleGFtX3Njb3JlJEFnZSA9PTMwLCBdDQpgYGANCg0K