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
research two local banks in your area and compare/contrast one service that they offer. For example you may want to look at the type of checking accounts offered and compare the features between these; What are the interest rates offered? How many withdrawls are you allowed? What fees are associated with the account ? Do they offer a budgeting app, online banking etc? You could do this for savings accounts, buisness accounts, etc. Discuss what features you find most important, and which bank you would choose based on your research.
Select one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth.
Your mini research paper should have the following.
It should be approximately four to five pages (excluding reference and title pages).
It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format.
These short papers do not require an abstract or running head.
Topics (select one)
What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve?
Select one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth.
Your mini research paper should have the following.
It should be approximately four to five pages (excluding reference and title pages).
It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format.
These short papers do not require an abstract or running head.
Topics (select one)
What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve?
800 Words Requirement
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 model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…arrow_forwardI understand the cost classification, but not the total amount and percent of total. Thanks!arrow_forwardGo to the Loan Calculator The cells in the range B6:B8 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula.Update the defined names in the worksheet as follows: a)Delete the Loan_Calculator defined name. b)For cell B8, edit the defined name to use Loan_Amount as the name. 2. In cell B8, calculate the loan amount by entering a formula without using a function that subtracts the Down_Payment from the Price. 3.Liam also wants to use defined names in other calculations to help him interpret the formulas.a) In the range D4:D8, create defined names based on the values in the range C4:C8.arrow_forward
- SHOW YOUR WORK IN THE SPACES PROVIDED BELOW FOR FULL CREDIT. a. Based on a sample of 1535 Internet users, a University of Southern California sponsored study reported Internet users followed an average of 9.9 companies on social network sites such as LinkedIn. State the population for this survey, the statistics, and some likely values from the population distribution.arrow_forwardIn cell F5, insert a lookup function that uses the credit rating to determine the minimum down payment based on the table array A:15:c:18. Include the range_lookup argument to ensure an exact match. Multiply the function result by the negotiated cost of the vehicle.arrow_forwardDownload the spreadsheet here which includes a tax table in each tab. Edit the spreadsheet so you can use it to answer the following questions. Then upload images of your spreadsheet in the last part of the question. Hint: create a spreadsheet with a tax table you have already used (in a practice), use it to answer questions that you answered in that practice for which you have correct answers. That will help you be sure that your ideas here work. a. Suppose Erick has a total taxable income of $181,860. They are taxed at the Married Jointly rates. What is Erick's total tax bill? $ 39,913.3 Erick pays taxes at the following tax brackets (pick all that apply). 10% 15% 25% 28% 33% 35%arrow_forward
- Please answer multichoice question in photo. There can be more than one answer.arrow_forwardFind the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $400 compounded for 1 year at 9.5%. $ An initial $400 compounded for 2 years at 9.5%. $ The present value of $400 due in 1 year at a discount rate of 9.5%. $ The present value of $400 due in 2 years at a discount rate of 9.5%. $arrow_forwardWhich one of the following best defines the term credit scoring? A. Categorizing customers into groups depending on the length of time it takes each customer to pay for purchases B. Compiling a list of accounts receivable segregated by the length of time each receivable has been outstanding C. Evaluating the opportunity costs of a credit policy D. Process of quantifying the probability of default when granting credit to customers E. Tracking of both the number and the size of customer orders over a period of timearrow_forward
- Your company is evaluating two cloud-based secured data storage services. "Great Sky," the newer service, claims its uploading and downloading speeds are faster than the older service, "Clear and Steady Skies." You need to make a decision based on published access times for both services at different times and for varying file sizes. To make your decision, you purchase two statistical studies from which you discover the average download time for Great Sky is 0.67 sec. per MB and for Clear Steady Skies is 0.84. Additionally, the studies indicate the following sample information: NGS = 60 ncss = 50, SGS = 0.25 and scss = 0.55. Use a = .05, and the five step hypothesis testing procedure to make the appropriate decision.arrow_forwardFor her flower sales, Beatrice is entering a number of customer payments as a bank deposit. After she selects a particular customer, what should she do next? Select an answer: Enter a description of the flowers. Select Product Sales under Account. Create an invoice for the sale.arrow_forwardCustomized SoftwareCustomized Software, a software company (the “Company”), is contracted by a bank (the“Bank”) to provide a customized online platform for the Bank’s mortgage loan applications (the“Loan Platform”). Bank customers use the Loan Platform to complete online mortgageapplications, which involves inputting relevant information (e.g., name, address, employment,income, assets) and uploading supporting documents (e.g., tax returns, bank statements). TheLoan Platform enables both the Bank and the applicants to retrieve necessary information anddocuments as well as track the status of the lending process in real time.To develop the Loan Platform, the Company significantly modifies and customizes itsproprietary loan application software to work with the existing systems used by the Bank’scredit, customer service, and accounting departments. To create a Loan Platform that meets theBank’s specifications, the Company is contractually required to perform the following specificsoftware…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
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,