Final Case 1

.xlsx

School

Capella University *

*We aren’t endorsed by this school

Course

QUAN5500

Subject

Economics

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by christellebadillo

BMW Age Mean 45.2622951 Standard Error 0.56486453 Median 45 Mode 46 Standard Deviation 4.41173299 Sample Variance 19.463388 Range 21 Minimum 36 Maximum 57 CV 0.09747038 BMW Age BMW Age 1 Cadillac Age 0.164538928081018 Lexus Age -0.102667924613451 Lincoln Age 0.149191764790844 Mercedes Age 0.240862914835549 BMW Income -0.134595495903878 Cadillac Income 0.139198060358169 Lexus Income -0.028973307453882 MANUFACTURER COEFFICIENT OF CORRELATION Cadillac -0.044752658 Lexus -0.02297443 Lincoln -0.146814669 BMW -0.1345955 Mercedes -0.03630938

Cadillac Age Lexus Age Lincoln Age Mercedes Age BMW Income 1 0.080743211408837 1 -0.363916448548303 -0.22270129 1 0.094396156621525 -0.03196645 0.11347393 1 0.033000081514039 -0.1729439 -0.02574731 0.00136643076 1 -0.0447526582009 -0.01823497 -0.19338788 -0.01686768188 0.08851955126 0.1384031703684 -0.02229744 0.20363043 -0.0705257444 -4.212738E-05 0.0020028 0.000497176 0.021554547 0.018115949 0.001318371 COEFFICIENT OF DETERMINATION R 2

Cadillac Income Lexus Income 1 -0.347297214049 1

BMW Age Cadillac Age Lexus Age Lincoln Age Mercedes Age BMW Income Cadillac Income 55 57 44 64 52 148,066 110,963 41 67 55 54 54 191,835 111,299 43 62 49 54 53 172,689 122,429 57 64 57 59 64 159,380 104,057 42 56 50 64 49 138,269 137,939 41 57 56 54 43 166,091 87,181 42 62 49 60 51 46,068 88,360 44 65 62 58 35 90,485 130,828 44 60 47 57 53 111,225 75,358 48 61 40 67 46 185,547 84,085 47 65 52 55 47 105,033 104,575 46 65 36 65 60 176,274 117,416 40 55 51 65 42 147,066 113,106 46 56 51 67 50 127,561 105,417 52 64 56 61 59 118,769 113,318 45 62 46 51 47 138,512 134,737 49 69 48 60 57 106,281 102,313 51 61 55 57 53 104,428 108,204 46 66 54 54 53 129,589 115,725 40 63 51 65 49 157,957 105,823 43 62 55 55 48 140,757 122,443 50 66 52 60 64 107,989 101,932 56 58 50 66 63 119,641 132,248 42 63 45 57 53 161,850 81,294 40 62 44 60 54 155,309 93,802 46 57 47 60 58 174,113 123,875 51 64 44 54 57 154,448 122,790 39 64 49 51 37 180,737 107,245 51 55 47 64 50 89,725 92,560 41 61 51 59 55 203,306 126,092 51 57 51 63 47 125,083 113,002 40 59 43 57 51 170,732 104,165 40 59 45 62 51 114,619 105,027 42 61 59 57 49 99,342 80,519 46 55 46 66 42 158,131 95,229 44 64 53 66 77 114,357 89,944 46 66 56 55 53 102,481 103,603 42 58 66 65 58 176,528 85,753 47 63 68 63 50 177,371 107,037 46 58 55 55 74 126,753 115,911 36 56 61 53 50 106,757 125,084

48 59 45 62 59 87,882 121,242 44 58 55 56 52 102,923 106,997 40 56 55 60 54 109,568 122,047 48 61 47 60 42 139,187 127,120 43 59 48 58 58 137,993 103,714 48 62 53 65 43 123,127 100,028 39 57 45 65 53 157,555 100,067 45 68 55 58 47 139,908 91,169 51 65 49 52 46 152,408 129,713 45 60 56 58 42 90,347 94,639 49 47 64 50 185,831 43 63 53 50 193,804 43 51 63 48 158,521 41 51 69 44 117,347 49 49 56 46 152,175 47 46 63 64 136,641 45 38 44 157,590 46 50 70 153,389 42 47 57 216,720 47 44 56 179,132 48 55 51 57 49 50 54 55 43 44 39 58 54 53 52 55 40 58 62 51 Average 45.2622951 Median BMW 45 -19779.0282 -0.1345955