Number 1 Number 2 SUM SUBTRACT MULTIPLY DIVIDE Absolute

6 4 10 2 24 1.5 2
3 2 5 1 6 1.5 1
1 2 3 -1 2 0.5 1
6 4 10 2 24 1.5 2
11 15 26 -4 165 0.733333 4
15 6 21 9 90 2.5 9
Student No Student Name Maths Physics Chemistry Computer Science SUM
1 Raja 199 155 154 192 700
2 Ravi 185 166 147 187 685
3 Vijay 195 189 169 177 730
4 Manoj 145 188 147 198 678
5 Sundar 198 169 187 176 730

Maximum 199 189 187 198

Minimum 145 155 147 176
Mean 184.4 173.4 160.8 186
Median 195 169 154 187
Mode #VALUE! #VALUE! 147 #VALUE!
Variance 515.8 217.3 295.2 90.5
Standard Deviation 22.71123 14.7411 17.1813853 9.51314879522022
AVERAGE
175
171.25
182.5
169.5
182.5
Student Name Gender Attendance Assignment Mid term
Raja M 9 12 19
Ravi M 13 11 12
Vijaya F 8 8 12
Manoj M 3 14 14
Sundari F 3 4 15
Final Total Description
Exercise 8: In
50 81 PASS midterm and
34 57 PASS
55 75 PASS
marks. Studen
41 69 PASS 50. Display the
20 39 FAIL

45
Exercise 8: In this problem you are given the name, gender, attendance,
midterm and final grades of five students. Find the total of the
marks. Students who pass need to have a total score greater than
50. Display the word "Pass" or "Fail" under a column called Description
er, attendance, assignment,
total of the assessment
greater than or equal to
Description
Student Name Gender Attendance Assignment Mid term Final
Raja M 9 12 19 50
Ravi M 13 11 12 34
Vijaya F 8 8 12 50
Manoj M 3 14 14 41
Sundari F 3 4 15 20
Siva M 8 14 20 49
Mani M 7 15 17 48
Ram M 12 12 18 44
Jegan M 14 10 17 37

Marks Range Grade

Score > =90 S
89 > Score >=80 A
79 > Score >=70 B
69 > Score >=60 C
59 > Score >=55 D
54 > Score >=50 E
Score < 50 F
Total Description Description Grade
81 pass pass a
Exercise 9: Extend
57 pass pass d also. A student pas
70 pass pass b
69 fail fail c he has a total greate
39 fail fail f
83 pass pass a
80 fail fail a
74 pass pass b
64 pass pass c
Exercise 10: In the
passing, calculate
below:
rcise 9: Extend the above pass/fail computation problem to include atten
A student passes if he has an attendance greater than 8 else he fails ev
as a total greater than 50

cise 10: In the previous problem, without considering attendance as criteri

ing, calculate the grades of the students as per the grade rule table g
w:
 to include attendance
else he fails even if

ndance as criteria for

ade rule table given
Name Age Minor Major Middle Aged
John 25 TRUE 0
Will 17 FALSE FALSE
Kins 45 FALSE FALSE
mark 18 TRUE FALSE
Mac 85 FALSE FALSE
Uno 100 FALSE FALSE
Fiene 23 TRUE FALSE
Jane 54 FALSE FALSE
Nero 42 FALSE FALSE
ander 34 FALSE FALSE
Dana 15 FALSE FALSE
Mike 55 FALSE FALSE
Tina 23 TRUE FALSE
Kate 32 FALSE FALSE
aeorae 55 FALSE FALSE
watson 22 TRUE FALSE
Clara 66 FALSE FALSE
Kile 16 FALSE FALSE
venna 51 FALSE FALSE
Kvle 54 FALSE FALSE
 Exercise 11: You
count the number
middle aged(26-4
using a single fun
conditions.

Exercise 11: You are given

Above Middle Aged Senior Citizen count the number of p
FALSE middle aged(26-40), abo
FALSE using a single function f
FALSE conditions.
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Exercise 11: You are given a file containing the name and age of people. Yo
count the number of people in each category as minor(<18), major(18-25),
middle aged(26-40), above middle age (40-60) and senior citizen (61-100)
using a single function for each scenario and print the count pertaining to the
conditions.

11: You are given a file containing the name and age of people. You have
e number of people in each category as minor(<18), major(18-25
aged(26-40), above middle age (40-60) and senior citizen (61-1
single function for each scenario and print the count pertaining to t
s.

Category Counts
Minor 3
Major 17

Middle Aged 5

Above middle size

Senior Citizen
Total 25
 age of people. You have to
8), major(18-25),
citizen (61-100)
nt pertaining to the 3 17 5

COUNTIF(E6:E25,"TRUE")

AND(D6>=18,D6<=25)

people. You have to

<18), major(18-25),
or citizen (61-100)
nt pertaining to the
Product Supplier Quantity
Cherries John 200 Products Quantity
Bananas Mike 350 Apples 410
Apples Peter 180 Bananas 600
Oranges Mike 400 Oranges 400
Bananas John 250 Cherries 530
Apples Mike 120
Cherries John 330
Apples Peter 110
 Exercise 12:Consider a table containing the consignm
different suppliers as shown in the figure below. You ha
A, supplier’s names in column B, and quantity in col
quantities of each fruit is received.

supplier Quantity product quantity round off

Jhon 0 apples 136.6667 137
Mike 0 bananas 300 300
Peter 0 oranges 400 400
cherries 265 265
ng the consignments of different fruits from
re below. You have the fruit names in column
quantity in column C. Find out how many
Stationery Order For The Month Of March
Description Quantitv Cost Per hem TC VAT
Note Pad 202 2.85 575.7 57.57
Hiqhhqhter Pen 280 2.95 826 82.6
Ball Point Pen Blue (oktl 520 2.5 1300 130
Ball Point Pen Red rnktl 340 2.5 850 85
Ball Point Pen Green fokt) 250 2.5 625 62.5
Exercise Book 1B 35 4.95 173.25 17.325
Cello-taoe 75 2.95 221.25 22.125
Manila Folders 100 2.95 295 29.5
A4 Refill Pad 90 5.95 535.5 53.55
Writina Pad 86 3.95 339.7 33.97
PencilSharpeners 110 0.95 104.5 10.45
Cravons (pkt) 80 3.85 308 30.8
Pencils 603 0.5 301.5 30.15
Colour Pencils rokl) 50 2.95 147.5 14.75
Felt Pens (pkt) 40 3.95 158 15.8
Staoles oktl 75 3.5 262.5 26.25
Staoler 30 9.95 298.5 29.85
Hole Punch 25 14.95 373.75 37.375
Rina Binder 45 10.95 492.75 49.275

Total Cost 9007.24

TC + VAT
633.27
908.60
1430.00
935.00
687.50
190.58
243.38 VAT= 10
324.50
589.05
373.67
114.95
338.80
331.65
162.25
173.80
288.75
328.35
411.13
542.03
28 37 26 Calculate the Determina
10 5 1 Matrix Multiplication
35 42 34

1 -3 -2
2 0 1 -1331

2 1 28 10
-2 -1 37 5
3 0 26 1

-0.096168 0.124718
0.229151 -0.031555
-0.184072 -0.089406

#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
ate the Determinant, Transpose, Inverse
x Multiplication

Err:502 Err:502

35 1 2 2
42 -3 0 1
34 -2 1

0.069872 Err:502 Err:502

-0.174305
0.172802

#NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME?
 -2 3
-1 0

#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
 Column 1 Column 2 Column 3
Column 1 9.2
Column 2 40 1000
Column 3 27.8 164 88
 X Y Z
Height Score Age
64 580 29
66 570 33
68 590 37
69 660 46 Height
73 600 55 Height 9.2
Score 40
Age 27.8
 Construct the variance-covariance matrix
Construct the correlation matrix

Score Age Height Score Age

40 27.8 Height 1
1000 164 Score 0.417029 1
164 88 Age 0.977034 0.55284389 1

X Y x-xbar y- ybar
Height Score
64 580 -4 -20
66 570 -2 -30
68 590 0 -10
69 660 1 60
73 600 5 0
(x-xbar)(y-ybar) (x-xbar)^2 (y-ybar)^2 covariance

80 16 400 20
60 4 900 15
0 0 100 0
60 1 3600 15
0 25 0 0
200 46 5000
Use Simple Linear Regression Line to estimate the increase in sa

Annual percentage
Annual percentage
Increase in Increase in Sales
FIRMS Advertising Revenue
Expenditure

A 1 1
B 3 2
C 4 2
D 6 4
E 8 6
F 9 8
G 11 8
H 14 9
te the increase in sales revenue expected from an increase of 7.5 percent in advertis

Dominant Vertical
Year specialization integration

(X1) (X2)
1974-75 70.58 22.03
1975-76 75.39 21.93
1976-77 74.43 23.6
1977-78 73.51 21.27
1978-79 74.78 20.04
1979-80 71.73 19.34
1980-81 72.34 18.27
1981-82 73.14 18.91
1982-83 76.31 17.33
1983-84 75.4 17.72
1984-85 75.37 18.76
1985-86 73.03 18.32
1986-87 74.66 17.56
1987-88 77.51 16.79
1988-89 77.32 17.76
1989-90 77.3 18.14
f 7.5 percent in advertising expenditure

Import R&D intensity Export Capital Post-tax profit

dependence competitiveness intensity margin

(X3) (X4) (X5) (X6) (Y)

18.29 1.48 3.61 4.3 1.27
18.56 1.7 4.38 4.71 1.39
16.77 1.81 5.88 4.63 3.2
15.16 1.77 7.8 4.48 3.12
15.43 1.96 6.92 4.1 3.19
16.92 2.62 6.11 4 3.28
17.92 3.39 5.31 3.75 4.41
16.06 2.97 5.18 3.64 5.06
15.93 2.12 5.63 3.85 4.17
15.52 1.88 4.11 3.9 3.27
14.23 2.6 4.49 3.91 3.41
16.03 2.16 3.37 3.9 2.52
17.35 1.6 2.64 3.96 1.08
16.44 1.84 2.91 4 1.16
16.04 1.6 3.4 3.62 2.24
15.34 1.94 4.38 3.73 3.06
Stationery Order For The Month Of March
Description Quantitv Cost Per hem
Note Pad 202 2.85
Hiqhhqhter Pen 280 2.95
Ball Point Pen Blue (oktl 520 2.5
Ball Point Pen Red rnktl 340 2.5
Ball Point Pen Green fokt) 250 2.5
Exercise Book 1B 35 4.95
Cello-taoe 75 2.95
Manila Folders 100 2.95
A4 Refill Pad 90 5.95
Writina Pad 86 3.95
PencilSharpeners 110 0.95
Cravons (pkt) 80 3.85
Pencils 603 0.5
Colour Pencils rokl) 50 2.95
Felt Pens (pkt) 40 3.95
Staoles oktl 75 3.5
Staoler 30 9.95
Hole Punch 25 14.95
Rina Binder 45 10.95

Countries RedMeat WhiteMeat

Albania 10.1 1.4
Austria 8.9 14
Belgium 13.5 9.3
Bulgaria 7.8 6
Czechoslovakia 9.7 11.4
Denmark 10.6 10.8
E Germany 8.4 11.6
Finland 9.5 4.9
France 18 9.9
Greece 10.2 3
Hungary 5.3 12.4
Ireland 13.9 10
Italy 9 5.1
Netherlands 9.5 13.6
Norway 9.4 4.7
Poland 6.9 10.2
Portugal 6.2 3.7
Romania 6.2 6.3
Spain 7.1 3.4
Sweden 9.9 7.8
Switzerland 13.1 10.1
UK 17.4 5.7
USSR 9.3 4.6
W Germany 11.4 12.5
Yugoslavia 4.4 5
 Line chart
700
600
500
400
300
200
100
0
d n tl tl t) B e rs d d rs t) ls l) t) tl r h r
Pa r Pe (ok rnk fok k 1 -tao lde l Pa Pa ne (pk nci rok (pk ok aole unc inde
e
t te e o
d n o lo Fo fi l n a pe e
s P ils ns les St e P B
No hqh Blu n Re ree e B Cel ila Re riti har von nc Pe ao l a
n
h e Pe n rc G i s n A 4 W i l S ra Pe elt St Ho Rin
q a c C r
Hi nt P int Pe Exe M n ou F
oi Po int Pe ol
P C
ll all Po
B a B all
B

Bar Chart
700
600
500
400
300
200
100
0
d n tl tl t) B e rs d d rs t) ls l) t) tl r h r
Pa r Pe (ok rnk fok k 1 -tao lde l Pa Pa ne (pk nci rok (pk ok aole unc inde
e o o l a e e s s t P
ot te e d n o lo F fi
N hqh Blu n Re ree e B Cel ila Re riti har von
n p s P il ns le S le a B
s 4 S a e nc Pe tao Ho Rin
h n e G i n W l r P l t S
q e P n rc a A ci C r Fe
Hi nt P int Pe Exe M n
lo
u
oi Po int Pe
Co
l l P all Po
B a B all
B

Eggs Milk Fish Cereal Starch Nuts FruitVeg

0.5 8.9 0.2 42.3 0.6 5.5 1.7
4.3 19.9 2.1 28 3.6 1.3 4.3
4.1 17.5 4.5 26.6 5.7 2.1 4
1.6 8.3 1.2 56.7 1.1 3.7 4.2
2.8 12.5 2 34.3 5 1.1 4
3.7 25 9.9 21.9 4.8 0.7 2.4
3.7 11.1 5.4 24.6 6.5 0.8 3.6
2.7 33.7 5.8 26.3 5.1 1 1.4
3.3 19.5 5.7 28.1 4.8 2.4 6.5
2.8 17.6 5.9 41.7 2.2 7.8 6.5
2.9 9.7 0.3 40.1 4 5.4 4.2
4.7 25.8 2.2 24 6.2 1.6 2.9
2.9 13.7 3.4 36.8 2.1 4.3 6.7
3.6 23.4 2.5 22.4 4.2 1.8 3.7
2.7 23.3 9.7 23 4.6 1.6 2.7
2.7 19.3 3 36.1 5.9 2 6.6
1.1 4.9 14.2 27 5.9 4.7 7.9
1.5 11.1 1 49.6 3.1 5.3 2.8
3.1 8.6 7 29.2 5.7 5.9 7.2
3.5 4.7 7.5 19.5 3.7 1.4 2
3.1 23.8 2.3 25.6 2.8 2.4 4.9
4.7 20.6 4.3 24.3 4.7 3.4 3.3
2.1 16.6 3 43.6 6.4 3.4 2.9
4.1 18.8 3.4 18.6 5.2 1.5 3.8
1.2 9.5 0.6 55.9 3 5.7 3.2
 Pie chart

Note Pad Hiqhhqhter Pen Ball Point Pen Blue (oktl Ball Point Pen Red rnktl Ball Point
Exercise Book 1B Cello-taoe Manila Folders A4 Refill Pad Writina Pa
PencilSharpeners Cravons (pkt) Pencils Colour Pencils rokl) Felt Pens
Staoles oktl Staoler Hole Punch Rina Binder
all Point Pen Red rnktl Ball Point Pen Green fokt)
4 Refill Pad Writina Pad
olour Pencils rokl) Felt Pens (pkt)
ina Binder