Below are the income per capita of a sample of different households. Per Capita Income 21,500 37,325 25,049 18,998 24,122 23,615 25,771 25,922 21,551 24,447 21,708 25,028 23,152 25,106 21,385 20,247 25,239 21,096 20,393 26,210 23,002 24,786 21,056 24,217 27,579 21,080 30,023 27,360 24,775 27,489 28,821 28,976 32,902 29,219 26,889 28,066 37,700 24,302 25,979 33,953 26,924 19,373 29,932 24,007 27,667 20,008 21,387 25,184 Determine each of the following measures for the sample of income by using the appropriate Excel function. Place your answers in the highlighted cells. (a) mean (b) median (c) variance (d) standard deviation

The table below contains data about the cost of electricity during a recent month for a random sample of 30 ​one-bedroom apartments in a large city. Complete parts​ (a) through​ (c) below. 97 161 141 94 109 174 184 148 162 124 206 88 208 153 184 179 119 174 152 153 146 174 124 133 112 104 112 129 142 135 Construct a cumulative percentage distribution. Cost($).               Percentage less than indicated amount 80.                             __% 100                            __% 120                            __% 140                            __% 160                            __% 180                            __% 200                           __% 220                           __%

A sample of rental cars showed the following annual mileage (in thousands of miles) 46.768 34.813 69.194 36.927 57.666 36.003 42.961 37.194 47.750 41.738 44.239 34.052 31.731 54.661 30.928 47.847 31.286 38.813 40.166 32.905 42.057 49.834 47.556 37.729 22.120 40.822 41.104 62.399 32.550 43.558 8 The sum of x is, a 1147.569   b 1183.061   c 1219.650   d 1257.371

The data below contains mileage, age, and selling price for a sample of 33 sedans. Price Mileage Age 16,998 35,000 3 17,599 16,000 3 15,998 42,000 3 15,998 62,000 4 11,599 102,000 7 12,998 109,000 4 14,998 60,000 5 11,599 88,000 9 12,599 58,000 8 14,998 27,000 6 15,998 32,000 3 Price Mileage Age 11,599 95,000 8 9,499 123,000 8 14,599 54,000 5 10,599 68,000 10 16,998 40,000 4 20,998 7,000 0 11,599 80,000 9 12,599 70,000 6 13,599 86,000 5 11,599 92,000 7 9,599 120,000 10 Price Mileage Age 18,998 20,000 2 12,599 63,000 7 12,599 70,000 6 10,998 88,000 10 11,998 86,000 6 13,998 60,000 6 17,599 45,000 2 9,998 95,000 11 9,998 60,000 11 16,998 36,000 2 17,599 45,000 2 #1) Is multicollinearity an issue for this model? Find the correlation between the independent variables to answer this question.(Round your answer to two decimal places.) The correlation between age and mileage is: ____________     #2) Find…