Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Banking Data Median Age 35.9 37.7 36.8 35.3 35.3 34.8 39.3 36.6 35.7 40.5 37.9 43.1 37.7 36.0 40.4 33.8 36.4 37.7 36.2 39.1 39.4

Banking Data Median Age 35.9 37.7 36.8 35.3 35.3 34.8 39.3 36.6 35.7 40.5 37.9 43.1 37.7 36.0 40.4 33.8 36.4 37.7 36.2 39.1 39.4 36.1 35.3 37.5 34.4 33.7 40.4 38.9 34.3 38.7 33.4 35.0 38.1 34.9 36.1 32.7 37.1 23.5 38.0 33.6 41.7 36.6 34.9 36.7 38.4 34.8 33.6 37.0 34.4 37.2 35.7 37.8 35.6 35.7 34.3 39.8 36.2 35.1 35.6 40.7 33.5 37.5 37.6 39.1 33.1 36.4 37.3 38.7 36.9 32.7 36.1 39.5 36.5 32.9 29.9 32.1 36.1 35.9 32.7 37.2 38.8 37.5 36.4 42.4 19.5 30.5 33.2 36.7 32.4 36.5 33.9 29.6 37.5 34.0 28.7 36.1 30.6 22.8 30.3 22.0 30.8 35.1 Median Years Median Median Education Income Home Value 14.8 $91,033 $183,104 $86,748 $163,843 13.8 $72,245 $142,732 13.8 $70,639 $145,024 13.2 $64,879 $135,951 13.2 $75,591 $155,334 13.7 $80,615 $181,265 14.4 $76,507 $149,880 13.9 $107,935 $276,139 16.1 $82,557 $182,088 15.1 $58,294 $123,500 14.2 $88,041 $194,369 15.8 $64,597 $119,305 12.9 $64,894 $141,011 13.1 $61,091 $194,928 16.1 $76,771 $159,531 13.6 $55,609 $123,085 13.5 $74,091 $143,750 12.8 $53,713 $112,649 12.9 $60,262 $126,928 12.7 $111,548 $230,893 16.1 $48,600 $105,737 12.8 $51,419 $104,149 12.7 $51,182 $106,898 12.8 $60,753 $95,869 12.8 $64,601 $103,737 13.8 $62,164 $114,257 13.2 $46,607 $94,576 12.7 $61,446 $122,619 12.7 $62,024 $134,430 12.8 $54,986 $105,647 12.6 $48,182 $114,436 12.7 $47,388 $92,820 12.7 $55,273 $102,468 12.5 $53,892 $92,968 12.9 $47,923 $104,539 12.6 $46,176 $92,654 12.5 $33,088 $105,430 13.6 $53,890 $108,446 13.6 $57,390 $111,836 12.7 $48,439 $100,788 13.0 $56,803 $149,138 14.1 $52,392 $93,875 12.4 $48,631 $95,490 12.8 $52,500 $105,377 12.5 $42,401 $106,478 12.5 $64,792 $116,071 12.7 $59,842 $106,949 14.1 $65,625 $129,688 12.7 $54,044 $108,654 12.5 $39,707 $89,552 12.6 $45,286 $108,431 12.9 $37,784 $92,712 12.8 $52,284 $92,143 12.4 $42,944 $86,192 12.4 $46,036 $99,508 13.4 $50,357 $90,750 12.3 $45,521 $82,720 12.3 $30,418 $139,739 16.1 $52,500 $94,792 12.7 $41,795 $94,456 12.5 $66,667 $78,906 12.5 $38,596 $95,364 12.9 $44,286 $93,103 12.6 $37,287 $75,561 12.2 $38,184 $80,099 12.9 $47,119 $88,958 12.5 $44,520 $96,112 13.6 $52,838 $101,705 12.7 $34,688 $82,870 12.3 $31,770 $74,525 12.4 $32,994 $89,223 12.8 $33,891 $72,739 12.3 $37,813 $86,667 12.4 $46,528 $88,889 12.3 $30,319 $67,083 12.3 $36,492 $172,768 13.3 $51,818 $80,357 12.4 $35,625 $64,737 12.2 $36,789 $86,563 12.6 $42,750 $77,717 12.3 $30,412 $138,911 13.0 $37,083 $70,909 12.5 $31,563 $81,597 12.6 $15,395 $67,500 16.1 $21,433 $83,456 12.8 $31,250 $91,049 12.3 $31,344 $77,541 12.5 $29,733 $60,252 12.6 $41,607 $76,270 12.4 $32,813 $40,313 12.1 $29,375 $52,096 12.1 $34,896 $65,357 11.1 $20,578 $113,239 12.6 $32,574 $50,244 12.1 $30,589 $69,375 12.2 $26,565 $64,038 12.3 $16,590 $67,850 12.3 $9,354 $91,708 12.2 $14,115 $53,923 12.0 $17,992 $46,885 11.9 $7,741 $99,375 11.0 Median Household Wealth $220,741 $223,152 $176,926 $166,260 $148,868 $188,310 $201,743 $189,727 $211,085 $220,782 $132,432 $267,556 $186,156 $160,017 $113,559 $197,264 $105,582 $217,869 $117,441 $161,322 $331,009 $106,671 $111,168 $88,370 $143,115 $134,223 $144,038 $114,799 $161,538 $149,351 $126,929 $102,732 $118,016 $126,959 $129,176 $88,384 $101,964 $44,223 $95,013 $134,434 $124,474 $101,695 $133,101 $105,202 $139,199 $94,867 $185,714 $135,329 $175,000 $140,726 $80,124 $91,928 $60,721 $146,028 $98,778 $98,343 $126,613 $105,346 $24,999 $147,222 $91,806 $143,750 $54,453 $110,465 $86,591 $76,438 $102,993 $93,915 $75,040 $93,750 $47,446 $50,592 $81,880 $69,643 $96,591 $34,367 $24,999 $135,185 $76,321 $69,764 $95,192 $24,999 $95,833 $71,759 $24,999 $24,999 $52,976 $36,510 $27,531 $98,455 $79,167 $24,999 $81,818 $24,999 $49,662 $48,890 $42,543 $24,999 $24,999 $24,999 $24,999 $24,999 Average Bank Balance $38,517 $40,618 $35,206 $33,434 $28,162 $36,708 $38,766 $34,811 $41,032 $41,742 $29,950 $51,107 $34,936 $32,387 $32,150 $37,996 $24,672 $37,603 $26,785 $32,576 $56,569 $26,144 $24,558 $23,584 $26,773 $27,877 $28,507 $27,096 $28,018 $31,283 $24,671 $25,280 $24,890 $26,114 $27,570 $20,826 $23,858 $20,834 $26,542 $27,396 $31,054 $29,198 $24,650 $23,610 $29,706 $21,572 $32,677 $29,347 $29,127 $27,753 $21,345 $28,174 $19,125 $29,763 $22,275 $27,005 $24,076 $23,293 $16,854 $28,867 $21,556 $31,758 $17,939 $22,579 $19,343 $21,534 $22,357 $25,276 $23,077 $20,082 $15,912 $21,145 $18,340 $19,196 $21,798 $13,677 $20,572 $26,242 $17,077 $20,020 $25,385 $20,463 $21,670 $15,961 $5,956 $11,380 $18,959 $16,100 $14,620 $22,340 $26,405 $13,693 $20,586 $14,095 $14,393 $16,352 $17,410 $10,436 $9,904 $9,071 $10,679 $6,207 Beverage Sales Temperature 85 90 79 82 84 96 88 76 93 97 89 83 85 90 82 91 90 84 79 81 95 Sales $ 1,810 $ 4,825 $ 438 $ 775 $ 1,213 $ 8,692 $ 2,356 $ 266 $ 4,930 $ 9,138 $ 2,714 $ 1,082 $ 1,290 $ 3,970 $ 894 $ 2,906 $ 4,615 $ 1,168 $ 462 $ 1,018 $ 5,950 Colleges and Universities School Amherst Barnard Bates Berkeley Bowdoin Brown Bryn Mawr Cal Tech Carleton Carnegie Mellon Claremont McKenna Colby Colgate Columbia Cornell Davisdson Duke Georgetown Grinnell Hamilton Harvard Haverford Johns Hopkins Middlebury MIT Mount Holyoke Northwestern Oberlin Occidental Pomona Princeton Rice Smith Stanford Swarthnore U Michigan U of Chicago U of Rochester U Pennsylvania U Va UCLA UNC Vassar Washington U (MO) Washinton and Lee Wellesley Wesleyan (CT) Williams Yale Type Median SAT Acceptance Rate Expenditures/Student Lib Arts 1315 22% $ 26,636 Lib Arts 1220 53% $ 17,653 Lib Arts 1240 36% $ 17,554 University 1176 37% $ 23,665 Lib Arts 1300 24% $ 25,703 University 1281 24% $ 24,201 Lib Arts 1255 56% $ 18,847 University 1400 31% $ 102,262 Lib Arts 1300 40% $ 15,904 University 1225 64% $ 33,607 Lib Arts 1260 36% $ 20,377 Lib Arts 1200 46% $ 18,872 Lib Arts 1258 38% $ 17,520 University 1268 29% $ 45,879 University 1280 30% $ 37,137 Lib Arts 1230 36% $ 17,721 University 1310 25% $ 39,504 University 1278 24% $ 23,115 Lib Arts 1244 67% $ 22,301 Lib Arts 1215 38% $ 20,722 University 1370 18% $ 46,918 Lib Arts 1285 35% $ 19,418 University 1290 48% $ 45,460 Lib Arts 1255 25% $ 24,718 University 1357 30% $ 56,766 Lib Arts 1200 61% $ 23,358 University 1230 47% $ 28,851 Lib Arts 1247 54% $ 23,591 Lib Arts 1170 49% $ 20,192 Lib Arts 1320 33% $ 26,668 University 1340 17% $ 48,123 University 1327 24% $ 26,730 Lib Arts 1195 57% $ 25,271 University 1370 18% $ 61,921 Lib Arts 1310 24% $ 27,487 University 1195 60% $ 21,853 University 1300 45% $ 38,937 University 1155 56% $ 38,597 University 1280 41% $ 30,882 University 1218 37% $ 19,365 University 1142 43% $ 26,859 University 1109 32% $ 19,684 Lib Arts 1287 43% $ 20,179 University 1225 54% $ 39,883 Lib Arts 1234 29% $ 17,998 Lib Arts 1250 49% $ 27,879 Lib Arts 1290 35% $ 19,948 Lib Arts 1336 28% $ 23,772 University 1350 19% $ 52,468 Top 10% HS Graduation % 85 93 69 80 58 88 95 68 78 90 80 90 70 84 98 75 75 80 52 77 68 74 52 84 61 85 78 90 85 83 77 89 91 91 79 89 65 73 51 85 90 90 71 87 69 86 65 92 95 86 47 83 77 82 64 77 54 72 79 80 89 93 85 88 65 87 92 88 78 88 71 77 74 73 52 73 87 86 77 88 96 61 82 73 53 84 71 76 61 78 76 86 73 91 86 93 90 93 Covariance Graduation % (X) Median SAT (Y) X - Mean(X) Y - Mean(Y) 93 1315 9.755 51.898 80 1220 -3.245 -43.102 88 1240 4.755 -23.102 68 1176 -15.245 -87.102 90 1300 6.755 36.898 90 1281 6.755 17.898 84 1255 0.755 -8.102 75 1400 -8.245 136.898 80 1300 -3.245 36.898 77 1225 -6.245 -38.102 74 1260 -9.245 -3.102 84 1200 0.755 -63.102 85 1258 1.755 -5.102 90 1268 6.755 4.898 83 1280 -0.245 16.898 89 1230 5.755 -33.102 91 1310 7.755 46.898 89 1278 5.755 14.898 73 1244 -10.245 -19.102 85 1215 1.755 -48.102 90 1370 6.755 106.898 87 1285 3.755 21.898 86 1290 2.755 26.898 92 1255 8.755 -8.102 86 1357 2.755 93.898 83 1200 -0.245 -63.102 82 1230 -1.245 -33.102 77 1247 -6.245 -16.102 72 1170 -11.245 -93.102 80 1320 -3.245 56.898 93 1340 9.755 76.898 88 1327 4.755 63.898 87 1195 3.755 -68.102 88 1370 4.755 106.898 88 1310 4.755 46.898 77 1195 -6.245 -68.102 73 1300 -10.245 36.898 73 1155 -10.245 -108.102 86 1280 2.755 16.898 88 1218 4.755 -45.102 61 1142 -22.245 -121.102 73 1109 -10.245 -154.102 84 1287 0.755 23.898 76 1225 -7.245 -38.102 78 1234 -5.245 -29.102 86 1250 2.755 -13.102 91 1290 7.755 26.898 93 1336 9.755 72.898 93 1350 9.755 86.898 Mean 83.245 1263.102 Sum Count Covariance COVARIANCE.S (X - Mean(X))(Y-Mean(Y)) 506.2698875469 139.8617242816 -109.8525614327 1327.8617242816 249.2494793836 120.9025406081 -6.1178675552 -1128.7097042899 -119.7301124531 237.9433569346 28.6780508122 -47.6484798001 -8.9546022491 33.0862140775 -4.1382757185 -190.5056226572 363.6984589754 85.739275302 195.6984589754 -84.4239900042 722.1066222407 82.2290712203 74.1066222407 -70.9341940858 258.6984589754 15.4535610162 41.2086630571 100.5556018326 1046.9229487714 -184.6280716368 750.1474385673 303.8413161183 -255.7301124531 508.3107038734 223.0045814244 425.2902957101 -378.0158267389 1107.4943773428 46.5556018326 -214.4648063307 2693.9025406081 1578.7596834652 18.0453977509 276.0453977509 152.6372344856 -36.0974593919 208.5964181591 711.127030404 847.6984589754 12641.7755102041 49 263.3703231293 263.3703231293 Correlation Mean Sample Standard Deviation Graduation % (X) Median SAT (Y) X - Mean(X) Y - Mean(Y) 93 1315 9.755 51.898 80 1220 -3.245 -43.102 88 1240 4.755 -23.102 68 1176 -15.245 -87.102 90 1300 6.755 36.898 90 1281 6.755 17.898 84 1255 0.755 -8.102 75 1400 -8.245 136.898 80 1300 -3.245 36.898 77 1225 -6.245 -38.102 74 1260 -9.245 -3.102 84 1200 0.755 -63.102 85 1258 1.755 -5.102 90 1268 6.755 4.898 83 1280 -0.245 16.898 89 1230 5.755 -33.102 91 1310 7.755 46.898 89 1278 5.755 14.898 73 1244 -10.245 -19.102 85 1215 1.755 -48.102 90 1370 6.755 106.898 87 1285 3.755 21.898 86 1290 2.755 26.898 92 1255 8.755 -8.102 86 1357 2.755 93.898 83 1200 -0.245 -63.102 82 1230 -1.245 -33.102 77 1247 -6.245 -16.102 72 1170 -11.245 -93.102 80 1320 -3.245 56.898 93 1340 9.755 76.898 88 1327 4.755 63.898 87 1195 3.755 -68.102 88 1370 4.755 106.898 88 1310 4.755 46.898 77 1195 -6.245 -68.102 73 1300 -10.245 36.898 73 1155 -10.245 -108.102 86 1280 2.755 16.898 88 1218 4.755 -45.102 61 1142 -22.245 -121.102 73 1109 -10.245 -154.102 84 1287 0.755 23.898 76 1225 -7.245 -38.102 78 1234 -5.245 -29.102 86 1250 2.755 -13.102 91 1290 7.755 26.898 93 1336 9.755 72.898 93 1350 9.755 86.898 83.245 1263.102 Sum 7.449 62.676 Count Sample Covariance Sample Correlation CORREL Function Assuming Population Data: Population Standard Deviation Population Covariance Population Correlation 7.372 257.9954185756 0.5641468267 62.034 (X - Mean(X))(Y-Mean(Y)) 506.2698875469 139.8617242816 -109.8525614327 1327.8617242816 249.2494793836 120.9025406081 -6.1178675552 -1128.7097042899 -119.7301124531 237.9433569346 28.6780508122 -47.6484798001 -8.9546022491 33.0862140775 -4.1382757185 -190.5056226572 363.6984589754 85.739275302 195.6984589754 -84.4239900042 722.1066222407 82.2290712203 74.1066222407 -70.9341940858 258.6984589754 15.4535610162 41.2086630571 100.5556018326 1046.9229487714 -184.6280716368 750.1474385673 303.8413161183 -255.7301124531 508.3107038734 223.0045814244 425.2902957101 -378.0158267389 1107.4943773428 46.5556018326 -214.4648063307 2693.9025406081 1578.7596834652 18.0453977509 276.0453977509 152.6372344856 -36.0974593919 208.5964181591 711.127030404 847.6984589754 12641.7755102041 49 263.3703231293 0.5641468267 0.5641468267 Crude Oil Prices Prices shown are dollars per barrel on the first Friday of the month Date 2006-Jan 2006-Feb 2006-Mar 2006-Apr 2006-May 2006-Jun 2006-Jul 2006-Aug 2006-Sep 2006-Oct 2006-Nov 2006-Dec 2007-Jan 2007-Feb 2007-Mar 2007-Apr 2007-May 2007-Jun 2007-Jul 2007-Aug 2007-Sep 2007-Oct 2007-Nov 2007-Dec 2008-Jan 2008-Feb 2008-Mar 2008-Apr 2008-May 2008-Jun Price $55.12 $59.84 $55.98 $61.27 $66.94 $64.67 $67.74 $69.79 $64.49 $54.92 $53.32 $56.13 $54.63 $52.11 $57.83 $64.93 $63.40 $65.37 $69.91 $73.81 $71.42 $75.57 $86.02 $85.91 $92.93 $88.71 $98.01 $98.39 $110.21 $121.36 Price $140.00 $120.00 $100.00 $80.00 $60.00 $40.00 $20.00 $0.00 Employee Salary Data Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Salary 28,260 43,392 56,322 26,086 36,807 57,119 48,907 34,301 31,104 60,054 41,420 36,508 40,015 48,329 39,849 31,985 59,160 60,335 35,911 57,814 42,377 62,430 46,928 34,403 45,714 42,247 54,789 31,702 34,406 84,876 27,399 55,785 34,649 64,236 50,241 Age 25 28 37 23 32 57 45 32 25 57 42 25 38 47 38 31 54 59 32 55 36 60 49 35 32 27 52 30 33 57 24 51 30 61 45 MBA No Yes Yes No No No No No No No No Yes No No No No No No No No No No No No Yes Yes No No No Yes No No No No No Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32 1,692 $87,500.00 32 2,372 $114,000.00 32 2,372 $113,200.00 33 1,666 $87,500.00 32 2,123 $116,100.00 32 1,620 $94,700.00 32 1,731 $86,400.00 32 1,666 $87,100.00 28 1,520 $83,400.00 27 1,484 $79,800.00 28 1,588 $81,500.00 28 1,598 $87,100.00 28 1,484 $82,600.00 28 1,484 $78,800.00 28 1,520 $87,600.00 27 1,701 $94,200.00 28 1,484 $82,000.00 28 1,468 $88,100.00 28 1,520 $88,100.00 27 1,520 $88,600.00 27 1,484 $76,600.00 28 1,520 $84,400.00 27 1,668 $90,900.00 28 1,588 $81,000.00 28 1,784 $91,300.00 27 1,484 $81,300.00 27 1,520 $100,700.00 28 1,520 $87,200.00 27 1,684 $96,700.00 27 1,581 $120,700.00 Home Market Value House Age Square Feet z-score Market Value z-score 33 1,812 0.5300 $90,000.00 -0.196 32 1,914 0.9931 $104,400.00 1.168 32 1,842 0.6662 $93,300.00 0.117 33 1,812 0.5300 $91,000.00 -0.101 32 1,836 0.6390 $101,900.00 0.932 33 2,028 1.5107 $108,500.00 1.557 32 1,732 0.1668 $87,600.00 -0.423 33 1,850 0.7025 $96,000.00 0.372 32 1,791 0.4347 $89,200.00 -0.272 33 1,666 -0.1329 $88,400.00 -0.348 32 1,852 0.7116 $100,800.00 0.827 32 1,620 -0.3417 $96,700.00 0.439 32 1,692 -0.0148 $87,500.00 -0.433 32 2,372 3.0725 $114,000.00 2.078 32 2,372 3.0725 $113,200.00 2.002 33 1,666 -0.1329 $87,500.00 -0.433 32 2,123 1.9420 $116,100.00 2.277 32 1,620 -0.3417 $94,700.00 0.249 32 1,731 0.1623 $86,400.00 -0.537 32 1,666 -0.1329 $87,100.00 -0.471 28 1,520 -0.7957 $83,400.00 -0.821 27 1,484 -0.9592 $79,800.00 -1.163 28 1,588 -0.4870 $81,500.00 -1.002 28 1,598 -0.4416 $87,100.00 -0.471 28 1,484 -0.9592 $82,600.00 -0.897 28 1,484 -0.9592 $78,800.00 -1.257 28 1,520 -0.7957 $87,600.00 -0.423 27 1,701 0.0261 $94,200.00 0.202 28 1,484 -0.9592 $82,000.00 -0.954 28 1,468 -1.0318 $88,100.00 -0.376 28 1,520 -0.7957 $88,100.00 -0.376 27 1,520 -0.7957 $88,600.00 -0.329 27 1,484 -0.9592 $76,600.00 -1.466 28 1,520 -0.7957 $84,400.00 -0.727 27 1,668 -0.1238 $90,900.00 -0.111 28 1,588 -0.4870 $81,000.00 -1.049 28 1,784 0.4029 $91,300.00 -0.073 27 1,484 -0.9592 $81,300.00 -1.020 27 1,520 -0.7957 $100,700.00 0.818 28 1,520 -0.7957 $87,200.00 -0.461 27 1,684 -0.0511 $96,700.00 0.439 27 1,581 -0.5188 $120,700.00 2.713 Mean 1,695 92,069 Standard Deviatio 220.257 10553.083 Price-Sales Data Price Demand $50.00 19964.085 $60.00 19706.855 $70.00 20240.83 $80.00 19698.807 $90.00 20095.808 $100.00 19390.994 $110.00 19430.071 $120.00 19273.695 $130.00 18716.381 $140.00 18925.364 $150.00 19484.776 $160.00 18934.879 $170.00 18915.765 $180.00 18893.373 $190.00 18961.622 $200.00 18443.294 $210.00 18811.981 $220.00 18561.917 $230.00 18158.619 $240.00 18412.56 $250.00 17771.387 Price-Sales Data 20500 20000 19500 f(x) = - 9.5116229448x + 20512.1273366493 R = 0.8330440154 19000 Sales 18500 18000 17500 17000 16500 $0.00 $50.00 $100.00 $150.00 Price $200.00 $250.00 $300.00 00 $300.00 Surface Finish Data Part 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Surface Finish RPM Cutting Tool 45.44 225 A 42.03 200 A 50.10 250 A 48.75 245 A 47.92 235 A 47.79 237 A 52.26 265 A 50.52 259 A 45.58 221 A 44.78 218 A 33.50 224 B 31.23 212 B 37.52 248 B 37.13 260 B 34.70 243 B 33.92 238 B 32.13 224 B 35.47 251 B 33.49 232 B 32.29 216 B 27.44 225 C 24.03 200 C 27.33 250 C 27.20 245 C 27.10 235 C 27.30 237 C 28.30 265 C 28.40 259 C 26.80 221 C 26.40 218 C 21.40 224 D 20.50 212 D 21.90 248 D 22.13 260 D 22.40 243 D Surface Finish Data Part 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Surface Finish RPM Type B Type C Type D 45.44 225 0 0 0 42.03 200 0 0 0 50.10 250 0 0 0 48.75 245 0 0 0 47.92 235 0 0 0 47.79 237 0 0 0 52.26 265 0 0 0 50.52 259 0 0 0 45.58 221 0 0 0 44.78 218 0 0 0 33.50 224 1 0 0 31.23 212 1 0 0 37.52 248 1 0 0 37.13 260 1 0 0 34.70 243 1 0 0 33.92 238 1 0 0 32.13 224 1 0 0 35.47 251 1 0 0 33.49 232 1 0 0 32.29 216 1 0 0 27.44 225 0 1 0 24.03 200 0 1 0 27.33 250 0 1 0 27.20 245 0 1 0 27.10 235 0 1 0 27.30 237 0 1 0 28.30 265 0 1 0 28.40 259 0 1 0 26.80 221 0 1 0 26.40 218 0 1 0 21.40 224 0 0 1 20.50 212 0 0 1 21.90 248 0 0 1 22.13 260 0 0 1 22.40 243 0 0 1 Banking Data Median Age 35.9 37.7 36.8 35.3 35.3 34.8 39.3 36.6 35.7 40.5 37.9 43.1 37.7 36.0 40.4 33.8 36.4 37.7 36.2 39.1 39.4 36.1 35.3 37.5 34.4 33.7 40.4 38.9 34.3 38.7 33.4 35.0 38.1 34.9 36.1 32.7 37.1 23.5 38.0 33.6 41.7 36.6 34.9 36.7 38.4 34.8 33.6 37.0 34.4 37.2 35.7 37.8 35.6 35.7 34.3 39.8 36.2 35.1 35.6 40.7 33.5 37.5 37.6 39.1 33.1 36.4 37.3 38.7 36.9 32.7 36.1 39.5 36.5 32.9 29.9 32.1 36.1 35.9 32.7 37.2 38.8 37.5 36.4 42.4 19.5 30.5 33.2 36.7 32.4 36.5 33.9 29.6 37.5 34.0 28.7 36.1 30.6 22.8 30.3 22.0 30.8 35.1 Median Years Median Median Education Income Home Value 14.8 $91,033 $183,104 $86,748 $163,843 13.8 $72,245 $142,732 13.8 $70,639 $145,024 13.2 $64,879 $135,951 13.2 $75,591 $155,334 13.7 $80,615 $181,265 14.4 $76,507 $149,880 13.9 $107,935 $276,139 16.1 $82,557 $182,088 15.1 $58,294 $123,500 14.2 $88,041 $194,369 15.8 $64,597 $119,305 12.9 $64,894 $141,011 13.1 $61,091 $194,928 16.1 $76,771 $159,531 13.6 $55,609 $123,085 13.5 $74,091 $143,750 12.8 $53,713 $112,649 12.9 $60,262 $126,928 12.7 $111,548 $230,893 16.1 $48,600 $105,737 12.8 $51,419 $104,149 12.7 $51,182 $106,898 12.8 $60,753 $95,869 12.8 $64,601 $103,737 13.8 $62,164 $114,257 13.2 $46,607 $94,576 12.7 $61,446 $122,619 12.7 $62,024 $134,430 12.8 $54,986 $105,647 12.6 $48,182 $114,436 12.7 $47,388 $92,820 12.7 $55,273 $102,468 12.5 $53,892 $92,968 12.9 $47,923 $104,539 12.6 $46,176 $92,654 12.5 $33,088 $105,430 13.6 $53,890 $108,446 13.6 $57,390 $111,836 12.7 $48,439 $100,788 13.0 $56,803 $149,138 14.1 $52,392 $93,875 12.4 $48,631 $95,490 12.8 $52,500 $105,377 12.5 $42,401 $106,478 12.5 $64,792 $116,071 12.7 $59,842 $106,949 14.1 $65,625 $129,688 12.7 $54,044 $108,654 12.5 $39,707 $89,552 12.6 $45,286 $108,431 12.9 $37,784 $92,712 12.8 $52,284 $92,143 12.4 $42,944 $86,192 12.4 $46,036 $99,508 13.4 $50,357 $90,750 12.3 $45,521 $82,720 12.3 $30,418 $139,739 16.1 $52,500 $94,792 12.7 $41,795 $94,456 12.5 $66,667 $78,906 12.5 $38,596 $95,364 12.9 $44,286 $93,103 12.6 $37,287 $75,561 12.2 $38,184 $80,099 12.9 $47,119 $88,958 12.5 $44,520 $96,112 13.6 $52,838 $101,705 12.7 $34,688 $82,870 12.3 $31,770 $74,525 12.4 $32,994 $89,223 12.8 $33,891 $72,739 12.3 $37,813 $86,667 12.4 $46,528 $88,889 12.3 $30,319 $67,083 12.3 $36,492 $172,768 13.3 $51,818 $80,357 12.4 $35,625 $64,737 12.2 $36,789 $86,563 12.6 $42,750 $77,717 12.3 $30,412 $138,911 13.0 $37,083 $70,909 12.5 $31,563 $81,597 12.6 $15,395 $67,500 16.1 $21,433 $83,456 12.8 $31,250 $91,049 12.3 $31,344 $77,541 12.5 $29,733 $60,252 12.6 $41,607 $76,270 12.4 $32,813 $40,313 12.1 $29,375 $52,096 12.1 $34,896 $65,357 11.1 $20,578 $113,239 12.6 $32,574 $50,244 12.1 $30,589 $69,375 12.2 $26,565 $64,038 12.3 $16,590 $67,850 12.3 $9,354 $91,708 12.2 $14,115 $53,923 12.0 $17,992 $46,885 11.9 $7,741 $99,375 11.0 Median Household Wealth $220,741 $223,152 $176,926 $166,260 $148,868 $188,310 $201,743 $189,727 $211,085 $220,782 $132,432 $267,556 $186,156 $160,017 $113,559 $197,264 $105,582 $217,869 $117,441 $161,322 $331,009 $106,671 $111,168 $88,370 $143,115 $134,223 $144,038 $114,799 $161,538 $149,351 $126,929 $102,732 $118,016 $126,959 $129,176 $88,384 $101,964 $44,223 $95,013 $134,434 $124,474 $101,695 $133,101 $105,202 $139,199 $94,867 $185,714 $135,329 $175,000 $140,726 $80,124 $91,928 $60,721 $146,028 $98,778 $98,343 $126,613 $105,346 $24,999 $147,222 $91,806 $143,750 $54,453 $110,465 $86,591 $76,438 $102,993 $93,915 $75,040 $93,750 $47,446 $50,592 $81,880 $69,643 $96,591 $34,367 $24,999 $135,185 $76,321 $69,764 $95,192 $24,999 $95,833 $71,759 $24,999 $24,999 $52,976 $36,510 $27,531 $98,455 $79,167 $24,999 $81,818 $24,999 $49,662 $48,890 $42,543 $24,999 $24,999 $24,999 $24,999 $24,999 Average Bank Balance $38,517 $40,618 $35,206 $33,434 $28,162 $36,708 $38,766 $34,811 $41,032 $41,742 $29,950 $51,107 $34,936 $32,387 $32,150 $37,996 $24,672 $37,603 $26,785 $32,576 $56,569 $26,144 $24,558 $23,584 $26,773 $27,877 $28,507 $27,096 $28,018 $31,283 $24,671 $25,280 $24,890 $26,114 $27,570 $20,826 $23,858 $20,834 $26,542 $27,396 $31,054 $29,198 $24,650 $23,610 $29,706 $21,572 $32,677 $29,347 $29,127 $27,753 $21,345 $28,174 $19,125 $29,763 $22,275 $27,005 $24,076 $23,293 $16,854 $28,867 $21,556 $31,758 $17,939 $22,579 $19,343 $21,534 $22,357 $25,276 $23,077 $20,082 $15,912 $21,145 $18,340 $19,196 $21,798 $13,677 $20,572 $26,242 $17,077 $20,020 $25,385 $20,463 $21,670 $15,961 $5,956 $11,380 $18,959 $16,100 $14,620 $22,340 $26,405 $13,693 $20,586 $14,095 $14,393 $16,352 $17,410 $10,436 $9,904 $9,071 $10,679 $6,207 Beverage Sales Temperature 85 90 79 82 84 96 88 76 93 97 89 83 85 90 82 91 90 84 79 81 95 Sales $ 1,810 $ 4,825 $ 438 $ 775 $ 1,213 $ 8,692 $ 2,356 $ 266 $ 4,930 $ 9,138 $ 2,714 $ 1,082 $ 1,290 $ 3,970 $ 894 $ 2,906 $ 4,615 $ 1,168 $ 462 $ 1,018 $ 5,950 Colleges and Universities School Amherst Barnard Bates Berkeley Bowdoin Brown Bryn Mawr Cal Tech Carleton Carnegie Mellon Claremont McKenna Colby Colgate Columbia Cornell Davisdson Duke Georgetown Grinnell Hamilton Harvard Haverford Johns Hopkins Middlebury MIT Mount Holyoke Northwestern Oberlin Occidental Pomona Princeton Rice Smith Stanford Swarthnore U Michigan U of Chicago U of Rochester U Pennsylvania U Va UCLA UNC Vassar Washington U (MO) Washinton and Lee Wellesley Wesleyan (CT) Williams Yale Type Median SAT Acceptance Rate Expenditures/Student Lib Arts 1315 22% $ 26,636 Lib Arts 1220 53% $ 17,653 Lib Arts 1240 36% $ 17,554 University 1176 37% $ 23,665 Lib Arts 1300 24% $ 25,703 University 1281 24% $ 24,201 Lib Arts 1255 56% $ 18,847 University 1400 31% $ 102,262 Lib Arts 1300 40% $ 15,904 University 1225 64% $ 33,607 Lib Arts 1260 36% $ 20,377 Lib Arts 1200 46% $ 18,872 Lib Arts 1258 38% $ 17,520 University 1268 29% $ 45,879 University 1280 30% $ 37,137 Lib Arts 1230 36% $ 17,721 University 1310 25% $ 39,504 University 1278 24% $ 23,115 Lib Arts 1244 67% $ 22,301 Lib Arts 1215 38% $ 20,722 University 1370 18% $ 46,918 Lib Arts 1285 35% $ 19,418 University 1290 48% $ 45,460 Lib Arts 1255 25% $ 24,718 University 1357 30% $ 56,766 Lib Arts 1200 61% $ 23,358 University 1230 47% $ 28,851 Lib Arts 1247 54% $ 23,591 Lib Arts 1170 49% $ 20,192 Lib Arts 1320 33% $ 26,668 University 1340 17% $ 48,123 University 1327 24% $ 26,730 Lib Arts 1195 57% $ 25,271 University 1370 18% $ 61,921 Lib Arts 1310 24% $ 27,487 University 1195 60% $ 21,853 University 1300 45% $ 38,937 University 1155 56% $ 38,597 University 1280 41% $ 30,882 University 1218 37% $ 19,365 University 1142 43% $ 26,859 University 1109 32% $ 19,684 Lib Arts 1287 43% $ 20,179 University 1225 54% $ 39,883 Lib Arts 1234 29% $ 17,998 Lib Arts 1250 49% $ 27,879 Lib Arts 1290 35% $ 19,948 Lib Arts 1336 28% $ 23,772 University 1350 19% $ 52,468 Top 10% HS Graduation % 85 93 69 80 58 88 95 68 78 90 80 90 70 84 98 75 75 80 52 77 68 74 52 84 61 85 78 90 85 83 77 89 91 91 79 89 65 73 51 85 90 90 71 87 69 86 65 92 95 86 47 83 77 82 64 77 54 72 79 80 89 93 85 88 65 87 92 88 78 88 71 77 74 73 52 73 87 86 77 88 96 61 82 73 53 84 71 76 61 78 76 86 73 91 86 93 90 93 Covariance Graduation % (X) Median SAT (Y) X - Mean(X) Y - Mean(Y) 93 1315 9.755 51.898 80 1220 -3.245 -43.102 88 1240 4.755 -23.102 68 1176 -15.245 -87.102 90 1300 6.755 36.898 90 1281 6.755 17.898 84 1255 0.755 -8.102 75 1400 -8.245 136.898 80 1300 -3.245 36.898 77 1225 -6.245 -38.102 74 1260 -9.245 -3.102 84 1200 0.755 -63.102 85 1258 1.755 -5.102 90 1268 6.755 4.898 83 1280 -0.245 16.898 89 1230 5.755 -33.102 91 1310 7.755 46.898 89 1278 5.755 14.898 73 1244 -10.245 -19.102 85 1215 1.755 -48.102 90 1370 6.755 106.898 87 1285 3.755 21.898 86 1290 2.755 26.898 92 1255 8.755 -8.102 86 1357 2.755 93.898 83 1200 -0.245 -63.102 82 1230 -1.245 -33.102 77 1247 -6.245 -16.102 72 1170 -11.245 -93.102 80 1320 -3.245 56.898 93 1340 9.755 76.898 88 1327 4.755 63.898 87 1195 3.755 -68.102 88 1370 4.755 106.898 88 1310 4.755 46.898 77 1195 -6.245 -68.102 73 1300 -10.245 36.898 73 1155 -10.245 -108.102 86 1280 2.755 16.898 88 1218 4.755 -45.102 61 1142 -22.245 -121.102 73 1109 -10.245 -154.102 84 1287 0.755 23.898 76 1225 -7.245 -38.102 78 1234 -5.245 -29.102 86 1250 2.755 -13.102 91 1290 7.755 26.898 93 1336 9.755 72.898 93 1350 9.755 86.898 Mean 83.245 1263.102 Sum Count Covariance COVARIANCE.S (X - Mean(X))(Y-Mean(Y)) 506.2698875469 139.8617242816 -109.8525614327 1327.8617242816 249.2494793836 120.9025406081 -6.1178675552 -1128.7097042899 -119.7301124531 237.9433569346 28.6780508122 -47.6484798001 -8.9546022491 33.0862140775 -4.1382757185 -190.5056226572 363.6984589754 85.739275302 195.6984589754 -84.4239900042 722.1066222407 82.2290712203 74.1066222407 -70.9341940858 258.6984589754 15.4535610162 41.2086630571 100.5556018326 1046.9229487714 -184.6280716368 750.1474385673 303.8413161183 -255.7301124531 508.3107038734 223.0045814244 425.2902957101 -378.0158267389 1107.4943773428 46.5556018326 -214.4648063307 2693.9025406081 1578.7596834652 18.0453977509 276.0453977509 152.6372344856 -36.0974593919 208.5964181591 711.127030404 847.6984589754 12641.7755102041 49 263.3703231293 263.3703231293 Correlation Mean Sample Standard Deviation Graduation % (X) Median SAT (Y) X - Mean(X) Y - Mean(Y) 93 1315 9.755 51.898 80 1220 -3.245 -43.102 88 1240 4.755 -23.102 68 1176 -15.245 -87.102 90 1300 6.755 36.898 90 1281 6.755 17.898 84 1255 0.755 -8.102 75 1400 -8.245 136.898 80 1300 -3.245 36.898 77 1225 -6.245 -38.102 74 1260 -9.245 -3.102 84 1200 0.755 -63.102 85 1258 1.755 -5.102 90 1268 6.755 4.898 83 1280 -0.245 16.898 89 1230 5.755 -33.102 91 1310 7.755 46.898 89 1278 5.755 14.898 73 1244 -10.245 -19.102 85 1215 1.755 -48.102 90 1370 6.755 106.898 87 1285 3.755 21.898 86 1290 2.755 26.898 92 1255 8.755 -8.102 86 1357 2.755 93.898 83 1200 -0.245 -63.102 82 1230 -1.245 -33.102 77 1247 -6.245 -16.102 72 1170 -11.245 -93.102 80 1320 -3.245 56.898 93 1340 9.755 76.898 88 1327 4.755 63.898 87 1195 3.755 -68.102 88 1370 4.755 106.898 88 1310 4.755 46.898 77 1195 -6.245 -68.102 73 1300 -10.245 36.898 73 1155 -10.245 -108.102 86 1280 2.755 16.898 88 1218 4.755 -45.102 61 1142 -22.245 -121.102 73 1109 -10.245 -154.102 84 1287 0.755 23.898 76 1225 -7.245 -38.102 78 1234 -5.245 -29.102 86 1250 2.755 -13.102 91 1290 7.755 26.898 93 1336 9.755 72.898 93 1350 9.755 86.898 83.245 1263.102 Sum 7.449 62.676 Count Sample Covariance Sample Correlation CORREL Function Assuming Population Data: Population Standard Deviation Population Covariance Population Correlation 7.372 257.9954185756 0.5641468267 62.034 (X - Mean(X))(Y-Mean(Y)) 506.2698875469 139.8617242816 -109.8525614327 1327.8617242816 249.2494793836 120.9025406081 -6.1178675552 -1128.7097042899 -119.7301124531 237.9433569346 28.6780508122 -47.6484798001 -8.9546022491 33.0862140775 -4.1382757185 -190.5056226572 363.6984589754 85.739275302 195.6984589754 -84.4239900042 722.1066222407 82.2290712203 74.1066222407 -70.9341940858 258.6984589754 15.4535610162 41.2086630571 100.5556018326 1046.9229487714 -184.6280716368 750.1474385673 303.8413161183 -255.7301124531 508.3107038734 223.0045814244 425.2902957101 -378.0158267389 1107.4943773428 46.5556018326 -214.4648063307 2693.9025406081 1578.7596834652 18.0453977509 276.0453977509 152.6372344856 -36.0974593919 208.5964181591 711.127030404 847.6984589754 12641.7755102041 49 263.3703231293 0.5641468267 0.5641468267 Crude Oil Prices Prices shown are dollars per barrel on the first Friday of the month Date 2006-Jan 2006-Feb 2006-Mar 2006-Apr 2006-May 2006-Jun 2006-Jul 2006-Aug 2006-Sep 2006-Oct 2006-Nov 2006-Dec 2007-Jan 2007-Feb 2007-Mar 2007-Apr 2007-May 2007-Jun 2007-Jul 2007-Aug 2007-Sep 2007-Oct 2007-Nov 2007-Dec 2008-Jan 2008-Feb 2008-Mar 2008-Apr 2008-May 2008-Jun Price $55.12 $59.84 $55.98 $61.27 $66.94 $64.67 $67.74 $69.79 $64.49 $54.92 $53.32 $56.13 $54.63 $52.11 $57.83 $64.93 $63.40 $65.37 $69.91 $73.81 $71.42 $75.57 $86.02 $85.91 $92.93 $88.71 $98.01 $98.39 $110.21 $121.36 Price $140.00 $120.00 $100.00 $80.00 $60.00 $40.00 $20.00 $0.00 Employee Salary Data Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Salary 28,260 43,392 56,322 26,086 36,807 57,119 48,907 34,301 31,104 60,054 41,420 36,508 40,015 48,329 39,849 31,985 59,160 60,335 35,911 57,814 42,377 62,430 46,928 34,403 45,714 42,247 54,789 31,702 34,406 84,876 27,399 55,785 34,649 64,236 50,241 Age 25 28 37 23 32 57 45 32 25 57 42 25 38 47 38 31 54 59 32 55 36 60 49 35 32 27 52 30 33 57 24 51 30 61 45 MBA No Yes Yes No No No No No No No No Yes No No No No No No No No No No No No Yes Yes No No No Yes No No No No No Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32 1,692 $87,500.00 32 2,372 $114,000.00 32 2,372 $113,200.00 33 1,666 $87,500.00 32 2,123 $116,100.00 32 1,620 $94,700.00 32 1,731 $86,400.00 32 1,666 $87,100.00 28 1,520 $83,400.00 27 1,484 $79,800.00 28 1,588 $81,500.00 28 1,598 $87,100.00 28 1,484 $82,600.00 28 1,484 $78,800.00 28 1,520 $87,600.00 27 1,701 $94,200.00 28 1,484 $82,000.00 28 1,468 $88,100.00 28 1,520 $88,100.00 27 1,520 $88,600.00 27 1,484 $76,600.00 28 1,520 $84,400.00 27 1,668 $90,900.00 28 1,588 $81,000.00 28 1,784 $91,300.00 27 1,484 $81,300.00 27 1,520 $100,700.00 28 1,520 $87,200.00 27 1,684 $96,700.00 27 1,581 $120,700.00 Home Market Value House Age Square Feet z-score Market Value z-score 33 1,812 0.5300 $90,000.00 -0.196 32 1,914 0.9931 $104,400.00 1.168 32 1,842 0.6662 $93,300.00 0.117 33 1,812 0.5300 $91,000.00 -0.101 32 1,836 0.6390 $101,900.00 0.932 33 2,028 1.5107 $108,500.00 1.557 32 1,732 0.1668 $87,600.00 -0.423 33 1,850 0.7025 $96,000.00 0.372 32 1,791 0.4347 $89,200.00 -0.272 33 1,666 -0.1329 $88,400.00 -0.348 32 1,852 0.7116 $100,800.00 0.827 32 1,620 -0.3417 $96,700.00 0.439 32 1,692 -0.0148 $87,500.00 -0.433 32 2,372 3.0725 $114,000.00 2.078 32 2,372 3.0725 $113,200.00 2.002 33 1,666 -0.1329 $87,500.00 -0.433 32 2,123 1.9420 $116,100.00 2.277 32 1,620 -0.3417 $94,700.00 0.249 32 1,731 0.1623 $86,400.00 -0.537 32 1,666 -0.1329 $87,100.00 -0.471 28 1,520 -0.7957 $83,400.00 -0.821 27 1,484 -0.9592 $79,800.00 -1.163 28 1,588 -0.4870 $81,500.00 -1.002 28 1,598 -0.4416 $87,100.00 -0.471 28 1,484 -0.9592 $82,600.00 -0.897 28 1,484 -0.9592 $78,800.00 -1.257 28 1,520 -0.7957 $87,600.00 -0.423 27 1,701 0.0261 $94,200.00 0.202 28 1,484 -0.9592 $82,000.00 -0.954 28 1,468 -1.0318 $88,100.00 -0.376 28 1,520 -0.7957 $88,100.00 -0.376 27 1,520 -0.7957 $88,600.00 -0.329 27 1,484 -0.9592 $76,600.00 -1.466 28 1,520 -0.7957 $84,400.00 -0.727 27 1,668 -0.1238 $90,900.00 -0.111 28 1,588 -0.4870 $81,000.00 -1.049 28 1,784 0.4029 $91,300.00 -0.073 27 1,484 -0.9592 $81,300.00 -1.020 27 1,520 -0.7957 $100,700.00 0.818 28 1,520 -0.7957 $87,200.00 -0.461 27 1,684 -0.0511 $96,700.00 0.439 27 1,581 -0.5188 $120,700.00 2.713 Mean 1,695 92,069 Standard Deviatio 220.257 10553.083 Price-Sales Data Price Demand $50.00 19964.085 $60.00 19706.855 $70.00 20240.83 $80.00 19698.807 $90.00 20095.808 $100.00 19390.994 $110.00 19430.071 $120.00 19273.695 $130.00 18716.381 $140.00 18925.364 $150.00 19484.776 $160.00 18934.879 $170.00 18915.765 $180.00 18893.373 $190.00 18961.622 $200.00 18443.294 $210.00 18811.981 $220.00 18561.917 $230.00 18158.619 $240.00 18412.56 $250.00 17771.387 Price-Sales Data 20500 20000 19500 f(x) = - 9.5116229448x + 20512.1273366493 R = 0.8330440154 19000 Sales 18500 18000 17500 17000 16500 $0.00 $50.00 $100.00 $150.00 Price $200.00 $250.00 $300.00 00 $300.00 Surface Finish Data Part 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Surface Finish RPM Cutting Tool 45.44 225 A 42.03 200 A 50.10 250 A 48.75 245 A 47.92 235 A 47.79 237 A 52.26 265 A 50.52 259 A 45.58 221 A 44.78 218 A 33.50 224 B 31.23 212 B 37.52 248 B 37.13 260 B 34.70 243 B 33.92 238 B 32.13 224 B 35.47 251 B 33.49 232 B 32.29 216 B 27.44 225 C 24.03 200 C 27.33 250 C 27.20 245 C 27.10 235 C 27.30 237 C 28.30 265 C 28.40 259 C 26.80 221 C 26.40 218 C 21.40 224 D 20.50 212 D 21.90 248 D 22.13 260 D 22.40 243 D Surface Finish Data Part 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Surface Finish RPM Type B Type C Type D 45.44 225 0 0 0 42.03 200 0 0 0 50.10 250 0 0 0 48.75 245 0 0 0 47.92 235 0 0 0 47.79 237 0 0 0 52.26 265 0 0 0 50.52 259 0 0 0 45.58 221 0 0 0 44.78 218 0 0 0 33.50 224 1 0 0 31.23 212 1 0 0 37.52 248 1 0 0 37.13 260 1 0 0 34.70 243 1 0 0 33.92 238 1 0 0 32.13 224 1 0 0 35.47 251 1 0 0 33.49 232 1 0 0 32.29 216 1 0 0 27.44 225 0 1 0 24.03 200 0 1 0 27.33 250 0 1 0 27.20 245 0 1 0 27.10 235 0 1 0 27.30 237 0 1 0 28.30 265 0 1 0 28.40 259 0 1 0 26.80 221 0 1 0 26.40 218 0 1 0 21.40 224 0 0 1 20.50 212 0 0 1 21.90 248 0 0 1 22.13 260 0 0 1 22.40 243 0 0 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Real Analysis

Authors: Robert G. Bartle, Donald R. Sherbert

4th edition

471433314, 978-1118135853, 1118135857, 978-1118135860, 1118135865, 978-0471433316

More Books

Students also viewed these Mathematics questions