Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Construct a parallel coordinates chart for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance in the Excel file Banking Data and

Construct a parallel coordinates chart for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance in the Excel file Banking Data and construct a variable plot for all the variables in the Excel file Banking Data. What conclusions can you reach?

Age Education Income Home Value Wealth Balance
35.9 14.8 $91,033 $183,104 $220,741 $38,517
37.7 13.8 $86,748 $163,843 $223,152 $40,618
36.8 13.8 $72,245 $142,732 $176,926 $35,206
35.3 13.2 $70,639 $145,024 $166,260 $33,434
35.3 13.2 $64,879 $135,951 $148,868 $28,162
34.8 13.7 $75,591 $155,334 $188,310 $36,708
39.3 14.4 $80,615 $181,265 $201,743 $38,766
36.6 13.9 $76,507 $149,880 $189,727 $34,811
35.7 16.1 $107,935 $276,139 $211,085 $41,032
40.5 15.1 $82,557 $182,088 $220,782 $41,742
37.9 14.2 $58,294 $123,500 $132,432 $29,950
43.1 15.8 $88,041 $194,369 $267,556 $51,107
37.7 12.9 $64,597 $119,305 $186,156 $34,936
36.0 13.1 $64,894 $141,011 $160,017 $32,387
40.4 16.1 $61,091 $194,928 $113,559 $32,150
33.8 13.6 $76,771 $159,531 $197,264 $37,996
36.4 13.5 $55,609 $123,085 $105,582 $24,672
37.7 12.8 $74,091 $143,750 $217,869 $37,603
36.2 12.9 $53,713 $112,649 $117,441 $26,785
39.1 12.7 $60,262 $126,928 $161,322 $32,576
39.4 16.1 $111,548 $230,893 $331,009 $56,569
36.1 12.8 $48,600 $105,737 $106,671 $26,144
35.3 12.7 $51,419 $104,149 $111,168 $24,558
37.5 12.8 $51,182 $106,898 $88,370 $23,584
34.4 12.8 $60,753 $95,869 $143,115 $26,773
33.7 13.8 $64,601 $103,737 $134,223 $27,877
40.4 13.2 $62,164 $114,257 $144,038 $28,507
38.9 12.7 $46,607 $94,576 $114,799 $27,096
34.3 12.7 $61,446 $122,619 $161,538 $28,018
38.7 12.8 $62,024 $134,430 $149,351 $31,283
33.4 12.6 $54,986 $105,647 $126,929 $24,671
35.0 12.7 $48,182 $114,436 $102,732 $25,280
38.1 12.7 $47,388 $92,820 $118,016 $24,890
34.9 12.5 $55,273 $102,468 $126,959 $26,114
36.1 12.9 $53,892 $92,968 $129,176 $27,570
32.7 12.6 $47,923 $104,539 $88,384 $20,826
37.1 12.5 $46,176 $92,654 $101,964 $23,858
23.5 13.6 $33,088 $105,430 $44,223 $20,834
38.0 13.6 $53,890 $108,446 $95,013 $26,542
33.6 12.7 $57,390 $111,836 $134,434 $27,396
41.7 13.0 $48,439 $100,788 $124,474 $31,054
36.6 14.1 $56,803 $149,138 $101,695 $29,198
34.9 12.4 $52,392 $93,875 $133,101 $24,650
36.7 12.8 $48,631 $95,490 $105,202 $23,610
38.4 12.5 $52,500 $105,377 $139,199 $29,706
34.8 12.5 $42,401 $106,478 $94,867 $21,572
33.6 12.7 $64,792 $116,071 $185,714 $32,677
37.0 14.1 $59,842 $106,949 $135,329 $29,347
34.4 12.7 $65,625 $129,688 $175,000 $29,127
37.2 12.5 $54,044 $108,654 $140,726 $27,753
35.7 12.6 $39,707 $89,552 $80,124 $21,345
37.8 12.9 $45,286 $108,431 $91,928 $28,174
35.6 12.8 $37,784 $92,712 $60,721 $19,125
35.7 12.4 $52,284 $92,143 $146,028 $29,763
34.3 12.4 $42,944 $86,192 $98,778 $22,275
39.8 13.4 $46,036 $99,508 $98,343 $27,005
36.2 12.3 $50,357 $90,750 $126,613 $24,076
35.1 12.3 $45,521 $82,720 $105,346 $23,293
35.6 16.1 $30,418 $139,739 $24,999 $16,854
40.7 12.7 $52,500 $94,792 $147,222 $28,867
33.5 12.5 $41,795 $94,456 $91,806 $21,556
37.5 12.5 $66,667 $78,906 $143,750 $31,758
37.6 12.9 $38,596 $95,364 $54,453 $17,939
39.1 12.6 $44,286 $93,103 $110,465 $22,579
33.1 12.2 $37,287 $75,561 $86,591 $19,343
36.4 12.9 $38,184 $80,099 $76,438 $21,534
37.3 12.5 $47,119 $88,958 $102,993 $22,357
38.7 13.6 $44,520 $96,112 $93,915 $25,276
36.9 12.7 $52,838 $101,705 $75,040 $23,077
32.7 12.3 $34,688 $82,870 $93,750 $20,082
36.1 12.4 $31,770 $74,525 $47,446 $15,912
39.5 12.8 $32,994 $89,223 $50,592 $21,145
36.5 12.3 $33,891 $72,739 $81,880 $18,340
32.9 12.4 $37,813 $86,667 $69,643 $19,196
29.9 12.3 $46,528 $88,889 $96,591 $21,798
32.1 12.3 $30,319 $67,083 $34,367 $13,677
36.1 13.3 $36,492 $172,768 $24,999 $20,572
35.9 12.4 $51,818 $80,357 $135,185 $26,242
32.7 12.2 $35,625 $64,737 $76,321 $17,077
37.2 12.6 $36,789 $86,563 $69,764 $20,020
38.8 12.3 $42,750 $77,717 $95,192 $25,385
37.5 13.0 $30,412 $138,911 $24,999 $20,463
36.4 12.5 $37,083 $70,909 $95,833 $21,670
42.4 12.6 $31,563 $81,597 $71,759 $15,961
19.5 16.1 $15,395 $67,500 $24,999 $5,956
30.5 12.8 $21,433 $83,456 $24,999 $11,380
33.2 12.3 $31,250 $91,049 $52,976 $18,959
36.7 12.5 $31,344 $77,541 $36,510 $16,100
32.4 12.6 $29,733 $60,252 $27,531 $14,620
36.5 12.4 $41,607 $76,270 $98,455 $22,340
33.9 12.1 $32,813 $40,313 $79,167 $26,405
29.6 12.1 $29,375 $52,096 $24,999 $13,693
37.5 11.1 $34,896 $65,357 $81,818 $20,586
34.0 12.6 $20,578 $113,239 $24,999 $14,095
28.7 12.1 $32,574 $50,244 $49,662 $14,393
36.1 12.2 $30,589 $69,375 $48,890 $16,352
30.6 12.3 $26,565 $64,038 $42,543 $17,410
22.8 12.3 $16,590 $67,850 $24,999 $10,436
30.3 12.2 $9,354 $91,708 $24,999 $9,904
22.0 12.0 $14,115 $53,923 $24,999 $9,071
30.8 11.9 $17,992 $46,885 $24,999 $10,679
35.1 11.0 $7,741 $99,375 $24,999 $6,207

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Renaissance

Authors: Vakils

1st Edition

8184621639, 978-8184621631

More Books

Students also viewed these Accounting questions

Question

5. detail different ways to increase intrinsic motivation;

Answered: 1 week ago

Question

For what purposes are departmental reports useful to management?

Answered: 1 week ago