EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 14PE
In the Excel file Banking Data, apply the following data visualization tools:
- Use data bars to visualize the relative values of
median home value. - Use color scales to visualize the relative values of median household wealth.
- Use an icon set to show high, medium, and low average bank balances, where high is above
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Using the data in the following table, calculate the return for investing in Boeing stock (BA) from January 2, 2008, to January 2, 2009, and also from January 3, 2011, to January 3, 2012, assuming all dividends are reinvested in the stock immediately.
Historical Stock and Dividend Data for Boeing
Date Price Dividend Date Price Dividend
1/2/2008 86.62 1/3/2011 66.40
2/6/2008 79.91 0.40 2/9/2011 72.63 0.42
5/7/2008 84.55 0.40 5/11/2011 79.08 0.42
8/6/2008 65.40 0.40 8/10/2011 57.41 0.42
11/5/2008 49.55 0.40 11/8/2011 66.65 0.42
1/2/2009 45.25 1/3/2012 74.22
Return from January 2, 2008, to January 2, 2009 is how much? (Round to two decimal places.)
In a subprime loan, interest rates are:
equal to prime loan rates
unrelated to a borrower's credit score
higher than prime loan rates
lower than prime loan rates
If a person has ATM fees each month of $19 for 9 years, what would be the total cost of those banking fees?
Chapter 3 Solutions
EBK BUSINESS ANALYTICS
Ch. 3 - Prob. 2PECh. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - Create a stacked area chart contrasting primary...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - The Excel file Facebook Survey provides data...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...
Ch. 3 - A marketing researcher surveyed 92 individuals,...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, apply...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- Information that is used by investors for expecting future earnings is recorded in Select one: a. Annual Report b. Five Years Report c. Exchange Report d. Stock Reportarrow_forwardWhich of the following are the Federal Advisory Council responsible for? Check all that apply. Making recommendations to the Board of Governors about economic and banking issues Manipulating the money supply through open-market operations Clearing checks Setting the minimum percentage of an investment in securities that must be with investor's casharrow_forward. Dolla Financial “I used to work at NCB (National Commercial Bank). When I left NCB, I started my first loan company at the age of 24, a company called M24 Investments in Lucea, Hanover,” Kadeen Mairs reflected as he took a deep breath. Mairs, previously worked as a loans officer at various branches of the NCB in rural Jamaica. “While I was working at the bank I would visit small businesses in need of loans, but because of the requirements to get these loans, a lot of the small businesses would not qualify to get the loan. But I could see the potential in these businesses and I realised there was a market for loans to informal businesses that are not structured enough to access credit from the bank,” he continued. “That was a big market so I decided to tap into that market starting small. I took a loan and on lend that money to small businesses.” He said the seed funds for his company came through two loans totalling $4 million. “When I started out in Lucea, I used to give loans…arrow_forward
- What is the main reason lenders pay borrowers' property taxes through a pre-paid escrow account? It prevents a tax lien from being applied to the home. The tax lien would be senior to the mortgage lien. It prevents the borrower from refinancing with another lender because they would lose all of their escrow funds. It allows the lender to earn interest on the pre- paid tax money as itsits in the account. It allows the lender to take advantage of corporate tax deductions.arrow_forwardOn-Balance Sheet Items (Assets) (in millions) Cash $ 10,000 Government securities 30,000 Interbank deposits 5,000 Home loans to personal finance customers 20,000 Loans to corporate customers 75,000 Total Balance Sheet Assets $140,000 Off-Balance Sheet Items Standby letters of credit backing corporate borrowings $ 10,000 Long term unused loan commitments made to private corporations 20,000 Total Off-Balance Sheet Items $30,000 Bank Capital Common stock (par value) $ 1,000 Surplus 1,500 Retained earnings 1,500 Subordinated debentures 2,000 Minority interest in subsidiaries 1,000 Allowance for loan and lease losses (reserves) 1,000 Non cumulative perpetual preferred stock 1,000 Intermediate term preferred stock 4,000 Equity commitment notes 2,000 Basel…arrow_forwardThe cash collection cycle is the number of days it takes to collect accounts receivable. The measure is important for tracking the ability of a business to grant a reasonable amount of credit to worthy customers and collect receivables on time. ELABORATE the advantages and disadvantages of the collection agency for an organization.arrow_forward
- Chris owes the bank $30. His friend Morgan owes the bank $18 Which inequality correctly expresses the relationship of the money they each owes ? Mark all that apply A -18>-30 B -1830 D -30arrow_forward50-The type of deposit account preferred by business organizations is: Recurring deposits Current deposits Savings bank deposits Fixed depositsarrow_forwardYour boss would like your help on a marketing research project he is conducting on the relationship between the price of juice and the quantity of juice supplied. He hands you the following document: Price of Juice Quantity of Juice Supplied (Dollars per can) (Billions of cans) 0.50 750 0.75 1,000 1.00 1,500 1.25 2,000 Your task is to take this and construct a graphical representation of the data. In doing so, you determine that as the price of juice rises, the quantity of juice supplied increases. This confirms thearrow_forward
- Describe how the following business transactions affect the three elements of the accounting equation. Received cash for services performed. Invested cash in business. Paid for utilities used in the business. Purchased supplies on account. Purchased supplies for cash.arrow_forwardIn this Harvard Business Review (HBR) article entitled, "How to Finance the Scale-Up of Your Company" written by Daniel Isenberg and Daniel Lawton, the authors provide practical ways to ensure your business has sources of financing, especially when scaling-up your business. https://hbr.org/2014/08/how-to-finance-the-scale-up-of-your-company INSTRUCTION: Prepare a Reaction Paper called Reading Reflection Memo (RRM). READING REACTION MEMO FOR THIS ARTICLE: The reading reaction memo after reading the article above should: (a) compare and contrast key points that strike you from the reading(s); (b) evaluate the arguments and evidence on the point(s) you cover, identifying what was insightful, mundane, unclear, incomplete, contradictory, etc.; and (c) conclude with 3-4 questions for class discussion. The reaction memo should not merely summarize the reading(s) you consider, but it should also demonstrate an active engagement with the point(s) you select to focus on, including how it (they)…arrow_forwardDolla Financial “I used to work at NCB (National Commercial Bank). When I left NCB, I started my first loan company at the age of 24, a company called M24 Investments in Lucea, Hanover,” Kadeen Mairs reflected as he took a deep breath. Mairs, previously worked as a loans officer at various branches of the NCB in rural Jamaica. “While I was working at the bank I would visit small businesses in need of loans, but because of the requirements to get these loans, a lot of the small businesses would not qualify to get the loan. But I could see the potential in these businesses and I realised there was a market for loans to informal businesses that are not structured enough to access credit from the bank,” he continued. “That was a big market so I decided to tap into that market starting small. I took a loan and on lend that money to small businesses.” He said the seed funds for his company came through two loans totalling $4 million. “When I started out in Lucea, I used to give loans…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage Learning
Accounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
How to make Frequency Distribution Table / Tally Marks and Frequency Distribution Table; Author: Reenu Math;https://www.youtube.com/watch?v=i_A6RiE8tLE;License: Standard YouTube License, CC-BY
Frequency distribution table in statistics; Author: Math and Science;https://www.youtube.com/watch?v=T7KYO76DoOE;License: Standard YouTube License, CC-BY
Frequency Distribution Table for Grouped/Continuous data | Math Dot Com; Author: Maths dotcom;https://www.youtube.com/watch?v=ErnccbXQOPY;License: Standard Youtube License