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

profiledse133

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:

  • Submit your assignment by 11:59 pm ET on Sunday.
  • It should include at least 2 academic sources, formatted and cited in APA.
  • 2 years ago
  • 10