Assignment 2
## vector

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)

## 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
NA

## Adding 2 row

exam_score_1=data.frame(
ID =c(1,2,3,4,5,6,7),
Name = c("Alice","Bob","David","John","Jenny","Joey","Rob"),
Age=c(20, 25, 30, 22, 18,35,32),
Score=c(100, 78, 90, 55, 81,85,60)
)
exam_score_1
NA
NA
NA

## Adding a new column

Income=c(50000,100000,60000,55000,70000,80000,67000)
exam_score_1 = cbind(exam_score_1,Income)
exam_score_1

## Finding max of columns Age, Score, and Income

max(Age)
[1] 30
max(Score)
[1] 100
max(Income)
[1] 1e+05

## Finding min of columns Age, Score, and Income

min(Age)
[1] 18
min(Score)
[1] 55
min(Income)
[1] 50000

## Finding median of columns Age, Score, and Income

median(Age)
[1] 22
median(Score)
[1] 81
median(Income)
[1] 67000

## Finding sum of columns Age, Score, and Income

sum(Age)
[1] 115
sum(Score)
[1] 404
sum(Income)
[1] 482000

## Finding standard deviation of columns Age, Score, and Income

sd(Age)
[1] 4.690416
sd(Score)
[1] 16.78392
sd(Income)
[1] 16955.12

## Finding variance of columns Age, Score, and Income

var(Age)
[1] 22
var(Score)
[1] 281.7
var(Income)
[1] 287476190

## Finding quantiles of columns Age, Score, and Income

quantile(Age)
  0%  25%  50%  75% 100% 
  18   20   22   25   30 
quantile(Score)
  0%  25%  50%  75% 100% 
  55   78   81   90  100 
quantile(Income)
    0%    25%    50%    75% 
 50000  57500  67000  75000 
  100% 
100000 

##Correlation between Age and score

cor(Age,Score)
[1] 0.0825674

##Correlation between Age and income

cor(Age,Income)
Error in cor(Age, Income) : incompatible dimensions

##Correlation between Score and income

cor(Score,Income)
Error in cor(Score, Income) : incompatible dimensions

##Selecteing rows where the score is greater than or equal to 80

exam_score_1[exam_score_1$Score>=80, c(1,2,3,4,5)]

##Selecting rows with the age range of 20 to 30

exam_score_1[exam_score_1$Age>=20 & exam_score_1$Age<=30, c(1,2,3,4,5)]
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KIDxmb250IHNpemU9NyA+IEFzc2lnbm1lbnQgMjwvZm9udD5cDQo8Zm9udCBzaXplPTUgPiAjIyB2ZWN0b3I8L2ZvbnQ+ICAgICAgICANCmBgYHtyfQ0KSUQgPWMoMSwyLDMsNCw1KQ0KTmFtZSA9IGMoIkFsaWNlIiwiQm9iIiwiRGF2aWQiLCJKb2huIiwiSmVubnkiKQ0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4KQ0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KSW5jb21lPWMoNTAwMDAsMTAwMDAwLDYwMDAwLDU1MDAwLDcwMDAwLDgwMDAwLDY3MDAwKQ0KYGBgDQoNCg0KPGZvbnQgc2l6ZT01ID4gIyMgRGF0YSBmcmFtZTwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZT1kYXRhLmZyYW1lKA0KSUQgPWMoMSwyLDMsNCw1KSwNCk5hbWUgPSBjKCJBbGljZSIsIkJvYiIsIkRhdmlkIiwiSm9obiIsIkplbm55IiksDQpBZ2U9YygyMCwgMjUsIDMwLCAyMiwgMTgpLA0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KKQ0KZXhhbV9zY29yZQ0KDQpgYGANCjxmb250IHNpemU9NSA+ICMjIEFkZGluZyAyIHJvdzwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZV8xPWRhdGEuZnJhbWUoDQpJRCA9YygxLDIsMyw0LDUsNiw3KSwNCk5hbWUgPSBjKCJBbGljZSIsIkJvYiIsIkRhdmlkIiwiSm9obiIsIkplbm55IiwiSm9leSIsIlJvYiIpLA0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4LDM1LDMyKSwNClNjb3JlPWMoMTAwLCA3OCwgOTAsIDU1LCA4MSw4NSw2MCkNCikNCmV4YW1fc2NvcmVfMQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEFkZGluZyBhIG5ldyBjb2x1bW48L2ZvbnQ+DQpgYGB7cn0NCkluY29tZT1jKDUwMDAwLDEwMDAwMCw2MDAwMCw1NTAwMCw3MDAwMCw4MDAwMCw2NzAwMCkNCmV4YW1fc2NvcmVfMSA9IGNiaW5kKGV4YW1fc2NvcmVfMSxJbmNvbWUpDQpleGFtX3Njb3JlXzENCmBgYA0KDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgbWF4IG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCm1heChBZ2UpDQptYXgoU2NvcmUpDQptYXgoSW5jb21lKQ0KDQpgYGANCg0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIG1pbiBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQptaW4oQWdlKQ0KbWluKFNjb3JlKQ0KbWluKEluY29tZSkNCmBgYA0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIG1lZGlhbiBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQptZWRpYW4oQWdlKQ0KbWVkaWFuKFNjb3JlKQ0KbWVkaWFuKEluY29tZSkNCmBgYA0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIHN1bSBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQpzdW0oQWdlKQ0Kc3VtKFNjb3JlKQ0Kc3VtKEluY29tZSkNCmBgYA0KDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgc3RhbmRhcmQgZGV2aWF0aW9uIG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCnNkKEFnZSkNCnNkKFNjb3JlKQ0Kc2QoSW5jb21lKQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgIHZhcmlhbmNlIG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCnZhcihBZ2UpDQp2YXIoU2NvcmUpDQp2YXIoSW5jb21lKQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgcXVhbnRpbGVzICBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQpxdWFudGlsZShBZ2UpDQoNCnF1YW50aWxlKFNjb3JlKQ0KDQpxdWFudGlsZShJbmNvbWUpDQpgYGANCg0KPGZvbnQgc2l6ZT01ID4gIyNDb3JyZWxhdGlvbiBiZXR3ZWVuIEFnZSBhbmQgc2NvcmU8L2ZvbnQ+DQpgYGB7cn0NCmNvcihBZ2UsU2NvcmUpDQpgYGANCg0KPGZvbnQgc2l6ZT01ID4gIyNDb3JyZWxhdGlvbiBiZXR3ZWVuIEFnZSBhbmQgIGluY29tZTwvZm9udD4NCmBgYHtyfQ0KY29yKEFnZSxJbmNvbWUpDQpgYGANCg0KDQo8Zm9udCBzaXplPTUgPiAjI0NvcnJlbGF0aW9uIGJldHdlZW4gU2NvcmUgYW5kIGluY29tZQ0KPC9mb250Pg0KYGBge3J9DQpjb3IoU2NvcmUsSW5jb21lKQ0KYGBgDQoNCg0KPGZvbnQgc2l6ZT01ID4gIyNTZWxlY3RlaW5nIHJvd3Mgd2hlcmUgdGhlIHNjb3JlIGlzIGdyZWF0ZXIgdGhhbiBvciBlcXVhbCB0byA4MDwvZm9udD4NCg0KYGBge3J9DQpleGFtX3Njb3JlXzFbZXhhbV9zY29yZV8xJFNjb3JlPj04MCwgYygxLDIsMyw0LDUpXQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjU2VsZWN0aW5nIHJvd3Mgd2l0aCB0aGUgYWdlIHJhbmdlIG9mIDIwIHRvIDMwIDwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZV8xW2V4YW1fc2NvcmVfMSRBZ2U+PTIwICYgZXhhbV9zY29yZV8xJEFnZTw9MzAsIGMoMSwyLDMsNCw1KV0NCmBgYA0KDQoNCg0K