Data Analytics For Accounting
Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
Question
Book Icon
Chapter 1, Problem 4P
To determine

Do an Excel PivotTable according to state and find out the number of rejected applications for each state. Reorder the numbers and draw a graph ordering the states and the number of rejected loans from highest to lowest. Identify whether there exist any variations among states.

Expert Solution & Answer
Check Mark

Explanation of Solution

The number of rejected applications for each state is as follows:

Row LabelsCount of Loan Title
CA                     99,792
TX                     62,049
NY                     60,718
FL                     60,051
PA                     33,167
IL                     31,488
GA                     29,000
OH                     28,510
NJ                     27,666
VA                     23,556
MI                     20,696
NC                     20,386
MA                     18,808
MD                     17,856
AZ                     16,281
MO                     14,605
WA                     14,007
CO                     13,335
AL                     13,185
SC                     12,146
CT                     12,137
LA                     11,181
WI                     10,664
MN                     10,400
KY                     10,286
NV                       9,513
AR                       9,400
OK                       8,165
OR                       7,198
KS                       6,336
UT                       5,126
WV                       4,975
HI                       4,341
NM                       4,329
NH                       4,038
RI                       3,637
DE                       2,708
MT                       2,102
AK                       2,005
DC                       1,900
VT                       1,829
SD                       1,620
WY                       1,608
IN                       1,134
MS                          551
TN                          449
NE                          175
IA                          144
ME                          108
ID                            69
ND                            38
(blank)                            21
Grand Total                   755,489

The graph ordering the states and the number of rejected loans from highest to lowest:

Data Analytics For Accounting, Chapter 1, Problem 4P

There is a varaibility among the number of loans rejected in a particular state and the population of that state. The number of rejected loans varies in a different manner.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Need answer the general accounting question
What is the companys CM ratio?
Tutor provide answer please
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Text book image
SWFT Comprehensive Volume 2019
Accounting
ISBN:9780357233306
Author:Maloney
Publisher:Cengage
Text book image
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning