AaBbCcDA LNorm :-. 2.. 1 Body Tet 1 Head ng i 1 Heading 2 1 List Para 1 No Spac !Table Pa- Heading 3 Tit ragraph Styles 18. When using the Regression tool in Excel the dependent variable is entered as the a X-range. b. Y-range d. independent-range. 19. What is the correct range for R2 values? 20. R2 is also referred to as b. coerelation coefficient c. total sum of squares d. regression sum of squares 21. R2 is calculated as a ESS/TSS b. 1-(RSS/TSS) c. RSSESS d. RSS TSS 22. The method of least squares finds parameter values that a minimizes TSS b. minimizes RSS. minimizs ESS +RSS 23. The standard error measures the a. variability in the X values b. variability in the actual data around the fitted regression function c. variability in the independent variable around the fitted regression function d. variability in the dependent variable around the fitted regression function 24. Which of the following is an advantage of using the TRENDO function versus the regression tool? a. The TRENDO function provides more statistical information b. The TREND.O function handles multiple dependent variable data c. The TRENDO function is dynamically updated when input to the finction changes d. The TRENDXO function does not use a least squares regression line 25. Residuals are assumed to be a. dependent, uniformly dastributed random variables b. independent, uniformaly distributed random variables c. depandent, normally distributed random variables d. independent, normally distrabuted random variables