Excel Quiz Student's Name Grader's Name Number correct 1Create a Table of the data below and rename it "AllData" 2Using the tables capabilities, insert a Totals row and calculate the average for...

1 answer below ยป
Directions:MAKE SURE I CAN SEE/ACCESS ALL OF THE FORMULAS YOU HAVE USED WITHIN YOUR SPREADSHEET SUBMISSION.


Excel Quiz Student's Name Grader's Name Number correct 1Create a Table of the data below and rename it "AllData" 2Using the tables capabilities, insert a Totals row and calculate the average for MonthlyCharges 3In the Yellow box, use a Structured Reference for the "AllData" table to calculate a correlation between Tenure and MonthlyChargesHINT: Use the correlation function under the data analysis tool pak 4Insert a Pivot Table based upon "AllData" create a cross tab that counts "Churn" by payment method.Hint: Use a pivot table with churn and payment method as the fields 5Generate a stacked bar chart based upon the pivot table. customerIDgenderTenureMonthly ChargesPayment MethodChurn 7590-VHVEGFemale129.85Electronic checkNo 5575-GNVDEMale3456.95Mailed checkNo 3668-QPYBKMale253.85Mailed checkYes 7795-CFOCWMale4542.3Bank transfer (automatic)No 9237-HQITUFemale270.7Electronic checkYes 9305-CDSKCFemale899.65Electronic checkYes 1452-KIOVKMale2289.1Credit card (automatic)No 6713-OKOMCFemale1029.75Mailed checkNo 7892-POOKPFemale28104.8Electronic checkYes 6388-TABGUMale6256.15Bank transfer (automatic)No 9763-GRSKDMale1349.95Mailed checkNo 7469-LKBCIMale1618.95Credit card (automatic)No 8091-TTVAXMale58100.35Credit card (automatic)No 0280-XJGEXMale49103.7Bank transfer (automatic)Yes 5129-JLPISMale25105.5Electronic checkNo 3655-SNQYZFemale69113.25Credit card (automatic)No 8191-XWSZGFemale5220.65Mailed checkNo 9959-WOFKTMale71106.7Bank transfer (automatic)No 4190-MFLUWFemale1055.2Credit card (automatic)Yes 4183-MYFRBFemale2190.05Electronic checkNo 8779-QRDMVMale139.65Electronic checkYes 1680-VDCWWMale1219.8Bank transfer (automatic)No 1066-JKSGKMale120.15Mailed checkYes 3638-WEABWFemale5859.9Credit card (automatic)No 6322-HRPFAMale4959.6Credit card (automatic)No 6865-JZNKOFemale3055.3Bank transfer (automatic)No 6467-CHFZWMale4799.35Electronic checkYes 8665-UTDHZMale130.2Electronic checkYes 5248-YGIJNMale7290.25Credit card (automatic)No 8773-HHUOZFemale1764.7Mailed checkYes 3841-NFECXFemale7196.35Credit card (automatic)No 4929-XIHVWMale295.5Credit card (automatic)No 6827-IEAUQFemale2766.15Mailed checkNo 7310-EGVHZMale120.2Bank transfer (automatic)No 3413-BMNZEMale145.25Bank transfer (automatic)No 6234-RAAPLFemale7299.9Bank transfer (automatic)No 6047-YHPVIMale569.7Electronic checkYes 6572-ADKRSFemale4674.8Credit card (automatic)No 5380-WJKOVMale34106.35Electronic checkYes 8168-UQWWFFemale1197.85Bank transfer (automatic)Yes 8865-TNMNXMale1049.55Mailed checkNo 9489-DEDVPFemale7069.2Credit card (automatic)No 9867-JCZSPFemale1720.75Mailed checkNo 4671-VJLCLFemale6379.85Credit card (automatic)No 4080-IIARDFemale1376.2Electronic checkNo 3714-NTNFOFemale4984.5Electronic checkNo 5948-UJZLFMale249.25Mailed checkNo 7760-OYPDYFemale280.65Electronic checkYes 7639-LIAYIMale5279.75Credit card (automatic)No 2954-PIBKOFemale6964.15Credit card (automatic)No 8012-SOUDQFemale4390.25Electronic checkNo 9420-LOJKXFemale1599.1Credit card (automatic)Yes 6575-SUVOIFemale2569.5Credit card (automatic)No 7495-OOKFYFemale880.65Credit card (automatic)Yes 4667-QONEAFemale6074.85Credit card (automatic)No 1658-BYGOYMale1895.45Electronic checkYes 8769-KKTPHFemale6399.65Credit card (automatic)No 5067-XJQFUMale66108.45Electronic checkNo 3957-SQXMLFemale3424.95Credit card (automatic)No 5954-BDFSGFemale72107.5Credit card (automatic)No 0434-CSFONFemale47100.5Electronic checkNo 1215-FIGMPMale6089.9Bank transfer (automatic)No 0526-SXDJPMale7242.1Bank transfer (automatic)No 0557-ASKVUFemale1854.4Credit card (automatic)No 5698-BQJOHFemale994.4Electronic checkYes 5122-CYFXAFemale375.3Electronic checkNo 8627-ZYGSZMale4778.9Electronic checkNo 3410-YOQBQFemale3179.2Mailed checkNo 3170-NMYVVFemale5020.15Bank transfer (automatic)No 7410-OIEDUMale1079.85Mailed checkNo 2273-QCKXAMale149.05Mailed checkNo 0731-EBJQBFemale5220.4Electronic checkNo 1891-QRQSAMale64111.6Bank transfer (automatic)No 8028-PNXHQMale6224.25Bank transfer (automatic)No 5630-AHZILFemale364.5Bank transfer (automatic)No 2673-CXQEUFemale56110.5Electronic checkNo 6416-JNVRKFemale4655.65Credit card (automatic)No 5590-ZSKRVFemale854.65Mailed checkNo 0191-ZHSKZMale3074.75Electronic checkNo 3887-PBQAOFemale4525.9Credit card (automatic)No 5919-TMRGDFemale179.35Electronic checkYes 8108-UXRQNFemale1150.55Electronic checkNo 9191-MYQKXFemale775.15Bank transfer (automatic)Yes 9919-YLNNGFemale42103.8Bank transfer (automatic)No 0318-ZOPWSFemale4920.15Bank transfer (automatic)No 4445-ZJNMUMale999.3Credit card (automatic)No 4808-YNLEUFemale3562.15Bank transfer (automatic)No 1862-QRWPEFemale4820.65Bank transfer (automatic)No 2796-NNUFIFemale4619.95Mailed checkNo 3016-KSVCPMale2933.75Mailed checkNo 4767-HZZHQMale3082.05Bank transfer (automatic)No 2424-WVHPLMale174.7Electronic checkNo 7233-PAHHLMale6684Mailed checkNo 6067-NGCEUFemale65111.05Credit card (automatic)No 9848-JQJTXMale72100.9Bank transfer (automatic)No 8637-XJIVRFemale1278.95Electronic checkYes 9803-FTJCGMale7166.85Credit card (automatic)No 0278-YXOOGMale521.05Mailed checkYes 3212-KXOCRMale5221Bank transfer (automatic)No 4598-XLKNJFemale2598.5Electronic checkYes 6380-ARCEHMale120.2Mailed checkNo 3679-XASPYFemale119.45Electronic checkNo 7123-WQUHXMale3895Bank transfer (automatic)No 5386-THSLQFemale6645.55Bank transfer (automatic)No 3192-NQECAMale68110Bank transfer (automatic)Yes 6180-YBIQIMale524.3Mailed checkNo 6728-DKUCOFemale72104.15Electronic checkNo 9750-BOOHVFemale3230.15Mailed checkNo 8597-CWYHHMale4394.35Mailed checkNo 2848-YXSMWMale7219.4Credit card (automatic)No 0486-HECZIMale5596.75Electronic checkYes 4549-ZDQYYFemale5257.95Credit card (automatic)No 5712-AHQNNFemale4391.65Electronic checkNo 4846-WHAFZFemale3776.5Electronic checkYes 5256-SKJGOFemale6454.6Electronic checkNo 3071-VBYPOMale389.85Electronic checkNo 9560-BBZXKFemale3631.05Bank transfer (automatic)No 5299-RULOAFemale10100.25Electronic checkYes 8402-OOOHJFemale4120.65Mailed checkNo 9445-ZUEQEMale2785.2Credit card (automatic)No 1091-SOZGAFemale5699.8Credit card (automatic)No 2928-HLDBAFemale620.7Mailed checkNo 0404-SWRVGMale374.4Electronic checkYes 6497-TILVLFemale750.7Mailed checkNo 7219-TLZHOFemale420.85Mailed checkNo 4622-YNKIJMale3388.95Electronic checkNo 4412-YLTKFFemale2778.05Electronic checkYes 6734-PSBAWMale7223.55Bank transfer (automatic)No 3930-ZGWVEMale119.75Mailed checkNo 2639-UGMAZMale7156.45Electronic checkNo 2876-GZYZCFemale1385.95Electronic checkNo 6207-WIOLXFemale2558.6Credit card (automatic)Yes 8587-XYZSFMale6750.55Bank transfer (automatic)No 3091-FYHKIMale135.45Electronic checkYes 2372-HWUHIMale244.35Electronic checkYes 7799-LGRDPFemale4325.7Credit card (automatic)No 7850-VWJUUFemale2375Bank transfer (automatic)No 3774-VBNXYFemale6420.2Mailed checkNo 6217-KDYWCMale5719.6Mailed checkNo 0390-DCFDQFemale170.45Mailed checkYes 3146-MSEGFFemale7288.05Credit card (automatic)No 4080-OGPJLFemale871.15Electronic checkYes 1095-WGNGGFemale61101.05Bank transfer (automatic)No 2636-SJDOUMale6484.3Credit card (automatic)No 1131-QQZEBMale7123.95Bank transfer (automatic)No 5716-EZXZNFemale6599.05Credit card (automatic)No 6837-BJYDQMale319.6Mailed checkNo 2135-RXIHGMale145.65Electronic checkYes 6440-DKQGEMale3064.5Credit card (automatic)No 3466-BYAVDMale1569.5Mailed checkNo 3780-YVMFAFemale868.55Electronic checkNo 3874-EQOEPMale795Mailed checkYes 1679-JRFBRFemale70108.15Credit card (automatic)No 9073-ZZIAYMale6286.1Electronic checkNo 3077-RSNTJFemale619.7Mailed checkNo 6551-GNYDGFemale1480.9Bank transfer (automatic)No 9167-APMXZFemale2284.15Bank transfer (automatic)No 2749-CTKAJMale2220.15Mailed checkNo 6371-NZYEGMale1664.25Mailed checkNo 7554-NEWDDMale1025.7Bank transfer (automatic)No 8992-VONJDFemale1356Electronic checkNo 0867-MKZVYFemale2082.4Electronic checkYes 4482-EWFMIFemale269.7Electronic checkNo 4648-YPBTMMale5373.9Bank transfer (automatic)No 2907-ILJBNFemale1120.6Mailed checkNo 6345-FZOQHMale6919.9Mailed checkNo 3376-BMGFEFemale470.9Bank transfer (automatic)Yes 5997-OPVFAMale7289.05Bank transfer (automatic)No 3445-HXXGFMale5845.3Electronic checkYes 1159-WFSGRFemale1620.4Electronic checkNo 7654-YWJUFMale4384.25Bank transfer (automatic)No 1875-QIVMEFemale2104.4Electronic checkYes 6727-IOTLZMale1481.95Mailed checkNo 0691-JVSYAFemale5394.85Bank transfer (automatic)Yes 5918-VUKWPFemale3220.55Bank transfer (automatic)No 1744-JHKYSFemale3424.7Electronic checkNo 2656-FMOKZFemale1574.45Mailed checkYes 2070-FNEXEFemale776.45Bank transfer (automatic)Yes 5947-SGKCLFemale15105.35Bank transfer (automatic)No 3712-PKXZAMale6120.55Credit card (automatic)No 6317-YPKDHFemale129.95Bank transfer (automatic)Yes 6582-OIVSPFemale145.3Mailed checkNo 9367-WXLCHMale884.5Bank transfer (automatic)Yes 5524-KHNJPMale3374.75Credit card (automatic)No 1918-ZBFQJFemale1379.25Electronic checkYes 1024-GUALDFemale124.8Electronic checkYes 4827-USJHPMale2051.8Mailed checkNo 8167-GJLRNMale330.4Electronic checkNo 0956-SYCWGFemale1319.65Electronic checkNo 8017-UVSZUFemale4056.6Credit card (automatic)No 7100-FQPRVMale4371.9Credit card (automatic)No 2472-OVKUPMale691Electronic checkYes 2984-RGEYAFemale6919.75Bank transfer (automatic)No 9680-NIAUVFemale72109.7Credit card (automatic)No 2146-EGVDTMale5919.3Credit card (automatic)No 2604-IJPDUFemale2096.55Electronic checkNo 9178-JHUVJMale2424.1Bank transfer (automatic)No 6168-YBYNPMale59111.35Electronic checkNo 7255-SSFBCMale72112.25Bank transfer (automatic)No 3645-DEYGFMale120.75Mailed checkNo 9323-HGFWYFemale27101.9Credit card (automatic)No 8544-GOQSHFemale1480.05Credit card (automatic)No 3363-DTIVDMale71105.55Electronic checkNo 7018-WBJNKMale1378.3Credit card (automatic)No 9142-KZXOPMale4468.85Credit card (automatic)No 7674-YTAFDFemale3379.95Bank transfer (automatic)No 6348-SNFUSMale7255.45Credit card (automatic)No 1285-OKIPPMale179.9Electronic checkYes 7825-ECJRFFemale19106.6Electronic checkYes 1347-KTTTAMale64102.45Credit card (automatic)No 7841-TZDMQMale246Credit card (automatic)Yes 4195-NZGTAFemale125.25Electronic checkNo 7157-SMCFKMale6119.75Mailed checkNo 4709-LKHYGFemale2920Electronic checkNo 2504-DSHIHMale2386.8Electronic checkNo 0699-NDKJMFemale5758.75Bank transfer (automatic)No 9286-BHDQGMale7245.25Credit card (automatic)No 0230-WEQUWMale6656.6Bank transfer (automatic)No 2040-LDIWQMale6584.2Bank transfer (automatic)No 6496-JDSSBFemale880Bank transfer (automatic)No 9408-SSNVZFemale470.15Electronic checkYes 4443-EMBNAFemale7124.75Bank transfer (automatic)No 6469-MRVETMale120.2Electronic checkNo 0742-MOABMMale450.05Mailed checkYes 5961-VUSRVFemale1219.35Bank transfer (automatic)No 6778-JFCMKMale2450.6Mailed checkNo 6341-JVQGFFemale3181.15Mailed checkNo 2232-DMLXUFemale155.2Mailed checkYes 4811-JBUVUMale3089.9Credit card (automatic)No 0945-TSONXFemale4785.3Credit card (automatic)No 2651-ZCBXVMale54108Credit card (automatic)No 3316-UWXUYMale5093.5Credit card (automatic)No 8937-RDTHPMale184.6Mailed checkYes 7083-MIOPCFemale7220.25Credit card (automatic)No 1984-GPTEHFemale2925.15Electronic checkNo 1251-KRREGMale254.4Mailed checkYes 0621-JFHOLFemale1029.6Mailed checkNo 9903-LYSABMale1873.15Electronic checkNo 0094-OIFMOFemale1195Electronic checkYes 9227-UAQFTMale1619.75Mailed checkNo 7301-ABVADFemale7286.6Bank transfer (automatic)No 6614-FHDBOMale72109.2Bank transfer (automatic)No 7576-ASEJUFemale4174.7Credit card (automatic)No 9058-HRZSVFemale6594.4Electronic checkNo 4522-AKYLRFemale1354.8Electronic checkNo 0221-WMXNQMale475.35Electronic checkNo 0303-UNCIPMale4165Mailed checkNo 9947-OTFQUMale1574.4Electronic checkYes 0322-YINQPMale148.55Mailed checkYes 0959-WHOKVMale4299Electronic checkNo 4075-JFPGRFemale5193.5Electronic checkNo 4629-NRXKXFemale270.4Electronic checkYes 9514-JDSKIMale140.2Electronic checkYes 3282-ZISZVMale3283.7Credit card (automatic)No 3675-YDUPJMale1019.85Mailed checkNo 4111-BNXIFFemale6759.55Electronic checkNo 7017-VFHAYFemale61115.1Credit card (automatic)No 6655-LHBYWMale50114.35Credit card (automatic)No 4959-JOSRXFemale244.6Credit card (automatic)Yes 5046-NUHWDFemale2945Electronic checkNo 7273-TEFQDMale341.15Electronic checkYes 3606-TWKGIMale13106.9Electronic checkYes 7529-ZDFXIMale5789.85Electronic checkNo 7605-BDWDCFemale3149.85Bank transfer (automatic)No 1950-KSVVJFemale45113.3Mailed checkNo 0123-CRBRTFemale6188.1Mailed checkNo 6292-TOSSSMale5024.9Bank transfer (automatic)No 3197-ARFOYFemale19105Mailed checkNo 6323-AYBRXMale5919.35Mailed checkYes 7014-ZZXAWFemale7124.25Credit card (automatic)No 4385-GZQXVFemale1694.45Electronic checkYes 7633-MVPUYMale5759.75Electronic checkNo 6366-ZGQGLMale124.8Bank transfer (automatic)Yes 4716-HHKQHMale20107.05Electronic checkNo 5940-AHUHDMale170.6Mailed checkYes 6432-TWQLBMale585.4Electronic checkYes 4484-GLZOUFemale52105.05Electronic checkYes 3179-GBRWVMale2164.95Bank transfer (automatic)No 8645-KWHJOMale1455Electronic checkNo 4130-MZLCCFemale550.55Bank transfer (automatic)No 0314-TKOSIFemale655.15Mailed checkNo 8229-MYEJZFemale1051.2Electronic checkNo 2080-SRCDEFemale125.4Mailed checkNo 9577-WJVCQFemale6854.45Mailed checkNo 9512-UIBFXMale1895.15Mailed checkYes 6202-DYYFXFemale2276Credit card (automatic)No 3808-HFKDEFemale2044.35Electronic checkNo 5583-SXDAGMale170Electronic checkYes 3488-PGMQJMale874.5Electronic checkYes 3580-REOACMale1044.85Credit card (automatic)Yes 7534-BFESCMale2476.1Electronic checkYes 3727-OWVYDMale3561.2Mailed checkNo 2294-SALNEMale2386.8Mailed checkNo 4847-TAJYIFemale689.35Electronic checkNo 1563-IWQEXFemale1219.7Mailed checkNo 8203-XJZRCMale120.25Mailed checkNo 6556-DBKZFFemale7176.05Electronic checkNo 6851-WEFYXMale35100.8Electronic checkNo 2985-JUUBZMale4074.55Electronic checkNo 6390-DSAZXFemale173.6Mailed checkYes 0895-LMRSFMale2364.9Bank transfer (automatic)No 8098-LLAZXFemale495.45Electronic checkYes 8266-VBFQLMale490.4Electronic checkNo 8181-YHCMFFemale6860.3Credit card (automatic)No 2240-HSJQDMale3881.85Mailed checkNo 1248-DYXUBMale5224.8Mailed checkNo 0265-EDXBDMale3274.9Electronic checkYes 4115-BNPJYMale2975.55Mailed checkNo 3167-SNQPLMale38101.15Electronic checkNo 4091-TVOCNMale4878.75Credit card (automatic)No 1098-TDVUQFemale119.25Bank transfer (automatic)No 7277-OZCGZFemale2289.05Electronic checkNo 1557-EMYVTFemale43115.05Credit card (automatic)No 2799-ARNLOFemale569.35Electronic checkNo 7563-BIUPCMale580.6Electronic checkYes 5027-YOCXNMale51110.05Credit card (automatic)No 3973-SKMLNMale7119.9Credit card (automatic)No 2321-OMBXYFemale3880.3Credit card (automatic)Yes 2840-XANRCMale2493.15Electronic checkYes 6745-JEFZBMale3591.5Credit card (automatic)No 5020-ZSTTYFemale5482.45Bank transfer (automatic)Yes 9880-TDQACFemale7260Electronic checkNo 8705-WZCYLMale144.8Electronic checkNo 7102-JJVTXFemale948.6Mailed checkNo 8626-PTQGEMale6960.05Bank transfer (automatic)No 4983-CLMLVFemale52102.7Credit card (automatic)No 5701-YVSVFFemale1182.9Electronic checkNo 5804-LEPIMFemale270.35Electronic checkYes 5697-GOMBFFemale2835.9Electronic checkNo 2739-CACDQFemale1782.65Credit card (automatic)No 9385-EHGDOFemale3519.85Mailed checkNo 9498-FIMXLFemale819.2Mailed checkNo 2379-GYFLQMale4694.9Credit card (automatic)No 0122-OAHPZFemale773.85Electronic checkYes 2868-SNELZFemale280.6Mailed checkYes 4322-RCYMTMale6875.8Bank transfer (automatic)Yes 6680-NENYNFemale43104.6Electronic checkYes 2088-IEBAUFemale6888.15Electronic checkNo 7982-VCELRFemale3694.8Credit card (automatic)No 1343-EHPYBMale63103.4Electronic checkYes 6035-BXTTYFemale3254.65Bank transfer (automatic)No 6885-PKOAMFemale7185.75Credit card (automatic)No 7520-HQWJUFemale6667.45Bank transfer (automatic)No 9639-BUJXTMale6320.5Mailed checkNo 5924-SNGKPFemale4120.25Credit card (automatic)No 0021-IKXGCFemale172.1Electronic checkNo 2034-GDRCNFemale290.4Electronic checkYes 8966-SNIZFFemale7019.45Bank transfer (automatic)No 6243-OZGFHFemale2344.95Electronic checkNo 4654-DLAMQFemale6497Bank transfer (automatic)No 0513-RBGPEMale3762.8Credit card (automatic)No 5160-UXJEDMale1744.6Mailed checkNo 4115-NZRKSFemale789.15Electronic checkNo 0219-YTZUEMale484.8Bank transfer (automatic)Yes 0623-IIHUGFemale2141.9Electronic checkYes 4572-DVCGNFemale1080.25Bank transfer (automatic)Yes 3351-NGXYIFemale1654.1Electronic checkNo 8984-EYLLLMale64105.25Electronic checkNo 9057-MSWCOMale2730.75Credit card (automatic)Yes 9833-TGFHXMale4297.1Electronic checkNo 9294-TDIPCMale520.2Mailed checkNo 5229-DTFYBFemale4198.8Bank transfer (automatic)No 0104-PPXDVMale5850.3Credit card (automatic)No 5176-LMJXEFemale4720.55Mailed checkNo 3583-KRKMDMale1875.9Bank transfer (automatic)No 1010-DIAUQMale596.5Bank transfer (automatic)Yes 9069-LGEULMale2359.95Bank transfer (automatic)No 7302-ZHMHPFemale119.15Mailed checkNo 9571-EDEBVMale7198.65Credit card (automatic)No 3520-FJGCVMale72112.6Credit card (automatic)No 6563-VRERXMale3320.6Mailed checkNo 0259-GBZSHMale285.65Electronic checkYes 6122-EFVKNMale2435.75Mailed checkNo 2805-EDJPQFemale5699.75Credit card (automatic)No 6862-CQUMBMale3796.1Credit card (automatic)No 7156-MXBJEFemale4385.1Credit card (automatic)No 6158-HDPXZMale125.35Mailed checkNo 9601-BRXPOFemale25104.95Bank transfer (automatic)Yes 2863-IMQDRFemale6189.65Electronic checkNo 5686-CMAWKMale1786.75Electronic checkNo 5651-CRHKQFemale4186.2Bank transfer (automatic)No 6905-NIQINMale150.65Mailed checkYes 8204-YJCLAMale7264.8Bank transfer (automatic)No 5167-ZFFMMMale190.85Credit card (automatic)Yes 6583-SZVGPMale48108.1Bank transfer (automatic)No 4895-TMWIRMale1119.95Mailed checkYes 0533-BNWKFFemale5585.45Electronic checkYes 1708-PBBOAFemale4254.75Electronic checkNo 8782-LKFPKMale4490.4Mailed checkNo 5522-JBWMOMale144Electronic checkNo 3597-MVHJTFemale2795.6Bank transfer (automatic)No 9774-NRNAUMale2784.8Bank transfer (automatic)No 0224-RLWWDFemale244.3Electronic checkNo 9967-ATRFSFemale1919.9Mailed checkNo 3951-NJCVIFemale4295.05Electronic checkNo 2977-CEBSXFemale6690.05Credit card (automatic)No 0177-PXBATMale33109.9Bank transfer (automatic)No 6599-CEBNNFemale3473.95Credit card (automatic)Yes 2519-ERQOJMale3354.6Electronic checkNo 5876-QMYLDFemale2320.05Mailed checkNo 2277-AXSDCFemale3219.75Bank transfer (automatic)No 9442-JTWDLFemale1120.05Credit card (automatic)No 0979-PHULVMale6999.45Credit card (automatic)Yes 3067-SVMTCFemale6855.9Bank transfer (automatic)No 5495-GPSRWMale2019.7Mailed checkNo 7606-BPHHNMale7219.8Credit card (automatic)No 4742-DRORAMale6095.4Bank transfer (automatic)No 0111-KLBQGMale3293.95Mailed checkNo 4800-VHZKIFemale119.9Mailed checkYes 7989-CHGTLMale119.6Mailed checkYes 0334-GDDSOMale381.35Electronic checkYes 4163-NCJAKFemale4624.45Bank transfer (automatic)No 5233-AOZUFFemale2974.95Electronic checkNo 5973-EJGDPMale5187.35Electronic checkNo 1996-DBMUSFemale4870.65Bank transfer (automatic)No 7916-VCCPBFemale1673.25Bank transfer (automatic)No 4686-GEFRMMale7098.7Bank transfer (automatic)No 5249-QYHEXFemale4024.8Mailed checkNo 0578-SKVMFFemale2283.3Electronic checkYes 5564-NEMQOFemale175.3Bank transfer (automatic)Yes 2233-FAGXVFemale524.3Mailed checkNo 5605-IYGFGFemale769.85Bank transfer (automatic)No 7663-ZTEGJMale29100.55Credit card (automatic)No 3935-TBRZZMale4425.7Mailed checkNo 8111-BKVDSFemale1040.7Bank transfer (automatic)No 2055-SIFSSFemale5551.65Bank transfer (automatic)No 2806-MLNTIMale52105.1Bank transfer (automatic)No 8734-DKSTZFemale1085.95Electronic checkNo 4360-PNRQBMale1875.6Bank transfer (automatic)No 6152-ONASVFemale6858.25Bank transfer (automatic)No 9063-ZGTUYFemale6119.4Mailed checkYes 7781-HVGMKFemale7265.2Credit card (automatic)No 2181-UAESMMale253.45Electronic checkNo 2957-LOLHOMale1245.4Bank transfer (automatic)Yes 6048-NJXHXMale4119.75Electronic checkNo 2320-SLKMBFemale2644.45Credit card (automatic)No 4980-URKXCMale3620.85Bank transfer (automatic)No 4376-KFVRSMale72114.05Credit card (automatic)No 5886-VLQVUMale3589.85Bank transfer (automatic)No 3577-AMVUXMale155.05Mailed checkNo 0771-WLCLAFemale16112.95Electronic checkNo 5628-RKIFKFemale49101.55Credit card (automatic)No 0206-TBWLCFemale54114.65Mailed checkNo 2937-FTHURFemale1864.8Electronic checkNo 1910-FMXJMFemale3680.4Electronic checkNo 7752-XUSCIFemale60105.9Electronic checkYes 4110-PFEUZFemale169.55Mailed checkYes 0732-OCQOCFemale5225.05Bank transfer (automatic)No 5168-MSWXTMale894.75Electronic checkNo 1090-ESELRMale72105.5Bank transfer (automatic)No 8592-PLTMQFemale6424.7Mailed checkNo 5760-WRAHCFemale2269.75Mailed checkNo 8847-GEOOQMale6060.2Bank transfer (automatic)No 0256-LTHVJFemale2881.05Electronic checkYes 4785-FCIFBFemale6124.4Mailed checkNo 8313-NDOIAFemale24104.15Electronic checkNo 5149-CUZUJMale2892.9Bank transfer (automatic)No 0942-KOWSMFemale3080.8Bank transfer (automatic)No 4237-CLSMMMale220Mailed checkNo 1452-VOQCHMale175.1Electronic checkNo 4719-UMSIYMale619.65Mailed checkNo 6614-VBEGUFemale2469.45Bank transfer (automatic)No 0880-TKATGMale4101.15Electronic checkYes 3811-VBYBZMale799.8Electronic checkYes 1480-BKXGAMale72116.05Bank transfer (automatic)No 2996-XAUVFMale7040.05Mailed checkNo 9076-AXYIKMale64102.1Electronic checkNo 5968-XQIVEMale7289.7Electronic checkNo 8896-RAZCRFemale4419.9Mailed checkNo 4640-UHDOSFemale1355.95Electronic checkYes 4933-IKULFFemale1720.65Mailed checkNo 3583-EKAPLMale155Electronic checkYes 1304-BCCFOMale970.05Mailed checkNo 4104-PVRPSMale2453.6Mailed checkNo 9399-APLBTFemale174.7Electronic checkYes 2359-KMGLIMale2480.25Electronic checkYes 3780-DDGSEMale3576.05Electronic checkNo 4431-EDMIQFemale775.7Electronic checkNo 0306-JAELEMale596.1Electronic checkYes 6227-HWPWXFemale1569Bank transfer (automatic)Yes 0486-LGCCHMale1119.65Mailed checkNo 0447-BEMNGFemale4845.3Bank transfer (automatic)Yes 4612-SSVHJFemale2081.45Electronic checkNo 5168-MQQCAFemale72108.5Bank transfer (automatic)No 5949-XIKAEFemale883.55Electronic checkYes 7971-HLVXIMale7284.5Credit card (automatic)No 9094-AZPHKFemale15100.15Electronic checkNo 3649-JPUGYMale7288.6Bank transfer (automatic)No 4472-LVYGIFemale052.55Bank transfer (automatic)No 8372-JUXUIMale174.35Electronic checkYes 3552-CTCYFMale63104.8Bank transfer (automatic)No 6778-YSNIHFemale259Electronic checkNo 0388-EOPEXFemale274.4Electronic checkYes 5756-OZRIOMale6164.05Bank transfer (automatic)No 6579-JPICPMale120.4Mailed checkNo 8205-OTCHBMale2243.75Bank transfer (automatic)Yes 4134-BSXLXMale2860.9Mailed checkNo 0505-SPOOWFemale7019.8Bank transfer (automatic)No 6235-VDHOMFemale528.45Electronic checkYes 7783-YKGDVFemale1299.7Bank transfer (automatic)Yes 4374-YMUSQMale34116.25Credit card (automatic)No 4513-CXYIXFemale7180.7Credit card (automatic)No 3957-HHLMRFemale7065.2Bank transfer (automatic)No 7803-XOCCZFemale5284.05Bank transfer (automatic)No 5736-YEJAXMale6979.45Credit card (automatic)No 5609-CEBIDFemale2094.1Electronic checkYes 8981-FJGLAMale1178Mailed checkNo 7218-HKQFKMale294.2Electronic checkYes 4636-QRJKYFemale680.5Electronic checkYes 1135-LMECXFemale119.85Mailed checkNo 4332-MUOEZMale2094.3Credit card (automatic)No 8535-SFUTNMale61106.45Electronic checkNo 5956-VKDTTFemale574.35Electronic checkYes 8677-HDZEEFemale56105.45Bank transfer (automatic)No 2475-MROZFMale3095Credit card (automatic)No 9412-GHEECMale40104.8Bank transfer (automatic)Yes 3482-ABPKKFemale2854.3Mailed checkNo 6705-LXORMFemale570.05Electronic checkNo 0257-ZESQCFemale2775.2Bank transfer (automatic)Yes 7531-GQHMEMale1220.05Credit card (automatic)No 5174-ITUMVMale67105.4Electronic checkNo 4109-CYRBDMale2951.6Electronic checkNo 0913-XWSCNMale5585.5Bank transfer (automatic)No 6825-UYPFKFemale2375.6Bank transfer (automatic)Yes 8397-MVTAZMale34100.05Electronic checkYes 0750-EBAIUMale5291.25Electronic checkNo 8606-CIQULMale72115.75Credit card (automatic)No 3571-DPYUHMale5894.7Credit card (automatic)No 7601-GNDYKMale3519.6Mailed checkNo 0356-OBMACFemale5699.9Bank transfer (automatic)No 8067-NIOYMFemale2421.1Credit card (automatic)No 1403-GYAFUMale7020.05Credit card (automatic)No 4234-XTNEAMale279.95Electronic checkNo 1297-VQDRPMale68107.15Credit card (automatic)No 9282-IZGQKFemale185Electronic checkYes 5348-CAGXBMale1289.55Electronic checkNo 0621-HJWXJFemale6381.55Bank transfer (automatic)No 5844-QVTATFemale3358.45Mailed checkNo 8905-IAZPFFemale6995.65Credit card (automatic)No 5394-MEITZFemale6080.6Bank transfer (automatic)No 6859-QNXIQFemale72113.1Bank transfer (automatic)No 2782-LFZVWFemale1158.95Mailed checkNo 2866-IKBTMFemale119.55Mailed checkNo 1342-JPNKIMale1086.05Bank transfer (automatic)Yes 2817-NTQDOMale1345.55Credit card (automatic)Yes 7129-AZJDEMale3478.95Bank transfer (automatic)No 6986-IJDHXMale3986.3Mailed checkYes 2560-PPCHEFemale65105.05Bank transfer (automatic)No 4676-MQUEAMale50101.9Bank transfer (automatic)No 8138-EALNDMale1519.75Mailed checkNo 3580-HYCSPMale72110.3Bank transfer (automatic)No 1352-HNSAWFemale72115.6Bank transfer (automatic)No 2075-PUEPRMale5519.35Bank transfer (automatic)No 1982-FEBTDFemale2325.6Credit card (automatic)No 5301-GAUUYMale3280.35Bank transfer (automatic)Yes 5791-KAJFDFemale5668.75Bank
Answered Same DaySep 04, 2021

Answer To: Excel Quiz Student's Name Grader's Name Number correct 1Create a Table of the data below and rename...

Sudipta answered on Sep 05 2021
133 Votes
Excel Quiz
        Student's Name
        Grader's Name
        Number correct
    1    Create a Table of the data below and rename it "AllData"
    2    Using the tables capabilities, insert a Totals row and calculate the average for MonthlyCharges
    3    0.2226336086    In the Yellow box, use a Structured Reference for the "AllData" table to calculate a correlation between Tenure and MonthlyCharges                                    HINT: Use the correlation function under the data analysis tool pak
    4    Insert a Pivot Table based upon "AllData" create a cross tab that counts "Churn" by payment method.                        Hint: Use a pivot table with churn and payment method as the fields
    5    Generate a stacked bar chart based upon the pivot table.
        customerID    gender    Tenure    Monthly Charges    Payment Method    Churn    Total monthly charges    Column1    Tenure2    Monthly Charges2
        7590-VHVEG    Female    1    29.85    Electronic check    No    29.85    Tenure    1
        5575-GNVDE    Male    34    56.95    Mailed check    No    1936.3    Monthly Charges    0.2226336086    1
        3668-QPYBK    Male    2    53.85    Mailed check    Yes    107.7
        7795-CFOCW    Male    45    42.3    Bank transfer (automatic)    No    1903.5
        9237-HQITU    Female    2    70.7    Electronic check    Yes    141.4                                Count of Churn    Column Labels
        9305-CDSKC    Female    8    99.65    Electronic check    Yes    797.2                                Row Labels    Bank transfer (automatic)    Credit card (automatic)    Electronic check    Mailed check    Grand Total
        1452-KIOVK    Male    22    89.1    Credit card (automatic)    No    1960.2                                No    391    381    352    350    1474
        6713-OKOMC    Female    10    29.75    Mailed check    No    297.5                                Yes    89    59    303    74    525
        7892-POOKP    Female    28    104.8    Electronic check    Yes    2934.4                                Grand Total    480    440    655    424    1999
        6388-TABGU    Male    62    56.15    Bank transfer (automatic)    No    3481.3
        9763-GRSKD    Male    13    49.95    Mailed check    No    649.35
        7469-LKBCI    Male    16    18.95    Credit card (automatic)    No    303.2
        8091-TTVAX    Male    58    100.35    Credit card (automatic)    No    5820.3
        0280-XJGEX    Male    49    103.7    Bank transfer (automatic)    Yes    5081.3
        5129-JLPIS    Male    25    105.5    Electronic check    No    2637.5
        3655-SNQYZ    Female    69    113.25    Credit card (automatic)    No    7814.25
        8191-XWSZG    Female    52    20.65    Mailed check    No    1073.8
        9959-WOFKT    Male    71    106.7    Bank transfer (automatic)    No    7575.7
        4190-MFLUW    Female    10    55.2    Credit card (automatic)    Yes    552
        4183-MYFRB    Female    21    90.05    Electronic check    No    1891.05
        8779-QRDMV    Male    1    39.65    Electronic check    Yes    39.65
        1680-VDCWW    Male    12    19.8    Bank transfer (automatic)    No    237.6
        1066-JKSGK    Male    1    20.15    Mailed check    Yes    20.15
        3638-WEABW    Female    58    59.9    Credit card (automatic)    No    3474.2
        6322-HRPFA    Male    49    59.6    Credit card (automatic)    No    2920.4
        6865-JZNKO    Female    30    55.3    Bank transfer (automatic)    No    1659
        6467-CHFZW    Male    47    99.35    Electronic check    Yes    4669.45
        8665-UTDHZ    Male    1    30.2    Electronic check    Yes    30.2
        5248-YGIJN    Male    72    90.25    Credit card (automatic)    No    6498
        8773-HHUOZ    Female    17    64.7    Mailed check    Yes    1099.9
        3841-NFECX    Female    71    96.35    Credit card (automatic)    No    6840.85
        4929-XIHVW    Male    2    95.5    Credit card (automatic)    No    191
        6827-IEAUQ    Female    27    66.15    Mailed check    No    1786.05
        7310-EGVHZ    Male    1    20.2    Bank transfer (automatic)    No    20.2
        3413-BMNZE    Male    1    45.25    Bank transfer (automatic)    No    45.25
        6234-RAAPL    Female    72    99.9    Bank transfer (automatic)    No    7192.8
        6047-YHPVI    Male    5    69.7    Electronic check    Yes    348.5
        6572-ADKRS    Female    46    74.8    Credit card (automatic)    No    3440.8
        5380-WJKOV    Male    34    106.35    Electronic check    Yes    3615.9
        8168-UQWWF    Female    11    97.85    Bank transfer (automatic)    Yes    1076.35
        8865-TNMNX    Male    10    49.55    Mailed check    No    495.5
        9489-DEDVP    F
emale    70    69.2    Credit card (automatic)    No    4844
        9867-JCZSP    Female    17    20.75    Mailed check    No    352.75
        4671-VJLCL    Female    63    79.85    Credit card (automatic)    No    5030.55
        4080-IIARD    Female    13    76.2    Electronic check    No    990.6
        3714-NTNFO    Female    49    84.5    Electronic check    No    4140.5
        5948-UJZLF    Male    2    49.25    Mailed check    No    98.5
        7760-OYPDY    Female    2    80.65    Electronic check    Yes    161.3
        7639-LIAYI    Male    52    79.75    Credit card (automatic)    No    4147
        2954-PIBKO    Female    69    64.15    Credit card (automatic)    No    4426.35
        8012-SOUDQ    Female    43    90.25    Electronic check    No    3880.75
        9420-LOJKX    Female    15    99.1    Credit card (automatic)    Yes    1486.5
        6575-SUVOI    Female    25    69.5    Credit card (automatic)    No    1737.5
        7495-OOKFY    Female    8    80.65    Credit card (automatic)    Yes    645.2
        4667-QONEA    Female    60    74.85    Credit card (automatic)    No    4491
        1658-BYGOY    Male    18    95.45    Electronic check    Yes    1718.1
        8769-KKTPH    Female    63    99.65    Credit card (automatic)    No    6277.95
        5067-XJQFU    Male    66    108.45    Electronic check    No    7157.7
        3957-SQXML    Female    34    24.95    Credit card (automatic)    No    848.3
        5954-BDFSG    Female    72    107.5    Credit card (automatic)    No    7740
        0434-CSFON    Female    47    100.5    Electronic check    No    4723.5
        1215-FIGMP    Male    60    89.9    Bank transfer (automatic)    No    5394
        0526-SXDJP    Male    72    42.1    Bank transfer (automatic)    No    3031.2
        0557-ASKVU    Female    18    54.4    Credit card (automatic)    No    979.2
        5698-BQJOH    Female    9    94.4    Electronic check    Yes    849.6
        5122-CYFXA    Female    3    75.3    Electronic check    No    225.9
        8627-ZYGSZ    Male    47    78.9    Electronic check    No    3708.3
        3410-YOQBQ    Female    31    79.2    Mailed check    No    2455.2
        3170-NMYVV    Female    50    20.15    Bank transfer (automatic)    No    1007.5
        7410-OIEDU    Male    10    79.85    Mailed check    No    798.5
        2273-QCKXA    Male    1    49.05    Mailed check    No    49.05
        0731-EBJQB    Female    52    20.4    Electronic check    No    1060.8
        1891-QRQSA    Male    64    111.6    Bank transfer (automatic)    No    7142.4
        8028-PNXHQ    Male    62    24.25    Bank transfer (automatic)    No    1503.5
        5630-AHZIL    Female    3    64.5    Bank transfer (automatic)    No    193.5
        2673-CXQEU    Female    56    110.5    Electronic check    No    6188
        6416-JNVRK    Female    46    55.65    Credit card (automatic)    No    2559.9
        5590-ZSKRV    Female    8    54.65    Mailed check    No    437.2
        0191-ZHSKZ    Male    30    74.75    Electronic check    No    2242.5
        3887-PBQAO    Female    45    25.9    Credit card (automatic)    No    1165.5
        5919-TMRGD    Female    1    79.35    Electronic check    Yes    79.35
        8108-UXRQN    Female    11    50.55    Electronic check    No    556.05
        9191-MYQKX    Female    7    75.15    Bank transfer (automatic)    Yes    526.05
        9919-YLNNG    Female    42    103.8    Bank transfer (automatic)    No    4359.6
        0318-ZOPWS    Female    49    20.15    Bank transfer (automatic)    No    987.35
        4445-ZJNMU    Male    9    99.3    Credit card (automatic)    No    893.7
        4808-YNLEU    Female    35    62.15    Bank transfer (automatic)    No    2175.25
        1862-QRWPE    Female    48    20.65    Bank transfer (automatic)    No    991.2
        2796-NNUFI    Female    46    19.95    Mailed check    No    917.7
        3016-KSVCP    Male    29    33.75    Mailed check    No    978.75
        4767-HZZHQ    Male    30    82.05    Bank transfer (automatic)    No    2461.5
        2424-WVHPL    Male    1    74.7    Electronic check    No    74.7
        7233-PAHHL    Male    66    84    Mailed check    No    5544
        6067-NGCEU    Female    65    111.05    Credit card (automatic)    No    7218.25
        9848-JQJTX    Male    72    100.9    Bank transfer (automatic)    No    7264.8
        8637-XJIVR    Female    12    78.95    Electronic check    Yes    947.4
        9803-FTJCG    Male    71    66.85    Credit card (automatic)    No    4746.35
        0278-YXOOG    Male    5    21.05    Mailed check    Yes    105.25
        3212-KXOCR    Male    52    21    Bank transfer (automatic)    No    1092
        4598-XLKNJ    Female    25    98.5    Electronic check    Yes    2462.5
        6380-ARCEH    Male    1    20.2    Mailed check    No    20.2
        3679-XASPY    Female    1    19.45    Electronic check    No    19.45
        7123-WQUHX    Male    38    95    Bank transfer (automatic)    No    3610
        5386-THSLQ    Female    66    45.55    Bank transfer (automatic)    No    3006.3
        3192-NQECA    Male    68    110    Bank transfer (automatic)    Yes    7480
        6180-YBIQI    Male    5    24.3    Mailed check    No    121.5
        6728-DKUCO    Female    72    104.15    Electronic check    No    7498.8
        9750-BOOHV    Female    32    30.15    Mailed check    No    964.8
        8597-CWYHH    Male    43    94.35    Mailed check    No    4057.05
        2848-YXSMW    Male    72    19.4    Credit card (automatic)    No    1396.8
        0486-HECZI    Male    55    96.75    Electronic check    Yes    5321.25
        4549-ZDQYY    Female    52    57.95    Credit card (automatic)    No    3013.4
        5712-AHQNN    Female    43    91.65    Electronic check    No    3940.95
        4846-WHAFZ    Female    37    76.5    Electronic check    Yes    2830.5
        5256-SKJGO    Female    64    54.6    Electronic check    No    3494.4
        3071-VBYPO    Male    3    89.85    Electronic check    No    269.55
        9560-BBZXK    Female    36    31.05    Bank transfer (automatic)    No    1117.8
        5299-RULOA    Female    10    100.25    Electronic check    Yes    1002.5
        8402-OOOHJ    Female    41    20.65    Mailed check    No    846.65
        9445-ZUEQE    Male    27    85.2    Credit card (automatic)    No    2300.4
        1091-SOZGA    Female    56    99.8    Credit card (automatic)    No    5588.8
        2928-HLDBA    Female    6    20.7    Mailed check    No    124.2
        0404-SWRVG    Male    3    74.4    Electronic check    Yes    223.2
        6497-TILVL    Female    7    50.7    Mailed check    No    354.9
        7219-TLZHO    Female    4    20.85    Mailed check    No    83.4
        4622-YNKIJ    Male    33    88.95    Electronic check    No    2935.35
        4412-YLTKF    Female    27    78.05    Electronic check    Yes    2107.35
        6734-PSBAW    Male    72    23.55    Bank transfer (automatic)    No    1695.6
        3930-ZGWVE    Male    1    19.75    Mailed check    No    19.75
        2639-UGMAZ    Male    71    56.45    Electronic check    No    4007.95
        2876-GZYZC    Female    13    85.95    Electronic check    No    1117.35
        6207-WIOLX    Female    25    58.6    Credit card (automatic)    Yes    1465
        8587-XYZSF    Male    67    50.55    Bank transfer (automatic)    No    3386.85
        3091-FYHKI    Male    1    35.45    Electronic check    Yes    35.45
        2372-HWUHI    Male    2    44.35    Electronic check    Yes    88.7
        7799-LGRDP    Female    43    25.7    Credit card (automatic)    No    1105.1
        7850-VWJUU    Female    23    75    Bank transfer (automatic)    No    1725
        3774-VBNXY    Female    64    20.2    Mailed check    No    1292.8
        6217-KDYWC    Male    57    19.6    Mailed check    No    1117.2
        0390-DCFDQ    Female    1    70.45    Mailed check    Yes    70.45
        3146-MSEGF    Female    72    88.05    Credit card (automatic)    No    6339.6
        4080-OGPJL    Female    8    71.15    Electronic check    Yes    569.2
        1095-WGNGG    Female    61    101.05    Bank transfer (automatic)    No    6164.05
        2636-SJDOU    Male    64    84.3    Credit card (automatic)    No    5395.2
        1131-QQZEB    Male    71    23.95    Bank transfer (automatic)    No    1700.45
        5716-EZXZN    Female    65    99.05    Credit card (automatic)    No    6438.25
        6837-BJYDQ    Male    3    19.6    Mailed check    No    58.8
        2135-RXIHG    Male    1    45.65    Electronic check    Yes    45.65
        6440-DKQGE    Male    30    64.5    Credit card (automatic)    No    1935
        3466-BYAVD    Male    15    69.5    Mailed check    No    1042.5
        3780-YVMFA    Female    8    68.55    Electronic check    No    548.4
        3874-EQOEP    Male    7    95    Mailed check    Yes    665
        1679-JRFBR    Female    70    108.15    Credit card (automatic)    No    7570.5
        9073-ZZIAY    Male    62    86.1    Electronic check    No    5338.2
        3077-RSNTJ    Female    6    19.7    Mailed check    No    118.2
        6551-GNYDG    Female    14    80.9    Bank transfer (automatic)    No    1132.6
        9167-APMXZ    Female    22    84.15    Bank transfer (automatic)    No    1851.3
        2749-CTKAJ    Male    22    20.15    Mailed check    No    443.3
        6371-NZYEG    Male    16    64.25    Mailed check    No    1028
        7554-NEWDD    Male    10    25.7    Bank transfer (automatic)    No    257
        8992-VONJD    Female    13    56    Electronic check    No    728
        0867-MKZVY    Female    20    82.4    Electronic check    Yes    1648
        4482-EWFMI    Female    2    69.7    Electronic check    No    139.4
        4648-YPBTM    Male    53    73.9    Bank transfer (automatic)    No    3916.7
        2907-ILJBN    Female    11    20.6    Mailed check    No    226.6
        6345-FZOQH    Male    69    19.9    Mailed check    No    1373.1
        3376-BMGFE    Female    4    70.9    Bank transfer (automatic)    Yes    283.6
        5997-OPVFA    Male    72    89.05    Bank transfer (automatic)    No    6411.6
        3445-HXXGF    Male    58    45.3    Electronic check    Yes    2627.4
        1159-WFSGR    Female    16    20.4    Electronic check    No    326.4
        7654-YWJUF    Male    43    84.25    Bank transfer (automatic)    No    3622.75
        1875-QIVME    Female    2    104.4    Electronic check    Yes    208.8
        6727-IOTLZ    Male    14    81.95    Mailed check    No    1147.3
        0691-JVSYA    Female    53    94.85    Bank transfer (automatic)    Yes    5027.05
        5918-VUKWP    Female    32    20.55    Bank transfer (automatic)    No    657.6
        1744-JHKYS    Female    34    24.7    Electronic check    No    839.8
        2656-FMOKZ    Female    15    74.45    Mailed check    Yes    1116.75
        2070-FNEXE    Female    7    76.45    Bank transfer (automatic)    Yes    535.15
        5947-SGKCL    Female    15    105.35    Bank transfer (automatic)    No    1580.25
        3712-PKXZA    Male    61    20.55    Credit card (automatic)    No    1253.55
        6317-YPKDH    Female    1    29.95    Bank transfer (automatic)    Yes    29.95
        6582-OIVSP    Female    1    45.3    Mailed check    No    45.3
        9367-WXLCH    Male    8    84.5    Bank transfer (automatic)    Yes    676
        5524-KHNJP    Male    33    74.75    Credit card (automatic)    No    2466.75
        1918-ZBFQJ    Female    13    79.25    Electronic check    Yes    1030.25
        1024-GUALD    Female    1    24.8    Electronic check    Yes    24.8
        4827-USJHP    Male    20    51.8    Mailed check    No    1036
        8167-GJLRN    Male    3    30.4    Electronic check    No    91.2
        0956-SYCWG    Female    13    19.65    Electronic check    No    255.45
        8017-UVSZU    Female    40    56.6    Credit card (automatic)    No    2264
        7100-FQPRV    Male    43    71.9    Credit card (automatic)    No    3091.7
        2472-OVKUP    Male    6    91    Electronic check    Yes    546
        2984-RGEYA    Female    69    19.75    Bank transfer (automatic)    No    1362.75
        9680-NIAUV    Female    72    109.7    Credit card (automatic)    No    7898.4
        2146-EGVDT    Male    59    19.3    Credit card (automatic)    No    1138.7
        2604-IJPDU    Female    20    96.55    Electronic check    No    1931
        9178-JHUVJ    Male    24    24.1    Bank transfer (automatic)    No    578.4
        6168-YBYNP    Male    59    111.35    Electronic check    No    6569.65
        7255-SSFBC    Male    72    112.25    Bank transfer (automatic)    No    8082
        3645-DEYGF    Male    1    20.75    Mailed check    No    20.75
        9323-HGFWY    Female    27    101.9    Credit card (automatic)    No    2751.3
        8544-GOQSH    Female    14    80.05    Credit card (automatic)    No    1120.7
        3363-DTIVD    Male    71    105.55    Electronic check    No    7494.05
        7018-WBJNK    Male    13    78.3    Credit card (automatic)    No    1017.9
        9142-KZXOP    Male    44    68.85    Credit card (automatic)    No    3029.4
        7674-YTAFD    Female    33    79.95    Bank transfer (automatic)    No    2638.35
        6348-SNFUS    Male    72    55.45    Credit card (automatic)    No    3992.4
        1285-OKIPP    Male    1    79.9    Electronic check    Yes    79.9
        7825-ECJRF    Female    19    106.6    Electronic check    Yes    2025.4
        1347-KTTTA    Male    64    102.45    Credit card (automatic)    No    6556.8
        7841-TZDMQ    Male    2    46    Credit card (automatic)    Yes    92
        4195-NZGTA    Female    1    25.25    Electronic check    No    25.25
        7157-SMCFK    Male    61    19.75    Mailed check    No    1204.75
        4709-LKHYG    Female    29    20    Electronic check    No    580
        2504-DSHIH    Male    23    86.8    Electronic check    No    1996.4
        0699-NDKJM    Female    57    58.75    Bank transfer (automatic)    No    3348.75
        9286-BHDQG    Male    72    45.25    Credit card (automatic)    No    3258
        0230-WEQUW    Male    66    56.6    Bank transfer (automatic)    No    3735.6
        2040-LDIWQ    Male    65    84.2    Bank transfer (automatic)    No    5473
        6496-JDSSB    Female    8    80    Bank transfer (automatic)    No    640
        9408-SSNVZ    Female    4    70.15    Electronic check    Yes    280.6
        4443-EMBNA    Female    71    24.75    Bank transfer (automatic)    No    1757.25
        6469-MRVET    Male    1    20.2    Electronic check    No    20.2
        0742-MOABM    Male    4    50.05    Mailed check    Yes    200.2
        5961-VUSRV    Female    12    19.35    Bank transfer (automatic)    No    232.2
        6778-JFCMK    Male    24    50.6    Mailed check    No    1214.4
        6341-JVQGF    Female    31    81.15    Mailed check    No    2515.65
        2232-DMLXU    Female    1    55.2    Mailed check    Yes    55.2
        4811-JBUVU    Male    30    89.9    Credit card (automatic)    No    2697
        0945-TSONX    Female    47    85.3    Credit card (automatic)    No    4009.1
        2651-ZCBXV    Male    54    108    Credit card (automatic)    No    5832
        3316-UWXUY    Male    50    93.5    Credit card (automatic)    No    4675
        8937-RDTHP    Male    1    84.6    Mailed check    Yes    84.6
        7083-MIOPC    Female    72    20.25    Credit card (automatic)    No    1458
        1984-GPTEH    Female    29    25.15    Electronic check    No    729.35
        1251-KRREG    Male    2    54.4    Mailed check    Yes    108.8
        0621-JFHOL    Female    10    29.6    Mailed check    No    296
        9903-LYSAB    Male    18    73.15    Electronic check    No    1316.7
        0094-OIFMO    Female    11    95    Electronic check    Yes    1045
        9227-UAQFT    Male    16    19.75    Mailed check    No    316
        7301-ABVAD    Female    72    86.6    Bank transfer (automatic)    No    6235.2
        6614-FHDBO    Male    72    109.2    Bank transfer (automatic)    No    7862.4
        7576-ASEJU    Female    41    74.7    Credit card (automatic)    No    3062.7
        9058-HRZSV    Female    65    94.4    Electronic check    No    6136
        4522-AKYLR    Female    13    54.8    Electronic check    No    712.4
        0221-WMXNQ    Male    4    75.35    Electronic check    No    301.4
        0303-UNCIP    Male    41    65    Mailed check    No    2665
        9947-OTFQU    Male    15    74.4    Electronic check    Yes    1116
        0322-YINQP    Male    1    48.55    Mailed check    Yes    48.55
        0959-WHOKV    Male    42    99    Electronic check    No    4158
        4075-JFPGR    Female    51    93.5    Electronic check    No    4768.5
        4629-NRXKX    Female    2    70.4    Electronic check    Yes    140.8
        9514-JDSKI    Male    1    40.2    Electronic check    Yes    40.2
        3282-ZISZV    Male    32    83.7    Credit card (automatic)    No    2678.4
        3675-YDUPJ    Male    10    19.85    Mailed check    No    198.5
        4111-BNXIF    Female    67    59.55    Electronic check    No    3989.85
        7017-VFHAY    Female    61    115.1    Credit card (automatic)    No    7021.1
        6655-LHBYW    Male    50    114.35    Credit card (automatic)    No    5717.5
        4959-JOSRX    Female    2    44.6    Credit card (automatic)    Yes    89.2
        5046-NUHWD    Female    29    45    Electronic check    No    1305
        7273-TEFQD    Male    3    41.15    Electronic check    Yes    123.45
        3606-TWKGI    Male    13    106.9    Electronic check    Yes    1389.7
        7529-ZDFXI    Male    57    89.85    Electronic check    No    5121.45
        7605-BDWDC    Female    31    49.85    Bank transfer (automatic)    No    1545.35
        1950-KSVVJ    Female    45    113.3    Mailed check    No    5098.5
        0123-CRBRT    Female    61    88.1    Mailed check    No    5374.1
        6292-TOSSS    Male    50    24.9    Bank transfer (automatic)    No    1245
        3197-ARFOY    Female    19    105    Mailed check    No    1995
        6323-AYBRX    Male    59    19.35    Mailed check    Yes    1141.65
        7014-ZZXAW    Female    71    24.25    Credit card (automatic)    No    1721.75
        4385-GZQXV    Female    16    94.45    Electronic check    Yes    1511.2
        7633-MVPUY    Male    57    59.75    Electronic check    No    3405.75
        6366-ZGQGL    Male    1    24.8    Bank transfer (automatic)    Yes    24.8
        4716-HHKQH    Male    20    107.05    Electronic check    No    2141
        5940-AHUHD    Male    1    70.6    Mailed check    Yes    70.6
        6432-TWQLB    Male    5    85.4    Electronic check    Yes    427
        4484-GLZOU    Female    52    105.05    Electronic check    Yes    5462.6
        3179-GBRWV    Male    21    64.95    Bank transfer (automatic)    No    1363.95
        8645-KWHJO    Male    14    55    Electronic check    No    770
        4130-MZLCC    Female    5    50.55    Bank transfer (automatic)    No    252.75
        0314-TKOSI    Female    6    55.15    Mailed check    No    330.9
        8229-MYEJZ    Female    10    51.2    Electronic check    No    512
        2080-SRCDE    Female    1    25.4    Mailed check    No    25.4
        9577-WJVCQ    Female    68    54.45    Mailed check    No    3702.6
        9512-UIBFX    Male    18    95.15    Mailed check    Yes    1712.7
        6202-DYYFX    Female    22    76    Credit card (automatic)    No    1672
        3808-HFKDE    Female    20    44.35    Electronic check    No    887
        5583-SXDAG    Male    1    70    Electronic check    Yes    70
        3488-PGMQJ    Male    8    74.5    Electronic check    Yes    596
        3580-REOAC    Male    10    44.85    Credit card (automatic)    Yes    448.5
        7534-BFESC    Male    24    76.1    Electronic check    Yes    1826.4
        3727-OWVYD    Male    35    61.2    Mailed check    No    2142
        2294-SALNE    Male    23    86.8    Mailed check    No    1996.4
        4847-TAJYI    Female    6    89.35    Electronic check    No    536.1
        1563-IWQEX    Female    12    19.7    Mailed check    No    236.4
        8203-XJZRC    Male    1    20.25    Mailed check    No    20.25
        6556-DBKZF    Female    71    76.05    Electronic check    No    5399.55
        6851-WEFYX    Male    35    100.8    Electronic check    No    3528
        2985-JUUBZ    Male    40    74.55    Electronic check    No    2982
        6390-DSAZX    Female    1    73.6    Mailed check    Yes    73.6
        0895-LMRSF    Male    23    64.9    Bank transfer (automatic)    No    1492.7
        8098-LLAZX    Female    4    95.45    Electronic check    Yes    381.8
        8266-VBFQL    Male    4    90.4    Electronic check    No    361.6
        8181-YHCMF    Female    68    60.3    Credit card (automatic)    No    4100.4
        2240-HSJQD    Male    38    81.85    Mailed check    No    3110.3
        1248-DYXUB    Male    52    24.8    Mailed check    No    1289.6
        0265-EDXBD    Male    32    74.9    Electronic check    Yes    2396.8
        4115-BNPJY    Male    29    75.55    Mailed check    No    2190.95
        3167-SNQPL    Male    38    101.15    Electronic check    No    3843.7
        4091-TVOCN    Male    48    78.75    Credit card (automatic)    No    3780
        1098-TDVUQ    Female    1    19.25    Bank transfer (automatic)    No    19.25
        7277-OZCGZ    Female    22    89.05    Electronic check    No    1959.1
        1557-EMYVT    Female    43    115.05    Credit card (automatic)    No    4947.15
        2799-ARNLO    Female    5    69.35    Electronic check    No    346.75
        7563-BIUPC    Male    5    80.6    Electronic check    Yes    403
        5027-YOCXN    Male    51    110.05    Credit card (automatic)    No    5612.55
        3973-SKMLN    Male    71    19.9    Credit card (automatic)    No    1412.9
        2321-OMBXY    Female    38    80.3    Credit card (automatic)    Yes    3051.4
        2840-XANRC    Male    24    93.15    Electronic check    Yes    2235.6
        6745-JEFZB    Male    35    91.5    Credit card (automatic)    No    3202.5
        5020-ZSTTY    Female    54    82.45    Bank transfer (automatic)    Yes    4452.3
        9880-TDQAC    Female    72    60    Electronic check    No    4320
        8705-WZCYL    Male    1    44.8    Electronic check    No    44.8
        7102-JJVTX    Female    9    48.6    Mailed check    No    437.4
        8626-PTQGE    Male    69    60.05    Bank transfer (automatic)    No    4143.45
        4983-CLMLV    Female    52    102.7    Credit card (automatic)    No    5340.4
        5701-YVSVF    Female    11    82.9    Electronic check    No    911.9
        5804-LEPIM    Female    2    70.35    Electronic check    Yes    140.7
        5697-GOMBF    Female    28    35.9    Electronic check    No    1005.2
        2739-CACDQ    Female    17    82.65    Credit card (automatic)    No    1405.05
        9385-EHGDO    Female    35    19.85    Mailed check    No    694.75
        9498-FIMXL    Female    8    19.2    Mailed check    No    153.6
        2379-GYFLQ    Male    46    94.9    Credit card (automatic)    No    4365.4
        0122-OAHPZ    Female    7    73.85    Electronic check    Yes    516.95
        2868-SNELZ    Female    2    80.6    Mailed check    Yes    161.2
        4322-RCYMT    Male    68    75.8    Bank transfer (automatic)    Yes    5154.4
        6680-NENYN    Female    43    104.6    Electronic check    Yes    4497.8
        2088-IEBAU    Female    68    88.15    Electronic check    No    5994.2
        7982-VCELR    Female    36    94.8    Credit card (automatic)    No    3412.8
        1343-EHPYB    Male    63    103.4    Electronic check    Yes    6514.2
        6035-BXTTY    Female    32    54.65    Bank transfer (automatic)    No    1748.8
        6885-PKOAM    Female    71    85.75    Credit card (automatic)    No    6088.25
        7520-HQWJU    Female    66    67.45    Bank transfer (automatic)    No    4451.7
        9639-BUJXT    Male    63    20.5    Mailed check    No    1291.5
        5924-SNGKP    Female    41    20.25    Credit card (automatic)    No    830.25
        0021-IKXGC    Female    1    72.1    Electronic check    No    72.1
        2034-GDRCN    Female    2    90.4    Electronic check    Yes    180.8
        8966-SNIZF    Female    70    19.45    Bank transfer (automatic)    No    1361.5
        6243-OZGFH    Female    23    44.95    Electronic check    No    1033.85
        4654-DLAMQ    Female    64    97    Bank transfer (automatic)    No    6208
        0513-RBGPE    Male    37    62.8    Credit card (automatic)    No    2323.6
        5160-UXJED    Male    17    44.6    Mailed check    No    758.2
        4115-NZRKS    Female    7    89.15    Electronic check    No    624.05
        0219-YTZUE    Male    4    84.8    Bank transfer (automatic)    Yes    339.2
        0623-IIHUG    Female    21    41.9    Electronic check    Yes    879.9
        4572-DVCGN    Female    10    80.25    Bank transfer (automatic)    Yes    802.5
        3351-NGXYI    Female    16    54.1    Electronic check    No    865.6
        8984-EYLLL    Male    64    105.25    Electronic check    No    6736
        9057-MSWCO    Male    27    30.75    Credit card (automatic)    Yes    830.25
        9833-TGFHX    Male    42    97.1    Electronic check    No    4078.2
        9294-TDIPC    Male    5    20.2    Mailed check    No    101
        5229-DTFYB    Female    41    98.8    Bank transfer (automatic)    No    4050.8
        0104-PPXDV    Male    58    50.3    Credit card (automatic)    No    2917.4
        5176-LMJXE    Female    47    20.55    Mailed check    No    965.85
        3583-KRKMD    Male    18    75.9    Bank transfer (automatic)    No    1366.2
        1010-DIAUQ    Male    5    96.5    Bank transfer (automatic)    Yes    482.5
        9069-LGEUL    Male    23    59.95    Bank transfer (automatic)    No    1378.85
        7302-ZHMHP    Female    1    19.15    Mailed check    No    19.15
        9571-EDEBV    Male    71    98.65    Credit card (automatic)    No    7004.15
        3520-FJGCV    Male    72    112.6    Credit card (automatic)    No    8107.2
        6563-VRERX    Male    33    20.6    Mailed check    No    679.8
        0259-GBZSH    Male    2    85.65    Electronic check    Yes    171.3
        6122-EFVKN    Male    24    35.75    Mailed check    No    858
        2805-EDJPQ    Female    56    99.75    Credit card (automatic)    No    5586
        6862-CQUMB    Male    37    96.1    Credit card (automatic)    No    3555.7
        7156-MXBJE    Female    43    85.1    Credit card (automatic)    No    3659.3
        6158-HDPXZ    Male    1    25.35    Mailed check    No    25.35
        9601-BRXPO    Female    25    104.95    Bank transfer (automatic)    Yes    2623.75
        2863-IMQDR    Female    61    89.65    Electronic check    No    5468.65
        5686-CMAWK    Male    17    86.75    Electronic check    No    1474.75
        5651-CRHKQ    Female    41    86.2    Bank transfer (automatic)    No    3534.2
        6905-NIQIN    Male    1    50.65    Mailed check    Yes    50.65
        8204-YJCLA    Male    72    64.8    Bank transfer (automatic)    No    4665.6
        5167-ZFFMM    Male    1    90.85    Credit card (automatic)    Yes    90.85
        6583-SZVGP    Male    48    108.1    Bank transfer (automatic)    No    5188.8
        4895-TMWIR    Male    11    19.95    Mailed check    Yes    219.45
        0533-BNWKF    Female    55    85.45    Electronic check    Yes    4699.75
        1708-PBBOA    Female    42    54.75    Electronic check    No    2299.5
        8782-LKFPK    Male    44    90.4    Mailed check    No    3977.6
        5522-JBWMO    Male    1    44    Electronic check    No    44
        3597-MVHJT    Female    27    95.6    Bank transfer (automatic)    No    2581.2
        9774-NRNAU    Male    27    84.8    Bank transfer (automatic)    No    2289.6
        0224-RLWWD    Female    2    44.3    Electronic check    No    88.6
        9967-ATRFS    Female    19    19.9    Mailed check    No    378.1
        3951-NJCVI    Female    42    95.05    Electronic check    No    3992.1
        2977-CEBSX    Female    66    90.05    Credit card (automatic)    No    5943.3
        0177-PXBAT    Male    33    109.9    Bank transfer (automatic)    No    3626.7
        6599-CEBNN    Female    34    73.95    Credit card (automatic)    Yes    2514.3
        2519-ERQOJ    Male    33    54.6    Electronic check    No    1801.8
        5876-QMYLD    Female    23    20.05    Mailed check    No    461.15
        2277-AXSDC    Female    32    19.75    Bank transfer (automatic)    No    632
        9442-JTWDL    Female    11    20.05    Credit card (automatic)    No    220.55
        0979-PHULV    Male    69    99.45    Credit card (automatic)    Yes    6862.05
        3067-SVMTC    Female    68    55.9    Bank transfer (automatic)    No    3801.2
        5495-GPSRW    Male    20    19.7    Mailed check    No    394
        7606-BPHHN    Male    72    19.8    Credit card (automatic)    No    1425.6
        4742-DRORA    Male    60    95.4    Bank transfer (automatic)    No    5724
        0111-KLBQG    Male    32    93.95    Mailed check    No    3006.4
        4800-VHZKI    Female    1    19.9    Mailed check    Yes    19.9
        7989-CHGTL    Male    1    19.6    Mailed check    Yes    19.6
        0334-GDDSO    Male    3    81.35    Electronic check    Yes    244.05
        4163-NCJAK    Female    46    24.45    Bank transfer (automatic)    No    1124.7
        5233-AOZUF    Female    29    74.95    Electronic check    No    2173.55
        5973-EJGDP    Male    51    87.35    Electronic check    No    4454.85
        1996-DBMUS    Female    48    70.65    Bank transfer (automatic)    No    3391.2
        7916-VCCPB    Female    16    73.25    Bank transfer (automatic)    No    1172
        4686-GEFRM    Male    70    98.7    Bank transfer (automatic)    No    6909
        5249-QYHEX    Female    40    24.8    Mailed check    No    992
        0578-SKVMF    Female    22    83.3    Electronic check    Yes    1832.6
        5564-NEMQO    Female    1    75.3    Bank transfer (automatic)    Yes    75.3
        2233-FAGXV    Female    5    24.3    Mailed check    No    121.5
        5605-IYGFG    Female    7    69.85    Bank transfer (automatic)    No    488.95
        7663-ZTEGJ    Male    29    100.55    Credit card (automatic)    No    2915.95
        3935-TBRZZ    Male    44    25.7    Mailed check    No    1130.8
        8111-BKVDS    Female    10    40.7    Bank transfer (automatic)    No    407
        2055-SIFSS    Female    55    51.65    Bank transfer (automatic)    No    2840.75
        2806-MLNTI    Male    52    105.1    Bank transfer (automatic)    No    5465.2
        8734-DKSTZ    Female    10    85.95    Electronic check    No    859.5
        4360-PNRQB    Male    18    75.6    Bank transfer (automatic)    No    1360.8
        6152-ONASV    Female    68    58.25    Bank transfer (automatic)    No    3961
        9063-ZGTUY    Female    61    19.4    Mailed check    Yes    1183.4
        7781-HVGMK    Female    72    65.2    Credit card (automatic)    No    4694.4
        2181-UAESM    Male    2    53.45    Electronic check    No    106.9
        2957-LOLHO    Male    12    45.4    Bank transfer (automatic)    Yes    544.8
        6048-NJXHX    Male    41    19.75    Electronic check    No    809.75
        2320-SLKMB    Female    26    44.45    Credit card (automatic)    No    1155.7
        4980-URKXC    Male    36    20.85    Bank transfer (automatic)    No    750.6
        4376-KFVRS    Male    72    114.05    Credit card (automatic)    No    8211.6
        5886-VLQVU    Male    35    89.85    Bank transfer (automatic)    No    3144.75
        3577-AMVUX    Male    1    55.05    Mailed check    No    55.05
        0771-WLCLA    Female    16    112.95    Electronic check    No    1807.2
        5628-RKIFK    Female    49    101.55    Credit card (automatic)    No    4975.95
        0206-TBWLC    Female    54    114.65    Mailed check    No    6191.1
        2937-FTHUR    Female    18    64.8    Electronic check    No    1166.4
        1910-FMXJM    Female    36    80.4    Electronic check    No    2894.4
        7752-XUSCI    Female    60    105.9    Electronic check    Yes    6354
        4110-PFEUZ    Female    1    69.55    Mailed check    Yes    69.55
        0732-OCQOC    Female    52    25.05    Bank transfer (automatic)    No    1302.6
        5168-MSWXT    Male    8    94.75    Electronic check    No    758
        1090-ESELR    Male    72    105.5    Bank transfer (automatic)    No    7596
        8592-PLTMQ    Female    64    24.7    Mailed check    No    1580.8
        5760-WRAHC    Female    22    69.75    Mailed check    No    1534.5
        8847-GEOOQ    Male    60    60.2    Bank transfer (automatic)    No    3612
        0256-LTHVJ    Female    28    81.05    Electronic check    Yes    2269.4
        4785-FCIFB    Female    61    24.4    Mailed check    No    1488.4
        8313-NDOIA    Female    24    104.15    Electronic check    No    2499.6
        5149-CUZUJ    Male    28    92.9    Bank transfer (automatic)    No    2601.2
        0942-KOWSM    Female    30    80.8    Bank transfer (automatic)    No    2424
        4237-CLSMM    Male    2    20    Mailed check    No    40
        1452-VOQCH    Male    1    75.1    Electronic check    No    75.1
        4719-UMSIY    Male    6    19.65    Mailed check    No    117.9
        6614-VBEGU    Female    24    69.45    Bank transfer (automatic)    No    1666.8
        0880-TKATG    Male    4    101.15    Electronic check    Yes    404.6
        3811-VBYBZ    Male    7    99.8    Electronic check    Yes    698.6
        1480-BKXGA    Male    72    116.05    Bank transfer (automatic)    No    8355.6
        2996-XAUVF    Male    70    40.05    Mailed check    No    2803.5
        9076-AXYIK    Male    64    102.1    Electronic check    No    6534.4
        5968-XQIVE    Male    72    89.7    Electronic check    No    6458.4
        8896-RAZCR    Female    44    19.9    Mailed check    No    875.6
        4640-UHDOS    Female    13    55.95    Electronic check    Yes    727.35
        4933-IKULF    Female    17    20.65    Mailed check    No    351.05
        3583-EKAPL    Male    1    55    Electronic check    Yes    55
        1304-BCCFO    Male    9    70.05    Mailed check    No    630.45
        4104-PVRPS    Male    24    53.6    Mailed check    No    1286.4
        9399-APLBT    Female    1    74.7    Electronic check    Yes    74.7
        2359-KMGLI    Male    24    80.25    Electronic check    Yes    1926
        3780-DDGSE    Male    35    76.05    Electronic check    No    2661.75
        4431-EDMIQ    Female    7    75.7    Electronic check    No    529.9
        0306-JAELE    Male    5    96.1    Electronic check    Yes    480.5
        6227-HWPWX    Female    15    69    Bank transfer (automatic)    Yes    1035
        0486-LGCCH    Male    11    19.65    Mailed check    No    216.15
        0447-BEMNG    Female    48    45.3    Bank transfer (automatic)    Yes    2174.4
        4612-SSVHJ    Female    20    81.45    Electronic check    No    1629
        5168-MQQCA    Female    72    108.5    Bank transfer (automatic)    No    7812
        5949-XIKAE    Female    8    83.55    Electronic check    Yes    668.4
        7971-HLVXI    Male    72    84.5    Credit card (automatic)    No    6084
        9094-AZPHK    Female    15    100.15    Electronic check    No    1502.25
        3649-JPUGY    Male    72    88.6    Bank transfer (automatic)    No    6379.2
        4472-LVYGI    Female    0    52.55    Bank transfer (automatic)    No    0
        8372-JUXUI    Male    1    74.35    Electronic check    Yes    74.35
        3552-CTCYF    Male    63    104.8    Bank transfer (automatic)    No    6602.4
        6778-YSNIH    Female    2    59    Electronic check    No    118
        0388-EOPEX    Female    2    74.4    Electronic check    Yes    148.8
        5756-OZRIO    Male    61    64.05    Bank transfer (automatic)    No    3907.05
        6579-JPICP    Male    1    20.4    Mailed check    No    20.4
        8205-OTCHB    Male    22    43.75    Bank transfer (automatic)    Yes    962.5
        4134-BSXLX    Male    28    60.9    Mailed check    No    1705.2
        0505-SPOOW    Female    70    19.8    Bank transfer (automatic)    No    1386
        6235-VDHOM    Female    5    28.45    Electronic check    Yes    142.25
        7783-YKGDV    Female    12    99.7    Bank transfer (automatic)    Yes    1196.4
        4374-YMUSQ    Male    34    116.25    Credit card (automatic)    No    3952.5
        4513-CXYIX    Female    71    80.7    Credit card (automatic)    No    5729.7
        3957-HHLMR    Female    70    65.2    Bank transfer (automatic)    No    4564
        7803-XOCCZ    Female    52    84.05    Bank transfer (automatic)    No    4370.6
        5736-YEJAX    Male    69    79.45    Credit card (automatic)    No    5482.05
        5609-CEBID    Female    20    94.1    Electronic check    Yes    1882
        8981-FJGLA    Male    11    78    Mailed check    No    858
        7218-HKQFK    Male    2    94.2    Electronic check    Yes    188.4
        4636-QRJKY    Female    6    80.5    Electronic check    Yes    483
        1135-LMECX    Female    1    19.85    Mailed check    No    19.85
        4332-MUOEZ    Male    20    94.3    Credit card (automatic)    No    1886
        8535-SFUTN    Male    61    106.45    Electronic check    No    6493.45
        5956-VKDTT    Female    5    74.35    Electronic check    Yes    371.75
        8677-HDZEE    Female    56    105.45    Bank transfer (automatic)    No    5905.2
        2475-MROZF    Male    30    95    Credit card (automatic)    No    2850
        9412-GHEEC    Male    40    104.8    Bank transfer (automatic)    Yes    4192
        3482-ABPKK    Female    28    54.3    Mailed check    No    1520.4
        6705-LXORM    Female    5    70.05    Electronic check    No    350.25
        0257-ZESQC    Female    27    75.2    Bank transfer (automatic)    Yes    2030.4
        7531-GQHME    Male    12    20.05    Credit card (automatic)    No    240.6
        5174-ITUMV    Male    67    105.4    Electronic check    No    7061.8
        4109-CYRBD    Male    29    51.6    Electronic check    No    1496.4
        0913-XWSCN    Male    55    85.5    Bank transfer (automatic)    No    4702.5
        6825-UYPFK    Female    23    75.6    Bank transfer (automatic)    Yes    1738.8
        8397-MVTAZ    Male    34    100.05    Electronic check    Yes    3401.7
        0750-EBAIU    Male    52    91.25    Electronic check    No    4745
        8606-CIQUL    Male    72    115.75    Credit card (automatic)    No    8334
        3571-DPYUH    Male    58    94.7    Credit card (automatic)    No    5492.6
        7601-GNDYK    Male    35    19.6    Mailed check    No    686
        0356-OBMAC    Female    56    99.9    Bank transfer (automatic)    No    5594.4
        8067-NIOYM    Female    24    21.1    Credit card (automatic)    No    506.4
        1403-GYAFU    Male    70    20.05    Credit card (automatic)    No    1403.5
        4234-XTNEA    Male    2    79.95    Electronic check    No    159.9
        1297-VQDRP    Male    68    107.15    Credit card (automatic)    No    7286.2
        9282-IZGQK    Female    1    85    Electronic check    Yes    85
        5348-CAGXB    Male    12    89.55    Electronic check    No    1074.6
        0621-HJWXJ    Female    63    81.55    Bank transfer (automatic)    No    5137.65
        5844-QVTAT    Female    33    58.45    Mailed check    No    1928.85
        8905-IAZPF    Female    69    95.65    Credit card (automatic)    No    6599.85
        5394-MEITZ    Female    60    80.6    Bank transfer (automatic)    No    4836
        6859-QNXIQ    Female    72    113.1    Bank transfer (automatic)    No    8143.2
        2782-LFZVW    Female    11    58.95    Mailed check    No    648.45
        2866-IKBTM    Female    1    19.55    Mailed check    No    19.55
        1342-JPNKI    Male    10    86.05    Bank transfer (automatic)    Yes    860.5
        2817-NTQDO    Male    13    45.55    Credit card (automatic)    Yes    592.15
        7129-AZJDE    Male    34    78.95    Bank transfer (automatic)    No    2684.3
        6986-IJDHX    Male    39    86.3    Mailed check    Yes    3365.7
        2560-PPCHE    Female    65    105.05    Bank transfer (automatic)    No    6828.25
        4676-MQUEA    Male    50    101.9    Bank transfer (automatic)    No    5095
        8138-EALND    Male    15    19.75    Mailed check    No    296.25
        3580-HYCSP    Male    72    110.3    Bank transfer (automatic)    No    7941.6
        1352-HNSAW    Female    72    115.6    Bank transfer (automatic)    No    8323.2
        2075-PUEPR    Male    55    19.35    Bank transfer (automatic)    No    1064.25
        1982-FEBTD    Female    23    25.6    Credit card (automatic)    No    588.8
        5301-GAUUY    Male    32    80.35    Bank transfer (automatic)    Yes    2571.2
        5791-KAJFD    Female    56    68.75    Bank transfer (automatic)    No    3850
        2654-VBVPB    Female    1    19.9    Bank transfer (automatic)    No    19.9
        1154-HYWWO    Male    38    70.6    Mailed check    No    2682.8
        2501-XWWTZ    Male    11    70.2    Electronic check    No    772.2
        3716-UVSPD    Male    1    49.3    Electronic check    No    49.3
        6815-ABQFQ    Male    56    107.25    Electronic check    No    6006
        7343-EOBEU    Male    3    23.6    Mailed check    No    70.8
        3701-SFMUH    Male    7    69.7    Credit card (automatic)    No    487.9
        6103-LIANB    Male    59    99.5    Credit card (automatic)    No    5870.5
        7319-VENRZ    Male    7    64.3    Bank transfer (automatic)    No    450.1
        5846-NEQVZ    Male    71    70.85    Credit card (automatic)    No    5030.35
        6967-QIQRV    Male    15    101.9    Electronic check    No    1528.5
        5781-RFZRP    Male    71    73.5    Credit card (automatic)    No    5218.5
        0939-YAPAF    Female    35    100.25    Electronic check    Yes    3508.75
        0308-IVGOK    Female    11    40.4    Credit card (automatic)    No    444.4
        7293-LSCDV    Female    60    19.25    Credit card (automatic)    No    1155
        7025-WCBNE    Male    47    59.6    Bank transfer (automatic)    No    2801.2
        5756-JYOJT    Female    11    64.9    Credit card (automatic)    No    713.9
        4710-FDUIZ    Male    56    100.3    Credit card (automatic)    Yes    5616.8
        6030-REHUX    Female    28    110.85    Electronic check    No    3103.8
        9548-LIGTA    Male    61    81.05    Mailed check    No    4944.05
        5150-LJNSR    Male    31    98.05    Bank transfer (automatic)    No    3039.55
        8270-RKSAP    Male    9    70.5    Electronic check    No    634.5
        6522-YRBXD    Male    35    94.55    Electronic check    No    3309.25
        2640-LYMOV    Male    2    19.65    Mailed check    No    39.3
        1218-VKFPE    Female    12    19    Mailed check    Yes    228
        3627-FHKBK    Female    1    75.3    Mailed check    Yes    75.3
        2865-TCHJW    Female    4    89.2    Electronic check    Yes    356.8
        1423-BMPBQ    Female    1    19    Mailed check    No    19
        2393-DIVAI    Female    3    20    Mailed check    No    60
        5192-EBGOV    Female    1    85.7    Electronic check    Yes    85.7
        4568-KNYWR    Male    52    63.25    Credit card (automatic)    No    3289
        8752-IMQOS    Male    5    20.1    Mailed check    No    100.5
        0742-LAFQK    Male    72    99.15    Electronic...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here