The questions is based on a data set that i attached to this also. it involves using SPSS inputFallB2020

M6 Assignment (35 points)

Instruction:

1. Review the Assignment Guides, which contains tutorials on how to show the math/process work

and examples of assignment answers

2. Use this Word document to fill in the answers to the questions. You must type out a clear answer

to each question, even if the answer is also contained in the SPSS output.

3. Download the Excel file for this assignment and use that data set to answer all the questions in

this assignment. Import the data into SPSS if instructed to do so.

4. Use = .05 for all hypothesis testing unless otherwise specified.

Q1. Perform and Interpret a Bivariate Linear Regression (9 points total)

Q1Q2 data set contains cognitive function scores and demographics from a group of older adults. The

focus of this question set is the executive function (Executive). Create an SPSS data file by importing the

Q1Q2 data. Configure the “measure” for each variable.

A . Perform exploratory bivariate correlations in SPSS.

1. Perform bivariate (Pearson’s) correlations among all the variables in the data set. Paste the

correlation matrix (table) here. Hint: Enter all the variables in the same correlation analysis. (1 point for

the table)

2. Report the correlation result in APA format (including r and p) for each of the following pairs of

variables: (1.5 points: .5 for each correlation, both r and p must be correct to earn .5 point)

Education and Executive:

MMSE and Executive:

Age and Executive:

B. Perform a bivariate (simple) linear regression.

The regression model should contain the following:

Outcome variable – Executive

Predictor – Variable with the strongest correlation with Executive (regardless of direction)

1. Create a scatter plot between the predictor variable (X axis) and outcome variable (Y axis). Make sure

the scatter plot has labels for the X and Y axes. Paste the scatter plot here.

(1 point: Deduct .5 for each error up to a total of 1.)

2. Perform the bivariate regression analysis in SPSS. Report the omnibus test result in APA style on the

regression model, including F, p, and adjusted R2. Be sure to paste the relevant output tables (Model

Summary and ANOVA tables) here to support your answer. (1.5 points: .5 for each error in value or format

up to 1.5 total. No credit is earned if no table is pasted.)

FallB2020

3. Discuss the regression result. Is the null hypothesis rejected? What does the result mean?

Hint: Think about the null hypothesis being tested here and form your answer based on whether the null hypothesis

is rejected or not.

(1 point: .5 for each answer)

4. Report the coefficient test on the predictor variable in APA format, including , t and p. Be sure to

paste the relevant output table (Coefficients table) if they have not been pasted above.

(1 point: .5 for any error in value or format, up to 1 total. No point is earned if the table is not included here)

5. Explain the coefficient test result. Is the null hypothesis rejected? What does that mean?

(1 point: .5 for each answer)

6. How much of the variance in the outcome variable can be predicted by the predictor variable? (1

point)

Q2. Perform and Interpret a Multiple Linear Regression (8 points total)

In Q1 above, we examined the relationship between executive function and one predictor variable. Here

we are interested in how multiple predictors may be combined to predict executive function even

better. Specifically, we would like to build a regression model for executive function with two predictor

variables that have the highest and second highest correlations with Executive.

A. Perform a multiple linear regression with Executive as the outcome variable and the two variables

with the highest and second highest correlations with Executive as the predictors in the regression

model. Use “ENTER” (the default in SPSS) as the method of adding the predictor variables to the

regression model.

1. Report the omnibus F test result for the regression model, in APA format, including F, p, and adjusted

R2. Be sure to paste the relevant tables (Model Summary and ANOVA tables) here to support your

answers. (1.5 points total: .5 for any error in value or format up to 1.5 total. No credit is earned if no relevant

table is pasted.)

2. Interpret the test result by answer the following questions: (2 points total: .5 for each question)

a. What was the null hypothesis (in words) tested by this multiple regression analysis?

b. What was the hypothesis test result? (Do you reject or fail to reject the null hypothesis?)

c. What is the effect size of this regression model?

FallB2020

d. What does the effect size mean? The answer should clearly indicate the predictor variables and the

outcome variable. Hint: Think about the extent that the predictors can collectively predict the outcome

variable.

3. Report the statistics on each predictor variable in APA format, including , t, and p. Paste the relevant

table (Coefficients table) here to support your answers.

(2 points total. .5 for each error in value or format, up to 2 total. No point is earned if the relevant table is not

pasted here.)

4. Discuss the relative contributions of the predictors in the model. (1.5 points total: .5 for each question)

a. Which is the strongest predictor?

b. How did you know which predictor is the strongest?

c. Is the strongest predictor statistically significant?

B. Compare this current multiple regression model with the bivariate (simple) regression model in Q1.

Does the model with two predictors predict the outcome variable better than the model with only one

predictor? How do you know? (1 point. .5 for each answer.)

Q3. Perform and Interpret a Bivariate Linear Regression (9.5 points total)

This analysis will be performed on a data set collected by a national company on their 27 chain stores.

The marketing department would like to know how various factors contribute to the net sales (Netsales)

amount for a chain store. Create an SPSS data file by importing the Q3Q4 data. Configure the “measure”

for each variable.

A . Perform exploratory bivariate correlations in SPSS.

1. Perform bivariate (Pearson’s) correlations among all the variables in the data set. Paste the

correlation matrix (table) here. Hint: Enter all the variables in the same correlation analysis. (1 point for

the table)

2. Report the correlation result in APA format (including r and p) for each of the following pairs of

variables: (2 points: .5 for each correlation, both r and p must be correct to earn .5 point)

Storesize and Netsales:

Adcost and Netsales:

FallB2020

Area and Netsales:

Competitor and Netsales:

B. Perform a bivariate (simple) linear regression.

The regression model should contain the following:

Outcome variable – Netsales

Predictor – Variable with the strongest correlation with Netsales (regardless of direction)

1. Create a scatter plot between the predictor variable (X axis) and outcome variable (Y axis). Make sure

the scatter plot has labels for the X and Y axes. Paste the scatter plot here.

(1 point: Deduct .5 for each error up to a total of 1.)

2. Perform the bivariate regression analysis in SPSS. Report the omnibus test result in APA style on the

regression model, including F, p, and adjusted R2. Be sure to paste the relevant output tables (Model

Summary and ANOVA tables) here to support your answer. (1.5 points: .5 for each statistic, both value and

APA format must be correct to earn the credit for each statistic. No credit is earned if no table is pasted.)

3. Discuss the regression result. Is the null hypothesis rejected? What does the result mean?

Hint: Think about the null hypothesis being tested here and form your answer based on whether the null hypothesis

is rejected or not.

(1 point: .5 for each answer)

4. Report the coefficient test on the predictor variable in APA format, including t and p. Be sure to paste

the relevant output table (Coefficients table) if they have not been pasted above.

(1 point: .5 for each statistic, both value and APA format must be correct to earn the credit for each statistic)

5. Explain the coefficient test result. Is the null hypothesis rejected? What does that mean?

(1 point: .5 for each answer)

6. How much of the variance in the outcome variable can be predicted by the predictor variable? (1

point)

Q4. Perform and Interpret a Multiple Linear Regression (8.5 points total)

In Q3 above, we examined the relationship between Netsales and one predictor variable. Here we are

interested in how multiple predictors may be combined to predict Netsales even better. Specifically, we

FallB2020

would like to build a regression model for Netsales with four predictor variables: Storesize, Adcost, Area,

Competitor.

A. Perform a multiple linear regression according to the research question above and answer the

following questions. Use “ENTER” (the default in SPSS) as the method of adding the predictor variables

to the regression model.

1. Report the omnibus F test result for the regression model, in APA format, including F, p, and adjusted

R2. Be sure to paste the relevant tables (Module Summary and ANOVA tables) here to support your

answers.

(1.5 points total. .5 for each statistic. Both value and format must be correct to earn the point. No credit is earned

if no relevant table is pasted.)

2. Interpret the test result by answer the following questions: (2 points total: .5 for each question)

a. What was the null hypothesis (in words) tested by this multiple regression analysis?

b. What was the hypothesis test result? (Do you reject or fail to reject the null hypothesis?)

c. What is the effect size of this regression model?

d. What does the effect size mean? The answer should clearly indicate the predictor variables and the

outcome variable. Hint: Think about the extent that the predictors can collectively predict the outcome

variable.

3. Report the statistics on each predictor variable in APA format, including , t, and p. Paste the relevant

table (Coefficients table) here to support your answers.

(2 points total. .5 for each error in value or format, up to 2 total. No point is earned if the relevant table is not

pasted here.)

4. Discuss the relative contributions of the predictors in the model. (2 points total: .5 for each question)

a. Which is the strongest predictor?

b. Which is the weakest predictor?

c. How do you determine the strength of each predictor?

d. Which variables are significant?

FallB2020

B. Compare this current multiple regression model with the bivariate regression model in Q3. Does the

model with four predictors predict the outcome variable better than the model with only one predictor?

How do you know? (1 point. .5 for each answer.)

Sub ID

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

Education MMSE

Age

16

28

12

28

13

29

8

29

12

28

12

29

16

30

13

28

12

26

14

26

13

29

17

30

12

29

16

28

14

26

20

28

15

28

16

30

16

29

18

29

12

29

19

28

14

30

16

30

19

28

13

28

18

30

16

28

18

27

16

30

20

30

16

30

20

29

18

30

16

30

12

29

16

30

18

30

16

30

14

29

65.8

66.9

76.9

79.9

84.1

72.6

75.6

79.6

78.0

66.3

65.1

67.2

69.0

78.9

69.4

73.6

78.4

69.6

65.8

69.5

75.4

66.7

65.5

72.8

76.5

72.9

69.7

68.2

65.7

73.4

65.8

66.0

71.4

75.8

68.1

67.5

67.8

73.0

71.9

68.3

Executive

84.44

79.88

80.11

100.42

97.59

89.75

108.95

100.00

100.05

97.63

95.63

98.52

103.15

89.73

91.22

93.71

96.87

101.35

97.42

110.68

91.38

105.13

102.57

102.72

107.08

96.14

95.35

104.15

104.76

106.80

100.89

110.68

111.41

114.54

117.27

123.48

116.20

108.14

117.73

93.19

Store ID

Netsales

1

2

3

40

4

5

6

28

30

7

8

29

31

9

32

10

33

11

34

12

35

13

37

14

36

15

39

38

16

17

18

19

20

21

22

23

24

25

26

27

Storesize

10

15

20

20

50

65

68

69

96

98

99

99

155

156

160

161

192

195

230

231

288

299

330

341

342

347

377

387

397

398

400

428

437

464

487

497

507

519

528

570

Adcost

0.5

0.6

1.2

0.8

1.1

1.2

0.6

0.5

0.9

1.6

0.8

1.5

2.3

2.2

2.5

2.6

2.7

2.5

3.5

3

3.2

3.1

3.4

3.5

3.3

3.6

4.1

3.9

3.8

4.3

8.6

4.2

4.4

4.7

4.8

5.3

5.1

5.5

5.6

5.4

Area

3

2.5

3.3

3

3.1

4.7

4.9

4.5

2.9

4.6

2.8

4.4

6.2

6.9

7

7.2

7.5

7.7

8.1

8.2

8.1

8.1

9.6

9.8

9.6

9.6

7.5

10.1

10.4

5.5

7

10.5

10.6

11.3

11.8

11.5

12

12

12.3

17.4

Competitor

9

8

11

6.3

8.1

3.3

4.7

5.2

6.6

2.7

6.5

3.1

4.3

4.1

6.5

6.3

8.1

8.4

5.4

8.2

10

7.7

12

11.5

11.2

8.1

8.4

8.5

8.2

10

12

14

8.8

11

10

16.3

15.7

16.1

16

12.3

1

8

5

0

13

8

5

3

9

10

12

8

2

0

12

11

5

4

2

0

6

4

13

14

12

14

10

11

11

10

15

7

1

7

3

12

15

1

12

6

Q1 Data Set

Variable Name

Education

Description

Number of years of schooling

Values

Number of years

MMSE

Mini Mental Status Exam

Test score

Age

Age of participant

Number of years

Executive

Executive function

Test score

Variable

Netsales

Description

annual net sale amount (in thousands)

Value

dollar amount in thousands

Storesize

square footage of the store

# of square feet

Adcost

advertising cost

dollar amount in thousands

Area

size of the area served by the store

# of square miles

Competitor

number of competitors in the area served by #the

of store

stores

Q2 Data Set

Purchase answer to see full

attachment

#### Why Choose Us

- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

#### How it Works

- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "
**PAPER DETAILS**" section. - Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “
**CREATE ACCOUNT & SIGN IN**” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page. - From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.