Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
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
Explanation of Solution
The number of rejected applications for each state is as follows:
Row Labels | Count 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 |
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:
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
Chapter 1 Solutions
Data Analytics For Accounting
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
Similar questions
- In a certain standard costing system, the following results occurred last period: total labor variance, 3200 F; labor efficiency variance, 4,300 F; and the actual labor rate was $0.35 more per hour than the standard labor rate. The number of direct labor hours used last period was __.arrow_forwardTotal assets turnoverarrow_forwardfinancial accountingarrow_forward
- An electronics store sold a home theater system to an employee for $400, even though the retail price was $650. The gross profit percentage is 47%. Such discounts are available to all employees. How much income should be recognized by the employee from these transactions?arrow_forwardAmount of manufacturing overhead applied during the month ?arrow_forwardexpert of general account answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
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
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning