Answered You can hire a professional tutor to get the answer.

QUESTION

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

  1. 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. 
  1. Finally, provide conclusions and present your recommendations to your client.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question