Question: How do you make a correlation matrix for all variables, and comment on the degree of correlation among the independent variables by the Use of

How do you make a correlation matrix for all variables, and comment on the degree of correlation among the independent variables by the Use of excel.

IMG_2494.jpg IMG_2495.jpg~ Q Search Q. Search P67 X V fx P67 X V fx G H C D 22.40 150.00 302.00 24.00 INDEPENDENT VARIABLES DEPENDENT VARIABLE 3779 0 6.00 0.04 8.00 225.00 302.00 0.08 8:00 25.00 Unknown 11925 Weight b) Cargo Seating Horsepower Displacement HP/Pound Orlinders Mpg_HWY Origin Price 2782.00 30.00 4.00 0.0.4 4 00 2900 11452 133.00 2390.00 16.00 5:00 118.00 97:00 0.05 4.DO 30 00 Asia 2720.0 20.70 5:00 110.00 12670 11778 90.00 153.00 0.03 4.00 27.00 Unknown 3077 00 16. 60 5 00 161.00 163.00 0.05 6.00 22.00 Asia 23-400 2582.00 17.00 6.00 4.00 26 00 Unknown 121.00 0.04 27/00 Europe 19685 2515.00 13.20 5.00 98.00 141.00 2558.00 10.20 5:00 4.00 21.00 Asia 8429 70.00 2932.00 16.50 5:00 130.00 141.00 0.04 5/00 7200 Europe 28030 989.00 11.40 5.00 30.00 12380 0.05 Europe 2482.00 13.70 5.00 $8.00 119.00 0.04 4.00 2855,00 14:30 5.00 168/00 152.00 6.00 22 00 26095 10050 12.20 5.00 92.00 91.00 0.05 4.00 32.00 Asia 3395 00 16.20 5.00 168.00 152 00 0.05 6.00 23.00 Europe 37000 2039.00 23 20 2:00 92.00 91.00 4.00 36.00 Asia 3835.00 17.60 5:00 208.00 209.00 0.05 6.00 19.50 Europe 54000 1819.00 4.00 26.00 14670 4.00 104.00 119.00 0.04 2764,00 15 80 110.00 151.00 0.04 4,00 13356 2522.00 11.20 35.00 11.20 $8.00 0.03 4.00 Asia 7634 5:00 90.00 31.00 16.40 6.00 165.00 231.00 0.05 6.00 28.00 18525 21580 90.00 0.03 4:00 33 00 Asia 3289.00 2011.00 11. 20 5.00 712.00 87 90 307.00 0.03 8.00 2400 4.00 Asia 4209.00 8.00 140.00 26.00 14869 2727.00 29.40 4.00 110.00 137.00 0.04 3267.00 16.80 6:100 165.00 231.00 0.05 6.00 28.00 16730 6.00 140.00 132.00 0.04 6.00 28.00 Unknown 27468 3628.00 19.00 27218 3394.00 10.30 200 165,00 231.00 6.00 28.00 26700 8.00 24.00 3722.00 14.20 5.00 225.00 302.00 0.06 Unknown 25205 3144.00 15.50 130.00 173.00 0.04 29.00 14739 4051.00 22.40 0.04 24.00 6.00 6.00 150.00 302.00 8.00 14459 0.03 4.00 24.00 Asia 3436.00 13.90 5.00 65.00 231.00 0.05 6.00 28.00 22540 3453.00 37.50 7.00 121.00 159.00 0.04 4.00 30.00 Asia 2469.00 13.50 5:00 90.00 121.00 0.04 4.00 32 00 9700 2175.00 14.70 5.00 82.00 97.00 4.00 28.00 Asia 13919 13.40 6:00 110.00 151.0 0.04 4.00 30 00 12345 2590.00 15.90 5.00 110.00 133.00 0.04 6.00 23.00 Asia 21920 16.20 200 200.00 273.0 0.05 8.00 23.00 57183 3373.00 15 10 5.00 158.00 180.00 0.05 19.00 51400 4190.00 19.50 6:00 140.00 307.00 0.03 8.00 24,00 25699 6.00 3730.00 15.20 5.00 177.00 81.00 0.05 32500 6.00 23.00 Europe 3470:00 18.40 6.00 155.00 273.00 0.04 8.00 25,00 34230 2955.0 158.00 159.00 6.00 24.00 Europe OOZGE 3422.00 14.10 5.00 155.00 273,00 0.05 8.00 25.00 29750 14.60 5.00 188.00 0.06 3210.00 159.00 9657 29.00 151 80 155.00 262.00 0.05 6.00 22.00 14754 2185.00 28.90 5.00 82.00 97.00 0.04 4.00 3084.00 800 25602 5.00 144.00 177.00 0.04 6.00 23.00 Unknown 34.80 25.00 14635 37.20 3083.00 4.00 220.00 305,00 0.07 8.00 3230.00 122.00 4:00 28.00 11819 5.00 3693.00 8.00 24,00 2601.00 102.00 20.90 170.00 305.00 16835 12.30 6:00 0.05 29.00 Asia 9329 4.00 32 00 9010 227100 10.30 5.00 81.00 90.00 0.04 4.00 2423,00 13.70 5.00 90.00 121.00 0.04 17069 142 00 181.00 0 05 6.00 22.00 Asia 4.00 30.00 11495 3075.00 12.40 5.00 21 00 14929 2751 00 16.20 6.00 98 00 151.0 0.04 107.00 143.00 0.03 4,00 18899 2595.00 13:50 5:00 90.00 121.00 0.03 4.00 31.00 10475 161.60 7:00 5:00 160.00 181.00 0.05 26.00 Asia 29.00 3229.00 31545 3086.00 14.50 Asia 12269 17.90 200 245 00 350.00 0.08 8:00 25.00 4.00 90.00 97:00 0.04 4:00 9419 3556.00 15.60 6:00 140.00 318.0 104 8.00 22.00 18345 2388.00 4:00 30.00 Asia 79 7231.00 12.00 5.00 90.00 97.00 0.04 12599 93.00 135.00 4.00 28.00 5.00 Unknown 12031 0.04 4.00 27.00 Asia 2659.00 42.60 2770.00 12.00 5.00 97.00 120.00 4 00 21 00 Asia 15744 3214.00 16.50 6.00 141.00 181.00 0.04 6.00 26.00 17416 106.00 146.00 61.00 3.03 3.00 42.00 Asia 6397 3330.00 157.60 7.00 4.00 25.00 Asia 13959 0.05 1775,00 33.00 4.00 53.00 2690.00 14.20 4:00 140.00 146.00 0.05 6.00 26.00 Asia 23049 34 135.00 1.04 4.00 30.00 8371 14.70 2.00 165.00 181.00 2323.00 15.00 6.00 93.00 11877 3139.00 6:00 29.00 Unknown 14295 100 00 153.00 0.03 4,00 23.00 3084.00 15.50 6.00 130.00 173.00 0.04 3304.00 150 00 8.0O 4,00 29.00 9362 165.0 231.00 0.05 6.00 28.00 Unknown 21995 2195.00 34 70 5:00 81.00 90.00 304 3361 00 14.10 6.00 122.00 0.03 4.00 23.00 13327 13.70 5.00 110.00 116.00 0.04 4.DO 24.00 37 2838.00 63 90 7.00 95.00 2460.00 0.04 4.00 30.00 Unknown 11159 2676.00 33 00 100.00 153.00 3.04 4.00 29.00 Unknow 9831 2592.00 13.10 5.00 110.00 151.00 0.04 6 00 29.00 Unknown 13899 181.00 0.05 4.00 28.00 12295 6:00 141.00 3167.00 15.00 6.00 130.00 173.00 3000.00 16.00 Unknown 8419 4:00 31.00 139.00 9.04 4:00 28.00 Unknow 11731 2235.00 18/40 5.00 74.00 98.00 0.03 2643.00 42/60 5.00 93.00 121.00 4.00 31.00 8949 7371 96.00 2237.00 33.00 5.00 93.00 135.00 4:00 30.00 Unknown 2433,00 15.20 5.00 9131 125,00 21.00 0.05 4:00 22.00 Europe 2558.00 33.00 5:00 93 00 135.00 0.04 4.00 28.00 2735.00 53.00 5.00 125.00 121 00 0.04 4.00 24.00 Europe 25140 132.00 0.04 4.00 27.00 10895 92 3022.00 56.50 5:00 6.00 23 00 Unknown 21429 2588.00 15.20 5:00 103.00 0.05 13276 93 3164.0 12 10 5.00 161.00 163.00 Asia 5656 31.00 35,00 2862.00 16.30 5.00 150.00 182.00 0.05 4.00 73.00 0.04 3.00 0.04 4.00 30.00 Unknown 9852 1745.00 21.90 4:00 27:00 45 10 30 5.00 81 00 90.00 0.04 Asia 12081 2271.00 4.00 31.00 8169 95 2240.00 14.90 5,00 90.00 109.00 13831 46 114.00 0.04 4:00 30,00 Asda 2222.00 38 50 5.00 90.00 0.04 4.00 31:00 Unknown 7616 96 2455.00 11.60 400 97.00 109.00 12158 30.00 1713.00 26.50 4.00 63.00 81.00 6.00 15851 2590.00 500 115.00 Asia 1540 122.00 0,04 97 0.04 4.00 10.00 Asia 9568 97.00 6.00 30200 0.04 8.00 24.00 3779.00 22 40 150.00 Unknown 11925 2207.00 11.00 500 90.00 21498 8.00 25.00 180.00 0.06 6:00 24 00 Asia 2782 00 30.00 4.00 225.00 302 00 0.08 11458 99 3417.00 12 00 5.00 190.00 30.00 14548 40 70 5.00 130.00 193.00 4.00 29.00 100 2350.00 7.80 2.00 115.00 0.05 4,00 23110 2720.00 4.00 27.00 11778 Asia 153.00 0.03 3459.00 12.80 4.00 200.00 180.00 0.06 23.00 9008 2982.00 17.00 6.00 90.00 4.00 32.00 141.00 0.04 4:00 26.00 Unknown 9722 102 37.80 5.00 78.00 89.00 0.04 2515 00 13 20 5:00 98.00 025.00 90.00 0.04 4.00 33.00 Asia 8429 103 2203.00 9.90 4.00 81,00 109.00 0.04 4.00 29:00 Europe 5.00 70.00 109.00 0.04 4.00 28.00 Europe 10415 1989 00 11.40 13.70 5.00 98.00 119.00 0.04 4.00 30.00 Asia 12380 104 2305.00 16.60 5.00 100.00 24:00 17820 2482.00 0.04 4.00 9200 91.00 0.05 4.00 32. 00 10090 14.00 5.00 114 00 140.00 20SSS 2039.00 12 20 5.00 2919.00 140.00 600 26.00 Europe 2.00 91 00 0.05 4:00 36.00 Asia 5880 92 00 14670 106 2954,00 16.80 5.00 114.00 4.00 31.00 4349 1819,00 23.20 0.04 4.00 Asia 0.03 Asia 26.00 107 1837.00 27 50 64.00 57 2523.06 11. 20 4 00 104.00 119.00 7634 5.8 2156.00 5:00 68.00 90.00 0.03 4.00 31 00 Asia DATA + 11.20 5:00 90.00 Asia 1140 70.00 4.00 33.00 8609 2011 00 110 00 137.00 0.04 4:00 26 00 Asia 14869 2727.00 29 40 4.00 DATA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Wage is the dependant variable here and all others are dependant variables Variable Definitions & Descriptive Statistics ? Which variable is the dependent variable and what are the independent...

b) Variable Definitions and Descriptive Statistics Which variable is the dependent variable and what are the independent variables? What do the variables mean and what are their units of measurement?...

Variable Definitions & Descriptive Statistics Which variable is the dependent variable and what are the independent variables? What do the variables mean and what are their units of measurement?...

2.Variable Definitions & Descriptive Statistics As a professional it is likely that you will be asked to conduct analyzes and present your findings in a report to stakeholders such as company...

Which variable is the dependent variable and what are the independent variables? What do the variables mean and what are their units of measurement? Present this in a table in Word. Present...

Name_________________ N6208 Assignment 9 Chapter 9 Correlation and Simple Regression 1. Given the following circumstances, determine whether the calculated values of r are statistically significant:...

pleasee answer each question pls Introduction Let us assume thit you are the Marketing Manager responsible for your company's Strategie Marketing Plan. You company is located in a core urban...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

A random sample of shoppers at a convenience store are selected to see how much they spent on that visit. The standard deviation of the population is $6.43. How large a sample must be selected if the...

The two components of shareholders' equity are: Common stock and preferned stock Common stock and retained earnings Common stock and shareholders equity Paid in capital and treasury stock

Sea has made deports of $12200 into savings account at the end of every month for 14 years interest in pearum compounded som annually and he leaves the accumulated balance for archers yeon, what...