Download the rejected loan data set of LendingClub data titled "RejectStatsA Ready" from the Connect Website and do an Excel PivotTable by state and figure out the number of rejected applications for each state. Reorder these and make a graph ordering the states and the number of rejected loans from highest to lowest.

Row Labels	Count of Rejected Loans
AK	1,608
AL	10,959
AR	7,868
AZ	13,830
CA	85,793
CO	11,697
CT	10,589
DC	1,524
DE	2,287
FL	49,620
GA	23,774
HI	3,715
IA	110
ID	52
IL	27,407
IN	965
KS	5,567
KY	8,827
LA	9,359
MA	16,444
MD	15,103
ME	89
MI	17,544
MN	9,083
MO	12,615
MS	387
MT	1,839
NC	17,248
ND	30
NE	144
NH	3,561
NJ	23,932
NM	3,814
NV	8,231
NY	51,487
OH	24,395
OK	7,125
OR	6,161
PA	28,411
RI	3,220
SC	10,130
SD	1,445
TN	355
TX	53,856
UT	4,470
VA	20,211
VT	1,617
WA	12,107
WI	9,235
WV	4,151
WY	1,423
Grand Total	645,414

Required:

Put the following states in order of their loan rejection percentage (from high (1) to low (11)).

State	Rank
Arkansas (AR)
Hawaii (HI)
Kansas (KS)
New Hampshire (NH)
New Mexico (NM)
Nevada (NV)
Oklahoma (OK)
Oregon (OR)
Rhode Island (RI)
Utah (UT)
West Virginia (WV)