Your client wants you to develop a model that will help their management team to understand what factors have the biggest influence on their customers’ credit score

Your client wants you to develop a model that will help their management team to understand what factors have the biggest influence on their customers’ credit score.1. Run a correlation analysis and discuss your findings about possible relationships between the variables. What did you learn?2. Run the appropriate regression analyses. Run as many repetitions of regression analysis as neccessary until you find the regression model that you believe is the best for our client. Be sure to include a discussion of hypothesis statements, confidence level, and your findings.3. Run the stepwise analysis and interpret your findings.Capital Credit Card Data SetCoding KeyA random sample of records was drawn from a database of 10,000 credit card customersInformation was taken from several sources including the individual’s applicationand also from their credit historyEach customer record was assigned a customer record number (from 001 to 324)Total number of records selected = 324Variables Include the following:Variable Variable Description (coding key in parentheses) V1V2V3V4V5V6V7 ======= V8V9V10 === Customer Record Number (from 001 to 324)Gender of Customer (Code: 1 = Male, 2 = Female)Age of customer (Code = actual years)Customer’s Income (Code = actual amount in $)Customer’s Short-Term Debt (Code = sum of CC + other short-term debt in $)Customer’s Credit Card (CC) Balance (Code = actual amount in $)Number of Credit Card Accounts in Customer’s Name(Code = actual number of separate accounts held by customer)Number of Late Payments Last 12 mos (actual count)Total Interest and PenaltiesCustomer’s Credit Score (from previous credit check)(code = actual score from previous application) * Final Exam CC Data Set (n = 324)CaseNumberV1 001002003004005006007008009010011012013014015016017018019020021022023024025026027028029030031032033034035 Gen Age V2_Gen V3_Age 12112221122112211212111112111111122 6745693249596643266632275163345732352866592048573534713855673655323158 HHIncome TotalST Debt CCDebt # ofC Cards V4_Inc V5_ST Debt V6_CC Debt V7_# CCs $92,489$52,910$34,398$33,150$98,274$54,782$46,800$47,000$34,950$71,960$48,900$37,750$40,097$51,387$48,314$61,725$44,314$44,250$63,761$60,420$70,264$31,250$51,304$39,125$51,750$42,169$44,950$60,264$47,300$72,290$36,850$101,210$65,714$61,500$72,942 $9,086$19,466$15,085$22,376$68,449$26,258$6,148$19,455$9,389$46,753$29,398$19,044$8,558$7,454$24,326$29,086$43,326$20,670$34,898$36,625$11,323$15,385$19,465$18,228$25,545$23,907$7,747$22,323$19,805$43,062$18,080$67,622$49,428$31,600$22,435 $6,935$7,695$8,127$18,955$28,350$6,094$2,939$15,198$8,086$19,642$22,307$9,987$8,058$2,275$19,643$18,086$30,643$17,443$12,026$11,870$10,230$10,776$10,917$7,910$15,805$19,118$3,910$18,230$5,529$26,933$7,974$31,794$36,241$26,649$4,746 # ofLate PayV8_# LPs 23343323335332435333353244252136441 02278003303421405222253123242136561 Interest +Penalties CreditScore V9_Int + Pen V10_CS $88$1,297$1,536$6,193$8,529$535$203$2,420$1,678$831$4,902$4,574$761$590$2,104$669$4,104$2,606$3,488$414$841$4,314$2,165$928$2,383$1,698$164$2,841$1,927$1,817$1,316$6,566$9,296$7,371$854 820746661506435760856590630687565593710846600672480653638667789567626672651615755597739604726447521578775 Bins For Histograms MaleFemaleV31830456075 V212V 10340500550600650700750800875 V13V12D/E# LateRatio PaymentsHighMedLow 0123V11# CCs1234 12345678 036037038039040041042043044045046047048049050051052053054055056057058059060061062063064065066067068069070071072073074075 1121222222122222221121222111111222211121 42252756503551332745345626255031214564252326555530525853205668587529275523663926 $52,750$34,750$39,000$48,300$52,750$46,860$69,695$48,890$53,000$58,025$66,192$49,948$38,115$31,840$41,535$38,325$31,500$48,100$86,232$39,500$28,500$33,850$59,172$71,598$62,806$76,250$43,615$54,000$52,338$40,838$35,192$103,150$33,791$60,124$29,790$66,462$29,245$30,790$48,700$52,650 $15,748$18,178$25,600$7,053$9,748$24,343$25,273$28,247$41,643$22,806$24,280$17,193$18,098$13,383$19,203$28,138$24,651$27,886$16,161$27,600$11,888$12,805$21,444$17,449$17,505$55,863$6,978$8,640$40,227$8,534$18,280$40,185$7,706$28,125$13,785$26,232$10,715$3,326$33,066$30,076 $14,860$10,637$23,212$6,705$3,536$17,888$8,191$22,385$14,467$16,527$18,743$6,038$3,200$7,247$15,584$18,089$11,224$14,089$8,587$24,649$3,538$8,275$6,094$14,695$11,354$25,164$5,849$5,468$29,165$3,731$14,743$21,043$7,176$15,875$6,924$18,214$2,498$1,726$28,649$19,906 3343353533421246532424332423434325332164 4542151542231143320603030221627303101192 $1,988$4,985$6,265$2,207$982$3,956$921$4,260$2,264$1,569$1,820$1,386$948$817$3,171$2,732$3,540$1,686$185$5,671$397$2,857$535$1,197$969$1,990$153$351$6,260$849$7,987$5,375$307$2,958$940$719$839$247$11,805$2,431 576607462680789655787590682701602748768760680603579689835558780631704725656588758773420765490560703626657700781790430651 076077078079080081082083084085086087088089090091092093094095096097098099100101102103104105106107108109110111112113114115 1111221211112222112222112121121122211121 27192757583427345021513629203456572721435633582747445122276725725047225525303639 $54,850$24,800$32,806$66,287$55,225$43,850$51,830$69,930$43,761$32,500$58,650$59,900$47,900$28,850$42,500$44,600$46,235$50,720$30,750$98,750$57,225$52,843$43,890$34,450$41,927$51,397$49,950$24,600$62,806$33,175$36,500$38,750$54,398$85,400$37,600$52,745$32,450$64,750$63,995$38,110 $25,178$29,961$8,544$32,606$18,563$21,519$22,733$49,333$9,980$18,261$11,912$39,374$24,345$16,239$14,068$23,654$12,198$22,955$18,044$43,500$38,450$38,845$9,242$14,045$28,516$19,454$28,433$13,889$28,249$5,474$5,487$7,390$11,813$49,162$12,961$18,531$18,649$38,044$28,934$16,441 $19,637$19,095$6,905$19,691$8,341$18,821$20,990$31,646$6,477$14,236$6,184$23,551$16,977$10,246$8,445$18,957$3,081$14,677$14,187$21,242$29,301$26,165$5,748$8,565$18,725$8,275$11,493$11,313$9,486$2,794$5,184$1,186$11,813$25,164$10,095$11,153$8,687$18,987$15,449$16,441 2422232334314345234353214423212233423322 1602140526023634204565102212111137214423 $485$6,487$326$1,149$116$3,391$856$3,428$962$4,334$384$2,371$3,563$5,462$4,256$5,439$589$230$3,174$5,175$9,468$4,960$485$837$1,580$1,250$908$1,219$275$270$813$513$1,175$10,759$2,987$607$3,396$3,074$789$3,940 657450701635812605666603697577729550621563610560767758593580532562743662615746700619757811768799698501570727591510741644 116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155 2111122222111211222111122121112121211221 74593321607023265951634545335535357568592049563032456550566722336651332631697060 $34,398$54,333$48,760$29,890$52,939$35,400$24,800$36,500$54,300$61,850$58,574$39,650$48,200$47,394$57,120$55,900$56,199$33,500$35,975$102,500$25,500$63,730$45,725$44,500$47,559$48,770$66,690$55,900$73,108$39,930$28,650$39,858$35,035$63,800$44,500$38,693$63,750$34,250$33,740$60,261 $15,813$15,977$39,066$19,247$15,823$5,360$14,961$7,250$8,910$22,472$17,212$6,701$25,129$18,170$12,940$36,540$36,117$22,648$8,449$43,985$19,261$29,025$9,531$39,700$36,125$16,734$14,284$46,540$49,447$18,753$8,744$29,110$5,921$10,782$32,700$19,944$29,465$12,458$8,569$10,594 $11,981$4,607$29,649$16,385$11,331$2,373$6,095$6,918$4,304$8,333$8,623$6,681$8,974$9,820$8,316$25,044$29,645$18,960$3,449$29,553$15,236$23,618$8,450$29,876$27,875$9,013$8,341$31,044$34,308$9,853$2,665$19,772$2,003$5,234$31,876$15,685$21,792$10,235$2,817$8,452 3254214313123224641455257314322623753414 1184012213010223820542076316210711661401 $1,853$467$9,805$4,260$890$191$2,487$902$186$1,453$912$237$675$148$437$3,189$9,973$1,245$249$2,188$2,934$1,877$902$8,245$8,958$828$116$8,189$1,831$907$215$8,989$564$800$11,245$3,863$933$3,377$170$923 697808420550802809680635782729760702695754775592521608840590595612698510444724802491628691769565764725500492661640782786 156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195 1121121222221111212111221122122212222212 49675840573052603468625226675569707267613234665233426167546067253562425248544527 $52,750$42,609$58,600$45,165$59,767$37,500$46,452$65,089$66,662$32,906$50,325$52,910$62,000$53,792$58,251$38,943$31,820$40,643$39,353$49,900$60,513$38,000$44,000$56,662$47,192$61,185$54,400$39,707$54,750$87,353$72,285$34,200$47,398$81,625$64,021$82,139$57,600$105,750$48,900$61,100 $36,100$7,201$47,606$21,633$49,860$27,900$25,015$10,414$33,227$8,989$9,052$27,175$26,574$24,876$19,464$9,911$16,280$4,911$3,542$6,491$46,308$12,706$18,260$14,834$26,280$28,668$9,910$5,562$8,760$59,283$8,951$23,602$6,504$30,217$43,841$45,928$37,520$32,788$10,129$32,326 $19,441$6,003$21,466$17,666$34,850$18,143$14,141$5,070$29,165$6,986$4,070$16,050$16,851$13,917$15,012$3,586$8,692$2,586$1,653$5,521$37,236$6,395$6,565$9,772$22,743$18,907$5,304$2,730$3,392$25,800$7,738$15,236$3,410$24,107$29,369$21,374$29,089$13,068$6,693$9,761 3352342152135322231344135312342513354223 2071441142141032111254104011142212425510 $1,210$564$10,369$4,940$3,432$6,886$411$764$2,660$875$964$2,500$981$865$269$399$810$299$222$877$2,503$2,500$492$139$4,320$863$186$237$433$931$933$6,334$139$2,999$4,493$4,434$5,420$4,506$477$941 634730475597520430732761575801761620634709704809658810812788519607763743585754762791776580730561761642544555592630703684 196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235 2121212122212212112111122121121122211211 69622751514327233231672561553268672952342654245523216567496640704348326933454650 $32,720$52,338$61,650$61,775$88,588$45,275$38,445$33,175$56,940$61,398$44,748$34,750$65,750$73,850$38,500$33,523$92,135$36,662$57,000$60,513$42,950$53,610$37,850$56,499$27,900$28,500$44,774$47,875$54,740$33,861$44,800$46,800$45,278$65,787$49,900$36,750$50,843$41,562$62,400$64,515 $5,955$24,227$28,349$30,046$32,238$7,244$39,744$13,154$47,395$15,813$28,576$12,044$25,020$38,160$23,900$9,917$15,875$14,227$9,120$9,096$38,376$45,166$19,805$38,917$15,103$13,163$7,242$26,575$12,948$10,066$33,654$13,781$11,644$36,472$44,700$9,185$39,995$11,419$35,462$10,903 $3,677$18,165$14,941$18,274$28,017$2,885$27,759$12,197$24,175$9,111$13,402$8,987$6,300$28,608$12,750$3,275$8,329$14,165$4,203$7,772$28,955$41,645$11,275$28,945$8,218$11,750$3,753$14,959$2,160$6,576$27,957$7,790$8,877$29,645$28,355$1,991$32,965$4,008$23,598$6,029 1433325462241232342356461412326225723343 1322117561141421231367380321114006714321 $630$4,260$3,169$947$968$419$11,102$6,433$10,914$296$1,937$3,474$884$807$1,848$298$452$2,260$339$701$5,993$11,973$1,057$8,973$932$2,327$956$845$788$458$6,439$842$158$9,761$11,383$806$3,860$1,863$3,543$470 805603672702592764496544509793695593800618541840792603730783492510631533661604815697789665552800768491511777560730649699 236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275 1222221222222121121112221212122121212111 67605632673220503950446944706345215720243631665545455944196323743328663366364444 $45,750$48,325$68,750$59,800$42,806$48,900$33,700$63,360$62,750$58,201$41,159$34,803$59,400$33,175$59,500$49,100$28,900$58,750$24,750$32,700$64,950$48,838$37,922$43,000$48,325$74,454$56,123$46,086$29,950$79,500$37,038$34,360$62,850$39,950$43,850$48,359$66,360$58,000$51,850$52,939 $6,405$7,674$15,225$46,652$8,726$37,398$31,220$27,802$28,902$12,836$17,110$7,274$29,039$9,814$35,700$10,129$15,900$27,225$15,044$25,900$38,970$35,387$12,275$6,880$9,532$37,913$19,875$24,217$20,376$48,700$13,408$5,091$34,110$7,383$6,947$28,343$11,272$43,480$35,110$22,823 $4,173$1,573$11,477$29,385$3,239$26,307$21,776$11,715$17,077$8,990$7,600$2,451$3,527$3,049$27,776$8,849$9,750$12,477$14,987$18,143$34,750$26,085$7,576$2,808$6,889$15,957$11,753$19,321$19,955$29,776$9,750$1,016$22,772$3,764$3,358$15,165$8,681$30,168$29,772$19,331 3155464332113141433464323115464141241333 0239173100023180334456213102853151031562 $498$419$2,286$12,140$421$8,902$6,979$817$513$356$952$550$569$279$9,033$589$3,848$3,886$2,074$8,593$9,297$8,893$2,258$291$1,420$857$193$2,153$11,935$9,033$2,827$340$5,989$469$239$2,455$432$6,420$8,205$2,260 740774690502830509524655654699651810784736501690588675530501444562661776644710788612348572604793557726822578818520506647 276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315 2221212121222222122112212221112211112111 29495665453355706966656667355826456622452373223626285531225766454935392466316950 $50,850$55,735$58,750$58,900$63,790$47,900$41,460$37,693$39,761$46,950$38,300$63,550$33,055$48,950$56,300$37,450$42,806$29,480$29,750$44,720$23,433$35,750$27,690$46,640$34,000$41,850$57,035$89,800$25,750$54,633$72,650$55,035$46,119$63,833$44,745$38,750$64,750$64,750$43,755$53,670 $37,910$18,704$14,400$32,366$29,562$26,740$12,991$33,844$5,449$26,747$6,190$31,406$5,289$32,345$17,990$6,384$7,413$11,306$25,093$11,079$12,753$18,465$23,690$32,656$22,602$8,383$14,153$54,720$12,999$5,977$19,281$27,781$19,224$28,753$5,400$28,385$28,900$39,385$8,978$9,997 $29,772$9,767$11,300$18,366$16,845$19,385$9,036$26,685$2,449$22,339$2,655$15,760$2,969$19,977$13,655$1,157$4,070$10,761$18,649$4,689$8,390$8,592$18,650$14,256$11,236$3,764$9,885$43,203$11,363$2,607$7,316$19,797$7,999$18,390$1,974$26,776$7,155$26,776$1,412$8,892 3311333514211432125231315135341424262612 8330242404211411106132505114322402151401 $8,205$276$2,602$640$1,163$7,840$1,174$3,863$89$1,167$181$519$193$4,563$781$208$885$541$8,332$352$2,451$1,933$6,406$1,528$4,934$469$301$8,951$1,851$297$447$3,171$920$1,451$279$8,314$378$3,314$155$321 521788692821674520740592819540792659816595753788735686401744622644455700561726815512620807810678643642773517805547792675 316317318319320321322323324 121112212 363641457227497455 $57,000$63,759$49,500$47,999$37,400$33,600$58,970$31,850$42,745 $28,455$19,482$43,700$29,740$4,099$23,602$32,345$8,383$12,531 $16,198$14,570$33,776$22,385$1,933$10,236$15,977$3,764$9,153 336325414 226602611 $820$663$11,033$9,990$112$4,334$10,563$469$607 735718482488793610490726727 *