Week2Excel2.xlsx

Question 1

MBA Motivation and Salary Expectations
AgeGenderYears Work ExperienceMotivationPre-MBA SalaryPost-MBA Salary
30MMore than 6Career Advancement$85,000$105,000
34FMore than 6Career Advancement$87,000$100,000
28M4 to 6Career Advancement$70,000$100,000
35MMore than 6Higher Financial Earnings$95,000$125,000
23M1 to 3Career Advancement$52,000$60,000
28F4 to 6Career Advancement$47,000$70,000
39MMore than 6Career Advancement$70,000$130,000
26F4 to 6Career Advancement$55,000$75,000
30MMore than 6Career Change$75,000$110,000
24M1 to 3Higher Financial Earnings$50,000$80,000
23M1 to 3Higher Financial Earnings$42,500$85,000
28M4 to 6Career Advancement$70,000$90,000
28M4 to 6Career Advancement$55,000$70,000
27F4 to 6Career Advancement$60,000$90,000
26F4 to 6Career Change$65,000$80,000
31MMore than 6Career Advancement$90,000$110,000
35MMore than 6Higher Financial Earnings$87,000$105,000
39FMore than 6Genuine Interest$110,000$125,000
24M1 to 3Higher Financial Earnings$37,000$70,000
30M4 to 6Career Change$60,000$75,000
35MMore than 6Career Advancement$73,000$95,000
28M4 to 6Career Advancement$57,000$75,000
23FNoneHigher Financial Earnings$45,000$80,000
29F4 to 6Career Advancement$65,000$90,000
33MMore than 6Higher Financial Earnings$85,000$100,000

Question 2

Syringe Samples
SampleSample Observations
Sample 14.96004.94604.95004.95604.9580
Sample 24.95804.92704.93504.94004.9500
Sample 34.97104.92904.96504.95204.9380
Sample 44.94004.98204.97004.95304.9600
Sample 54.96404.95004.95304.96204.9560
Sample 64.96904.95104.95504.96604.9540
Sample 74.96004.94404.95704.94804.9510
Sample 84.96904.94904.96304.95204.9620
Sample 94.98404.92804.96004.94304.9550
Sample 104.97004.93404.96104.94004.9650
Sample 114.97504.95904.96204.97104.9680
Sample 124.94504.97704.95004.96904.9540
Sample 134.97604.96404.97004.96804.9720
Sample 144.97004.95404.96404.95904.9680
Sample 154.98204.96204.96804.97504.9630

Question 4

Store and Regional Sales Database
IDStore No.Sales RegionItem No.Item DescriptionUnit PriceUnits SoldWeek Ending
11South200524" Monitor$229.0028October
21South200524" Monitor$229.0030November
31South200524" Monitor$229.009December
41South3006Wireless Keyboard$19.9530October
51South3006Wireless Keyboard$19.9535November
61South3006Wireless Keyboard$19.9539December
71South6050PC Mouse$8.9528October
81South6050PC Mouse$8.953November
91South6050PC Mouse$8.9538December
101South8500Laptop$849.9525October
111South8500Laptop$849.9527November
121South8500Laptop$849.9533December
132South200524" Monitor$229.008October
142South200524" Monitor$229.008November
152South200524" Monitor$229.0010December
162South3006Wireless Keyboard$19.958October
172South3006Wireless Keyboard$19.958November
182South3006Wireless Keyboard$19.958December
192South6050PC Mouse$8.959October
202South6050PC Mouse$8.959November
212South6050PC Mouse$8.958December
222South8500Laptop$849.9518October
232South8500Laptop$849.9518November
242South8500Laptop$849.9520December
253South200524" Monitor$229.0038October
263South200524" Monitor$229.0030November
273South200524" Monitor$229.003December
283South3006Wireless Keyboard$19.9530October
293South3006Wireless Keyboard$19.9532November
303South3006Wireless Keyboard$19.9533December
313South6050PC Mouse$8.9525October
323South6050PC Mouse$8.955November
333South6050PC Mouse$8.9526December
343South8500Laptop$849.9528October
353South8500Laptop$849.9527November
363South8500Laptop$849.9529December
374North200524" Monitor$229.0018October
384North200524" Monitor$229.0020November
394North200524" Monitor$229.004December
404North3006Wireless Keyboard$19.9512October
414North3006Wireless Keyboard$19.9524November
424North3006Wireless Keyboard$19.9536December
434North6050PC Mouse$8.9529October
444North6050PC Mouse$8.9511November
454North6050PC Mouse$8.9538December
464North8500Laptop$849.9521October
474North8500Laptop$849.9524November
484North8500Laptop$849.9530December
495North200524" Monitor$229.0027October
505North200524" Monitor$229.0025November
515North200524" Monitor$229.0023December
525North3006Wireless Keyboard$19.9580October
535North3006Wireless Keyboard$19.9582November
545North3006Wireless Keyboard$19.9575December
555North6050PC Mouse$8.9565October
565North6050PC Mouse$8.9524November
575North6050PC Mouse$8.9555December
585North8500Laptop$849.9555October
595North8500Laptop$849.9557November
605North8500Laptop$849.9547December
616East200524" Monitor$229.0024October
626East200524" Monitor$229.0085November
636East200524" Monitor$229.0056December
646East3006Wireless Keyboard$19.9552October
656East3006Wireless Keyboard$19.9558November
666East3006Wireless Keyboard$19.9569December
676East6050PC Mouse$8.9535October
686East6050PC Mouse$8.9539November
696East6050PC Mouse$8.9544December
706East8500Laptop$849.9578October
716East8500Laptop$849.9588November
726East8500Laptop$849.9599December
737East200524" Monitor$229.0034October
747East200524" Monitor$229.0036November
757East200524" Monitor$229.0035December
767East3006Wireless Keyboard$19.9549October
777East3006Wireless Keyboard$19.9547November
787East3006Wireless Keyboard$19.9548December
797East6050PC Mouse$8.9545October
807East6050PC Mouse$8.9542November
817East6050PC Mouse$8.9545December
827East8500Laptop$849.9555October
837East8500Laptop$849.9557November
847East8500Laptop$849.9555December
858East200524" Monitor$229.0018October
868East200524" Monitor$229.0017November
878East200524" Monitor$229.0023December
888East3006Wireless Keyboard$19.9522October
898East3006Wireless Keyboard$19.9518November
908East3006Wireless Keyboard$19.9522December
918East6050PC Mouse$8.9514October
928East6050PC Mouse$8.9516November
938East6050PC Mouse$8.9517December
948East8500Laptop$849.9532October
958East8500Laptop$849.9528November
968East8500Laptop$849.9530December

Question 5

Purchase Orders
SupplierOrder No.Item No.Item DescriptionItem CostQuantityCost per orderA/P Terms (Months)Order DateArrival Date
Hulkey FastenersAug110011122Airframe fasteners$4.2519,500$82,875.003008/05/1108/13/11
Alum SheetingAug110021243Airframe fasteners$4.2510,000$42,500.003008/08/1108/14/11
Fast-Tie AerospaceAug110035462Shielded Cable/ft.$1.0523,000$24,150.003008/10/1108/15/11
Fast-Tie AerospaceAug110045462Shielded Cable/ft.$1.0521,500$22,575.003008/15/1108/22/11
Steelpin Inc.Aug110055319Shielded Cable/ft.$1.1017,500$19,250.003008/20/1108/31/11
Fast-Tie AerospaceAug110065462Shielded Cable/ft.$1.0522,500$23,625.003008/20/1108/26/11
Steelpin Inc.Aug110074312Bolt-nut package$3.754,250$15,937.503008/25/1109/01/11
Durrable ProductsAug110087258Pressure Gauge$90.00100$9,000.004508/25/1108/28/11
Fast-Tie AerospaceAug110096321O-Ring$2.451,300$3,185.003008/25/1109/04/11
Fast-Tie AerospaceAug110105462Shielded Cable/ft.$1.0522,500$23,625.003008/25/1109/02/11
Steelpin Inc.Aug110115319Shielded Cable/ft.$1.1018,100$19,910.003008/25/1109/05/11
Hulkey FastenersAug110123166Electrical Connector$1.255,600$7,000.003008/25/1108/29/11
Hulkey FastenersAug110139966Hatch Decal$0.75500$375.003008/25/1108/31/11
Steelpin Inc.Aug110145234Electrical Connector$1.654,500$7,425.003008/28/1109/05/11
Steelpin Inc.Sep110014312Bolt-nut package$3.754,200$15,750.003009/01/1109/10/11
Alum SheetingSep110025417Control Panel$255.00406$103,530.003009/01/1109/10/11
Hulkey FastenersSep110033166Electrical Connector$1.255,500$6,875.003009/01/1109/06/11
Steelpin Inc.Sep110045234Electrical Connector$1.654,850$8,002.503009/02/1109/11/11
Steelpin Inc.Sep110054312Bolt-nut package$3.754,150$15,562.503009/03/1109/11/11
Hulkey FastenersSep110061122Airframe fasteners$4.2515,500$65,875.003009/04/1109/12/11
Spacetime TechnologiesSep110074111Bolt-nut package$3.554,800$17,040.002509/05/1109/20/11
Alum SheetingSep110081243Airframe fasteners$4.259,000$38,250.003009/05/1109/12/11
Durrable ProductsSep110097258Pressure Gauge$90.00120$10,800.004509/05/1109/09/11
Steelpin Inc.Sep110105234Electrical Connector$1.654,750$7,837.503009/05/1109/13/11
Hulkey FastenersSep110111122Airframe fasteners$4.2512,500$53,125.003009/05/1109/11/11
Hulkey FastenersSep110125066Shielded Cable/ft.$0.9525,000$23,750.003009/05/1109/12/11
Hulkey FastenersSep110133166Electrical Connector$1.255,650$7,062.503009/05/1109/10/11
Hulkey FastenersSep110141122Airframe fasteners$4.2515,000$63,750.003009/08/1109/15/11
Spacetime TechnologiesSep110154111Bolt-nut package$3.554,585$16,276.752509/10/1109/30/11
Hulkey FastenersSep110163166Electrical Connector$1.255,425$6,781.253009/10/1109/15/11
Fast-Tie AerospaceSep110176321O-Ring$2.451,200$2,940.003009/12/1109/23/11
Steelpin Inc.Sep110185319Shielded Cable/ft.$1.1016,500$18,150.003009/15/1110/05/11
Spacetime TechnologiesSep110194111Bolt-nut package$3.554,200$14,910.002509/15/1110/15/11
Hulkey FastenersSep110205066Shielded Cable/ft.$0.9517,500$16,625.003009/15/1109/22/11
Spacetime TechnologiesSep110219752Gasket$4.051,500$6,075.002509/20/1109/25/11
Spacetime TechnologiesSep110224111Bolt-nut package$3.554,250$15,087.502509/20/1110/10/11
Pylon AccessoriesSep110239764Gasket$3.751,980$7,425.001509/20/1109/29/11
Pylon AccessoriesSep110249764Gasket$3.751,750$6,562.501509/20/1109/25/11
Spacetime TechnologiesSep110259752Gasket$4.051,550$6,277.502509/25/1110/05/11
Spacetime TechnologiesSep110264111Bolt-nut package$3.554,200$14,910.002509/25/1110/25/11
Durrable ProductsSep110271369Airframe fasteners$4.2015,000$63,000.004509/25/1109/30/11
Manley ValveSep110286431O-Ring$2.851,300$3,705.003009/25/1110/01/11
Fast-Tie AerospaceSep110296321O-Ring$2.452,500$6,125.003009/25/1110/04/11
Pylon AccessoriesSep110309764Gasket$3.751,850$6,937.501509/25/1110/05/11
Durrable ProductsSep110311369Airframe fasteners$4.2014,000$58,800.004509/27/1110/03/11
Hulkey FastenersSep110321122Airframe fasteners$4.2514,500$61,625.003009/28/1110/03/11
Pylon AccessoriesSep110339764Gasket$3.751,800$6,750.001509/28/1110/05/11
Durrable ProductsSep110341369Airframe fasteners$4.2010,000$42,000.004509/29/1110/04/11
Spacetime TechnologiesOct110015125Shielded Cable/ft.$1.1515,000$17,250.002510/01/1110/15/11
Durrable ProductsOct110029399Gasket$3.651,250$4,562.504510/01/1110/06/11
Manley ValveOct110036431O-Ring$2.851,350$3,847.503010/01/1110/07/11
Pylon AccessoriesOct110046433O-Ring$2.951,500$4,425.001510/01/1110/10/11
Fast-Tie AerospaceOct110055166Electrical Connector$1.255,650$7,062.503010/01/1110/06/11
Hulkey FastenersOct110061122Airframe fasteners$4.2518,000$76,500.003010/01/1110/08/11
Durrable ProductsOct110079399Gasket$3.651,450$5,292.504510/03/1110/08/11
Spacetime TechnologiesOct110086489O-Ring$3.001,100$3,300.002510/05/1110/10/11
Durrable ProductsOct110099399Gasket$3.651,985$7,245.254510/05/1110/11/11
Spacetime TechnologiesOct110104111Bolt-nut package$3.554,600$16,330.002510/05/1110/19/11
Durrable ProductsOct110114569Bolt-nut package$3.503,900$13,650.004510/05/1110/10/11
Manley ValveOct110126431O-Ring$2.851,250$3,562.503010/05/1110/10/11
Durrable ProductsOct110139399Gasket$3.651,470$5,365.504510/07/1110/12/11
Durrable ProductsOct110145454Control Panel$220.00550$121,000.004510/09/1110/14/11
Spacetime TechnologiesOct110156489O-Ring$3.00900$2,700.002510/10/1110/18/11
Alum SheetingOct110161243Airframe fasteners$4.2510,500$44,625.003010/10/1110/17/11
Steelpin Inc.Oct110178008Machined Valve$645.00100$64,500.003010/10/1110/21/11
Manley ValveOct110187258Pressure Gauge$100.5090$9,045.003010/10/1110/17/11
Manley ValveOct110198148Machined Valve$655.50125$81,937.503010/10/1110/17/11
Hulkey FastenersOct110201122Airframe fasteners$4.2517,000$72,250.003010/11/1110/19/11
Fast-Tie AerospaceOct110216321O-Ring$2.451,250$3,062.503010/12/1110/21/11
Alum SheetingOct110224224Bolt-nut package$3.954,500$17,775.003010/15/1110/20/11
Durrable ProductsOct110235454Control Panel$220.00500$110,000.004510/15/1110/20/11
Manley ValveOct110247258Pressure Gauge$100.50100$10,050.003010/15/1110/24/11
Steelpin Inc.Oct110258008Machined Valve$645.00150$96,750.003010/15/1110/26/11
Alum SheetingOct110265417Control Panel$255.00500$127,500.003010/20/1110/27/11
Manley ValveOct110277258Pressure Gauge$100.5095$9,547.503010/20/1110/29/11
Alum SheetingOct110285634Side Panel$185.00150$27,750.003010/25/1111/03/11
Durrable ProductsOct110295275Shielded Cable/ft.$1.0025,000$25,000.004510/25/1110/30/11
Fast-Tie AerospaceOct110306321O-Ring$2.451,500$3,675.003010/25/1111/02/11
Fast-Tie AerospaceOct110315689Side Panel$175.00155$27,125.003010/25/1111/03/11
Hulkey FastenersOct110321122Airframe fasteners$4.2517,500$74,375.003010/25/1111/03/11
Steelpin Inc.Oct110335677Side Panel$195.00130$25,350.003010/28/1111/07/11
Steelpin Inc.Oct110348008Machined Valve$645.00120$77,400.003010/28/1111/04/11
Spacetime TechnologiesOct110356489O-Ring$3.001,050$3,150.002510/29/1111/10/11
Alum SheetingOct110365634Side Panel$185.00140$25,900.003010/29/1111/04/11
Manley ValveNov110019977Panel Decal$1.00525$525.003011/01/1111/07/11
Manley ValveNov110029955Door Decal$0.55150$82.503011/01/1111/06/11
Fast-Tie AerospaceNov110035689Side Panel$175.00150$26,250.003011/01/1111/09/11
Fast-Tie AerospaceNov110047268Pressure Gauge$95.00110$10,450.003011/01/1111/12/11
Steelpin Inc.Nov110055677Side Panel$195.00120$23,400.003011/02/1111/13/11
Manley ValveNov110069967Hatch Decal$0.85550$467.503011/05/1111/11/11
Fast-Tie AerospaceNov110077268Pressure Gauge$95.00105$9,975.003011/05/1111/16/11
Fast-Tie AerospaceNov110085689Side Panel$175.00175$30,625.003011/05/1111/15/11
Steelpin Inc.Nov110095677Side Panel$195.00110$21,450.003011/05/1111/17/11
Manley ValveNov110109955Door Decal$0.55125$68.753011/05/1111/10/11

Question 12

Purchase Orders
SupplierOrder No.Item No.Item DescriptionItem CostQuantityCost per orderA/P Terms (Months)Order DateArrival Date
Hulkey FastenersAug110011122Airframe fasteners$4.2519,500$82,875.003008/05/1108/13/11
Alum SheetingAug110021243Airframe fasteners$4.2510,000$42,500.003008/08/1108/14/11
Fast-Tie AerospaceAug110035462Shielded Cable/ft.$1.0523,000$24,150.003008/10/1108/15/11
Fast-Tie AerospaceAug110045462Shielded Cable/ft.$1.0521,500$22,575.003008/15/1108/22/11
Steelpin Inc.Aug110055319Shielded Cable/ft.$1.1017,500$19,250.003008/20/1108/31/11
Fast-Tie AerospaceAug110065462Shielded Cable/ft.$1.0522,500$23,625.003008/20/1108/26/11
Steelpin Inc.Aug110074312Bolt-nut package$3.754,250$15,937.503008/25/1109/01/11
Durrable ProductsAug110087258Pressure Gauge$90.00100$9,000.004508/25/1108/28/11
Fast-Tie AerospaceAug110096321O-Ring$2.451,300$3,185.003008/25/1109/04/11
Fast-Tie AerospaceAug110105462Shielded Cable/ft.$1.0522,500$23,625.003008/25/1109/02/11
Steelpin Inc.Aug110115319Shielded Cable/ft.$1.1018,100$19,910.003008/25/1109/05/11
Hulkey FastenersAug110123166Electrical Connector$1.255,600$7,000.003008/25/1108/29/11
Hulkey FastenersAug110139966Hatch Decal$0.75500$375.003008/25/1108/31/11
Steelpin Inc.Aug110145234Electrical Connector$1.654,500$7,425.003008/28/1109/05/11
Steelpin Inc.Sep110014312Bolt-nut package$3.754,200$15,750.003009/01/1109/10/11
Alum SheetingSep110025417Control Panel$255.00406$103,530.003009/01/1109/10/11
Hulkey FastenersSep110033166Electrical Connector$1.255,500$6,875.003009/01/1109/06/11
Steelpin Inc.Sep110045234Electrical Connector$1.654,850$8,002.503009/02/1109/11/11
Steelpin Inc.Sep110054312Bolt-nut package$3.754,150$15,562.503009/03/1109/11/11
Hulkey FastenersSep110061122Airframe fasteners$4.2515,500$65,875.003009/04/1109/12/11
Spacetime TechnologiesSep110074111Bolt-nut package$3.554,800$17,040.002509/05/1109/20/11
Alum SheetingSep110081243Airframe fasteners$4.259,000$38,250.003009/05/1109/12/11
Durrable ProductsSep110097258Pressure Gauge$90.00120$10,800.004509/05/1109/09/11
Steelpin Inc.Sep110105234Electrical Connector$1.654,750$7,837.503009/05/1109/13/11
Hulkey FastenersSep110111122Airframe fasteners$4.2512,500$53,125.003009/05/1109/11/11
Hulkey FastenersSep110125066Shielded Cable/ft.$0.9525,000$23,750.003009/05/1109/12/11
Hulkey FastenersSep110133166Electrical Connector$1.255,650$7,062.503009/05/1109/10/11
Hulkey FastenersSep110141122Airframe fasteners$4.2515,000$63,750.003009/08/1109/15/11
Spacetime TechnologiesSep110154111Bolt-nut package$3.554,585$16,276.752509/10/1109/30/11
Hulkey FastenersSep110163166Electrical Connector$1.255,425$6,781.253009/10/1109/15/11
Fast-Tie AerospaceSep110176321O-Ring$2.451,200$2,940.003009/12/1109/23/11
Steelpin Inc.Sep110185319Shielded Cable/ft.$1.1016,500$18,150.003009/15/1110/05/11
Spacetime TechnologiesSep110194111Bolt-nut package$3.554,200$14,910.002509/15/1110/15/11
Hulkey FastenersSep110205066Shielded Cable/ft.$0.9517,500$16,625.003009/15/1109/22/11
Spacetime TechnologiesSep110219752Gasket$4.051,500$6,075.002509/20/1109/25/11
Spacetime TechnologiesSep110224111Bolt-nut package$3.554,250$15,087.502509/20/1110/10/11
Pylon AccessoriesSep110239764Gasket$3.751,980$7,425.001509/20/1109/29/11
Pylon AccessoriesSep110249764Gasket$3.751,750$6,562.501509/20/1109/25/11
Spacetime TechnologiesSep110259752Gasket$4.051,550$6,277.502509/25/1110/05/11
Spacetime TechnologiesSep110264111Bolt-nut package$3.554,200$14,910.002509/25/1110/25/11
Durrable ProductsSep110271369Airframe fasteners$4.2015,000$63,000.004509/25/1109/30/11
Manley ValveSep110286431O-Ring$2.851,300$3,705.003009/25/1110/01/11
Fast-Tie AerospaceSep110296321O-Ring$2.452,500$6,125.003009/25/1110/04/11
Pylon AccessoriesSep110309764Gasket$3.751,850$6,937.501509/25/1110/05/11
Durrable ProductsSep110311369Airframe fasteners$4.2014,000$58,800.004509/27/1110/03/11
Hulkey FastenersSep110321122Airframe fasteners$4.2514,500$61,625.003009/28/1110/03/11
Pylon AccessoriesSep110339764Gasket$3.751,800$6,750.001509/28/1110/05/11
Durrable ProductsSep110341369Airframe fasteners$4.2010,000$42,000.004509/29/1110/04/11
Spacetime TechnologiesOct110015125Shielded Cable/ft.$1.1515,000$17,250.002510/01/1110/15/11
Durrable ProductsOct110029399Gasket$3.651,250$4,562.504510/01/1110/06/11
Manley ValveOct110036431O-Ring$2.851,350$3,847.503010/01/1110/07/11
Pylon AccessoriesOct110046433O-Ring$2.951,500$4,425.001510/01/1110/10/11
Fast-Tie AerospaceOct110055166Electrical Connector$1.255,650$7,062.503010/01/1110/06/11
Hulkey FastenersOct110061122Airframe fasteners$4.2518,000$76,500.003010/01/1110/08/11
Durrable ProductsOct110079399Gasket$3.651,450$5,292.504510/03/1110/08/11
Spacetime TechnologiesOct110086489O-Ring$3.001,100$3,300.002510/05/1110/10/11
Durrable ProductsOct110099399Gasket$3.651,985$7,245.254510/05/1110/11/11
Spacetime TechnologiesOct110104111Bolt-nut package$3.554,600$16,330.002510/05/1110/19/11
Durrable ProductsOct110114569Bolt-nut package$3.503,900$13,650.004510/05/1110/10/11
Manley ValveOct110126431O-Ring$2.851,250$3,562.503010/05/1110/10/11
Durrable ProductsOct110139399Gasket$3.651,470$5,365.504510/07/1110/12/11
Durrable ProductsOct110145454Control Panel$220.00550$121,000.004510/09/1110/14/11
Spacetime TechnologiesOct110156489O-Ring$3.00900$2,700.002510/10/1110/18/11
Alum SheetingOct110161243Airframe fasteners$4.2510,500$44,625.003010/10/1110/17/11
Steelpin Inc.Oct110178008Machined Valve$645.00100$64,500.003010/10/1110/21/11
Manley ValveOct110187258Pressure Gauge$100.5090$9,045.003010/10/1110/17/11
Manley ValveOct110198148Machined Valve$655.50125$81,937.503010/10/1110/17/11
Hulkey FastenersOct110201122Airframe fasteners$4.2517,000$72,250.003010/11/1110/19/11
Fast-Tie AerospaceOct110216321O-Ring$2.451,250$3,062.503010/12/1110/21/11
Alum SheetingOct110224224Bolt-nut package$3.954,500$17,775.003010/15/1110/20/11
Durrable ProductsOct110235454Control Panel$220.00500$110,000.004510/15/1110/20/11
Manley ValveOct110247258Pressure Gauge$100.50100$10,050.003010/15/1110/24/11
Steelpin Inc.Oct110258008Machined Valve$645.00150$96,750.003010/15/1110/26/11
Alum SheetingOct110265417Control Panel$255.00500$127,500.003010/20/1110/27/11
Manley ValveOct110277258Pressure Gauge$100.5095$9,547.503010/20/1110/29/11
Alum SheetingOct110285634Side Panel$185.00150$27,750.003010/25/1111/03/11
Durrable ProductsOct110295275Shielded Cable/ft.$1.0025,000$25,000.004510/25/1110/30/11
Fast-Tie AerospaceOct110306321O-Ring$2.451,500$3,675.003010/25/1111/02/11
Fast-Tie AerospaceOct110315689Side Panel$175.00155$27,125.003010/25/1111/03/11
Hulkey FastenersOct110321122Airframe fasteners$4.2517,500$74,375.003010/25/1111/03/11
Steelpin Inc.Oct110335677Side Panel$195.00130$25,350.003010/28/1111/07/11
Steelpin Inc.Oct110348008Machined Valve$645.00120$77,400.003010/28/1111/04/11
Spacetime TechnologiesOct110356489O-Ring$3.001,050$3,150.002510/29/1111/10/11
Alum SheetingOct110365634Side Panel$185.00140$25,900.003010/29/1111/04/11
Manley ValveNov110019977Panel Decal$1.00525$525.003011/01/1111/07/11
Manley ValveNov110029955Door Decal$0.55150$82.503011/01/1111/06/11
Fast-Tie AerospaceNov110035689Side Panel$175.00150$26,250.003011/01/1111/09/11
Fast-Tie AerospaceNov110047268Pressure Gauge$95.00110$10,450.003011/01/1111/12/11
Steelpin Inc.Nov110055677Side Panel$195.00120$23,400.003011/02/1111/13/11
Manley ValveNov110069967Hatch Decal$0.85550$467.503011/05/1111/11/11
Fast-Tie AerospaceNov110077268Pressure Gauge$95.00105$9,975.003011/05/1111/16/11
Fast-Tie AerospaceNov110085689Side Panel$175.00175$30,625.003011/05/1111/15/11
Steelpin Inc.Nov110095677Side Panel$195.00110$21,450.003011/05/1111/17/11
Manley ValveNov110109955Door Decal$0.55125$68.753011/05/1111/10/11

Question 13

Sales Transactions: July 14
Cust IDRegionPaymentTransaction CodeSourceAmountProductTime Of Day
10001EastPaypal93816545Web$20.19DVD22:19
10002WestCredit74083490Web$17.85DVD13:27
10003NorthCredit64942368Web$23.98DVD14:27
10004WestPaypal70560957Email$23.51Book15:38
10005SouthCredit35208817Web$15.33Book15:21
10006WestPaypal20978903Email$17.30DVD13:11
10007EastCredit80103311Web$177.72Book21:59
10008WestCredit14132683Web$21.76Book4:04
10009WestPaypal40128225Web$15.92DVD19:35
10010SouthPaypal49073721Web$23.39DVD13:26
10011SouthPaypal57398827Email$24.45Book14:17
10012EastCredit34400661Web$20.39Book1:01
10013NorthPaypal54242587Web$19.54DVD10:04
10014EastCredit62597750Web$151.67Book9:09
10015WestCredit51555882Web$21.01DVD5:05
10016WestPaypal54332964Web$22.91DVD20:29
10017WestCredit26623353Email$19.51Book15:03
10018WestPaypal78594431Web$20.16Book18:54
10019WestCredit89385348Web$17.53DVD20:00
10020WestCredit69868417Web$17.74DVD12:37
10021NorthPaypal59660276Email$17.16Book5:05
10022WestCredit25456590Web$205.58Book20:42
10023SouthCredit93283893Email$18.12Book10:12
10024WestCredit45991123Web$20.04DVD16:27
10025WestPaypal79121745Email$23.21DVD20:22
10026WestCredit80685117Email$22.79DVD19:58
10027WestCredit56686474Web$16.91DVD19:44
10028SouthCredit25270813Web$20.22Book19:28
10029EastPaypal59736137Web$18.36DVD15:48
10030WestPaypal79615191Email$206.80Book18:14
10031NorthPaypal55365094Email$17.95DVD15:15
10032EastCredit79118930Web$18.29Book12:59
10033SouthPaypal84470584Web$18.55Book17:38
10034WestCredit71097636Web$18.82Book2:02
10035WestCredit73290219Web$16.35Book14:05
10036EastCredit92093991Web$16.30DVD4:04
10037SouthPaypal11165609Web$217Book0:00
10038EastCredit79944825Web$16.15DVD10:28
10039NorthCredit59537977Web$18.78DVD5:05
10040SouthCredit37870882Web$150.99Book7:07
10041WestCredit59747081Web$21.39DVD19:20
10042WestCredit33511221Web$16.60DVD16:23
10043SouthPaypal69676186Web$23.81Book7:07
10044SouthCredit72150231Web$15.87Book13:46
10045WestCredit64874923Web$20.82DVD9:09
10046SouthCredit79755506Web$21.15Book6:06
10047SouthPaypal43322747Web$19.66DVD18:50
10048WestPaypal57979095Email$21.02DVD3:03
10049WestCredit96485037Web$23.13DVD6:06
10050WestPaypal85636284Web$15.17DVD18:53
10051EastPaypal42519148Web$209.51Book9:09
10052WestCredit59845178Web$16.03Book17:28
10053NorthCredit47961093Email$16.17DVD13:18
10054EastCredit32857450Web$18.37DVD8:08
10055EastCredit23437096Web$15.96Book8:08
10056NorthPaypal23846199Web$19.29Book0:00
10057WestPaypal15630914Email$16.49DVD19:59
10058EastPaypal64471213Web$18.12Book17:35
10059EastCredit70288635Web$18.22DVD15:52
10060EastCredit46067931Web$18.32Book10:15
10061WestCredit73400603Web$23.77DVD19:53
10062EastPaypal31794035Web$24.35Book15:16
10063SouthCredit72954240Email$20.13DVD13:55
10064NorthCredit12364851Email$20.77DVD13:34
10065NorthCredit19974213Email$16.98DVD19:21
10066EastCredit68753569Email$19.40Book15:02
10067EastPaypal77232784Email$23.49Book4:04
10068SouthCredit94731015Web$15.58Book11:39
10069SouthCredit49007475Web$21.94DVD20:19
10070SouthCredit71384600Email$229.73Book1:01
10071WestCredit15282110Web$16.06Book10:31
10072SouthCredit87012305Web$22.21DVD10:01
10073WestCredit27742544Email$21.58DVD0:00
10074NorthPaypal97981670Email$16.09Book3:03
10075EastCredit83670405Email$16.10DVD10:13
10076EastCredit99063530Web$15.95DVD0:00
10077SouthCredit25978103Email$17.77Book1:01
10078NorthCredit81824666Web$19.30DVD11:24
10079WestPaypal86833489Web$21.75Book10:23
10080WestPaypal73512800Web$20.51Book11:29
10081NorthCredit11673210Web$16.14DVD4:04
10082WestPaypal76787805Email$157.76Book19:02
10083SouthCredit34610946Web$21.55Book9:09
10084NorthPaypal69586073Web$21.85DVD12:24
10085EastCredit87017416Web$21.70DVD13:33
10086EastPaypal37371293Web$20.31Book19:26
10087EastCredit27497600Email$23.62Book22:20
10088EastCredit29510284Web$216.37Book10:20
10089NorthPaypal40878208Web$21.99DVD3:03
10090WestCredit83375454Email$18.20DVD5:05
10091EastCredit61236522Email$17.31Book0:00
10092WestCredit68788857Web$23.94Book16:08
10093WestPaypal58309878Email$174.25Book18:31
10094WestPaypal84324439Web$20.26DVD4:04
10095NorthCredit90647889Web$18.73DVD0:00
10096NorthPaypal31225474Web$22.88Book13:09
10097WestPaypal79286039Web$19.15DVD14:44
10098SouthCredit69628094Email$15.33Book1:01
10099WestPaypal19891764Web$20.82DVD18:01
10100WestCredit21992857Web$20.61DVD18:29
10101EastCredit40572972Web$16.43DVD11:23
10102WestCredit80218197Web$21.10DVD2:02
10103NorthPaypal72072353Email$21.64Book22:40
10104WestPaypal44250706Email$18.06Book16:00
10105EastCredit31062653Web$19.35Book10:06
10106NorthCredit84047393Web$23.70DVD19:02
10107NorthCredit59891368Web$18.93Book9:09
10108NorthCredit47234209Email$16.83Book16:20
10109WestCredit47893510Web$22.19Book18:52
10110WestCredit23513829Web$23.90Book19:40
10111EastCredit20993720Web$17.47DVD10:53
10112WestCredit58724265Email$209.37Book20:11
10113NorthCredit47687764Web$18DVD8:08
10114EastCredit53008101Web$22.83Book10:17
10115EastCredit68494188Email$20.31DVD14:34
10116SouthPaypal40357817Web$22.06DVD11:07
10117NorthPaypal91328383Web$15.22Book10:39
10118SouthPaypal51497241Web$20.60DVD20:46
10119EastCredit42829269Web$18.25DVD20:42
10120EastCredit56174714Web$174.18Book12:42
10121NorthCredit17210514Email$19.58DVD22:31
10122WestPaypal40504819Web$17.91Book19:14
10123WestCredit58186991Web$22.90Book12:16
10124NorthPaypal46376047Web$22.26Book17:50
10125SouthCredit95760408Web$19.04Book15:23
10126EastCredit73024614Web$17.42DVD5:05
10127WestPaypal63167563Web$18.54Book19:30
10128NorthCredit83800724Web$19.74DVD12:49
10129WestCredit11739665Web$22.03DVD14:49
10130WestPaypal74393415Web$236.49Book16:24
10131SouthPaypal30372359Email$19.30DVD17:00
10132EastCredit47768495Email$23.73DVD16:57
10133WestPaypal74154714Web$19.96Book16:50
10134EastCredit33525138Web$20.75DVD15:02
10135SouthPaypal84542864Web$22.37DVD8:08
10136WestCredit24537107Email$24.03DVD11:14
10137WestCredit74241899Web$24.59DVD4:04
10138WestPaypal33200655Email$155.91Book18:38
10139EastCredit89349547Email$16.43Book9:09
10140SouthPaypal83528887Web$15.71Book16:44
10141WestPaypal21113649Web$15.19Book16:22
10142WestPaypal35126822Web$21.35DVD17:54
10143WestCredit98692914Web$19.47DVD18:17
10144WestCredit96105789Web$21.49DVD9:09
10145EastPaypal72991138Web$22.20DVD12:29
10146EastPaypal77775458Web$21.15DVD7:07
10147EastCredit71420485Web$15.16DVD11:19
10148EastCredit55498553Email$15.71Book9:09
10149WestPaypal93904863Web$24.65Book20:41
10150WestPaypal37998977Email$24.88Book15:23
10151EastPaypal24697741Email$17.49Book21:46
10152WestCredit77906388Web$19.71DVD7:07
10153SouthCredit79915334Web$17.33Book2:02
10154WestCredit50624253Web$15.56DVD21:07
10155EastCredit32851119Web$18.94DVD20:00
10156NorthCredit79812666Web$22.86Book16:02
10157SouthPaypal45319579Web$15.18Book6:06
10158SouthCredit44466808Web$22.46Book17:44
10159WestCredit26950438Email$21.39Book17:17
10160SouthCredit66610830Email$22.17DVD10:23
10161NorthPaypal45496161Web$234.63Book9:09
10162NorthPaypal57085887Web$24.97Book22:11
10163WestCredit86987062Web$15.72Book10:53
10164EastCredit75029194Web$24.35Book8:08
10165WestPaypal16712886Email$16.09Book8:08
10166WestCredit39307303Web$23.51Book16:18
10167NorthPaypal41334963Web$22.59Book16:51
10168EastCredit58630343Web$15.59DVD9:09
10169WestCredit87184105Web$190.81Book21:57
10170WestPaypal35358631Web$21.12Book16:40
10171NorthCredit55749730Web$24.60DVD20:38
10172NorthPaypal62374456Web$21.22DVD12:20
10173WestCredit84556568Web$21.78DVD7:07
10174WestCredit57605353Web$16.54DVD17:52
10175EastCredit45033697Email$177.32Book15:52
10176SouthCredit33917941Web$21.50Book10:53
10177WestPaypal39654675Web$24.65DVD20:45
10178NorthPaypal47532285Web$19.43DVD9:09
10179WestCredit85998809Web$21.12DVD20:13
10180WestCredit34960635Web$18.10DVD20:32
10181EastCredit85117076Email$24.40Book13:25
10182SouthCredit67865323Web$19.37Book21:48
10183WestCredit55061563Email$19.17DVD0:00
10184SouthCredit58022125Email$241.77Book9:09
10185WestPaypal25679000Web$19.65Book20:46
10186WestPaypal35078468Web$19.88Book8:08
10187WestPaypal75772325Web$15.18DVD12:30
10188WestPaypal25433486Web$15.08Book12:15
10189NorthPaypal65056232Web$23.74Book5:05
10190NorthCredit96077043Web$19.44Book9:09
10191SouthCredit68380003Web$17.70DVD2:02
10192WestCredit92733708Web$16.99DVD17:34
10193EastPaypal17547620Email$16.13Book13:37
10194WestPaypal95291830Web$24.80DVD20:28
10195WestPaypal49471722Web$17.52Book20:35
10196NorthPaypal70336893Web$23.63Book19:47
10197WestCredit44142213Web$23.03DVD11:27
10198WestPaypal69832322Web$21.03DVD19:18
10199SouthCredit54284580Web$21.88Book3:03
10200SouthCredit69967343Email$24.86Book17:27
10201NorthCredit70932816Email$21.43DVD7:07
10202SouthPaypal74082072Web$16.32DVD15:09
10203EastCredit92299116Web$17.20DVD0:00
10204NorthPaypal33160396Web$17.87DVD7:07
10205SouthCredit22141389Web$17.27DVD7:07
10206SouthCredit43297905Web$19.76Book21:13
10207EastPaypal72307242Web$17.10Book6:06
10208WestCredit66131853Email$15.66Book11:18
10209WestCredit71755916Web$22.37Book16:21
10210EastCredit55102089Web$15.81DVD12:26
10211SouthCredit25266837Web$18.75DVD2:02
10212WestCredit17246696Email$192.41Book20:23
10213SouthCredit55149876Email$242.52Book9:09
10214NorthCredit66024609Web$20.40Book0:00
10215EastCredit74962881Web$24.71DVD12:45
10216EastCredit66903731Web$21.49DVD8:08
10217WestPaypal71026884Web$22.26DVD5:05
10218WestCredit86140667Web$22.39Book16:16
10219EastCredit97905965Email$21.01Book8:08
10220WestCredit40197352Web$226.15Book16:41
10221WestPaypal43741856Web$20.67Book19:27
10222WestCredit78186031Web$21.72DVD20:04
10223EastCredit58045939Email$16.34Book17:53
10224WestCredit16151482Web$19.19Book19:08
10225WestCredit16578164Email$19.21DVD2:02
10226WestCredit96323938Web$16.06Book17:30
10227SouthPaypal77228031Web$20.87DVD13:41
10228WestCredit10779898Web$15.33DVD5:05
10229WestCredit85174502Web$23.58DVD2:02
10230NorthCredit73359370Email$15.34Book10:08
10231NorthPaypal10400774Web$216.20Book10:33
10232EastCredit69035250Email$21.85DVD14:28
10233WestCredit45792515Web$23.59Book3:03
10234NorthPaypal28433265Web$20.44Book11:52
10235EastCredit55311936Web$22.05DVD8:08
10236WestPaypal64115201Email$20.42Book0:00
10237WestCredit66071683Email$20.49DVD20:10
10238WestCredit97687340Web$161.46Book14:23
10239SouthPaypal41078038Web$19.69DVD4:04
10240SouthPaypal55142477Web$24.16Book2:02
10241EastCredit41419462Web$22.80DVD10:59
10242EastPaypal39303323Web$243.70Book20:26
10243WestPaypal95949085Web$210.38Book12:19
10244WestPaypal28911817Email$161.50Book16:15
10245SouthCredit36561487Email$21.92DVD6:06
10246WestCredit71502183Web$23.75DVD20:34
10247WestCredit54077093Email$23.74DVD3:03
10248WestPaypal92266350Web$21.67Book12:41
10249WestPaypal60490288Email$22.04Book3:03
10250NorthPaypal72701137Email$17.83DVD12:55
10251SouthPaypal32435141Web$23.60Book2:02
10252NorthCredit48330352Web$19.90Book14:04
10253EastCredit17689891Email$209.20Book17:19
10254EastCredit67182932Email$24Book11:52
10255WestCredit97950489Web$17.81Book12:36
10256WestPaypal50561229Email$24.77DVD0:00
10257EastCredit70759248Web$21DVD17:14
10258NorthPaypal77616151Web$191.43Book16:36
10259SouthPaypal79551499Web$24.52DVD21:59
10260EastCredit90656731Web$17.34DVD8:08
10261EastPaypal33909737Web$17.19Book3:03
10262WestCredit63841931Web$22.55Book11:43
10263SouthCredit30506370Web$15.35DVD10:15
10264SouthCredit81572757Web$23.20Book15:38
10265WestCredit70596149Web$241.65Book20:39
10266WestPaypal95125046Email$242.40Book17:19
10267WestPaypal10754185Web$23.01DVD17:44
10268EastCredit88506060Email$17.22DVD1:01
10269NorthPaypal80319080Web$15.96DVD1:01
10270EastCredit27016365Web$15.45DVD9:09
10271NorthCredit80034508Email$17.41DVD5:05
10272EastCredit76677689Web$21.64Book10:39
10273SouthCredit96855830Web$157.86Book5:05
10274WestPaypal54775836Web$18.17DVD16:09
10275WestCredit18066842Web$18.73Book20:18
10276WestPaypal28240563Web$17.24Book20:47
10277SouthCredit24796034Web$23.91DVD13:59
10278SouthCredit60979466Web$22.12Book17:31
10279WestCredit44558261Web$15.25DVD19:11
10280SouthCredit49683597Web$24.77Book0:00
10281WestPaypal70748780Email$20.28Book6:06
10282SouthPaypal80637514Email$20.33DVD8:08
10283SouthCredit77963353Web$16.90Book21:41
10284SouthPaypal55003920Web$16.47Book16:22
10285WestPaypal66231568Web$21.18Book15:10
10286WestCredit49290839Web$15.86Book18:00
10287WestCredit65745301Web$24.42Book1:01
10288SouthPaypal18744208Web$222.38Book18:53
10289SouthPaypal52683186Web$188.85Book5:05
10290EastCredit87677897Web$15.32Book9:09
10291WestCredit78943440Email$24.71Book16:22
10292EastCredit92175770Web$20.97Book11:17
10293WestCredit32571506Email$21.92DVD19:17
10294WestPaypal11427628Web$15.40Book17:16
10295EastCredit92399789Web$23.08Book7:07
10296EastPaypal63645553Web$23.40DVD1:01
10297NorthCredit11175481Web$22.65Book6:06
10298EastPaypal71269390Email$24.61Book13:08
10299EastCredit97215985Web$24.97Book16:53
10300SouthCredit50531437Web$18.57Book12:45
10301WestCredit94922677Email$16.15DVD3:03
10302WestPaypal17454394Web$19.95Book19:35
10303WestPaypal84850536Web$15.61DVD22:02
10304SouthCredit32164694Email$19.13Book22:55
10305WestCredit88979280Web$231.23Book0:00
10306EastCredit21059538Email$244.75Book10:13
10307SouthPaypal12677778Web$21.36DVD20:25
10308WestCredit77758706Web$21.83Book1:01
10309SouthCredit14512758Email$21.58DVD1:01
10310NorthPaypal23076219Email$17.51Book20:19
10311SouthPaypal71350323Web$23.29DVD4:04
10312WestPaypal60395312Web$18.35Book20:54
10313WestCredit38530736Email$23.06DVD11:48
10314SouthCredit16039556Web$19.81DVD21:19
10315EastCredit93353650Web$162.74Book9:09
10316EastCredit14150787Web$16.86DVD9:09
10317SouthCredit97279689Web$23.31Book16:23
10318WestCredit65882511Email$22.92Book0:00
10319WestCredit88066592Email$22.84DVD17:37
10320NorthCredit82643293Web$16.97DVD4:04
10321SouthCredit97730191Email$188.16Book19:21
10322WestCredit59686740Web$22.57DVD18:45
10323NorthPaypal93594435Web$24.71DVD13:34
10324SouthCredit82961120Web$246.67Book16:47
10325SouthCredit97623213Web$20.97Book8:08
10326EastPaypal14765562Email$19.83Book4:04
10327WestPaypal85470735Email$19.09Book11:45
10328SouthCredit55160635Email$16.52Book6:06
10329SouthCredit90852426Email$22.31Book2:02
10330NorthCredit15945216Email$19.52DVD0:00
10331WestCredit96688991Web$24.79DVD9:09
10332WestCredit31841597Email$18.84DVD22:04
10333EastCredit69450143Web$24.58DVD0:00
10334NorthCredit43384272Web$17.19Book12:19
10335EastPaypal65292790Web$19.65Book6:06
10336SouthCredit71336291Web$17.35Book21:37
10337WestPaypal99300859Web$22.92DVD16:23
10338NorthCredit81921349Email$18.81DVD7:07
10339WestPaypal40237279Web$20.08Book3:03
10340WestCredit38167466Email$24.54Book4:04
10341WestPaypal88466601Web$24.81Book14:40
10342WestPaypal27965385Email$15.94DVD0:00
10343NorthPaypal80215999Web$18.29DVD8:08
10344EastCredit12222505Web$15.55DVD6:06
10345WestPaypal64014515Web$19.20DVD20:52
10346WestCredit90818758Email$17.34DVD18:10
10347EastPaypal94873280Email$22.51DVD5:05
10348SouthPaypal73200296Email$23.45DVD2:02
10349EastPaypal38960810Web$16.15DVD13:45
10350WestPaypal88326061Web$17.68Book0:00
10351NorthCredit41691635Email$22.11Book11:28
10352WestCredit58121431Web$18.41DVD1:01
10353WestPaypal55259994Web$17.08DVD17:06
10354SouthPaypal61072223Web$15.77DVD10:36
10355EastCredit17256670Web$22.41Book7:07
10356NorthPaypal98206099Web$20.63DVD3:03
10357SouthCredit43063718Email$18.14Book3:03
10358NorthCredit67151337Web$20.18Book11:13
10359WestCredit39969279Email$177.30Book11:33
10360SouthPaypal58790759Web$15.71DVD5:05
10361NorthCredit45790914Web$21.75DVD17:22
10362SouthCredit85351233Email$18.25Book5:05
10363SouthCredit40331224Web$203.72Book14:29
10364WestPaypal13065288Email$15.54Book19:36
10365WestCredit30370343Web$17.50DVD5:05
10366EastCredit38342520Web$21.32Book2:02
10367EastPaypal37778643Web$150.86Book13:17
10368WestPaypal21005551Web$17.39Book4:04
10369EastCredit80160243Web$23.87DVD13:52
10370NorthCredit70859272Web$21.53Book16:04
10371NorthCredit41514905Web$19.64DVD16:14
10372WestPaypal68986646Web$18.27Book18:39
10373WestCredit51423763Web$19.27DVD6:06
10374NorthCredit78615837Web$20.16Book14:38
10375WestCredit95641106Web$15.59DVD4:04
10376SouthPaypal40892422Email$16.34DVD12:35
10377EastCredit70431710Web$199.18Book14:00
10378SouthPaypal95673115Web$19.99Book20:29
10379NorthCredit72527223Email$18.44DVD18:38
10380WestCredit77577648Web$23.75Book9:09
10381WestCredit26849225Web$20.88DVD0:00
10382SouthCredit27508938Web$197.43Book10:43
10383WestCredit43095105Web$20.32Book18:33
10384SouthCredit70978581Web$16.82DVD8:08
10385WestPaypal72898757Web$20.16Book13:40
10386WestCredit56976893Web$16.79Book21:27
10387NorthCredit35119351Email$22.53Book11:41
10388SouthPaypal65437162Email$21.68Book14:32
10389NorthPaypal70003314Email$23.54Book6:06
10390EastPaypal54664522Web$17.67DVD9:09
10391WestCredit10325805Web$22.79Book0:00
10392EastPaypal28672617Web$24.80Book18:09
10393SouthPaypal21364705Email$15.27Book8:08
10394WestCredit44719881Email$18.74Book22:41
10395WestCredit42164058Web$16.47DVD20:26
10396WestPaypal68675115Web$18.11DVD0:00
10397WestPaypal48712948Web$20.73DVD17:46
10398WestCredit93152672Web$21.64DVD16:11
10399EastCredit12824694Web$17.38Book16:14
10400WestCredit73484989Web$17.70DVD7:07
10401WestCredit79418802Web$24.66Book17:07
10402WestCredit85598102Web$24.24DVD19:16
10403SouthPaypal81254753Email$19.79Book7:07
10404NorthCredit97869460Web$16.86DVD8:08
10405NorthCredit19446725Web$19.97DVD22:37
10406EastCredit12075708Web$22.99Book9:09
10407NorthCredit87645248Web$153.83Book15:07
10408SouthCredit88351358Web$15.20DVD15:03
10409WestCredit86741411Web$16.01DVD20:02
10410WestPaypal85689748Web$18.88DVD17:57
10411SouthCredit39676844Email$21.54Book19:37
10412EastCredit59845402Web$24.11Book0:00
10413NorthPaypal39267241Web$21.43Book8:08
10414NorthCredit82025542Web$24.80DVD0:00
10415WestCredit16559991Web$19.76DVD20:15
10416NorthCredit80278554Web$23.97DVD18:39
10417NorthCredit30257860Web$19.96DVD11:25
10418WestCredit46744434Web$18.19Book1:01
10419EastCredit49155614Web$17.28DVD15:45
10420WestCredit53795790Web$24.84Book8:08
10421SouthPaypal75332091Email$16.32Book13:50
10422NorthCredit83194866Web$23.47Book17:00
10423WestCredit33911548Email$16.65Book19:19
10424EastPaypal20917768Web$22.64Book11:53
10425NorthCredit63888401Web$16.66Book2:02
10426NorthCredit99361092Email$21.78Book14:10
10427WestPaypal39373058Web$21.29DVD14:14
10428NorthPaypal91945826Web$160.78Book14:47
10429WestCredit39442197Web$21.10Book14:38
10430EastCredit96995760Web$169.79Book20:13
10431WestPaypal99830378Web$16.99Book3:03
10432NorthCredit97898924Email$23.64DVD8:08
10433NorthCredit48100304Email$18.92Book13:23
10434WestPaypal61029935Email$23.96Book7:07
10435SouthPaypal74335115Web$18.53Book21:20
10436WestCredit94386287Web$24.44DVD5:05
10437SouthCredit94086275Web$21.81DVD5:05
10438SouthPaypal59470574Email$18.25DVD15:54
10439EastCredit20030922Web$17.42Book1:01
10440SouthCredit45769254Web$18.40Book10:25
10441NorthPaypal94775848Email$23.88DVD3:03
10442WestCredit98078573Web$17.76Book14:37
10443SouthCredit48152632Email$23.06Book11:57
10444WestPaypal44336631Web$18.87Book16:33
10445WestCredit74850396Web$17.87DVD16:11
10446EastCredit85688947Web$18.77Book15:09
10447NorthCredit83549993Web$18.60DVD0:00
10448NorthCredit62629771Web$152.27Book6:06
10449NorthCredit76032910Web$20.83Book16:46
10450WestCredit78837536Email$21.47Book17:52
10451WestCredit61532595Web$218.60Book12:33
10452NorthPaypal50289683Web$163.37Book16:55
10453NorthPaypal56319779Web$24.78Book21:56
10454WestCredit26242351Web$17.01Book7:07
10455SouthCredit80577738Web$231.23Book20:26
10456EastCredit81079401Web$22.57DVD15:02
10457WestPaypal17165782Web$24.16DVD11:02
10458SouthPaypal90636722Web$20.68Book21:51
10459SouthPaypal43626259Web$21.20DVD7:07
10460WestCredit61496170Web$247.14Book17:16
10461SouthCredit16101751Web$19.10Book13:04
10462SouthPaypal55348039Web$19.02DVD22:07
10463EastCredit50785284Web$19.66Book1:01
10464WestCredit92997267Email$168.10Book16:22
10465WestCredit30255549Web$16.83Book8:08
10466EastCredit85660114Email$23.89Book0:00
10467SouthCredit43913307Web$16.73DVD19:20
10468SouthCredit47286881Email$22.05DVD10:27
10469NorthPaypal62265606Email$17.88Book6:06
10470WestCredit63133211Email$15.18DVD19:25
10471WestPaypal24646414Web$15.62DVD3:03
10472NorthCredit65043803Web$20.58DVD18:02

Question 19

Credit Risk Data
Loan PurposeCheckingSavingsMonths CustomerMonths EmployedGenderMarital StatusAgeHousingYearsJobCredit Risk
Small Appliance$0$7391312MSingle23Own3UnskilledLow
Furniture$0$1,230250MDivorced32Own1SkilledHigh
New Car$0$38919119MSingle38Own4ManagementHigh
Furniture$638$3471314MSingle36Own2UnskilledHigh
Education$963$4,7544045MSingle31Rent3SkilledLow
Furniture$2,827$01113MMarried25Own1SkilledLow
New Car$0$2291316MMarried26Own3UnskilledLow
Business$0$533142MSingle27Own1UnskilledLow
Small Appliance$6,509$493379MSingle25Own2SkilledHigh
Small Appliance$966$0254FDivorced43Own1SkilledHigh
Business$0$989490MSingle32Rent2ManagementHigh
New Car$0$3,3051115MSingle34Rent2UnskilledLow
Business$322$5781014MMarried26Own1SkilledLow
New Car$0$8212563MSingle44Own1SkilledHigh
New Car$396$2281326MSingle46Own3UnskilledLow
Used Car$0$129318MDivorced39Own4ManagementLow
Furniture$652$732494FDivorced25Own2SkilledHigh
New Car$708$6831333MSingle31Own2SkilledLow
Repairs$207$028116MSingle47Own4SkilledLow
Education$287$12,34872FDivorced23Rent2SkilledHigh
Furniture$0$17,5453416FDivorced22Own4SkilledHigh
Furniture$101$3,871135FDivorced26Rent4SkilledHigh
Furniture$0$02523MMarried19Own4SkilledHigh
Furniture$0$4853723FDivorced27Own2ManagementHigh
New Car$0$10,7231115MSingle39Rent2UnskilledLow
Business$141$2452233MSingle26Own3SkilledLow
Used Car$0$01958MSingle50Other4SkilledHigh
Used Car$2,484$04946MSingle34Other1SkilledLow
Small Appliance$237$2363724MSingle23Rent4SkilledLow
Small Appliance$0$4851912MSingle23Own2SkilledLow
Education$335$1,708377MSingle46Other4SkilledHigh
Small Appliance$3,565$03132MSingle35Own3SkilledLow
Small Appliance$0$407132FDivorced28Own2SkilledLow
Business$16,647$8951634MSingle25Rent4SkilledLow
Business$0$1504946FDivorced36Rent4SkilledHigh
Small Appliance$0$490541MSingle41Own1UnskilledLow
Furniture$0$162251MDivorced54Own1SkilledHigh
Small Appliance$940$715940FDivorced43Own2UnskilledLow
Small Appliance$0$3234942MMarried33Own1SkilledHigh
New Car$0$1281374MSingle34Own3SkilledHigh
Other$218$0490MSingle39Other4UnemployedLow
Used Car$0$1092526MSingle34Own3UnskilledLow
Small Appliance$16,935$1893760MSingle30Own2SkilledLow
Furniture$664$5373133MSingle48Own2SkilledHigh
Furniture$150$6,520121FDivorced19Own1SkilledLow
Small Appliance$0$1387119MMarried29Rent2SkilledLow
Furniture$216$0193FDivorced26Rent3SkilledHigh
New Car$0$6601775MSingle42Rent4SkilledHigh
Business$0$724258MSingle30Rent2SkilledHigh
Small Appliance$0$897195MMarried38Own4SkilledLow
Small Appliance$265$947255MMarried21Own1SkilledHigh
Furniture$4,256$01636FDivorced32Rent4UnskilledLow
Business$870$917286MSingle35Own2SkilledHigh
New Car$162$5952210MDivorced46Own4SkilledLow
Used Car$0$7892528MSingle37Own3ManagementLow
Education$0$037114MSingle39Own4ManagementHigh
Furniture$0$7461316FDivorced29Own3SkilledLow
New Car$461$1401932MSingle27Rent3UnskilledLow
New Car$0$659195FDivorced22Rent3SkilledHigh
Furniture$0$7173760MSingle40Own2SkilledHigh
New Car$0$6672910MSingle44Own2UnskilledHigh
New Car$580$0118MSingle26Own4UnskilledHigh
Small Appliance$0$7631346FDivorced57Own3UnskilledLow
New Car$0$1,3661917MSingle34Own4UnskilledLow
Small Appliance$0$552254MMarried47Own4SkilledHigh
Small Appliance$0$14,64316115MSingle46Own3SkilledLow
Business$758$2,6651331MSingle38Own4UnskilledLow
Used Car$399$0310FDivorced52Own1ManagementHigh
Furniture$513$44270MSingle34Own1ManagementLow
Furniture$0$8,357255MSingle29Other4SkilledHigh
New Car$0$0229MSingle39Own2UnskilledHigh
Small Appliance$565$8631081MSingle36Own4UnskilledLow
Business$0$3222828MSingle25Own4SkilledLow
Furniture$0$8001369MSingle59Own3SkilledHigh
Small Appliance$0$6563785MSingle27Own2SkilledLow
New Car$166$922132FDivorced24Rent1SkilledHigh
Business$9,783$885133FDivorced25Own1UnemployedHigh
Business$674$2,8864932MSingle29Own2SkilledLow
Repairs$0$626430MSingle64Own4UnemployedLow
Business$15,328$0259MSingle31Own4SkilledLow
New Car$0$904126MSingle38Own4UnskilledLow
Education$713$7846117MSingle41Other4SkilledHigh
New Car$0$806193FDivorced22Own2UnskilledHigh
Education$0$3,2811920FDivorced29Own2SkilledHigh
New Car$0$7591659MSingle32Rent3SkilledHigh
Small Appliance$0$680253FDivorced34Own4SkilledHigh
Used Car$0$1043725MSingle23Own4SkilledHigh
Small Appliance$303$899133MSingle21Own1SkilledHigh
Small Appliance$900$1,7323711FDivorced49Other4SkilledHigh
Furniture$0$7063114MDivorced31Own2SkilledLow
Education$1,257$01065FDivorced40Rent4UnskilledLow
Small Appliance$0$576714FDivorced28Own1SkilledLow
Repairs$273$90472MMarried21Own1UnskilledLow
Business$522$1942579MDivorced30Own4SkilledHigh
Small Appliance$0$710251FDivorced37Own3SkilledLow
Small Appliance$0$5,5642593MSingle33Own2SkilledLow
Small Appliance$0$1924613MSingle22Other4SkilledHigh
New Car$0$6371321FDivorced23Own2UnskilledHigh
Small Appliance$514$4054913FDivorced21Own2SkilledHigh
Furniture$457$31819108MSingle40Own1SkilledLow
Small Appliance$5,133$6981914MSingle36Own2SkilledHigh
New Car$0$3691016MSingle29Own1SkilledLow
Retraining$644$01388MSingle37Own4SkilledLow
Furniture$305$492191FDivorced26Own1SkilledLow
New Car$9,621$3082541MSingle37Other3SkilledHigh
Education$0$1271322MSingle39Rent4UnskilledHigh
Business$0$5651914MMarried27Own2SkilledHigh
Furniture$0$12,632169FDivorced19Rent4SkilledLow
New Car$0$1164945MSingle45Other4SkilledHigh
Used Car$0$1781389MSingle34Other4SkilledHigh
Small Appliance$6,851$9011321FDivorced43Rent2UnskilledLow
Furniture$13,496$6501920MSingle33Own1UnskilledHigh
Business$509$2412514MSingle35Own4UnskilledHigh
Used Car$0$609376MSingle31Other2ManagementLow
Furniture$19,155$1312524MSingle25Own2SkilledLow
Furniture$0$5441915FDivorced27Own2SkilledLow
Small Appliance$0$10,8532581FDivorced56Rent4ManagementLow
Used Car$374$02514MSingle45Own4ManagementLow
Large Appliance$0$4094915MSingle53Own4SkilledHigh
Furniture$828$391912FDivorced23Own4SkilledHigh
Furniture$0$322139FDivorced25Own1SkilledLow
Small Appliance$829$583718FDivorced63Own3SkilledLow
Small Appliance$0$12,2422553MSingle34Own2SkilledHigh
Furniture$0$479190MSingle24Own1UnemployedHigh
New Car$939$4961956MSingle35Own4SkilledHigh
New Car$0$4662542MSingle30Own3SkilledHigh
New Car$889$1,5833779MSingle29Other3SkilledLow
Furniture$876$1,5333121FDivorced20Rent4SkilledHigh
Small Appliance$893$01694MSingle49Own4SkilledLow
Business$12,760$4,8731373MSingle56Rent4UnskilledLow
Furniture$0$01394MSingle48Rent4SkilledLow
Small Appliance$0$7172210FDivorced24Own2SkilledHigh
Small Appliance$959$7,8762820MSingle22Own2UnskilledHigh
Small Appliance$0$4,4492587MSingle30Own4SkilledHigh
Other$0$02554MSingle39Own3ManagementHigh
Business$0$1042523MMarried20Own2UnskilledLow
Repairs$0$897192FDivorced22Own4SkilledHigh
New Car$698$4,0331620MMarried24Rent2SkilledHigh
Furniture$0$945136MDivorced41Own1SkilledLow
Furniture$0$8362599MSingle32Own4SkilledLow
Small Appliance$0$3251913FDivorced23Own2SkilledHigh
Small Appliance$12,974$19,568137FDivorced41Rent3SkilledLow
Furniture$0$8031389MSingle52Other4ManagementHigh
Small Appliance$317$10,9801317MSingle65Own3UnskilledHigh
Business$0$2651310FDivorced26Own2SkilledLow
Repairs$0$609313MDivorced33Own1UnskilledHigh
Small Appliance$0$1,851120FDivorced56Own4UnskilledLow
Furniture$192$199255FDivorced24Own4UnskilledHigh
New Car$0$500287FDivorced20Rent3SkilledHigh
New Car$0$509163MSingle35Own3SkilledLow
Used Car$0$2702525MSingle34Own3SkilledLow
New Car$0$4571363MSingle38Own4ManagementLow
Used Car$0$2602578MSingle34Own4ManagementLow
New Car$942$3,0362536MSingle37Own3SkilledLow
Small Appliance$0$643196MSingle31Other2ManagementLow
New Car$3,329$01915MSingle67Rent4SkilledHigh
Used Car$0$6,3452519MSingle26Own2SkilledLow
Education$0$922379FDivorced24Own2ManagementHigh
Furniture$0$909253MSingle21Other1SkilledLow
Large Appliance$0$775198MMarried46Own3UnskilledHigh
Furniture$0$9792548MSingle22Rent4SkilledHigh
Furniture$0$948192FDivorced20Rent4SkilledLow
Business$339$2,7902255MDivorced60Rent2UnskilledHigh
Used Car$0$3094937MSingle25Own3SkilledLow
Small Appliance$0$762101FDivorced21Rent4SkilledHigh
Small Appliance$0$9701314FDivorced22Own1SkilledLow
Used Car$105$3202854MSingle29Own2ManagementLow
Small Appliance$0$86113111MSingle56Own4UnskilledHigh
Repairs$216$262372MSingle32Rent1UnskilledHigh
Furniture$113$6921114MDivorced30Own2UnskilledLow
Used Car$109$540371MMarried27Rent4ManagementHigh
New Car$0$470130FDivorced37Own2UnemployedLow
New Car$0$19272MSingle39Own4UnskilledLow
New Car$8,176$12,23075MMarried26Own2UnemployedLow
Repairs$0$7722519MDivorced32Own2SkilledLow
Furniture$468$14,1862224MSingle31Own2SkilledLow
Used Car$7,885$6,3301614MSingle35Own2SkilledLow
Small Appliance$0$18,7161993MSingle31Own3ManagementLow
New Car$0$8862296MSingle64Own4SkilledLow
Business$0$750372MDivorced27Own1SkilledHigh
Small Appliance$0$3,8702511FDivorced31Own2UnskilledHigh
Small Appliance$0$3,273134MMarried32Own3UnskilledHigh
Business$0$406635MSingle73Own4UnskilledLow
Furniture$0$4611348FDivorced30Own4UnskilledLow
Furniture$0$340194MMarried42Own1UnskilledHigh
Small Appliance$0$6,4901985MSingle45Own4SkilledLow
Small Appliance$734$3487100MSingle27Own4SkilledLow
Furniture$0$506253FDivorced22Rent4UnskilledHigh
Used Car$0$14,717287MSingle26Own2SkilledLow
Business$172$02536MSingle33Own3SkilledLow
New Car$644$1,571191FDivorced27Own3SkilledHigh
New Car$0$02519FDivorced24Rent4SkilledHigh
Furniture$617$411313MMarried21Own1SkilledLow
New Car$0$544250FDivorced28Rent4UnemployedHigh
Small Appliance$586$0130MSingle51Own1ManagementHigh
Furniture$0$8351942FDivorced21Own1SkilledHigh
Small Appliance$0$8232547MSingle27Own2SkilledLow
Business$0$5,180224MSingle40Own2UnskilledHigh
Small Appliance$0$4081612MSingle34Other4SkilledLow
New Car$0$821485FDivorced34Own1UnskilledLow
Education$522$3851066MSingle63Own4UnskilledLow
New Car$585$2,223160MSingle33Own2ManagementHigh
New Car$5,588$02210FDivorced28Own4SkilledHigh
New Car$0$6053720FDivorced24Own2SkilledHigh
Furniture$352$7,525134FDivorced18Rent4UnskilledLow
Small Appliance$0$3,529140FDivorced63Own4SkilledLow
Business$2,715$1,4354914MDivorced37Own2SkilledHigh
Other$560$8872520MSingle38Own3ManagementHigh
Small Appliance$895$243134MMarried22Rent1SkilledHigh
New Car$305$4,55372FDivorced31Own1UnskilledHigh
Small Appliance$0$418194MSingle31Own2SkilledLow
New Car$0$771250MSingle42Other2SkilledHigh
Furniture$0$4631113MSingle24Rent2UnskilledHigh
Business$8,948$1103190MSingle65Own4ManagementHigh
Used Car$0$10,09916108MSingle22Rent4SkilledLow
Used Car$0$13,42870FDivorced22Rent2UnemployedLow
Small Appliance$0$2081323MSingle51Own4SkilledLow
Small Appliance$0$5521315FDivorced23Own4UnskilledHigh
Education$0$3,1051619FDivorced30Own3SkilledLow
Small Appliance$483$415196MMarried32Own2SkilledHigh
Large Appliance$0$1,238130FDivorced21Own3SkilledHigh
Education$0$238132FDivorced52Own4SkilledHigh
Furniture$0$1273135FDivorced22Rent4SkilledHigh
Business$663$01957MSingle41Own2SkilledLow
New Car$624$785379FDivorced53Rent2SkilledLow
Repairs$0$718190FDivorced54Other4UnemployedHigh
Furniture$0$4931321MSingle37Own3UnskilledLow
Small Appliance$152$7574945MSingle27Own4SkilledHigh
New Car$0$9,1251324FDivorced25Own2SkilledHigh
Small Appliance$0$3641312FDivorced34Own2SkilledLow
Business$498$5983714MDivorced29Own2ManagementHigh
New Car$0$3741019MSingle27Own3UnskilledHigh
Small Appliance$156$01358FDivorced32Own3UnskilledHigh
Used Car$1,336$03711MSingle29Own2ManagementLow
New Car$0$508133MSingle32Own1UnskilledHigh
Small Appliance$0$956254FDivorced28Rent2UnskilledHigh
Furniture$0$6362241FDivorced25Rent4UnskilledLow
New Car$2,641$01371FDivorced51Other4ManagementLow
Used Car$0$1,5194074MSingle44Own2ManagementLow
Business$0$9221929MSingle33Own1SkilledLow
Furniture$0$18052FDivorced22Rent3UnskilledLow
Used Car$0$70122108MSingle35Own4ManagementLow
Small Appliance$0$296168MSingle30Own2SkilledLow
Small Appliance$887$519742MMarried27Own3UnskilledLow
Business$0$800492FDivorced23Rent4SkilledHigh
Furniture$0$736136FDivorced19Rent4SkilledHigh
Small Appliance$0$11,838770MSingle44Own4UnskilledLow
Small Appliance$0$364535MSingle41Own1UnskilledLow
New Car$18,408$212139FDivorced35Own2SkilledLow
New Car$497$888163FDivorced25Rent1UnemployedHigh
Used Car$0$999250MSingle28Other2ManagementLow
Small Appliance$946$01683MSingle34Own2SkilledLow
Business$986$578281FDivorced31Own1SkilledLow
Education$8,122$136224MDivorced32Rent1SkilledHigh
Furniture$0$73437111MSingle41Own2SkilledHigh
Business$778$8614921MSingle22Own2SkilledHigh
Other$645$8552517MSingle28Own3ManagementHigh
Furniture$0$4,486103FDivorced21Rent4SkilledLow
New Car$682$2,0173785MSingle41Own4ManagementHigh
New Car$19,812$02537MSingle36Own2UnskilledHigh
Business$0$500251MSingle26Own2SkilledHigh
Used Car$0$8593189MSingle37Other4ManagementLow
Business$859$3,3052526MSingle35Rent4ManagementLow
Small Appliance$0$1,2181338MSingle34Own1SkilledLow
New Car$0$9,0164922MSingle43Other2SkilledHigh
New Car$0$11,5872246FDivorced30Own2ManagementLow
Furniture$0$8,9442566MSingle31Rent3SkilledLow
Repairs$0$8072575MSingle43Other4SkilledLow
Small Appliance$0$8673127FDivorced24Own2SkilledLow
Small Appliance$795$16,8044940MSingle26Own2SkilledHigh
Furniture$0$347165FDivorced45Rent1SkilledLow
Furniture$0$836164MSingle26Own3UnskilledLow
Furniture$0$142753FDivorced48Own1SkilledLow
Furniture$0$169196MSingle43Own3SkilledHigh
Other$852$3,6136183FDivorced59Other4ManagementHigh
Education$0$40375FDivorced55Own2SkilledLow
Small Appliance$0$836250MSingle29Own2ManagementHigh
New Car$425$0197FDivorced32Own2SkilledHigh
Business$0$11,4812518MSingle53Own3ManagementHigh
Business$0$3,285721MSingle33Own2UnskilledLow
Education$0$1641365FDivorced56Other4UnskilledLow
New Car$11,072$8916117MSingle33Other4SkilledLow
Used Car$0$03749MSingle46Other4SkilledHigh
Used Car$219$841430MSingle54Other2ManagementLow
New Car$8,060$6071971FDivorced22Own2ManagementLow
New Car$0$4861222MSingle35Rent2SkilledLow
New Car$0$1082552MSingle46Own4UnskilledHigh
Small Appliance$0$04328FDivorced29Own3ManagementHigh
New Car$0$1132531FDivorced22Rent4SkilledHigh
New Car$1,613$025118MMarried53Own4SkilledLow
Furniture$757$2082536MDivorced42Own3SkilledHigh
Retraining$0$6031335MMarried20Rent4SkilledHigh
New Car$0$3431922FDivorced35Own3SkilledLow
Education$977$4631061FDivorced33Own3ManagementHigh
Education$197$03717MMarried26Own2SkilledLow
Furniture$0$2991911MSingle46Other4SkilledLow
New Car$0$4901315FDivorced28Own2SkilledHigh
Small Appliance$0$6,6283765MSingle38Own4SkilledLow
Business$0$8591923MSingle35Own2SkilledHigh
New Car$0$7501314MSingle47Own4SkilledHigh
Small Appliance$256$9541013MSingle23Own3SkilledLow
New Car$296$59137103MSingle56Other4SkilledHigh
Furniture$0$13,9701324FDivorced28Rent4UnskilledHigh
New Car$0$8571134MSingle48Own3SkilledLow
Furniture$0$5,8571920MSingle27Own2SkilledLow
Small Appliance$298$3,3267315MMarried23Own2SkilledHigh
Small Appliance$0$726197FDivorced24Rent4SkilledHigh
Furniture$8,636$214113FDivorced22Own2SkilledLow
New Car$0$20713119MSingle42Rent4SkilledHigh
New Car$0$7131329MSingle25Own2SkilledHigh
New Car$19,766$2,1411154FDivorced47Other4UnskilledHigh
New Car$0$4831990FDivorced32Rent4SkilledHigh
New Car$0$127713MSingle25Rent3SkilledLow
Furniture$0$3673722MSingle36Own2SkilledLow
Small Appliance$0$8134328MSingle25Own2SkilledHigh
Furniture$4,089$0714MMarried26Own2SkilledLow
New Car$0$10270FDivorced53Own4UnemployedLow
Repairs$271$759190FDivorced66Own4SkilledLow
New Car$949$04936FDivorced23Own2SkilledLow
Small Appliance$0$5031362MSingle25Own2SkilledLow
Small Appliance$911$823464MSingle24Own2UnskilledHigh
New Car$0$6931928MSingle31Other4UnskilledHigh
Used Car$0$9734981FDivorced57Other4UnskilledHigh
New Car$0$6481557MDivorced44Own4ManagementHigh
Other$0$523370MDivorced42Own3ManagementLow
Used Car$271$7,090252FDivorced27Rent4SkilledHigh
Small Appliance$0$5961367MSingle51Own4SkilledLow
Used Car$0$90449119MSingle23Other4SkilledHigh
New Car$0$5411913MSingle31Own2SkilledHigh
Furniture$0$154372FDivorced22Rent4SkilledHigh
New Car$4,802$03712MSingle35Own4SkilledLow
Business$177$0499MSingle37Other4SkilledLow
Small Appliance$0$33725107MSingle35Own1ManagementLow
New Car$0$7161933MSingle30Own2SkilledHigh
Education$996$8374983MSingle49Other4SkilledHigh
Education$705$02524FDivorced32Own2SkilledLow
Furniture$0$7,71025114MSingle52Own4SkilledLow
New Car$0$531135MSingle45Own2SkilledHigh
Small Appliance$5,960$1291316MMarried23Own1SkilledLow
Furniture$0$94113111MSingle41Own4SkilledLow
Furniture$759$5961018FDivorced28Own2SkilledHigh
Furniture$0$98737101MSingle30Own4SkilledHigh
Small Appliance$651$037102MSingle50Own2SkilledLow
Business$257$4604975FDivorced58Rent3SkilledHigh
Small Appliance$955$04929MSingle36Own3SkilledLow
Small Appliance$0$7982542MSingle23Rent4UnskilledHigh
Small Appliance$8,249$03177MSingle48Own4UnskilledLow
Small Appliance$0$9591121MSingle37Own4SkilledLow
Small Appliance$956$1,4824619MSingle20Rent4SkilledHigh
New Car$382$8833120FDivorced23Own2SkilledHigh
Furniture$0$12,7213731FDivorced39Own4SkilledLow
Education$842$0379MSingle34Other4UnskilledLow
Repairs$3,111$01327FDivorced22Own4SkilledLow
Small Appliance$0$3021030MSingle21Own2SkilledHigh
Furniture$0$5382559MSingle38Rent2ManagementHigh
Small Appliance$2,846$01314MSingle36Other4SkilledLow
Small Appliance$231$7021099MSingle26Own4UnskilledLow
Repairs$0$2,6881089MSingle47Own4SkilledLow
Small Appliance$17,366$01621MSingle38Other4SkilledHigh
Small Appliance$0$4251310MSingle27Rent2SkilledHigh
New Car$332$214252MSingle25Own1SkilledLow
Small Appliance$242$0196MSingle28Own3SkilledLow
New Car$0$272790MSingle67Own4ManagementHigh
Business$929$12491MMarried25Own2SkilledLow
Small Appliance$0$17,1241395MMarried34Own1SkilledLow
Used Car$0$6124932MSingle38Other4SkilledHigh
New Car$0$8624962MSingle41Other4ManagementHigh
Furniture$0$1462546MSingle26Own4SkilledHigh
New Car$0$14,1903792MSingle35Own4SkilledLow
Used Car$0$3964973MSingle45Other4SkilledHigh
Small Appliance$0$5193123FDivorced32Own2SkilledLow
Used Car$646$0259MDivorced47Other4SkilledLow
New Car$538$3441340MMarried24Own3UnskilledHigh
Furniture$0$204315MDivorced30Own4UnskilledHigh
Small Appliance$0$148432MSingle33Own3SkilledHigh
Furniture$0$4351916FDivorced23Rent4SkilledHigh
Small Appliance$0$914190FDivorced21Rent4SkilledHigh
New Car$135$0377MSingle36Other4SkilledHigh
Used Car$2,472$03741MSingle30Own2ManagementLow
New Car$0$4122522MSingle52Other4SkilledHigh
New Car$10,417$19,8111327MMarried27Own2SkilledHigh
Small Appliance$211$82285FDivorced44Own1SkilledLow
Small Appliance$16,630$01147MSingle26Own2SkilledLow
Furniture$0$3,3692517MSingle24Own1SkilledLow
Furniture$642$01365FDivorced24Own2SkilledHigh
Small Appliance$0$707726MSingle50Own2SkilledLow
Small Appliance$296$8181993MMarried31Own2UnskilledLow
Business$898$17722105FDivorced38Own4SkilledHigh
New Car$478$4,0711040MSingle28Own3SkilledHigh
New Car$315$466133MSingle48Own3UnskilledLow
New Car$122$46037109MSingle56Other2ManagementHigh
Furniture$0$99173FDivorced31Own4SkilledHigh
Small Appliance$0$17,653224FDivorced28Own2SkilledLow
Education$0$4974124MSingle26Own3SkilledHigh
Business$670$4,0143121FDivorced25Rent4UnskilledHigh
Business$444$9212851FDivorced41Other4ManagementHigh
New Car$3,880$02337FDivorced24Rent4SkilledLow
Used Car$819$01323MSingle29Own2SkilledLow
Used Car$0$6073717MSingle25Own2SkilledHigh
Large Appliance$0$15,8001640MSingle35Own3SkilledLow
Furniture$0$369723MSingle35Own2UnskilledLow
Business$0$4,9732517MSingle26Own3UnskilledLow
Furniture$0$04030MSingle29Own4ManagementLow
New Car$0$7612592MSingle59Own4UnskilledHigh
Education$0$471752FDivorced34Other4SkilledHigh
Used Car$0$6743769MSingle41Other4SkilledLow
New Car$0$5471340MDivorced35Own3SkilledHigh
Furniture$161$52413106MSingle27Rent4SkilledLow
Furniture$0$8151913MSingle41Own3SkilledHigh
Used Car$0$0114FDivorced30Rent4SkilledLow
New Car$789$989310MMarried27Own2ManagementHigh
Small Appliance$765$10,4061024FDivorced65Own3UnskilledLow
Furniture$0$9571911FDivorced19Rent4SkilledHigh
New Car$0$770373FDivorced33Own4SkilledHigh
Furniture$983$950135FDivorced24Rent3SkilledHigh
Used Car$0$160137MMarried40Rent4SkilledLow
Used Car$0$2762591MSingle62Own4SkilledLow
Education$798$1372525FDivorced33Other4UnskilledHigh
New Car$0$5792270MMarried29Own3SkilledLow
New Car$193$2,684135FDivorced22Own2UnskilledHigh
Small Appliance$497$0751MSingle35Other4SkilledLow
Furniture$0$03153MSingle30Own4SkilledHigh
New Car$0$025103FDivorced28Own2SkilledHigh
New Car$0$712166FDivorced28Own2SkilledHigh
New Car$0$912739MSingle44Own3ManagementLow

Question 20

President's Inn Guest Database
IDGuest First NameGuest Last NameRoomRoom TypeArrival DateDeparture DateNo of GuestsDaily Rate
1BarryLloydHayesBay-window12/1/1412/4/142$150.00
2MichaelLunsfordClevelandOcean12/1/1412/9/143$112.50
3KimKyuongCoolidgeBay-window12/4/1412/7/141$150.00
4EdwardHoltWashingtonOcean12/1/1412/3/144$325.00
5ThomasCollinsLincolnOcean12/9/1412/13/142$300.00
6PaulBodkinCoolidgeBay-window12/1/1412/3/142$150.00
7RandallBattenburgWashingtonOcean12/4/1412/12/142$292.50
8CalvinNowotneyLincolnOcean12/2/1412/4/141$300.00
9HomerGonzalezLincolnOcean12/5/1412/7/145$320.00
10DavidSanchezJeffersonBay-window12/5/1412/7/142$175.00
11BusterWhislerJacksonOcean12/5/1412/8/142$250.00
12JuliaMartinesReaganBay-window12/10/1412/15/141$150.00
13SamuelKimTrumanSide12/20/1412/30/143$112.50
14ArthurGottfriedGarfieldSide12/13/1412/15/142$125.00
15DarleneShoreArthurOcean12/24/1412/31/145$198.00
16CarlyleCharlestonQuincy AdamsBay-window12/3/1412/6/142$150.00
17AlbertGoldstoneJohnsonOcean12/5/1412/7/143$250.00
18CharleneTilsonVan BurenBay-window12/5/1412/7/141$150.00
19EverettChadMadisonOcean12/10/1412/14/142$275.00
20GeraldPittsfieldRooseveltOcean12/5/1412/7/142$275.00
21JamalSmithTylerBay-window12/20/1412/23/142$150.00
22LouisParisJacksonOcean12/10/1412/14/141$250.00
23NigelStratfordEisenhowerOcean12/14/1412/16/142$200.00
24PeterWillingtonGrantOcean12/19/1412/21/141$200.00
25RonaldCartierJeffersonBay-window12/24/1412/28/144$175.00
26TristaLevenEisenhowerOcean12/17/1412/20/141$200.00
27ValerieSnellAdamsBay-window12/3/1412/6/141$150.00
28WalterActonPolkSide12/24/1412/31/146$148.50
29XavierTrezzaMcKinleySide12/14/1412/17/142$125.00
30ZacharyMillerWashingtonOcean12/13/1412/16/142$325.00