ZuoTi.Pro
Question

Statistics 8 ίΞ Question Help * The following data contains coaches salaries and team revenues (in millions of dollars) for ten college basketball teams. Use this data to complete parts (a) through Salary 1.5 .70.8 0.5 1.9 0.2 1.8 1.6 0.4 1.2 Revenue 16.2 17.9 11.6 3.5 9.7 1.17.9 11.9 3.2 5.7 a. Compute the covariance. 2.544 (Round to three decimal places as needed.) b. Compute the coefficient of correlation (Round to three decimal places as needed.)

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting 15 16 17 18 19 20 21 SALARY REVENUE X-E(X) Y-E(Y) A A 16.2 17.9 11.6 0.34 0.54 0.36 7.33 0.1156 53.7289 2.4922 9.03 0.291681.5409 4.8762 2.73 0.1296 7.4529 -0.9828 3.5-0.66 -5.37 0.4356 28.83693.5442 0.83 0.5476 0.6889 0.6142 1.1-0.96 -7.77 0.9216 60.37297.4592 0.97 0.4096 0.9409 0.6208 3.03 0.193 9.1809 1.3332 5.67 0.5776 32.1489 4.3092 0.04-3.17 0.0016 10.0489 -0.1268 3.624 284.941 22.898 0.8 1.9 9.7 0.74 0.64 0.44 0.76 23 24 25 26 27 28 29 30 31 32 1.8 7.9 0.4 3.2 E(X) & E(Y)-1.168.87 (AVERAGE) SUM(X-E(X)A2)- SUM(Y-EY)A2) SUM(X-E(X))(Y-E(Y))22.898 3.624 284.941 4 PV FV DIVIDEND EMV MEAN STDV DEAR Sheet2 | COV TIME SERIES corr REGRESSION CAMERAEXP RETURN MATRIXINTERVAL, NORMAL HY 130% 03:51 22-01-2019Home nert Page Layout Formulas Data Review View dd-Ins E AutoSum Cut ー E ゴWrap Text Sort &Find & ta copy. B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Formatting as Table Styles2 Clear Format Painter Cells Edting Number Alignment Clipboard SUM(X-E(X)(Y-E(Y)/ (n-1)- 2.544 (22.898/10-1) COVARIANCE 34 35 36 37 38 39 40 41 42 43 CORRELATION COEEFICIENT SUM(X-E(X))(Y-E(Y))/ SQRT (SUM(X-E(X)A2)*SUM(Y-E(YA2)) CORRELATION COEEFICIENT22.898/SQRT(3.624*284.941) 0.713 OR WE CAN ALSO FIND USING EXCEL COVARIANCE- CORRELATION COEEFICIENT- 2.544 0.713 EXCEL FORMULAS COVARIANCE.S(P17:P26,Q17:Q26) CORREL(P17:P26,017:Q26) 45 46 47 48 49 50 51 MATRD, INTERVAL, NORMAL HY14 11 DEAR (Sheet2 | COV TIME SERIES corr REGRESSION CAMERAEXP RETURN 福 130% 03:52 22-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
Statistics 8 ίΞ Question Help * The following data contains coaches' salaries and team revenues (in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Statistics 8 Question Help The following data contains coaches' salaries and team revenues (in millions of...

    Statistics 8 Question Help The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college basketball teams. Use this data to complete parts (a) through Salary 1.5 1.7 0.8 0.5 19 0.2 1.8 1.6 0.4 1.2 Revenue 16.2 17.9 11.6 3.5 9.7 1.1 7.9 11.9 3.2 5.7 a. Compute the covariance. (Round to three decimal places as needed.)

  • Statistics 8 Ξ Question Help The following data contains coaches' salaries and team revenues (in millions...

    Statistics 8 Ξ Question Help The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college basketball teams. Use this data to complete parts (a) through Salary 0.9 0.5 0.6 17 0.7 1.8 0.2 1.6 0.3 1.4 Revenue 4.4 5.9 9.5 7.4 8.2 9.4 18 9.6 4.7 11.0 a. Compute the covariance (Round to three decimal places as needed.)

  • The following data contains​ coaches' salaries and team revenues​ (in millions of​ dollars) for ten college...

    The following data contains​ coaches' salaries and team revenues​ (in millions of​ dollars) for ten college basketball teams. Use this data to complete parts​ (a) through​ (c). Salary: 1.1 0.2 1.5 0.4 0.9 1.3 1.4 1.2 0.8 0.3 Revenue : 16.2 2.4 16.4 5.5 3.7 6.2 18.5 14.1 12.5 3.9 a. compute the covariance (round to three decimal places as needed) b. . Compute the coefficient of correlation. c. What conclusions can you reach about the relationship between a​ coach's...

  • The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college...

    The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college basketball teams. Use this data to complete parts (a) through (c). Salary 1.4 0.4 0.7 1.5 0.8 1.6 0.5 0.3 1.7 0.6 Revenue 17.6 1.7 3. 0 6 .2 12.3 11.7 3.8 2.9 14.2 3.8 a. Compute the covariance. (Round to three decimal places as needed.) b. Compute the coefficient of correlation. (Round to three decimal places as needed.) c. What conclusions can you...

  • The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college...

    The following data contains coaches' salaries and team revenues (in millions of dollars) for ten college basketball teams. Use this data to complete parts (a) through (c). Salary Revenue 0.7 0.7 3.0 1.1 15.0 0.8 11. 6 1.2 .4 1.6 14.7 1.5 9.9 0.2 2.3 0.5 7.6 1.3 17.4 0.4 5.4 7 a. Compute the covariance. (Round to three decimal places as needed.) b. Compute the coefficient of correlation. (Round to three decimal places as needed.) c. What conclusions can...

  • Question 17 > B0/2 pts Perform rank correlation analysis on the following data set: Y -0.5...

    Question 17 > B0/2 pts Perform rank correlation analysis on the following data set: Y -0.5 14.4 11.6 20.5 1 2.8 3.7 5.3 7.2 7.8 9.7 11.1 11.7 162 19.4 16.8 25.7 38.2 The scatterplot of the data looks like this: Fill in the following table: у X-rank y-rank 1 -0.5 1 2.8 14.4 2 3.7 11.6 3 5.3 20.5 4 7.2 16.2 5 7.8 19.4 6 9.7 16.8 7 11.1 25.7 8 11.7 38.2 9 What is the rank...

  • Cyclic Consumer Industrial Full data set 3.7 12.6 48.7 5.4 14.9 - 23.4 23.5 13.2 -4.5...

    Cyclic Consumer Industrial Full data set 3.7 12.6 48.7 5.4 14.9 - 23.4 23.5 13.2 -4.5 0.2 -7.7 5.9 36.1 45.4 -3.6 1.2 -1.1 2.3 24.4 5.8 42.4 -8.6 14.1 4.5 -17,6 -7.6 45.8 -5.2 3.2 22.6 10.8 -3.7 6.4 - 26.8 38.1 8.4 29.6 36.9 1.1 8,5 18.6 1.5 -17.1 21.5 30.3 20.8 2.7 6.5 17.6 29.5 18.8 13.1 16.7 12.9 -8.8 5.2 - 9.5 1.7 34.6 -4.7 12.7 26.4 -9.2 32.9 36.5 -8.4 -27.8 9.2 33.8 23.1 1.1...

  • The following data represent the calories and sugar, in grams, of various breakfast cereals. Product A...

    The following data represent the calories and sugar, in grams, of various breakfast cereals. Product A B с D E F G Calories 260 380 390 410 460 540 590 Sugar 8.7 5.1 21.5 21.4 16.5 22.3 24.2 Use the data above to complete parts (a) through (d). a. Compute the covariance. 742.000 (Round to three decimal places as needed.) b. Compute the coefficient of correlation. r= 0.690 (Round to three decimal places as needed.) c. Which do you think...

  • This Question: 4 pts 12 of 25 (22 complete) This Quiz: 100 pts possibl The balowing...

    This Question: 4 pts 12 of 25 (22 complete) This Quiz: 100 pts possibl The balowing dala contains coaches salaries and team revenues (n milions of dalars for ten college baskethull teams Use these data to complete parts (o) through (다 Salary 11 09 18 04 08 16 14 12 17 13 Revenue9685 165 37 79 103 101 64 11961 a Compute the covariance (Round to theee decimal places as needed ) b. Compute the coefficlent of comelation (Round to...

  • The data on the below shows the number of hours a particular drug is in the...

    The data on the below shows the number of hours a particular drug is in the system of 200 females. Develop a histogram of this data according to the following intervals: Follow the directions. Test the hypothesis that these data are distributed exponentially. Determine the test statistic. Round to two decimal places. (sort the data first) [0, 3) [3, 6) [6, 9) [9, 12) [12, 18) [18, 24) [24, infinity) 34.7 11.8 10 7.8 2.8 20 9.8 20.4 1.2 7.2...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT