Question

The data in the table to the right are based on the results of a survey comparing the commute time of adults to their score on a well-being test. Draw a scatter diagram of the data. Does a linear relation exist between the commute time and well-being index score, when the linear correlation coefficient is -0.991? Commute Time (in minutes) Well-Being Score 4 69.2 16 68.9 23 67.9 34 67.7 53 66.3 74 65.2 95 63.1.

Answer 1

Page Layout Formulas Data Review View 11 AA Wrap Text General AutoSum Fill- 6 Merge & Center - % Insert Delete Format - Conditional Format Cell Formatting as Table Styles F Styles 2 Clear Sort & Find & Filter Select- Editing Font Alignment E Number Cells G H 1 K 1 M N 0 P R S T V w Scatter diagram 70 69 8 68 y (well-being index number) 66 X 65 64 63 62 0 90 20 10 30 40 70 60 100 80 50 X (Commute time) Interpretation: From above graph we can observe that their exists negative correlation between Commute time and well being index number. Sheet3 Sneet 100% A 4 ENG 11:04 AM 30-07-2020 IPS P

cat Calibri 10 Copy 2 M Paste Format Painter Clipboard Font A19 A B D E 1 2 3 X: Commute time 4. Y: Well being index number 5 6 X Y 7 4 69.2 8 16 23 68.9 67.9 677 53 66.3 65.2 95 63.1 15 Correlation -0.99081 16 Using CORREL function above correlation value is computed 17 lt is -0.991 19 20 22