Using the below dataset calculate in Excel; R2 and p-value to determine the power of association and if your calculations are statistically significant.
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
other Questions(10)