Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Quantitive Analysis with Excel > Linear Regression > Flashcards

Linear Regression Flashcards

1
Q

What does a slope of 2 mean?

A

That every 1-unit change in X yields a 2-unit change in Y

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the formula to find the slope?

A

Rise/Run

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the formula to find linear?

A

Y = Mx + B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What measures the relative strength of the linear relationship between two variables?

A

Correlation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

True or False:

Correlation is unit-less

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the range of correlation?

A

-1 and 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Fill in the Blanks:

The closer correlation is to -1, the ______ the ______ linear relationship

A
  1. Stronger

1. Negative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Fill in the Blanks:

The closer correlation is to 1, the ______ the ______ linear relationship

A
  1. Stronger

2. Positive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Fill in the Blanks:

The closer correlation is to 0, the ______ any ______ linear relationship

A
  1. Weaker

2. Positive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What measures the strength and direction of the linear relationship?

A

The Coefficient of Correlation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do you know when a scatter plot has a correlation coefficient of -1?

A

The dots form a downward line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How do you know when a scatter plot has a correlation coefficient of 1?

A

The dots form a upward line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you know when a scatter plot has a correlation coefficient of 0?

A

The dots form a straight line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How do you know when a linear correlation has no relationship on a scatter plot?

A

The dots are scattered everywhere

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How do you know when a linear correlation has a relationship on a scatter plot?

A

The dots are clustered together

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

True or False:

In linear correlation, the two variables are treated as equals

A

True

17
Q

Fill in the Blanks:

In linear regression, one variable is considered the ________ variable while the other is considered the ________ variable

A
  1. Independent

2. Dependent

18
Q

In linear regression which variable is considered the independent variable?

A

X

19
Q

In linear regression which variable is considered the dependent variable?

A

Y

20
Q

What is another name for the x variable in linear regression?

A

The predictor

21
Q

What is another name for the y variable in linear regression?

A

The outcome

22
Q

What is the difference between linear regression and correlation?

A

Correlation tells if two things travel together while Regression tells if one thing can predict another

23
Q

List the 4 things that linear regression assumes

A
  1. The relationship between X and Y is linear
  2. Y is distributed normally at each value of X
  3. The variance of Y at every value of X is the same
  4. The observations are independent
24
Q

Which function provides the correlation coefficient (r)?

A

The CORREL function

25
Q

Which function provides r-squared?

A

The RSQ function

26
Q

Which function provides the y-intercept?

A

The INTERCEPT function

27
Q

Which function returns the best fit line against x values?

A

The TREND function

28
Q

What should you do if you have more than 1 causal (i.e. X) variable?

A

Use multiple linear regressions

29
Q

What is the percentage variation explained by the X variables?

A

The adjusted r square

30
Q

What does it indicate when the significance F is < .05?

A

That regression is significant at 95% confidence level

31
Q

What does it indicate when the p-values of variables is < .05?

A

That variables are significant at 95% confidence level

32
Q

What arises when two variables that measure the same thing or similar things are both included in a multiple regression model?

A

Multicollinearity

33
Q

What is a numeric variable that represents categorical data?

A

A dummy variable

34
Q

What is the dummy variable also known as?

A

The indicator variable

35
Q

List the 4 steps to using multiple regression in Excel

A
  1. Input your Y and X variables into the input box
  2. Select where you want the output to go
  3. Drop X variables that fail the P-value test
  4. Rerun your model
36
Q

True or False:

Name of the game in multiple regression is to use the maximum number of variables required to predict Y

A

False, minimum

37
Q

What are 3 examples of categorical data?

A

Gender, race, and political affiliation

38
Q

What is the regression equation?

A

Income = b0+ b1X1+ b2X2

Quantitive Analysis with Excel (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions