Spreadsheet Modeling Exam 1 Questions And Answers

Spreadsheet Modeling Exam 1
Questions And Answers
3tcomponentstoftBAt-tCORRECTttANSWER-DescriptivetAnalytics
PredictivetAnalytics
PrescriptivetAnalytics

3tcomponentstoftDSSt-tCORRECTttANSWER-DatatManagement
Modeltmanagement
CommunicationtSystem

3ttypestoftinputstintatDecisiontModelt-tCORRECTttANSWER-Data
UncontrollabletVariables
DecisiontVariables

AbsolutetReferencet-tCORRECTttANSWER-
Usestthetdollartsigntbeforeteithertthetrowtortcolumntlabeltortbotht$A$4

Algorithmt-tCORRECTttANSWER-Atsystematictproceduretthattfindstatsolutionttotatproblem

ANDtFunctiont-tCORRECTttANSWER-
AtlogicaltfunctiontthattreturnstTRUEtiftalltconditionstarettruetandtFALSEtiftnot

BigtDatat-tCORRECTttANSWER-
Thetmassivetamountstoftbusinesstdatatfromtatwidetvarietytoftsources,tmuchtoftwhichtistavail
abletintrealttime,tandtmuchtoftwhichtistuncertaintandtunpredictable

BigtDatatcharacteristicstbytIBMt(4)t-tCORRECTttANSWER-Volume
Variety
Velocity
Veracity

Branchest-tCORRECTttANSWER-Arrowstontantinfluencetdiagram

BusinesstAnalyticst-tCORRECTttANSWER-
Thetusetoftdata,tinformationttechnology,tstatisticaltanalysis,tquantitativetmethods,tandtmath
ematicaltortcomputer-
basedtmodelsttothelptmanagerstgaintimprovedtinsighttaboutttheirtbusinesstoperationstandt
maketbettertfact-

, basedtdecisions.t"Thetprocesstofttransformingtdatatintotactionstthroughtanalysistandtinsight
stintthetcontexttoftorganizationaltdecisiontmakingtandtproblem-solbing.

BusinesstIntelligencet-tCORRECTttANSWER-
Thetcollection,tmanagement,tanalysistandtreportingtoftdata,tattermtcoinedtbytIBMtresearche
rtLuhn.tBItcantanswertsimpletquestions.

CategoricaltDatat-tCORRECTttANSWER-
Sortedtintotcategoriest(manager,tsupervisor,tassociate).tCouldtalsotsorttbytregion

CommonttypestoftdecisionstbasedtontBAt(4)t-tCORRECTttANSWER-Pricing
CustomertSegmentation
Merchandising
Location

CommunicationtSystemt-tCORRECTttANSWER-
Providestthetinterfacetnecessarytfortthetuserttotinteracttwithtthetdatatandtmodeltmanagemen
ttcomponents

Continuoustmetrict-tCORRECTttANSWER-
Basedtontatcontinuoustscaletoftatmeasurement.tAnythingtwithtdollars,tlength,ttime,tvolumeto
rtweight

Datat-tCORRECTttANSWER-
Numericaltfactstandtfigurestthattaretcollectedtthroughtsomettypetoftmeasurementtprocess

Datatcantbetcategorizedtintot4tgroupst-tCORRECTttANSWER-Categorical
Ordinal
Interval
Ratio

DatatintDecisiontModelst-tCORRECTttANSWER-Constant

DatatManagementt-tCORRECTttANSWER-
Includestdatabasestfortstoringtdatatandtallowstthetuserttotinput,tretrieve,tupdatetandtmanipul
atetdata

DatatMiningt-tCORRECTttANSWER-
Bettertunderstandingtcharacteristicstandtpatternstamongtvariablestintlargetdatabasestusing
tatvarietytoftstatisticaltandtanalyticalttools




DatatSett-tCORRECTttANSWER-Atcollectiontoftdata

Databaset-tCORRECTttANSWER-
Atcollectiontoftrelatedtfilestcontainingtrecordstontpeople,tplaces,tortthingst(entities)