Hi, I was wondering if you could help me explain and break down how to solve thi
ID: 3438625 • Letter: H
Question
Hi, I was wondering if you could help me explain and break down how to solve this for me. ThanksRecode the data into a new data set (on a different worksheet), making four transformations:
change Gender to list "Male" or "Female";
change Children to list "No children" or "At least one child";
change Salary to be categorical with categories "Less than $40K" , "Between $40K and $70K" , "Between $70K and $100K", and "Greater than $100K" (where you can treat the breakpoints however you like); This is a question that includes encoding and needs to be solved on an excel database
Explanation / Answer
Following table shows the sorted data according to salary from (smallest to largest):
And following is the frequency distribution of the data according to given class:
Age Gender State Children Salary Opinion Young Female New York At least one child $20,687 5 Middle-aged Male Florida At least one child $20,735 3 Young Female Illinois At least one child $23,109 1 Young Female Ohio At least one child $23,657 5 Young Female Arizona At least one child $26,600 4 Young Female Ohio At least one child $28,124 2 Young Male Minnesota At least one child $30,020 3 Young Female Minnesota At least one child $31,314 5 Elderly Female Texas No Children $34,199 2 Young Female Ohio No Children $35,629 2 Young Female California No Children $36,025 4 Young Female Michigan At least one child $36,564 4 Young Male Virginia At least one child $36,607 3 Young Female Texas At least one child $36,749 4 Young Female Virginia No Children $36,973 5 Young Female New York No Children $37,255 2 Elderly Female Texas No Children $37,289 2 Young Male Arizona No Children $37,929 5 Young Female California At least one child $37,963 1 Young Female Virginia At least one child $38,097 5 Young Male Arizona At least one child $38,114 5 Middle-aged Male Illinois No Children $38,235 5 Young Female Virginia At least one child $38,258 3 Young Female Florida At least one child $38,514 1 Middle-aged Female Michigan No Children $39,086 2 Young Female Arizona At least one child $39,665 1 Young Female Ohio At least one child $39,733 3 Young Male Illinois At least one child $40,741 2 Young Male Arizona At least one child $40,883 2 Young Female Arizona No Children $41,126 4 Young Female Ohio At least one child $41,734 3 Young Male Minnesota At least one child $41,774 3 Young Male California No Children $41,967 1 Young Female Florida At least one child $41,978 1 Young Male Arizona At least one child $42,300 2 Young Male Arizona No Children $43,045 5 Young Female Arizona At least one child $43,267 5 Young Female Michigan At least one child $43,604 4 Middle-aged Male New York At least one child $43,644 3 Young Male Arizona No Children $43,773 4 Middle-aged Female Michigan At least one child $43,824 5 Young Male Minnesota At least one child $43,918 5 Young Male Virginia At least one child $44,006 1 Young Female Virginia At least one child $44,107 2 Elderly Male New York No Children $44,155 2 Young Female California At least one child $44,176 2 Young Female Ohio At least one child $44,511 4 Young Male Virginia At least one child $44,628 3 Young Male New York At least one child $44,964 1 Young Female New York At least one child $45,022 5 Young Male Arizona At least one child $45,424 2 Elderly Male New York At least one child $45,483 2 Middle-aged Female Virginia No Children $45,516 3 Young Female New York At least one child $45,950 3 Young Female Florida At least one child $46,015 2 Young Female Virginia At least one child $46,198 3 Young Female California At least one child $46,239 5 Elderly Female Ohio At least one child $46,243 4 Young Female California No Children $46,848 1 Young Male Florida At least one child $47,017 4 Young Male Florida At least one child $47,096 5 Young Female Texas At least one child $47,172 3 Young Female Florida At least one child $47,293 1 Young Female Virginia At least one child $47,927 2 Young Male Florida At least one child $48,213 4 Young Male Michigan At least one child $48,225 3 Young Female California At least one child $48,251 1 Young Female Texas At least one child $48,643 2 Elderly Female Arizona No Children $48,966 2 Middle-aged Female Florida No Children $48,975 2 Young Male Florida At least one child $49,165 4 Young Female Virginia At least one child $49,505 1 Young Female Florida At least one child $49,538 2 Young Female Arizona At least one child $49,687 4 Young Male California At least one child $49,723 1 Young Female Michigan At least one child $50,386 1 Young Male Arizona At least one child $50,434 1 Young Female Michigan No Children $50,516 1 Young Male Virginia At least one child $50,729 5 Young Male Michigan No Children $51,081 4 Young Female Ohio At least one child $51,169 3 Young Male Ohio No Children $51,612 3 Middle-aged Female New York At least one child $52,008 1 Young Female Florida No Children $52,109 2 Young Male Virginia At least one child $52,163 2 Young Male California At least one child $52,686 5 Young Female Michigan No Children $53,071 1 Young Male Virginia No Children $53,173 2 Young Female California No Children $53,306 3 Young Female Illinois At least one child $53,335 1 Middle-aged Male Florida At least one child $54,291 5 Elderly Female Michigan No Children $54,506 1 Young Female Ohio At least one child $54,784 4 Young Female Virginia No Children $55,269 5 Young Female Illinois At least one child $55,677 4 Young Female Minnesota At least one child $55,958 2 Elderly Male Illinois At least one child $56,140 1 Young Male Texas No Children $57,217 5 Young Male California At least one child $57,429 1 Elderly Male New York At least one child $57,713 5 Young Female Michigan At least one child $58,544 5 Elderly Male Minnesota No Children $58,608 5 Middle-aged Female Texas No Children $59,157 2 Elderly Female Ohio No Children $59,629 3 Elderly Female Michigan No Children $59,892 1 Elderly Female California At least one child $59,906 2 Elderly Female Arizona At least one child $60,242 4 Elderly Female Florida At least one child $60,375 4 Middle-aged Male Arizona At least one child $60,580 2 Middle-aged Female California No Children $60,715 3 Young Female Minnesota At least one child $60,924 2 Middle-aged Male California No Children $61,803 4 Elderly Female Virginia At least one child $62,043 1 Middle-aged Male California No Children $62,268 5 Middle-aged Male California At least one child $62,454 1 Elderly Male Illinois At least one child $62,929 5 Middle-aged Female Texas At least one child $63,017 5 Middle-aged Female Virginia At least one child $63,642 2 Elderly Female New York No Children $64,293 4 Elderly Male Texas No Children $64,364 4 Middle-aged Female Texas At least one child $64,443 4 Elderly Male Michigan At least one child $64,658 5 Elderly Female Michigan At least one child $64,844 1 Elderly Male Ohio No Children $64,879 3 Elderly Female Minnesota At least one child $65,085 2 Elderly Male Florida No Children $65,530 5 Middle-aged Female Texas At least one child $65,563 3 Elderly Female Michigan At least one child $65,626 3 Young Male Virginia At least one child $65,992 4 Elderly Female California At least one child $66,001 3 Elderly Male Ohio No Children $66,120 5 Middle-aged Male Minnesota At least one child $66,348 5 Elderly Female Michigan At least one child $66,636 4 Elderly Male California At least one child $67,073 5 Elderly Female Florida At least one child $67,683 3 Elderly Female Florida At least one child $67,723 2 Elderly Female Texas At least one child $67,748 3 Middle-aged Female Minnesota No Children $68,017 2 Elderly Male Virginia No Children $68,506 5 Elderly Female Ohio At least one child $68,783 2 Middle-aged Male California At least one child $69,222 2 Middle-aged Female New York No Children $69,546 5 Elderly Female Virginia At least one child $69,622 2 Elderly Female Florida At least one child $69,700 1 Young Female Texas At least one child $69,785 2 Elderly Male Minnesota At least one child $69,817 5 Middle-aged Female Illinois At least one child $70,903 4 Middle-aged Female Michigan At least one child $70,989 2 Middle-aged Female Virginia At least one child $71,078 1 Middle-aged Male Arizona No Children $71,280 5 Middle-aged Female Arizona No Children $71,281 1 Middle-aged Female New York At least one child $71,370 2 Middle-aged Female Illinois At least one child $71,679 4 Elderly Male Illinois At least one child $72,085 1 Young Male New York No Children $72,239 3 Elderly Female Minnesota At least one child $72,263 4 Elderly Male Virginia No Children $72,423 1 Middle-aged Female Texas At least one child $72,802 4 Middle-aged Female Michigan At least one child $72,888 5 Middle-aged Male Illinois No Children $73,224 3 Middle-aged Male Minnesota At least one child $73,359 3 Elderly Male Florida At least one child $73,618 2 Middle-aged Female Texas At least one child $73,629 2 Middle-aged Male Ohio No Children $73,823 1 Elderly Female Illinois At least one child $74,219 3 Elderly Female Ohio No Children $74,438 5 Elderly Female Michigan No Children $74,623 1 Middle-aged Female Florida At least one child $74,707 5 Elderly Female Ohio At least one child $74,751 5 Elderly Female Ohio No Children $75,011 2 Middle-aged Male Texas No Children $75,250 3 Middle-aged Male Ohio At least one child $75,359 4 Elderly Female Texas At least one child $75,365 1 Middle-aged Female New York At least one child $75,368 2 Elderly Female Minnesota No Children $75,851 5 Elderly Female Florida At least one child $75,892 1 Middle-aged Female Florida At least one child $75,997 3 Elderly Male Michigan No Children $76,193 4 Middle-aged Female Ohio No Children $76,219 1 Elderly Female Texas At least one child $76,391 4 Middle-aged Male New York No Children $76,408 5 Middle-aged Male New York No Children $76,476 5 Middle-aged Male Virginia No Children $76,810 3 Middle-aged Female Illinois At least one child $76,933 5 Middle-aged Male Florida At least one child $77,085 4 Elderly Male Florida At least one child $77,152 4 Elderly Female California At least one child $77,506 5 Middle-aged Female California At least one child $77,753 1 Middle-aged Male Illinois At least one child $77,804 3 Elderly Female Ohio At least one child $78,030 1 Middle-aged Female Minnesota At least one child $78,090 5 Middle-aged Female Illinois At least one child $78,374 4 Middle-aged Male New York At least one child $78,483 4 Elderly Female Michigan At least one child $78,500 1 Middle-aged Female Minnesota At least one child $78,578 2 Middle-aged Female California At least one child $78,689 5 Elderly Female Texas No Children $78,850 2 Middle-aged Female Arizona At least one child $79,122 5 Elderly Female Texas At least one child $79,204 3 Elderly Female Minnesota At least one child $79,212 1 Middle-aged Male Virginia At least one child $79,244 3 Elderly Male Texas At least one child $79,433 4 Middle-aged Female California No Children $79,709 3 Elderly Female Illinois At least one child $79,877 5 Elderly Female New York At least one child $79,958 3 Middle-aged Female Virginia At least one child $80,112 1 Middle-aged Male Illinois At least one child $80,193 5 Elderly Male Ohio No Children $80,256 3 Elderly Male California At least one child $80,366 5 Elderly Female Florida No Children $80,440 5 Middle-aged Female Ohio At least one child $80,445 4 Middle-aged Female Illinois No Children $80,701 2 Elderly Male California No Children $81,099 2 Elderly Male Illinois No Children $81,163 2 Middle-aged Female Texas At least one child $81,674 1 Middle-aged Female Michigan At least one child $81,799 2 Middle-aged Female Florida At least one child $81,926 3 Elderly Female Arizona No Children $81,981 4 Elderly Male Arizona At least one child $82,092 1 Middle-aged Female Michigan No Children $82,101 3 Elderly Female Florida At least one child $82,218 3 Middle-aged Female Texas No Children $82,327 4 Middle-aged Female Arizona At least one child $82,558 1 Middle-aged Female Texas At least one child $83,191 1 Middle-aged Female Illinois No Children $83,326 2 Elderly Female Minnesota At least one child $83,433 5 Elderly Male Illinois No Children $83,768 4 Middle-aged Male Virginia No Children $83,843 1 Middle-aged Male New York At least one child $83,848 2 Elderly Male Michigan At least one child $83,914 1 Elderly Female Texas At least one child $83,939 2 Middle-aged Female Michigan At least one child $84,005 3 Elderly Male Michigan No Children $84,038 3 Middle-aged Female Florida At least one child $84,146 4 Elderly Female California No Children $84,163 2 Elderly Female Michigan At least one child $84,168 3 Elderly Female Texas At least one child $84,185 4 Middle-aged Female New York At least one child $84,313 3 Middle-aged Female Ohio No Children $84,454 4 Elderly Female Michigan No Children $84,571 4 Middle-aged Female Texas No Children $84,572 5 Elderly Female Virginia At least one child $84,837 4 Middle-aged Male New York At least one child $84,880 5 Middle-aged Male Texas At least one child $85,110 2 Elderly Male Michigan At least one child $85,301 2 Middle-aged Male Virginia At least one child $85,412 2 Middle-aged Female Texas No Children $85,489 4 Middle-aged Male Illinois At least one child $85,526 3 Middle-aged Female Michigan At least one child $85,534 4 Middle-aged Male Minnesota No Children $85,603 1 Middle-aged Female Ohio At least one child $85,732 5 Middle-aged Male New York At least one child $85,886 5 Middle-aged Male Virginia At least one child $85,906 1 Middle-aged Female Florida No Children $86,486 4 Middle-aged Male New York At least one child $86,538 2 Middle-aged Male Michigan At least one child $86,791 1 Middle-aged Male Minnesota At least one child $86,840 2 Middle-aged Male Minnesota No Children $86,896 1 Middle-aged Female New York At least one child $86,913 1 Elderly Female Ohio At least one child $87,059 3 Middle-aged Female Minnesota At least one child $87,254 3 Middle-aged Male Illinois At least one child $87,457 4 Middle-aged Male California At least one child $87,854 3 Middle-aged Male Michigan No Children $88,427 2 Elderly Female Michigan At least one child $88,448 2 Middle-aged Female California At least one child $88,561 4 Elderly Female Virginia No Children $88,636 5 Middle-aged Female Arizona At least one child $88,855 2 Middle-aged Male Michigan No Children $90,021 4 Middle-aged Female Florida At least one child $90,190 3 Middle-aged Female Texas At least one child $90,218 2 Middle-aged Male Virginia No Children $90,349 4 Middle-aged Male Ohio At least one child $90,675 4 Elderly Male Florida At least one child $91,007 1 Elderly Male New York No Children $91,183 1 Middle-aged Male Ohio At least one child $91,299 1 Middle-aged Male Illinois At least one child $91,331 5 Middle-aged Female Michigan No Children $91,531 5 Middle-aged Female Texas At least one child $91,557 1 Middle-aged Male Arizona No Children $91,650 5 Middle-aged Male Virginia At least one child $91,760 2 Elderly Female Virginia No Children $91,767 1 Middle-aged Male Texas No Children $91,778 4 Middle-aged Female Minnesota No Children $91,844 5 Middle-aged Male Illinois No Children $92,025 4 Middle-aged Male New York At least one child $92,094 4 Elderly Male Texas At least one child $92,538 4 Middle-aged Male Arizona At least one child $92,590 1 Elderly Female Arizona No Children $92,888 5 Middle-aged Female New York At least one child $93,344 4 Middle-aged Female Michigan At least one child $93,370 5 Middle-aged Female Minnesota At least one child $93,524 3 Middle-aged Male Ohio No Children $93,790 4 Middle-aged Male Illinois At least one child $94,296 2 Middle-aged Female Michigan At least one child $94,339 3 Middle-aged Male Virginia At least one child $94,455 5 Middle-aged Female Illinois At least one child $94,679 2 Elderly Female Michigan At least one child $95,120 5 Middle-aged Male Florida At least one child $95,760 5 Middle-aged Female Arizona At least one child $95,833 3 Elderly Male Texas At least one child $95,962 3 Middle-aged Male New York No Children $96,180 4 Elderly Female Texas No Children $96,274 4 Middle-aged Male Illinois At least one child $96,949 2 Middle-aged Male Illinois No Children $96,961 1 Middle-aged Male Texas No Children $97,543 3 Middle-aged Male Michigan At least one child $97,785 1 Middle-aged Male New York No Children $97,814 2 Middle-aged Male New York No Children $97,857 4 Elderly Male Illinois At least one child $97,975 2 Middle-aged Male Ohio At least one child $98,341 5 Middle-aged Male Virginia At least one child $98,774 4 Middle-aged Male New York At least one child $98,889 2 Middle-aged Female New York At least one child $99,813 4 Middle-aged Male Michigan At least one child $100,009 2 Middle-aged Female New York At least one child $100,062 5 Middle-aged Female Virginia At least one child $100,302 1 Middle-aged Male Texas At least one child $100,403 4 Middle-aged Female Texas At least one child $101,325 5 Middle-aged Female Illinois At least one child $101,475 5 Elderly Female Ohio At least one child $101,526 2 Middle-aged Female Texas At least one child $101,894 4 Middle-aged Female New York No Children $101,962 2 Middle-aged Female Virginia No Children $102,213 5 Middle-aged Male Florida At least one child $102,315 3 Middle-aged Female Ohio No Children $102,405 1 Middle-aged Female Ohio At least one child $102,900 1 Middle-aged Female New York At least one child $103,419 4 Middle-aged Female Illinois No Children $103,500 5 Middle-aged Male Illinois At least one child $103,556 4 Middle-aged Female New York No Children $103,667 2 Middle-aged Female Florida At least one child $103,708 3 Middle-aged Male Ohio No Children $104,032 1 Middle-aged Female Minnesota At least one child $104,772 4 Middle-aged Female Ohio At least one child $106,139 4 Elderly Male Florida No Children $106,185 1 Middle-aged Female Ohio At least one child $106,828 3 Middle-aged Male California At least one child $107,069 2 Middle-aged Male Florida At least one child $107,121 5 Middle-aged Male Minnesota At least one child $107,253 1 Middle-aged Female Michigan At least one child $107,768 3 Middle-aged Male Ohio No Children $107,931 3 Middle-aged Male California At least one child $108,418 5 Middle-aged Female Illinois At least one child $108,552 2 Middle-aged Female Texas No Children $109,022 2 Middle-aged Male Texas No Children $109,183 2 Middle-aged Female Florida At least one child $109,270 4 Middle-aged Male Minnesota At least one child $109,315 2 Middle-aged Female Ohio At least one child $109,417 4 Middle-aged Female Arizona No Children $109,677 4 Middle-aged Female Michigan At least one child $109,819 4 Middle-aged Female Texas At least one child $110,102 2 Middle-aged Male New York At least one child $110,140 4 Middle-aged Female New York At least one child $110,266 4 Middle-aged Male New York No Children $110,389 5 Middle-aged Male Ohio At least one child $110,627 1 Middle-aged Female New York No Children $110,945 5 Middle-aged Female Illinois At least one child $111,213 4 Middle-aged Male Illinois At least one child $111,391 3 Middle-aged Female Minnesota At least one child $111,796 4 Middle-aged Female New York At least one child $111,921 5 Middle-aged Male Minnesota At least one child $115,138 5 Middle-aged Female Florida At least one child $115,555 5 Middle-aged Female California At least one child $115,659 1 Middle-aged Female Texas At least one child $116,079 2 Middle-aged Male Florida At least one child $119,453 4 Middle-aged Male Michigan No Children $119,992 2 Middle-aged Female Illinois At least one child $120,713 5 Middle-aged Female Ohio No Children $121,206 3 Middle-aged Female New York No Children $122,617 1 Middle-aged Female Ohio At least one child $122,748 5 Middle-aged Male New York At least one child $124,005 3 Middle-aged Male New York At least one child $124,798 4 Middle-aged Male Texas No Children $126,369 2 Middle-aged Male Texas No Children $126,983 2 Middle-aged Male Ohio At least one child $127,032 1 Middle-aged Male Florida At least one child $127,108 3 Middle-aged Female Arizona At least one child $127,638 1 Middle-aged Male Arizona At least one child $127,725 4 Middle-aged Female Ohio At least one child $129,493 3 Middle-aged Female Michigan At least one child $129,494 1 Middle-aged Female Texas No Children $131,312 1 Middle-aged Female Illinois At least one child $131,489 1 Middle-aged Male California No Children $132,176 2 Middle-aged Female Ohio No Children $132,182 1 Middle-aged Female Virginia At least one child $132,655 1 Middle-aged Male Michigan No Children $133,741 5 Middle-aged Female Minnesota At least one child $134,254 4 Middle-aged Male Minnesota No Children $134,634 5 Middle-aged Female Virginia At least one child $140,022 1 Middle-aged Female California No Children $144,043 5 Middle-aged Male Arizona At least one child $144,335 3 Middle-aged Female New York At least one child $144,518 2 Middle-aged Female Texas At least one child $144,884 1 Middle-aged Male Arizona At least one child $148,014 3 Middle-aged Female Arizona At least one child $148,075 2 Middle-aged Female Texas At least one child $148,408 5 Middle-aged Male Michigan At least one child $150,149 5 Middle-aged Female Florida At least one child $160,134 3Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.