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

Tags

CCSS.HSS.ID.A.1

CCSS.6.SP.B.4

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

• =CORREL

• =CORRELATE

• =CORRELATION

• =COEFF

Tags

CCSS.HSS.ID.C.8

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

Tags

CCSS.HSS.ID.C.8

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

• Line chart

• Scatter plot

• Pie chart

• Bar chart

Tags

CCSS.8.SP.A.2

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

• Data tab

• File menu

• Customize tab

• Edit menu

Tags

CCSS.8.SP.A.2

What does the R squared value represent?

• Y-intercept

• Slope of the line

• Coefficient of determination

• Correlation coefficient

Tags

CCSS.HSS.ID.B.6B

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

Tags

CCSS.HSS.ID.B.6B

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

Tags

CCSS.HSS.ID.C.8

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

• =SQRT()

• =SQ()

• =SQUARE()

• =ROOT()

Tags

CCSS.8.EE.A.2