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

28

Uploaded by christellebadillo

Report
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
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
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
Mode 46 Variance 19.463388 SD 4.41173299
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Lexus Income Lincoln Income Mercedes Income BMW Cadillac Lexus Lincoln 159,132 131,641 161,590 18 14 16 13 200,609 122,973 129,017 16 14 14 13 170,884 66,110 194,379 17 15 19 13 123,177 140,306 226,016 17 15 17 15 98,373 132,986 153,589 11 10 13 13 120,165 135,128 275,299 17 14 19 14 160,062 138,170 205,005 14 13 17 14 170,619 131,989 195,133 17 16 15 15 152,710 110,223 204,746 19 13 16 11 191,240 97,970 140,063 14 16 16 15 135,788 118,975 181,621 15 14 12 11 150,583 105,504 127,299 15 13 13 14 128,902 110,176 183,915 16 11 17 13 159,707 130,339 142,456 17 12 16 11 118,571 110,488 176,622 16 12 15 12 129,564 126,474 159,456 11 13 12 12 120,807 120,775 193,406 15 11 18 13 131,023 105,431 158,495 19 11 17 12 142,258 110,790 180,799 18 15 16 12 180,633 137,001 245,639 14 15 15 13 173,107 95,723 196,212 16 11 17 13 170,710 94,719 143,964 17 13 21 14 172,265 113,108 219,721 18 12 13 13 203,410 97,098 171,527 14 13 20 13 178,881 133,514 191,132 17 14 13 15 122,481 95,850 220,800 18 11 14 12 146,011 157,904 161,224 14 11 13 15 117,654 148,989 189,757 17 13 15 11 179,617 100,540 155,509 14 13 13 11 112,906 96,301 158,560 17 11 14 15 163,248 87,192 243,773 18 12 16 13 149,288 105,633 200,577 18 13 18 15 139,938 118,194 203,597 15 12 13 11 242,145 83,566 293,339 16 13 17 12 151,133 89,470 132,906 16 16 20 14 174,810 54,622 160,548 13 10 19 13 172,232 115,021 232,004 16 11 16 14 134,556 96,192 224,281 16 12 14 14 153,138 109,639 159,670 18 14 12 15 127,162 122,008 150,295 15 12 13 13 114,276 108,284 173,028 16 11 17 12
168,078 148,650 236,780 15 13 19 13 142,599 114,465 134,937 15 13 18 13 144,512 80,743 144,835 14 15 13 11 121,780 68,653 159,011 16 11 20 9 169,935 127,561 228,837 14 13 16 17 248,134 108,006 86,431 19 13 19 15 225,988 135,423 130,505 16 15 17 16 158,123 91,426 140,489 17 12 19 15 183,818 116,635 240,556 15 13 17 15 113,445 111,974 254,652 17 11 16 13 174,201 84,370 111,676 16 20 13 171,605 117,587 135,562 12 13 13 162,147 95,090 211,308 16 21 11 156,740 127,253 207,514 14 14 11 135,680 96,093 145,942 13 12 12 173,449 107,376 190,828 18 18 13 164,640 239,748 13 13 119,412 184,735 18 15 179,617 177,769 16 14 126,774 188,328 17 13 126,361 268,645 19 155,846 190,486 18 174,257 197,472 16 132,175 192,997 15 146,415 127,488 16 96,069 49,941 15 156,310 219,020 14 182,008 115,064 12 208,509 334,823 186,070 189,758
Mercedes 20 14 Mean 18 Standard Error 17 Median 18 Mode 17 Standard Deviation 16 Sample Variance 16 Range 19 Minimum 16 Maximum 19 CV 17 13 19 15 19 17 17 15 20 15 17 18 15 21 14 20 18 15 15 17 19 18 17 16 22 17 14 17 17 20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
17 17 19 20 17 BMW Age Cadillac Age 17 BMW Age 1 17 Cadillac Age 0.16453893 1 16 Lexus Age -0.10266792 0.080743211408837 16 Lincoln Age 0.14919176 -0.3639164485483 19 Mercedes Age 0.24086291 0.094396156621525 18 BMW Income -0.1345955 0.033000081514039 17 Cadillac Income 0.13919806 -0.0447526582009 15 Lexus Income -0.02897331 0.1384031703684 17 19 17 17 17 20 19 17 16 15 17 18 17 16 18 17 19 17 18
BMW Age Cadillac Age Lexus 45.2622951 60.9803921568627 50.4347826087 0.56486453 0.521303190602267 0.73850331954 45 61 50 46 62 51 4.41173299 3.72284942525712 6.13446929693 19.463388 13.8596078431373 37.631713555 21 14 32 36 55 36 57 69 68 0.09747038 0.061049942343445 0.12163171882
Lexus Age Lincoln Age Mercedes Age BMW Income Cadillac Income Lexus Income 1 -0.22270129 1 -0.03196645 0.113473925521908 1 -0.1729439 -0.02574730646518 0.00136643076 1 -0.01823497 -0.19338787734891 -0.01686768188 0.08851955126 1 -0.02229744 0.203630430122708 -0.0705257444 -4.212738E-05 -0.347297214049 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
e
BMW Age Lower Classes 35 40 Classes Frequency 40 45 40 9 45 50 45 23 55 60 50 20 65 70 60 9 75 80 70 0 85 90 80 0 90 0 More 0 BMW Age BMW Income 55 148,066 41 191,835 43 172,689 57 159,380 42 138,269 41 166,091 42 46,068 44 90,485 44 111,225 48 185,547 47 105,033 46 176,274 40 147,066 46 127,561 52 118,769 45 138,512 49 106,281 51 104,428 46 129,589 40 157,957 43 140,757 50 107,989 56 119,641 42 161,850 0 5 10 15 20 25 Frequency 150,000 200,000 250,000 BMW Income
40 155,309 46 174,113 51 154,448 39 180,737 51 89,725 41 203,306 51 125,083 40 170,732 40 114,619 42 99,342 46 158,131 44 114,357 46 102,481 42 176,528 47 177,371 46 126,753 36 106,757 48 87,882 44 102,923 40 109,568 48 139,187 43 137,993 48 123,127 39 157,555 45 139,908 51 152,408 45 90,347 49 185,831 43 193,804 43 158,521 41 117,347 49 152,175 47 136,641 45 157,590 46 153,389 42 216,720 47 179,132 30 35 40 45 0 50,000 100,000 150,000 f(x) = − 1033.15407939806 x + 187 R² = 0.01811594751761
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Fixed cost 187307 40 45 50 60 70 80 90 0 5 0 5 0 5 BMW Age Classes
50 55 60 7307.21988882
BMW Income
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Lower Classes 35 40 Classes Frequency 40 45 40 0 45 50 45 0 55 60 50 0 65 70 60 22 75 80 70 29 85 90 80 0 90 0 More 0 Cadillac Age Cadillac Income 57 110,963 67 111,299 62 122,429 64 104,057 56 137,939 57 87,181 62 88,360 65 130,828 60 75,358 61 84,085 65 104,575 65 117,416 55 113,106 56 105,417 64 113,318 62 134,737 69 102,313 61 108,204 66 115,725 63 105,823 62 122,443 66 101,932 0 5 10 15 20 25 30 35 Frequency
58 132,248 63 81,294 62 93,802 57 123,875 64 122,790 64 107,245 55 92,560 61 126,092 57 113,002 59 104,165 59 105,027 61 80,519 55 95,229 64 89,944 66 103,603 58 85,753 63 107,037 58 115,911 56 125,084 59 121,242 58 106,997 56 122,047 61 127,120 59 103,714 62 100,028 57 100,067 68 91,169 65 129,713 60 94,639 54 56 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 f(x) = R² =
40 45 50 60 70 80 90 0 5 0 5 0 5 0 5 Cadillac Age Classes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6 58 60 62 64 66 68 70 = − 185.094929545582 x + 119119.004527191 0.002002800416047 Cadillac Income
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Lexus Age Lower Classes 35 40 Classes Frequency 40 45 40 4 45 50 45 10 55 60 50 21 65 70 60 29 75 80 70 5 85 90 80 0 90 0 More 0 Lexus Age Lexus Income 44 159,132 55 200,609 49 170,884 57 123,177 50 98,373 56 120,165 49 160,062 62 170,619 47 152,710 40 191,240 52 135,788 36 150,583 51 128,902 51 159,707 56 118,571 46 129,564 48 120,807 55 131,023 54 142,258 51 180,633 55 173,107 52 170,710 50 172,265 45 203,410 0 5 10 15 20 25 30 35 Frequency
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
44 178,881 47 122,481 44 146,011 49 117,654 47 179,617 51 112,906 51 163,248 43 149,288 45 139,938 59 242,145 46 151,133 53 174,810 56 172,232 66 134,556 68 153,138 55 127,162 61 114,276 45 168,078 55 142,599 55 144,512 47 121,780 48 169,935 53 248,134 45 225,988 55 158,123 49 183,818 56 113,445 47 174,201 63 171,605 51 162,147 51 156,740 49 135,680 46 173,449 38 164,640 50 119,412 47 179,617 44 126,774 48 126,361 51 155,846 49 174,257 54 132,175 43 146,415 30 35 4 0 50,000 100,000 150,000 200,000 250,000 300,000 f(x) = − R² = 0.0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
39 96,069 54 156,310 52 182,008
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
40 45 50 60 70 80 90 0 5 0 5 0 5 0 5 Lexus Age Classes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
40 45 50 55 60 65 70 − 110.951236917222 x + 160000.047890898 000497175962676 Lexus Age vs Income
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Lincoln Age Lower Classes 35 40 40 45 45 50 55 60 65 70 75 80 85 90
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help