Familiarization with Excel - Numerical Methods Laboratory Module 1

)*%ER&!'" %E+-S /&+ !-%*+&) "'B-R'+-R 'cti(ity no. 1

amiliari4ation /it Ecel

Submitted by: Eusebio, Jan Rafael B. 201110356 E!E60"#!11

En$r. %arc !abrera &nstructor

Score

Interpretation of Data

&n tis e7eriment, 8e familiari4ed oursel(es and utili4ed %icrosoft -9ce Ecel as a com7utational macine. %icrosoft Ecel is a s7readseet a77lication tat features calculation, $ra7in$ tools and some 7ro$rammin$ lan$ua$e.

i$ure 1: %icrosoft Ecel /indo8

%icrosoft Ecels functions $reatly benet ma;in$ a class record. ' class record is a record of data, basically com7osed of $rades of students, tat describes e(ery students 7erformance in te class. +ese data are commonly numerical and most of te time it re
Besides 7erformin$ basic aritmetic and matematical functions, modern s7readseets li;e %icrosoft Ecel 7ro(ide built#in functions for common statistical o7erations. %ost of te statistical metods mentioned

abo(e are commonly com7uted 8it suc formulas some are determined by ins7ection. +ose formulas are not len$ty but if used 8it lot of data, te ans8er can be erroneous. ' class record is commonly com7osed of 30 or more students 8it eac student com7osin$ 5 or more eamination $rades. ' metod of 7a7er and 7en is not con(enient enou$ to 7erform tese statistical metods. ortunately, %icrosoft Ecel is not only a basic s7readseet 7ro$ram but it can 7erform di=erent matematical functions tat also include statistics.

'fter te indi(idual $rades are encoded, te data is com7lete. /it te el7 of te %icrosoft Ecel function bar, tose statistical metods can be com7leted. E(ery statistical metods mentioned abo(e can be 7erformed by te %icrosoft Ecel.

i$ure 2: %icrosoft Ecel unction Bar

 +e function bar 8or;s by enterin$ te function and enclosin$ te data to be com7uted. Eac statistical metod as a uni
'lso, te %icrosoft Ecel can con(ert tese data into $ra7ical form by insertin$ cart. &n te &nsert %enu bar, tere is a !arts 8indo8 tat can ma;e us coose 8at ;ind of $ra7 to use. +e users may ad>ust any stored (alue and obser(e te e=ects on te calculated (alues and te cart.

i$ure 3: !arts !om7ared to te 7a7er and 7en metod, %icrosoft Ecel is (ery muc faster and is not 7rone to errors. +e only 7ossible causes of error in usin$ %icrosoft Ecel are ty7o$ra7ical errors and 8ron$ encodin$ of data. Basically, S7readseets a(e re7laced 7a7er#based systems and is normally used in any contet 8ere tabular lists are built and sorted.

Conclusion

•

%icrosoft Ecel is a s7readseet a77lication tat features calculation,

•

$ra7in$ tools and some 7ro$rammin$ lan$ua$e. *sers interact 8it %icrosoft Ecel 7rimarily trou$ cells. %icrosoft Ecel as te basic features of all s7readseets, usin$ a $ri7

•

of cells arran$ed in numbered ro8s and letter#named columns to •

or$ani4e data.  +e ;ey feature of a s7readseet li;e Ecel is te ability for a formula to refer to te contents of oter cells, 8ic may in turn be te result

•

of te formula. &t can dis7lay data as line $ra7s, isto$rams and carts $enerated

•

from s7ecied $rou7s of cells.  +e dis7layed carts are dynamically u7dated if te content of te

•

s7ecied cells can$e.  +is is (ery useful for 8at#if analysis since many cases can be ra7idly

•

in(esti$ated 8itout manual recalculation.  +e users may ad>ust any stored (alue and obser(e te e=ects on te

•

calculated (alues and te cart. %icrosoft Ecel can use a 8ide (ariety of functions included in its

•

7ro$ram. &t can also use user#dened functions 8it ?isual Basic ro$rammin$

•

encry7ted in te soft8are. S7readseets a(e re7laced 7a7er#based systems trou$out te business 8orld.