SnowPro Advanced: Data Scientist — Question 1

A Data Scientist wants to get the coefficient of determination for two columns in a table.
Which function can be used for that?

Answer options

• A. REGR_INTERCEPT
• B. REGR_SLOPE
• C. REGR_R2
• D. REGR_SXY

Correct answer: C

Explanation

The correct answer is C, REGR_R2, as it specifically calculates the coefficient of determination, which indicates how well the independent variable explains the variability of the dependent variable. Options A and B, REGR_INTERCEPT and REGR_SLOPE, are used to find the y-intercept and slope of the regression line, respectively, while D, REGR_SXY, computes the covariance between the two variables, not the coefficient of determination.