DATA ANALYTICS FOR ACCOUNTING W/CONNECT
DATA ANALYTICS FOR ACCOUNTING W/CONNECT
1st Edition
ISBN: 9781260574449
Author: RICHARDSON
Publisher: MCG
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 W/CONNECT, 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!
Previous
Chapter 1, Problem 3P
Next
Chapter 1, Problem 6P
Students have asked these similar questions
Nicole is a calendar-year taxpayer who accounts for her business using the cash method. On average, Nicole sends out bills for about $12,000 of her services on the first of each month. The bills are due by the end of the month, and typically 70 percent of the bills are paid on time and 98 percent are paid within 60 days. a. Suppose that Nicole is expecting a 2 percent reduction in her marginal tax rate next year. Ignoring the time value of money, estimate the tax savings for Nicole if she postpones mailing the December bills until January 1 of next year.
General accounting
Can you solve this general accounting question with accurate accounting calculations?

Chapter 1 Solutions

DATA ANALYTICS FOR ACCOUNTING W/CONNECT

Ch. 1 - Prob. 1MCQCh. 1 - Prob. 2MCQCh. 1 - Prob. 3MCQCh. 1 - Prob. 4MCQCh. 1 - Prob. 5MCQCh. 1 - Prob. 6MCQCh. 1 - Prob. 7MCQCh. 1 - Prob. 8MCQCh. 1 - Prob. 9MCQCh. 1 - Prob. 10MCQ
Ch. 1 - Prob. 1DQCh. 1 - Give an example of how Data Analytics creates...Ch. 1 - Prob. 3DQCh. 1 - Prob. 4DQCh. 1 - Prob. 5DQCh. 1 - Prob. 6DQCh. 1 - Prob. 7DQCh. 1 - Prob. 8DQCh. 1 - Prob. 9DQCh. 1 - Prob. 10DQCh. 1 - Prob. 11DQCh. 1 - Prob. 12DQCh. 1 - To address the question Will I receive a loan from...Ch. 1 - Download and consider the data dictionary file...Ch. 1 - Download and consider the rejected loans dataset...Ch. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Consider the 2013 declined loan data from...Ch. 1 - Consider the 2013 declined loan data from...
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS