Answered You can hire a professional tutor to get the answer.
Can you please help me with this analysis Gen Age HH Total CC # of # of Interest + Credit Income ST Debt Debt C Cards Late Pay Penalties Score V2_Gen...
Can you please help me with this analysis
GenAgeHH TotalCC # of# ofInterest +Credit
IncomeST DebtDebtC CardsLate PayPenaltiesScore
V2_GenV3_AgeV4_IncV5_ST DebtV6_CC DebtV7_# CCsV8_# LPsV9_Int + PenV10_CS
167$92,489$9,086$6,93520$88820
245$52,910$19,466$7,69532$1,297746
169$34,398$15,085$8,12732$1,536661
132$33,150$22,376$18,95547$6,193506
249$98,274$68,449$28,35038$8,529435
259$54,782$26,258$6,09430$535760
266$46,800$6,148$2,93920$203856
143$47,000$19,455$15,19833$2,420590
126$34,950$9,389$8,08633$1,678630
266$71,960$46,753$19,64230$831687
232$48,900$29,398$22,30753$4,902565
127$37,750$19,044$9,98734$4,574593
151$40,097$8,558$8,05832$761710
263$51,387$7,454$2,27521$590846
234$48,314$24,326$19,64344$2,104600
157$61,725$29,086$18,08630$669672
132$44,314$43,326$30,64355$4,104480
235$44,250$20,670$17,44332$2,606653
128$63,761$34,898$12,02632$3,488638
266$60,420$36,625$11,87032$414667
159$70,264$11,323$10,23032$841789
120$31,250$15,385$10,77655$4,314567
148$51,304$19,465$10,91733$2,165626
157$39,125$18,228$7,91021$928672
135$51,750$25,545$15,80542$2,383651
234$42,169$23,907$19,11843$1,698615
171$44,950$7,747$3,91022$164755
138$60,264$22,323$18,23054$2,841597
155$47,300$19,805$5,52922$1,927739
167$72,290$43,062$26,93311$1,817604
136$36,850$18,080$7,97433$1,316726
155$101,210$67,622$31,79466$6,566447
132$65,714$49,428$36,24145$9,296521
231$61,500$31,600$26,64946$7,371578
258$72,942$22,435$4,74611$854775
142$52,750$15,748$14,86034$1,988576
125$34,750$18,178$10,63735$4,985607
227$39,000$25,600$23,21244$6,265462
156$48,300$7,053$6,70532$2,207680
250$52,750$9,748$3,53631$982789
235$46,860$24,343$17,88855$3,956655
251$69,695$25,273$8,19131$921787
233$48,890$28,247$22,38555$4,260590
227$53,000$41,643$14,46734$2,264682
245$58,025$22,806$16,52732$1,569701
134$66,192$24,280$18,74342$1,820602
256$49,948$17,193$6,03823$1,386748
226$38,115$18,098$3,20011$948768
225$31,840$13,383$7,24721$817760
250$41,535$19,203$15,58444$3,171680
231$38,325$28,138$18,08963$2,732603
221$31,500$24,651$11,22453$3,540579
245$48,100$27,886$14,08932$1,686689
164$86,232$16,161$8,58720$185835
125$39,500$27,600$24,64946$5,671558
223$28,500$11,888$3,53820$397780
126$33,850$12,805$8,27543$2,857631
255$59,172$21,444$6,09430$535704
255$71,598$17,449$14,69533$1,197725
230$62,806$17,505$11,35420$969656
158$43,615$6,978$5,84922$153758
153$54,000$8,640$5,46831$351773
120$52,338$40,227$29,16546$6,260420
156$40,838$8,534$3,73132$849765
168$35,192$18,280$14,74347$7,987490
258$103,150$40,185$21,04333$5,375560
275$33,791$7,706$7,17620$307703
229$60,124$28,125$15,87553$2,958626
227$29,790$13,785$6,92431$940657
155$66,462$26,232$18,21430$719700
123$29,245$10,715$2,49821$839781
166$30,790$3,326$1,72611$247790
239$48,700$33,066$28,64969$11,805430
126$52,650$30,076$19,90642$2,431651
127$54,850$25,178$19,63721$485657
119$24,800$29,961$19,09546$6,487450
127$32,806$8,544$6,90520$326701
157$66,287$32,606$19,69122$1,149635
258$55,225$18,563$8,34121$116812
234$43,850$21,519$18,82134$3,391605
127$51,830$22,733$20,99020$856666
234$69,930$49,333$31,64635$3,428603
150$43,761$9,980$6,47732$962697
121$32,500$18,261$14,23646$4,334577
151$58,650$11,912$6,18430$384729
136$59,900$39,374$23,55112$2,371550
229$47,900$24,345$16,97743$3,563621
220$28,850$16,239$10,24636$5,462563
234$42,500$14,068$8,44543$4,256610
256$44,600$23,654$18,95754$5,439560
157$46,235$12,198$3,08122$589767
127$50,720$22,955$14,67730$230758
221$30,750$18,044$14,18744$3,174593
243$98,750$43,500$21,24235$5,175580
256$57,225$38,450$29,30156$9,468532
233$52,843$38,845$26,16535$4,960562
158$43,890$9,242$5,74821$485743
127$34,450$14,045$8,56510$837662
247$41,927$28,516$18,72542$1,580615
144$51,397$19,454$8,27542$1,250746
251$49,950$28,433$11,49321$908700
122$24,600$13,889$11,31332$1,219619
127$62,806$28,249$9,48621$275757
267$33,175$5,474$2,79411$270811
125$36,500$5,487$5,18421$813768
172$38,750$7,390$1,18621$513799
250$54,398$11,813$11,81333$1,175698
247$85,400$49,162$25,16437$10,759501
222$37,600$12,961$10,09542$2,987570
155$52,745$18,531$11,15321$607727
125$32,450$18,649$8,68734$3,396591
130$64,750$38,044$18,98734$3,074510
236$63,995$28,934$15,44922$789741
139$38,110$16,441$16,44123$3,940644
274$34,398$15,813$11,98131$1,853697
159$54,333$15,977$4,60721$467808
133$48,760$39,066$29,64958$9,805420
121$29,890$19,247$16,38544$4,260550
160$52,939$15,823$11,33120$890802
270$35,400$5,360$2,37311$191809
223$24,800$14,961$6,09542$2,487680
226$36,500$7,250$6,91832$902635
259$54,300$8,910$4,30411$186782
251$61,850$22,472$8,33333$1,453729
163$58,574$17,212$8,62310$912760
145$39,650$6,701$6,68121$237702
145$48,200$25,129$8,97430$675695
233$47,394$18,170$9,82022$148754
155$57,120$12,940$8,31622$437775
135$55,900$36,540$25,04443$3,189592
235$56,199$36,117$29,64568$9,973521
275$33,500$22,648$18,96042$1,245608
268$35,975$8,449$3,44910$249840
159$102,500$43,985$29,55345$2,188590
120$25,500$19,261$15,23654$2,934595
149$63,730$29,025$23,61852$1,877612
156$45,725$9,531$8,45020$902698
230$44,500$39,700$29,87657$8,245510
232$47,559$36,125$27,87576$8,958444
145$48,770$16,734$9,01333$828724
265$66,690$14,284$8,34111$116802
150$55,900$46,540$31,04446$8,189491
156$73,108$49,447$34,30832$1,831628
167$39,930$18,753$9,85321$907691
222$28,650$8,744$2,66520$215769
133$39,858$29,110$19,77267$8,989565
266$35,035$5,921$2,00321$564764
151$63,800$10,782$5,23431$800725
233$44,500$32,700$31,87676$11,245500
126$38,693$19,944$15,68556$3,863492
131$63,750$29,465$21,79231$933661
269$34,250$12,458$10,23544$3,377640
270$33,740$8,569$2,81710$170782
160$60,261$10,594$8,45241$923786
149$52,750$36,100$19,44132$1,210634
167$42,609$7,201$6,00330$564730
258$58,600$47,606$21,46657$10,369475
140$45,165$21,633$17,66621$4,940597
157$59,767$49,860$34,85034$3,432520
230$37,500$27,900$18,14344$6,886430
152$46,452$25,015$14,14121$411732
260$65,089$10,414$5,07011$764761
234$66,662$33,227$29,16554$2,660575
268$32,906$8,989$6,98622$875801
262$50,325$9,052$4,07011$964761
252$52,910$27,175$16,05034$2,500620
126$62,000$26,574$16,85151$981634
167$53,792$24,876$13,91730$865709
155$58,251$19,464$15,01223$269704
169$38,943$9,911$3,58622$399809
270$31,820$16,280$8,69221$810658
172$40,643$4,911$2,58631$299810
267$39,353$3,542$1,65311$222812
161$49,900$6,491$5,52132$877788
132$60,513$46,308$37,23645$2,503519
134$38,000$12,706$6,39544$2,500607
266$44,000$18,260$6,56511$492763
252$56,662$14,834$9,77230$139743
133$47,192$26,280$22,74354$4,320585
142$61,185$28,668$18,90730$863754
261$54,400$9,910$5,30411$186762
267$39,707$5,562$2,73021$237791
154$54,750$8,760$3,39231$433776
267$72,285$8,951$7,73822$933730
225$34,200$23,602$15,23652$6,334561
135$47,398$6,504$3,41011$139761
262$81,625$30,217$24,10732$2,999642
242$64,021$43,841$29,36934$4,493544
252$82,139$45,928$21,37452$4,434555
248$57,600$37,520$29,08945$5,420592
145$48,900$10,129$6,69321$477703
227$61,100$32,326$9,76130$941684
269$32,720$5,955$3,67711$630805
162$52,338$24,227$18,16543$4,260603
227$61,650$28,349$14,94132$3,169672
151$61,775$30,046$18,27432$947702
251$88,588$32,238$28,01731$968592
143$45,275$7,244$2,88521$419764
227$38,445$39,744$27,75957$11,102496
123$33,175$13,154$12,19745$6,433544
232$56,940$47,395$24,17566$10,914509
231$61,398$15,813$9,11121$296793
267$44,748$28,576$13,40221$1,937695
125$34,750$12,044$8,98744$3,474593
261$65,750$25,020$6,30011$884800
255$73,850$38,160$28,60824$807618
132$38,500$23,900$12,75032$1,848541
268$33,523$9,917$3,27521$298840
167$92,135$15,875$8,32932$452792
129$36,662$14,227$14,16543$2,260603
252$57,000$9,120$4,20321$339730
134$60,513$9,096$7,77233$701783
126$42,950$38,376$28,95556$5,993492
154$53,610$45,166$41,64567$11,973510
124$37,850$19,805$11,27543$1,057631
255$56,499$38,917$28,94568$8,973533
223$27,900$15,103$8,21810$932661
121$28,500$13,163$11,75043$2,327604
265$44,774$7,242$3,75312$956815
167$47,875$26,575$14,95921$845697
149$54,740$12,948$2,16031$788789
266$33,861$10,066$6,57621$458665
140$44,800$33,654$27,95764$6,439552
170$46,800$13,781$7,79020$842800
243$45,278$11,644$8,87720$158768
232$49,900$44,700$28,35577$11,383511
169$36,750$9,185$1,99121$806777
133$50,843$39,995$32,96534$3,860560
245$41,562$11,419$4,00833$1,863730
146$62,400$35,462$23,59842$3,543649
150$64,515$10,903$6,02931$470699
167$45,750$6,405$4,17330$498740
260$48,325$7,674$1,57312$419774
256$68,750$15,225$11,47753$2,286690
232$59,800$46,652$29,38559$12,140502
267$42,806$8,726$3,23941$421830
232$48,900$37,398$26,30767$8,902509
120$33,700$31,220$21,77643$6,979524
250$63,360$27,802$11,71531$817655
239$62,750$28,902$17,07730$513654
250$58,201$12,836$8,99020$356699
244$41,159$17,110$7,60010$952651
269$34,803$7,274$2,45112$550810
244$59,400$29,039$3,52733$569784
170$33,175$9,814$3,04911$279736
263$59,500$35,700$27,77648$9,033501
145$49,100$10,129$8,84910$589690
121$28,900$15,900$9,75043$3,848588
257$58,750$27,225$12,47733$3,886675
120$24,750$15,044$14,98734$2,074530
124$32,700$25,900$18,14344$8,593501
136$64,950$38,970$34,75065$9,297444
231$48,838$35,387$26,08546$8,893562
266$37,922$12,275$7,57632$2,258661
255$43,000$6,880$2,80821$291776
145$48,325$9,532$6,88933$1,420644
245$74,454$37,913$15,95711$857710
159$56,123$19,875$11,75310$193788
244$46,086$24,217$19,32152$2,153612
119$29,950$20,376$19,95548$11,935348
263$79,500$48,700$29,77665$9,033572
223$37,038$13,408$9,75043$2,827604
174$34,360$5,091$1,01611$340793
233$62,850$34,110$22,77245$5,989557
128$39,950$7,383$3,76411$469726
266$43,850$6,947$3,35820$239822
133$48,359$28,343$15,16543$2,455578
266$66,360$11,272$8,68111$432818
136$58,000$43,480$30,16835$6,420520
144$51,850$35,110$29,77236$8,205506
144$52,939$22,823$19,33132$2,260647
229$50,850$37,910$29,77238$8,205521
249$55,735$18,704$9,76733$276788
256$58,750$14,400$11,30013$2,602692
165$58,900$32,366$18,36610$640821
245$63,790$29,562$16,84532$1,163674
133$47,900$26,740$19,38534$7,840520
255$41,460$12,991$9,03632$1,174740
170$37,693$33,844$26,68554$3,863592
269$39,761$5,449$2,44910$89819
166$46,950$26,747$22,33944$1,167540
265$38,300$6,190$2,65522$181792
266$63,550$31,406$15,76011$519659
267$33,055$5,289$2,96911$193816
235$48,950$32,345$19,97744$4,563595
258$56,300$17,990$13,65531$781753
226$37,450$6,384$1,15721$208788
145$42,806$7,413$4,07011$885735
266$29,480$11,306$10,76120$541686
222$29,750$25,093$18,64956$8,332401
145$44,720$11,079$4,68921$352744
123$23,433$12,753$8,39033$2,451622
273$35,750$18,465$8,59212$1,933644
222$27,690$23,690$18,65035$6,406455
136$46,640$32,656$14,25610$1,528700
226$34,000$22,602$11,23655$4,934561
228$41,850$8,383$3,76411$469726
255$57,035$14,153$9,88531$301815
131$89,800$54,720$43,20354$8,951512
122$25,750$12,999$11,36333$1,851620
157$54,633$5,977$2,60742$297807
266$72,650$19,281$7,31612$447810
245$55,035$27,781$19,79744$3,171678
149$46,119$19,224$7,99920$920643
135$63,833$28,753$18,39042$1,451642
139$44,745$5,400$1,97421$279773
124$38,750$28,385$26,77665$8,314517
266$64,750$28,900$7,15521$378805
131$64,750$39,385$26,77664$3,314547
169$43,755$8,978$1,41210$155792
150$53,670$9,997$8,89221$321675
136$57,000$28,455$16,19832$820735
236$63,759$19,482$14,57032$663718
141$49,500$43,700$33,77666$11,033482
145$47,999$29,740$22,38536$9,990488
172$37,400$4,099$1,93320$112793
227$33,600$23,602$10,23652$4,334610
249$58,970$32,345$15,97746$10,563490
174$31,850$8,383$3,76411$469726
255$42,745$12,531$9,15341$607727
- Run a complete correlation analysis and discuss your findings about possible relationships between the variables (especially the IVs with the DV). What did you learn?
- Run the appropriate regression analyses. Run as many repetitions of regression analysis as necessary 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.Note: If you wish to "exclude" the data for 1 or more variables in your regression analysis, you will need to copy the data in a new worksheet and delete the columns containing the variables you do not want to include in your regression model. Be sure to position the Dependent Variable as the last variable (column) in the worksheet.
- Finally, provide conclusions and present your recommendations to your client.
