The following shows the Excel spreadsheet for Education and Income . A B C 1 Individual i Education (x) Income (y) 2 1 3 45 3 2 4 56 4 3 6 85 5 4 2 35 6 5 5 57 7 6 4 48 8 7 8 100 9 8 0 38 10 11 =COVARIANCE.S(C2:C9,B2:B9) 12 =CORREL(C2:C9,B2:B9) Group of answer choices The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the variance of Education and the variance of Income. The values are 51.4287 and 0.9137. The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the correlation between Education and the variance of Income. The value is 0.9137 The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the covariance between Education and Income. The value is 51.4286. The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the correlation between Education and Income. The value is 0.9137.
The following shows the Excel spreadsheet for Education and Income . A B C 1 Individual i Education (x) Income (y) 2 1 3 45 3 2 4 56 4 3 6 85 5 4 2 35 6 5 5 57 7 6 4 48 8 7 8 100 9 8 0 38 10 11 =COVARIANCE.S(C2:C9,B2:B9) 12 =CORREL(C2:C9,B2:B9) Group of answer choices The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the variance of Education and the variance of Income. The values are 51.4287 and 0.9137. The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the correlation between Education and the variance of Income. The value is 0.9137 The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the covariance between Education and Income. The value is 51.4286. The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the correlation between Education and Income. The value is 0.9137.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
The following shows the Excel spreadsheet for Education and Income .
| A | B | C | ||
| 1 | Individual i | Education (x) | Income (y) | |
| 2 | 1 | 3 | 45 | |
| 3 | 2 | 4 | 56 | |
| 4 | 3 | 6 | 85 | |
| 5 | 4 | 2 | 35 | |
| 6 | 5 | 5 | 57 | |
| 7 | 6 | 4 | 48 | |
| 8 | 7 | 8 | 100 | |
| 9 | 8 | 0 | 38 | |
| 10 | ||||
| 11 | = |
|||
| 12 | =CORREL(C2:C9,B2:B9) |
Group of answer choices
The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the variance of Education and the variance of Income. The values are 51.4287 and 0.9137.
The formula in B11 is “=covariance.s(C2:C9,B2:B9)”. It gives the
The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the covariance between Education and Income. The value is 51.4286.
The formula in B12 is “=correl(C2:C9,B2:B9)”. It gives the correlation between Education and Income. The value is 0.9137.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman