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
What is the dividend yield on these financial accounting question? Not use ai please don't
answer plz
correct 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
- Solve this Accounting problemarrow_forwardAnalysts are projecting that Capital Railways will have earnings per share of $4.20. If the average industry P/E ratio is 22, what is the current price of Capital Railways?arrow_forwardPluto Flyers, Inc., has balance sheet equity of $6.2 million. At the same time, the income statement shows net income of $865,000. The company paid dividends of $472,500 and has 120,000 shares of stock outstanding. If the benchmark PE ratio is 20, what is the target stock price in one year?arrow_forward
- Financial Accountingarrow_forwardPhoenix Industries has twelve million shares outstanding, generates free cash flows of $75 million each year, and has a cost of capital of 12%. It also has $50 million of cash on hand. Phoenix wants to decide whether to repurchase stock or invest the cash in a project that generates free cash flows of $3 million each year. Should Phoenix invest or repurchase the shares? A) Repurchase B) Invest C) Indifferent between options D) Cannot say for surearrow_forwardWhat was his capital gain?arrow_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
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