Module 7: Assignment 1
Using the below dataset calculate in Excel; R 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
12/2/25, 10:46 AM Module 7: Assignment 1
1/1