Which of the following statements is true when using the Excel Regression tool?

A、TherangefortheindependentvariablevaluesmustbespecifiedintheboxfortheInputYRange.
B、CheckingtheoptionConstantisZeroforcestheintercepttozero.
C、TheRegressiontoolcanbefoundintheToolstabunderInsertgroup.
D、Addinganintercepttermreducestheanalysis'fittothedata.