Questions and Answers of Business Analytics Data

Determining how well a company performed relative to its budget is an example of which type of financial analytics?a. Prescriptive analyticsb. Descriptive analyticsc. Diagnostic analyticsd.
Describe two sources of financial statement data.
Which branch of finance determines how well the company performed relative to the budget?a. Corporate financeb. Investmentsc. Financial market and institutionsd. Banking
Explain what the Sharpe ratio tells the analyst.
List five factors (independent variables) that a bank might use to determine whether a prospective borrower will be able to repay a loan. Is each of these factors positively or negatively related to
How does an analysis of financial ratios, including the DuPont ratios, qualify as diagnostic analysis?
XBRL is a means of disclosing financial information in a computer-readable format. Its submission is required by thea. New York Stock Exchange.b. Securities and Exchange Commission.c. Financial
Which has a higher return on investment? S&P 500, High-Grade Corporate Bonds, or the U.S. Treasury Bond. Download the Investment Returns dataset. The source is from A swath Damodaran, NYU Finance
The DuPont ratio analysis decomposes return on equity into how many component parts?a. Fourb. Threec. Twod. Five
Predicting whether a loan applicant will receive a loan is an example of predictive analytics. Why is predicting whether the borrower will repay the loan fundamental to that analysis?
EDGAR serves as a repository for information about.a. Stock prices.b. Interest rates.c. The economy.d. Financial statements
Which has the highest return on investment: the S&P 500, high-grade corporate bonds, or U.S. Treasury bonds? Download the Investment Returns data set from Connect or Additional Student
Altman’s fifth factor in predicting bankruptcy (X5) is sales divided by total assets. The greater the sales divided by assets, the greater the possibility of not going bankrupt. Why?
The ratio of the average return earned in excess of the risk-free rate to a unit of volatility or total risk is thea. Sharpe ratio.b. Return on equity (ROE).c. Return on asset (ROA).d. Current ratio
Different industries have different levels of returns. This problem works to compare industries to each other, including gross margin, net profit margin and R&D expenditures as a percentage of
If a potential borrower has a high amount of debt relative to income, is it more likely or less likely that a loan will be granted to that borrower? Explain.
Which of the following has a higher risk and higher return than a corporate bond?a. Treasury bondb. Treasury billc. Share of stockd. Deposit at a bank
The lower the cost of capital, the better for a company. The cost of capital is the cost to use someone else’s money or investment such as the interest rate of the debt or the cost of
To predict whether firms are at high or low risk of bankruptcy, analysts can use the predictive analytics technique ofa. Sensitivity analysis.b. Regression analysis.c. Classification analysis.d. Time
Why is a visualization of sensitivity analysis easier to interpret than a table of sensitivity analysis? Stock Intrinsic Value per Share $600.00 $500.00 $400.00 $300.00 $200.00 $100.00 Market
Visualizations that show performance relative to relevant benchmarks are examples ofa. Prescriptive analytics.b. Descriptive analytics.c. Diagnostic analytics.d. Predictive analytics
Use summary measures to examine the salaries and the net promoter scores (NPS) of sales representatives depending on their personality types and sex in the software
Perform a similar analysis to the one conducted in this section, but choose two other college
According to recent estimates, annually, the average American spends $583 on alcohol and $1,100 on coffee.a. Describe the relevant population.b. Are the estimates based on sample or population data?
Millions of tourists visit Yosemite National Park in California each year. Stunning waterfalls, giant redwood trees, and spectacular granite rock formations are among the main attractions at the
Go to the U.S. Census Bureau website at www.census.gov and search for the most recent median household income for Alabama, Arizona, California, Florida, Georgia, Indiana, Iowa, Maine, Massachusetts,
Use summary measures to examine the high school GPA and the SAT scores of those students who were admitted to the School of Business & Economics versus those students who were admitted to the
A novel coronavirus, SARS-CoV-2, caused a worldwide pandemic of COVID-19 disease. Many public health organizations gathered and provided COVID-19 data for scientists, epidemiologists, and the general
Subset the data set based on the location, day of the week, type of collision, and lighting condition. Compare these subsets of data to find interesting patterns. Can you identify any links between
Subset the data based on variables, such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of the house. Which variables can be removed when predicting
Subset the data based on age, sex, or race. Are there any missing values in the data? Which strategy should you use to handle the missing values? Consider if any new variables can be created using
Consider whether data distribution skewness exists in some of the numeric variables, and if it does, determine how to transform the data into a less skewed distribution. Perform data sub-setting and
To examine the impact of the pandemic of COVID-19 disease on the economy, visit the U.S. Department of Labor’s website on unemployment insurance weekly claim data
Perform a similar analysis to the one conducted in this section, but choose another
The accompanying data file shows the sale price (in $1,000s) for 36 homes sold in a suburb outside Chicago, Illinois. Find the mean and median sale
The accompanying data file shows the salary (in $) and work experience (in years) of 100 employees in a marketing firm.a. Construct the five-number summary for each variable.b. What are the minimum
The accompanying data file shows U.S. life expectancy (in years) for the 50 states. Find the mean and median life expectancy.RankStateLife_Expectancy1Hawaii81.52Minnesota80.93California80.44New
Choose a college town and use tabular and graphical methods to examine house prices along with other variables of
Go to https://finance.yahoo.com/ and extract at least 20 years of annual return data for two mutual funds. Perform a similar analysis to the one that was conducted for the introductory case to this
To examine the impact of the COVID-19 pandemic on the economy, go to the U.S. Department of Labor’s website on unemployment insurance weekly claims data
South Bay Candles makes two types of scented candles: 10-inch pillars and 2-inch decorative gel. The production requirements for each product and available resources are shown in Table 17.3. The
The accompanying data file shows the net profit (Net_Profit), counter sales (Counter_Sales), and drive-through sales (Drive_Sales) for a chain of 100 fastfood restaurants. All variables are measured
The accompanying data file shows the net profit (Net_Profit) counter sales (Counter_Sales), and drive-through sales (Drive_Sales) for a chain of 100 fast-food restaurants. All variables are
An oil and gas company has two refineries that produce light and heavy crude oil. The first refinery can produce 500 barrels of light crude oil and 300 barrels of heavy crude oil per day, and the
A financial portfolio usually consists of a number of investment options such as stocks and mutual funds. Visit online sources such as the Wall Street Journal (www.wsj.com), Google Finance
A pet daycare facility offers pet sitting services where owners can drop off their pets for training and socializing with other pets. To feed the pets, the daycare makes two types of pet food. A bag
At a shipping warehouse, a manager has purchased two warehouse automation robots, an autonomous mobile robot (AMR) and a preprogrammed aerial drone. The AMR can retrieve 17 packages per hour, and its
Use tabular and graphical methods to examine the salaries of sales representatives along with other variables of
Use tabular and graphical methods to examine the result of a Covid test along with other variables of
An urban university conducts a transportation survey of its students, faculty, and staff to learn about commuting patterns. The accompanying data file shows each respondent’s most common mode of
The COVID-19 pandemic resulted in the distinctive rise of online learning. At a recent conference, 10 out of 15 professors indicated that they will use elements of online learning post-pandemic.
Develop a logistic regression model for predicting if the respondent is outgoing in adulthood. Use cross-validation to select the appropriate predictor variables. In order to estimate this model, you
A logistic regression is estimated to analyze the probability of complications for male patients resulting from a serious infection. Predictor variables include the patient’s weight, age, and
Choose a college of interest and use the sample of enrolled students to best predict a student’s college grade point average. Explore interactions of the relevant predictor variables and use model
Amanda Chen is the manager of a subscription firm that sells products on a scheduled time basis. She would like to analyze the impact on subscription due to a recent marketing initiative where
Develop a model for predicting a player’s salary. For predictor variables, consider age (quadratic effect), height, weight, and relevant performance measures. Use model selection criteria to assess
The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the software product group with a college degree to develop the logistic regression
Choose two comparable college towns. Develop a predictive, model for the sale price of a house for each college town. Explore loglinear transformations, dummy variables, and interactions of the
The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the hardware product group with a college degree to develop a regression model that
Visit a public health website such as the World Health Organization (https://covid19.who.int/) and the U.S. Centers for Disease Control and Prevention (https://www.cdc.gov/) and explore the COVID-19
Estimate and interpret a logistic regression model to predict COVID testing results using the appropriate predictor variables. Note: You may need to first subset the data based on age, sex, and/or
Automobiles, including cars and light trucks, are the most held nonfinancial assets among Americans, which are often financed through loans. Peter Firsov works in the car loan division of a major
Subset the data to include any one county of your choice. Develop a logistic regression model to analyze the probability of a head-on crash using predictor variables such as the weather condition,
The accompanying file contains historical data for 400 customers related to automobile loans. The information includes whether the customer defaulted on the loan (Default = 1 for default, 0
A logistic regression model is estimated to analyze the probability of complications for male patients resulting from a serious infection. Predictor variables include the patient’s weight and age
The manager is concerned about the attrition rate at her gym. She would like to identify the profile of loyal members who retain the membership for at least one year. The accompanying data file
Consider the accompanying data file to estimate the logistic regression model for predicting loyalty (Loyal equals 1 if the member stayed at the gym for at least one year, 0 otherwise). Predictor
Consider the accompanying data file for predicting an interview call (Yes or No). Use the k-fold cross validation method, with k = 4, to compare the accuracy rates of two logistic regression models.
Use the accompanying data file to analyze subscription (Subscribe equals 1 if a customer subscribes, 0 otherwise). Also included in the data file are the percentage discount (Discount) and the
A recent study analyzed the influence of looks on a candidate’s chances of getting called for an interview. Interestingly, more interviews were granted to plain looking women than to attractive
Use the accompanying data file to analyze loyalty (Loyal equals 1 if the member stayed at the gym for at least one year, 0 otherwise). Also included in the file are the member’s age and income (in
Use the accompanying data file to analyze subscription (Subscribe equals 1 if a customer subscribes, 0 otherwise). Also included in the file are the percentage discount (Discount) and the
Subset the data set to include only college-educated sales professionals in the software product group. Predict whether the sales professional will receive a high (9 or 10) net promoter score (NPS)
Subset the data to include only those individuals who lived in an urban area. Predict whether or not an individual’s marriage will end up in a divorce, a separation, or a remarriage using predictor
Amazon.com, Inc., was a money-losing company when it went public on May 15, 1997, with an IPO valued at a modest $438 million. Amazon has since had an epic run as a public company, worth over a
Subset the data to include only one of the colleges. Predict whether an admitted applicant will eventually decide to enroll at the college using predictor variables such as gender, race, high school
Subset the data to include only the accidents that occured in one city or during one month. Predict whether or not a car crash will result in fatality or severe injuries by using predictor variables
Develop a model to predict COVID testing results using predictor variables such as whether an individual has certain symptoms (i.e., cough, fever, sore throat, shortness of breath, and headache),
A linear trend model estimated from 30 days of data is given by y ̂ = 80.20 + 0.62t . Use the estimated model to forecast y for the next two days.
COVID-19 disease caused a worldwide pandemic in 2020 and necessitated the need for public health organizations to gather and provide COVID-19 data to study the spread of the disease. Visit
Subset the data to select only those individuals who lived in an urban area. Reduce the dimensionality of the data by converting numerical variables such as age, height, weight, number of years of
Select the data for one of the three colleges. Reduce the dimensionality of the data by converting numerical variables such as high school GPAs, college GPAs, SAT scores, and ACT scores into a
Subset the data to include only the employees who work in the hardware division and have a college degree. Reduce the dimensionality of the data by converting numerical variables such as age, years
Subset the data to include only those individuals who lived in an urban area. Develop a decision tree model to predict an individual’s body mass index (BMI) or whether an individual is going to be
Subset the data to include only the accidents that occurred in one city or during one month. Develop a decision tree model that predicts whether an automobile accident results in fatal or severe
Subset the data to include only college-educated sales professionals in the software product group. Develop a decision tree model to predict whether or not the sales professional will receive a high
Develop a series of decision tree models to predict how likely a given university applicant will be accepted by the colleges based on the applicant’s sex, race, high school GPA, SAT/ACT score, and
Develop a decision tree model to predict the sale price of a house by using predictor variables, such as number of bedrooms, number of bathrooms, home square footage, lot square footage, and age of
Subset the data to include only one of the three colleges. Group college applicants into clusters based on categorical variables of your choice (e.g., sex, parent’s education). Determine the
Subset the data to include only one of the three colleges. Find a combination of numerical and categorical variables to include in cluster analysis. Determine the appropriate number of clusters and
Subset the data set to include only sales professionals in one of the two product groups. Cluster the sales professionals based on numerical variables of your choice (e.g., age, salary). Determine
Group NBA players into clusters based on either their career performance or performance statistics from a particular season (e.g., 2013–2014). Determine an appropriate number of clusters, and write
Subset the data set to include only those individuals who lived in an urban area. Cluster the individuals using a combination of numerical and categorical variables. Determine the appropriate number
Perform association rule analysis on the positive COVID-19 tests. Which attributes of the patients tend to be present simultaneously for those patients who tested positive for COVID-19? Cluster the
Consider a major Internet company whose social media platform you use regularly. Suppose this company is considering purchasing one of its competitors to gain market share. Develop a spreadsheet
A real estate developer wants to analyze the profitability of developing a new residential community with 100 single-family homes and 200 apartment units. Research the costs of real estate
An airline company is going through a major cost reduction effort that involves reducing the number of flights by 20%, increasing fuel efficiency by 5%, and offering to 10% of the pilots and flight
The accompanying spreadsheet model, which is designed to analyze profits, contains an error.a. Use the model auditing tools to identify the error. Is the error due to circular reference, incorrect
The accompanying spreadsheet model, which is designed to compute student grades, contains some errors.a. Show and review the formulas in the spreadsheet model. Which cells are most likely to contain
The accompanying spreadsheet model, which is designed to compute commissions and salaries, contains some errors.a. Use the model auditing tools and techniques to identify the errors. Are the errors

Showing 400 - 500 of 946