Spreadsheet Assignment 1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
First NameLast NameGender
Social Security Numbers
CityStateCredit Card TypeCredit Card NumberDate card was received# of transactions made (Date card was received - Oct 1, 2016)
2
JudithFisherFemale259-20-7067StamfordConnecticutjcb35823182871444694/6/20151,336
3
JaneBradleyFemale875-57-8502HuntingtonWest Virginiavisa-electron41750062583719374/6/20161,120
4
JudyLeeFemale320-45-3417FrederickMarylandbankcard56022575962191367/15/20161,540
5
JohnNguyenMale424-50-4831Fort WayneIndianaswitch63333981069984257004/21/20151,085
6
JulieJamesFemale340-65-9307MontgomeryAlabamamastercard51087520921366764/24/2015714
7
MarthaHartFemale774-02-9222WichitaKansasjcb357264878242017611/30/20151,061
8
EdwardRussellMale335-87-7170Los AngelesCaliforniachina-unionpay56022531656308035/1/2015899
9
MatthewMitchellMale322-90-2231OmahaNebraskamastercard50483729566604318/24/20161,237
10
RachelDiazFemale270-34-1807Fort WayneIndianadiners-club-us-ca55348488409783461/3/2016594
11
NormaLongFemale844-90-8070TylerTexaschina-unionpay56022335440357646577/12/20161,463
12
LouiseArmstrongFemale982-18-3849RoanokeVirginiajcb35280623172931889/7/20152,104
13
JaneHansenFemale983-29-3059El PasoTexassolo67677113695176141185/8/20161,096
14
AnthonyPerryMale649-79-9037MeridianMississippijcb35374573358700347/28/20151,347
15
RubyLynchFemale708-48-7724Santa RosaCaliforniajcb356263287274882110/15/2015545
16
GaryYoungMale102-00-9473MonroeLouisianajcb35535893132576749/23/20151,587
17
DianaStanleyFemale396-77-0123El PasoTexasjcb35384321522551218/21/20152,322
18
AaronLawrenceMale843-00-2557Little RockArkansasjcb352804933342043211/5/20152,155
19
EvelynWoodsFemale433-81-5309HoustonTexasjcb35896270866186784/27/20151,822
20
MatthewGonzalezMale506-18-9722AshevilleNorth Carolinajcb35316037101620281/2/20151,030
21
CarolynSanchezFemale497-05-8356BradentonFloridamaestro6762075138201936139/5/2015814
22
KennethRamosMale464-14-8894ChicagoIllinoisdiners-club-enroute2015600588489799/23/20161,331
23
RichardGeorgeMale811-97-7357FullertonCaliforniajcb35469359775460114/1/2016579
24
LouisPalmerMale400-91-1003Fort WorthTexasjcb35447479572766973/15/20151,632
25
AmyPetersonFemale232-36-1383LubbockTexasjcb35761156645521184/2/20152,373
26
RogerAlvarezMale754-61-7384Washington
District of Columbia
visa-electron41750091223262513/26/20162,193
27
LauraDunnFemale709-58-1700DallasTexasmaestro67633285701096596197/28/2016759
28
JanetWestFemale825-39-8412MaconGeorgiajcb35669821719676485/22/20151,465
29
WalterBryantMale890-34-8428PensacolaFloridajcb35512362311681696/30/20161,620
30
MarthaRamirezFemale763-88-0681FairbanksAlaskajcb35725081777744494/10/20161,440
31
HowardHartMale836-57-3853ProvoUtahmaestro589371852462724267/20/2016813
32
JoanAndersonFemale834-07-8553MadisonWisconsinmastercard53706517796470573/23/2015515
33
AntonioHarrisMale386-11-1396MilwaukeeWisconsinchina-unionpay56022257651247734410/6/20141,897
34
SandraBishopFemale926-60-5336AuroraColoradomaestro6049169187140958/9/20152,385
35
GregoryBurkeMale183-70-7125RochesterNew Yorkbankcard56022145076674572/3/20162,136
36
AndrewSanchezMale245-29-5537MariettaGeorgiajcb3.52885E+151/10/20151,910
37
RoseGreenFemale433-13-3726MilwaukeeWisconsinamericanexpress3723011120065338/19/20151,966
38
ChristineStevensFemale109-00-5896BuffaloNew Yorkchina-unionpay560222400535460794411/13/20141,812
39
ChrisSanchezMale783-03-9979HuntsvilleTexasjcb35878619195218239/14/20161,323
40
CraigJamesMale272-86-3824AtlantaGeorgiajcb35351288543712728/21/20151,071
41
AnniePriceFemale114-18-9497YonkersNew Yorkvisa-electron45085109347539867/31/2016706
42
GaryBaileyMale555-73-9372Santa MonicaCaliforniajcb35729291161861339/18/20151,049
43
GloriaNguyenFemale556-36-4397NorcrossGeorgiadiners-club-us-ca55206563708784484/27/2016822
44
JessicaWatkinsFemale133-66-4462RichmondVirginiabankcard56022174443853318/7/2016720
45
MildredMasonFemale428-87-8747ClevelandOhiojcb355262317625662111/30/20152,457
46
RuthStewartFemale277-22-9744Fort WorthTexasjcb35387582995706382/7/20152,573
47
JeremyWheelerMale121-81-1720HuntsvilleAlabamachina-unionpay56022348480265433388/17/2015994
48
SeanRileyMale386-19-9815CincinnatiOhiodiners-club-carte-blanche302946605901786/6/20151,514
49
LarryMurphyMale905-36-9668JamaicaNew Yorkdiners-club-enroute2014091049237196/21/2015976
50
RalphMooreMale990-55-4186San JoseCaliforniajcb35458465721378858/29/20152,200
51
JuliaClarkFemale509-22-1132TulsaOklahomajcb3.58211E+151/21/20161,049
52
TerryGeorgeMale362-27-8943PhoenixArizonamastercard500235350563949212/15/20151,848
53
JaneRoseFemale148-61-3390FayettevilleNorth Carolinavisa-electron48447754660072178/15/20152,533
54
JerryGordonMale892-75-9426Fort WorthTexasjcb35602667343806972/17/20162,328
55
ChristopherRichardsonMale210-35-0644WichitaKansasvisa-electron49170430684111761/31/2015777
56
LarryBaileyMale888-04-1940TopekaKansasjcb358749590962650612/11/20141,076
57
LisaOliverFemale830-86-9645White PlainsNew Yorkbankcard56108607692817081/15/20151,225
58
JuanWeaverMale430-23-2070Fort WayneIndianaamericanexpress3499069523287618/11/20161,955
59
RaymondJohnstonMale547-05-6097ViennaVirginiasolo676793863879351675012/6/20141,318
60
DorisPayneFemale629-80-6601AustinTexaslaser677148791329193458212/2/2015684
61
CraigAlvarezMale791-93-5920
Colorado Springs
Coloradolaser63044659530762831/10/2015729
62
KatherineGibsonFemale687-08-4116ArlingtonVirginiaswitch49059873217814989310/31/20152,274
63
JulieStephensFemale965-53-2383Washington
District of Columbia
jcb358123572815061910/29/2014899
64
ClarenceEvansMale782-62-9701WilmingtonDelawarejcb35590364949886972/10/20162,432
65
RichardHayesMale722-17-5885AlhambraCaliforniadiners-club-carte-blanche301872074611869/17/20151,621
66
LouisHillMale242-38-3633Oklahoma CityOklahomamaestro67636547128896705314/21/2016895
67
RonaldRichardsMale547-41-7547ClevelandOhiodiners-club-carte-blanche303982365058817/30/20162,486
68
SusanWellsFemale617-36-0629OrangeCaliforniavisa40413723601988/30/20151,948
69
JenniferRamirezFemale978-35-5364BethlehemPennsylvaniajcb35705699410213529/2/20161,414
70
RobertPerkinsMale388-82-4628EriePennsylvaniajcb35764725705742011/27/2015701
71
RandyPerkinsMale828-33-7517PuebloColoradoamericanexpress3742834586900051/13/20151,617
72
AnnieEdwardsFemale908-42-7373Saint PetersburgFloridajcb35318762628679845/2/2016743
73
AaronMyersMale512-43-2711CincinnatiOhiojcb35338162792417715/16/20162,531
74
NicholasPhillipsMale843-62-6317ChicagoIllinoismastercard510875937528486712/16/20141,219
75
KathySpencerFemale713-01-0489EvansvilleIndianamaestro6761411099789067393/20/20151,277
76
KarenKelleyFemale669-88-4176MontpelierVermontjcb3559875244682456/25/20161,175
77
HaroldArnoldMale354-30-2660Jersey CityNew Jerseybankcard56022577012029939/23/20161,374
78
AdamJamesMale272-77-5210Fort MyersFloridajcb35712750254577645/31/20151,912
79
KathrynCarrollFemale239-34-6660MuncieIndianajcb35629363637236437/26/20162,423
80
RubyNelsonFemale707-91-7203PuebloColoradomastercard51001443322281668/9/20161,714
81
WilliamFernandezMale571-17-6091DenverColoradojcb35411063590339799/13/20152,479
82
LouisCampbellMale346-63-6762Las CrucesNew Mexicodiners-club-enroute2015876923837096/29/20162,042
83
KathyHuntFemale710-53-7813RoanokeVirginiavisa-electron49138815944753958/20/2015831
84
KathyMendozaFemale675-94-6838MiamiFloridachina-unionpay56022475565734084/4/2015712
85
JanetStewartFemale617-55-2154LouisvilleKentuckyjcb353099300165032312/10/20142,027
86
JohnnyThomasMale946-51-6976Los AngelesCaliforniajcb35432308949943924/17/20151,853
87
LoisTorresFemale233-21-8696KnoxvilleTennesseemaestro0604572757184267525/2/20161,468
88
AlanGardnerMale608-07-4416NorthridgeCaliforniadiners-club-carte-blanche303355643378834/13/2015889
89
IreneFernandezFemale490-93-0203New CastlePennsylvaniamastercard527182881952758612/3/20151,351
90
JeanGeorgeFemale569-24-9025Washington
District of Columbia
jcb352874669002892811/27/2015870
91
MarkStephensMale716-74-4802AmarilloTexasjcb35333465501256267/26/20151,497
92
DanielFisherMale538-34-3202Virginia BeachVirginiajcb35325380475672765/1/2016537
93
RoseCooperFemale721-88-3256New HavenConnecticutjcb35825242730023697/23/20151,149
94
JesseSullivanMale781-10-3173RacineWisconsinjcb35895021081633513/8/20151,538
95
NancyLynchFemale865-20-6499Kansas CityMissourijcb358758568399302110/28/20141,654
96
PeterGreeneMale581-69-9073Daytona BeachFloridajcb355738471404089510/14/2015910
97
JerryRobinsonMale687-51-0977HartfordConnecticutmaestro675985675954864867/20/2015764
98
KarenJacobsFemale493-98-3103KnoxvilleTennesseemastercard537774073269007312/8/20142,343
99
DonaldLewisMale709-26-8962Washington
District of Columbia
laser6706703813571670745/13/20161,530
100
AlbertMorganMale678-34-3038San DiegoCaliforniamastercard51001435209281324/13/20162,356
Loading...
 
 
 
Raw Data
Manipulated Data
Summary