Business Spreadsheet Modeling Exam #2 Questions And Answers

Business Spreadsheet Modeling Exam
#2 Questions And Answers
3tStepsttotanalyzingtdatat-tCORRECTttANSWER-1)tDescribetthetcurrenttsituation
2)tPredicttthetfuturetsituation
3)tPrescribetspecifictactionsttottake

4tMainttopicstintdatatmanagementt-tCORRECTttANSWER-1)tDatatstructure
2)tTypestoftvariables
3)tDatatexploration
4)tDatatpreparation

6tcharacteristicstfortvariableteliminationt-tCORRECTttANSWER-1)tIrrelevantttotoutcome
2)tExpensivettotcollect
3)tNottavailabletatttimetoftprediction
4)tContainstmanytmissingtvariables
5)tMeasuredtinaccurately
6)tHighlytcorrelatedtwithtothertvariables

6tStepsttotlogicallytexploretdatat-tCORRECTttANSWER-1)tUnderstandtthetdata
2)tOrganizetandtsubsettyourtdata
3)tExaminetindividualtvariablestgraphically
4)tCalculatetsummarytmeasurestfortindividualtvariables
5)Examinetrelationshipstamongtvariablestgraphically
6)tExaminetrelationshipstamongtvariablestnumerically

Allttimetseriestforecasttinvolves?t-tCORRECTttANSWER-
Weightedtaveragestofthistoricaltobservationst(actual).

Base-CasetAnalysist-tCORRECTttANSWER-
Measuringtantoutcometcomparedttotsometcommontpointtoftanalysis.

BreakeventAnalysist-tCORRECTttANSWER-
Findingtthetbreakeventvaluetfortparameters.t(Attwhattpointtwilltthetinputtchangestresulttintatp
ositivetoutcome?)