Question 1

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

Question 2

new_r1 = c(6, "Kelly", 23, 90)
new_r2 = c(7, "Lisa", 27, 95)
exam_score = rbind(exam_score, new_r1, new_r2)
exam_score

Question 3

Income = c(2000, 5000, 10000, 3000, 1000, 3500, 8000)
exam_score = cbind(exam_score, Income)
exam_score
NA

Question 4

exam_score$Score = as.numeric(exam_score$Score)
exam_score$Age = as.numeric(exam_score$Age)
exam_score$ID = as.numeric(exam_score$ID)


min(exam_score$Age)
[1] 18
min(exam_score$Score)
[1] 55
min(exam_score$Income)
[1] 1000
max(exam_score$Age)
[1] 30
max(exam_score$Score)
[1] 100
max(exam_score$Income)
[1] 10000
median(exam_score$Age)
[1] 23
median(exam_score$Score)
[1] 90
median(exam_score$Income)
[1] 3500
sd(exam_score$Age)
[1] 4.117327
sd(exam_score$Score)
[1] 14.91564
sd(exam_score$Income)
[1] 3275.086
var(exam_score$Age)
[1] 16.95238
var(exam_score$Score)
[1] 222.4762
var(exam_score$Income)
[1] 10726190
quantile(exam_score$Age)
  0%  25%  50%  75% 100% 
  18   21   23   26   30 
quantile(exam_score$Score)
   0%   25%   50%   75%  100% 
 55.0  79.5  90.0  92.5 100.0 
quantile(exam_score$Income)
   0%   25%   50%   75%  100% 
 1000  2500  3500  6500 10000 

Question 5

cor(exam_score$Age, exam_score$Score)
[1] 0.1884212
cor(exam_score$Age, exam_score$Income)
[1] 0.9817195
cor(exam_score$Score, exam_score$Income)
[1] 0.2605157

Question 6

exam_score[exam_score$Score>=80, ]

Question 7

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

Question 8

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