Calculating Correlation Coefficient and Best Fit Regression in Google Sheets

What are the two main objectives of the video?

• Learning basic formulas in Google Sheets

• Creating pie charts and bar graphs in Google Sheets

• Calculating correlation coefficient and best fit regression equation in Google Sheets

• Calculating mean and median in Google Sheets

Which variable should be placed first in Google Sheets?

• Dependent variable

• Control variable

• Independent variable

• Random variable

What is the formula used to calculate the correlation coefficient in Google Sheets?

• =CORREL

• =CORRELATE

• =CORRELATION

• =COEFF

What should you do after highlighting the independent and dependent variable columns to calculate the correlation coefficient?

• Insert a chart

• Save the file

• Close the spreadsheet

• Press Enter

What type of chart should you insert to visualize the best fit regression line?

• Line chart

• Scatter plot

• Pie chart

• Bar chart

Where do you go to customize the chart and add a trend line?

• Data tab

• File menu

• Customize tab

• Edit menu

What does the R squared value represent?

• Y-intercept

• Slope of the line

• Coefficient of determination

• Correlation coefficient

How do you find the correlation coefficient from the R squared value?

• Divide the R squared value by 2

• Multiply the R squared value by 100

• Take the square root of the R squared value

• Square the R squared value

What should you check to determine if the correlation coefficient is positive or negative?

• The value of R squared

• The slope of the line

• The y-intercept

• The x-values

What is the formula for calculating the square root in Google Sheets?

• =SQRT()

• =SQ()

• =SQUARE()

• =ROOT()