Question

For INTERCEPT() and SLOPE() functions, do we place x values or y values first in the parentheses?
For CORREL() function, do we place x values or y values first in the parentheses?
What is the difference in meaning between y and y_hat?
What does the regression model minimize?  SSE or SSR or SST?
Variation in Y = Time explained by X = Miles is SST, SSR or SSE?
Variation in Y = Time not explained by X = Miles is SST, SSR or SSE?
Which is the coefficient of determination?  R or r-squared?
In general, what is lowest possible value for r-squared?
In general, what is the lowest possible value for r?

Answer 1

I can only answer 1 question at a time but I am solving 2 questions here.

INTERCEPT(known_y's, known_x's)

SLOPE(known_y's, known_x's)

Hence, we place Y values first and then x values in the intercept() and SLOPE() functions.

CORREL(array1, array2)

Hence, you can place any of of x or y at the first and then the other. It does not matter.

Please do rate me and mention doubts, if any, in the comments section.