AaBbCcDA LNorm :-. 2.. 1 Body Tet 1 Head ng i 1 Heading 2 1 List Para 1 No Spac

Question

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

Explanation / Answer

Answer 18) b. Y-range.

Answer 19) c. (0 <= R2 <= 1)

Answer 20) a. coefficient of determination
it is the proportion of the variance in the dependent variable that is
predictable from the independent variable(s)

Answer 21) b. 1- (RSS/TSS)

Answer 22) b. minimizes ESS

Answer 23) b. variablity in the actual data around the fitted regression function.

Answer 24) b. The TREND() function handles multiple dependent variable data.

Answer 25) d. independent, normally distributed random variables.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.