Using the below dataset calculate in Excel; R2 and p-value to determine the power of association and if your calculations are statistically significant.

V1 (Input Y Range) (Dependent Variable)

V2 (Input X Range) (Independent Variable)

12

45

15

54

17

61

13

51

18

70

20

73

22

71

18

66

25

106

Hint: Excel Data Analysis; Regression.

Submission Instructions:

-EXCEL FORMAT

1 PAGE

CAN’T HAVE MORE THAN 10% PLAGIARISM OR AI TEXT- WILL BE SUBMITTED VIA TURNIN IN

It should include at least 2 academic sources, formatted and cited in APA with the past 5 year.

EACH ASSIGNMENT MUST BE DONE IN A SEPARATE WORD DOCUMENT

REFERENCES ARE MANDATORY

Rubric

– Official Assignment Rubric