Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed
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.774

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management

Authors: Frank Rothaermel

6th Edition

1265951500, 9781265951504

Students also viewed these Mathematics questions

Question

Are you at your best around 8 or 9 AM? Yes No

Answered: 1 week ago