BSIS FINAL EXAM QUESTIONS WITH COMPLETE SOLUTIONS

BSIS FINAL EXAM QUESTIONS WITH COMPLETE
SOLUTIONS

Simple |linear |regression |refers |to |the |type |of |regression |analysis |for |which |the |relationship |
between |the |independent |variable |and |dependent |variable |are |approximated |by |a(n) |- |
CORRECT |ANSWER✔✔-straight |line.



________ |functions |search |for |a |corresponding |value |in |a |defined |range |of |cells |located |in |
another |part |of |the |workbook. |- |CORRECT |ANSWER✔✔-Lookup



The |study |of |how |a |dependent |variable |y |is |related |to |two |or |more |independent |variables |is |
called |- |CORRECT |ANSWER✔✔-multiple |linear |regression.



The |_____ |is |the |range |of |values |of |the |independent |variables |in |the |data |used |to |estimate |
the |regression |model. |- |CORRECT |ANSWER✔✔-experimental |region



A |variable |used |to |model |the |effect |of |categorical |independent |variables |is |called |a(n) |- |
CORRECT |ANSWER✔✔-dummy |variable.



In |the |simple |linear |regression |equation, |the |parameter |represents |the |_____ |of |the |true |
regression |line. |- |CORRECT |ANSWER✔✔-y-intercept



Which |of |the |following |options |is |NOT |an |iterative |variable |selection |procedure? |- |CORRECT |
ANSWER✔✔-best |subsets |regression.



The |phenomenon |by |which |the |value |of |an |estimate |generally |gets |closer |to |the |value |of |the |
parameter |being |estimated |as |the |sample |size |grows |is |called |the |_____. |- |CORRECT |
ANSWER✔✔-law |of |large |numbers

, When |we |use |the |estimated |regression |equation |to |develop |an |interval |that |can |be |used |to |
predict |the |mean |for |ALL |units |that |meet |a |particular |set |of |given |criteria, |that |interval |is |
called |a |- |CORRECT |ANSWER✔✔-confidence |interval.



The |tests |of |significance |in |regression |analysis |are |based |on |assumptions |about |the |error |term
|ε. |One |such |assumption |is |that |the |error |term |ε |is |a |random |variable |with |a |mean |or |


expected |value |of |- |CORRECT |ANSWER✔✔-0.



Which |statement |is |NOT |true |of |influence |diagrams? |- |CORRECT |ANSWER✔✔-The |influence |
diagram |is |a |means |of |gaining |influence |over |competitors.



A(n) |________ |refers |to |a |measurable |factor |that |defines |a |characteristic |of |a |population, |
process, |or |system. |- |CORRECT |ANSWER✔✔-parameter



The |coefficient |of |determination |- |CORRECT |ANSWER✔✔-is |defined |as |SSR/SST.



A(n) |_______ |is |a |visual |representation |that |shows |which |entities |affect |others |in |a |model. |- |
CORRECT |ANSWER✔✔-influence |diagram



If |a |residual |plot |of |x |verses |the |residuals, |, |shows |a |non-linear |pattern, |then |we |should |
conclude |that |- |CORRECT |ANSWER✔✔-the |regression |model |is |not |an |adequate |
representation |of |the |relationship |between |the |variables.



The |mathematical |equation |relating |the |expected |value |of |the |dependent |variable |to |the |
value |of |the |independent |variables, |which |has |the |form |of |is |called |- |CORRECT |ANSWER✔✔-a |
multiple |regression |model.



Which |formula |is |used |for |counting |cells |where |the |value |in |column |"D" |is |at |least |$70,000? |- |
CORRECT |ANSWER✔✔-=COUNTIF(D2:D17,">=70000")