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 division's margin of this financial accounting question?
Waht is the correct option? General accounting question
Silverline Enterprises has Total Assets of $9,750,
Contributed Capital of $5,200, and Retained
Earnings of $850.
What is the total amount of liabilities on the
balance sheet?
a. $4,600
b. $3,700
c. $4,750
d. $9,100
e. None of the above
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
- Please Solve this Questionarrow_forwardSeveral years ago, a parent company acquired all of the outstanding common stock of its subsidiary for a purchase price of $320,000. On the acquisition date, this purchase price was $75,000 more than the subsidiary's book value of Stockholders' Equity. The AAP was entirely attributable to Goodwill. On the date of acquisition, the parent company's management believed that the goodwill had a 10-year useful life. Since the date of acquisition, the subsidiary has reported a cumulative net income of $260,000 and paid $105,000 in dividends to its parent company. Compute the balance of the Equity Investment account on the parent's balance sheet, assuming that the Goodwill asset has not declined in value since the date of acquisition.arrow_forwardwhat is sunset's total asset turnover ratio?arrow_forward
- what amount and direction during that same period?arrow_forwardLark Industries incurs annual fixed costs of $90,000. Variable costs for Lark’s product are $50 per unit, and the sales price is $75 per unit. Lark desires to earn an annual profit of $45,000. Use the contribution margin ratio approach to determine the sales volume in dollars and units required to earn the desired profit.arrow_forwardSunset Corporation had sales of $200,000, year-end receivables of $25,000, inventories of $40,000, and total assets of $120,000. It uses a 365-day year for ratio calculations. What is Sunset's total asset turnover ratio?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