Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I insert this formula in to excel? Based on the above table, the following is calculated: X = Xi = 39967 - 9991.75
How do I insert this formula in to excel?
Based on the above table, the following is calculated: X = Xi = 39967 - 9991.75 n 4 i=1 34018 Y = - 8504.5 1=1 4 n n SSXX = X? Xi = 399388317 - 399672/4 - 48044.75 n SSyy = Yi = 289338526 - 340182/4 = 32445 i=1 SSxY = >XiVi- n i=1 [vi = 339868791 - 39967 x 34018/4= i=1 -30560.5 Therefore, based on the above calculations, the correlation coefficient is obtained as follows: SSXY VSSxx . SSYY -30560.5 = V48044.75 - 32445 = -0.774Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started