NO BS: Multiple Regression Excel Tutorial

NO BS: Multiple Regression Excel Tutorial

Assessment

Interactive Video

Computers

10th - 12th Grade

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how to perform multiple regression analysis in Excel, focusing on setting up the data, understanding R-squared and adjusted R-squared values, determining significance using P-values, constructing the regression equation, and interpreting the results. The tutorial uses a Mac version of Excel, but the steps are similar for Windows. It emphasizes the importance of understanding the relationship between dependent and independent variables and how to report and interpret the results effectively.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What does an adjusted R-squared value indicate compared to a regular R-squared value?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the P value in the context of regression analysis?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe how to construct a regression equation from the output of a multiple regression analysis.

Evaluate responses using AI:

OFF