Questions and Answers of Business Analytics Data

Predicting Delayed Flights. The file FlightDelays . jmp contains information on all commercial flights departing the Washington, DC area and arriving at New York during January 2004. For each flight
Predicting Prices of Used Cars (Regression Trees). The file ToyotaCorolla.jmp contains the data on used cars (Toyota Corolla) on sale during late summer of 2004 in The Netherlands. It has 1436
Predicting Used Car Prices (Bootstrap Forest and Boosted Trees). Return to the Toyota Corolla data, and refit the partition model. (Hint: Use the recall button in the partition dialog). This time,
Predicting Flight Delays (Bootstrap Forest and Boosted Trees). We return to the flight delays data for this exercise, and fit both a bootstrap forest and a boosted tree to the data. Use scheduled
Credit Card Use. Consider the following hypothetical bank data on consumers' use of credit card credit facilities in Table 11.3 . Create JMP data, and create a neural network like that used for the
Car Sales. Consider again the data on used cars (ToyotaCorolla.jmp) with 1436 records and details on 38 attributes, including Price, Age, KM, HP, and other specifications. The goal is to predict the
Statistical distance between records can be measured in several ways. Consider Euclidean distance, measured as the square root of the sum of the squared differences. For the first two records in
The dataset ToyotaCorolla.jmp contains data on used cars on sale during the late summer of 2004 in the Netherlands. It has 1436 records containing details on 38 attributes, including Price, Age,
Describe specific types of questions asked in marketing for a specific company of your choice that might require descriptive, diagnostic, predictive, prescriptive, and adaptive/autonomous analytics,
Using the HackUsNow.xlsx data, create a data visualization in Tableau to answer the question “Which location has the most hacks?”
The dataset HackUsNow.xlsx includes an additional column labeled Computer Age that has not been analyzed yet. Ask a question related to Computer Age and hacks. Then create a data visualization in
How does the use of pivot tables differ between descriptive analytics and diagnostic analytics? Provide an example.
DJI Mavic is attempting to understand its sales and cost structure to allocate appropriate personnel to its sales force. Download the DJI Mavic Drone Sales Journal data set in Excel. Note the sales
SkyDio is attempting to understand its sales and cost structure to understand its overall profitability in relation to each sale. Download the SkyDio Drone Sales Journal data set in Excel. Note the
Which of the following is not part of operations?a. Advertisingb. Integrating information technologyc. Ordering raw materialsd. Scheduling production
Let’s examine the Dell computer order process. A customer places an online order for a computer and then pays for the order. After the order is placed and paid for, Dell orders the parts, vendors
A chief information officer (CIO) is the corporate executive in charge of the strategy and implementation of the company’s IT. In other words, the CIO is in charge of all IT personnel, processes,
A realtor is analyzing the relationship between the sale price of a house (Price in $), its square footage (Sqft), the number of bedrooms (Beds), the number of bathrooms (Baths), and a Colonial dummy
The accompanying data file includes monthly data on the personal savings rate (Savings in %) and the personal disposable income (Income in $ billions) in the U.S.a. Estimate the linear model Savings
Consider the accompanying data file to estimate the logistic regression model for predicting college admission (Admit equals 1 if admitted, 0 otherwise). Predictor variables include the applicant’s
An investor seeking to gain from the positive momentum of a company’s stock price analyzes 53 weeks of stock price data. The accompanying file includes the data.a. Estimate and interpret the linear
A county has been battling COVID for the last few months. The accompanying data file includes the daily number of new COVID cases in this county for six weeks. It is known that the number of COVID
A venture capitalist is considering investing in five different startups that conduct research for developing and improving all-electric and hybrid vehicular technologies. The first two startups
At a disaster and emergency relief operation, volunteers are needed 24 hours a day to support many activities such as search and rescue, first aid and basic medical services, and preparation of food
Given all the advanced technologies presented in this chapter, what skills will employers be looking for in new hires?
Which of the following is NOT true of a smart contract?a. It is a legal contract between members of the blockchain.b. It is programmed into the blockchain.c. It is self-executing based on met
Instead of paper or electronic tickets, some airlines now want to use your face as a boarding pass. At the 20 largest airports in the United States, the U.S. Customs and Border Protection Agency is
Bitcoin is an application of:a. Artificial intelligence.b. Blockchain.c. Machine learning.d. Neural networks.
A company has work sites all over a large city. The company pays employees based on the number of hours worked on the sites. The company also has valuable assets at each work site. How could the
How is voice analytics different than the natural language processing technology behind Amazon’s Alexa and Apple’s Siri?
A good candidate for robotic process automation is a task with a:a. High number of exceptions.b. High volume of processed data.c. Low number of human errors.d. Process that changes frequently.
How could visual analytics help retailers make product recommendations to customers?
Kuki is an example of:a. An AI-based chatbot.b. AIOps.c. A robo-adviser.d. A a rules-based chatbot.
What term means using market signals to predict customer demand for the next 10 to 18 months to manage production operations and inventory?a. Data miningb. Demand planningc. Fintechd. Predictive
How can chatbots be used to automate the supply chain?
Which of the following items would be considered strong AI?a. A robot that can beat the best human chess player in the world.b. A robot that can perform a bank reconciliation of millions of
Companies typically use leases to rent property, buildings, and equipment. A lease is based on a lease agreement, which a legal contract between two parties. The tax law determines how the lease
Which type of technology is based on the human brain?a. Artificial neural networksb. Blockchainc. Data miningd. Website scraping
AI can develop a personal network for banking customers (specifically, all the entities associated with a customer) to help identify potential money laundering. When conducting a financial statement
The types of business analytics are not related.a. Falseb. True
Describe how the first four types of analytics are related to the fifth type, adaptive autonomous analytics.
Which type of analytics answers the question “What action(s) should we take?”a. Adaptive/autonomousb. Descriptivec. Diagnosticd. Predictivee. Prescriptive
Match the branch of operations (Human Resources, IT Operations, Supply Chain) to the operations questions. Operations Question How many minutes of downtime did the company website have last
Which of the following collects data at remote points and transmits the data to monitoring equipment?a. Fill rateb. Operations dashboardc. Supply chaind. Telemetry
A human resource management (HRM) system can be set up to include information about a (potential) employee from the person’s public social media activity including likes/dislikes and tweets. Do you
Business analysts can use regression to assess the relationship between variables and to predict future dependent-variable outcome values based on a given independent variable. For the following
If an executive wanted to see more detailed information about a KPI on a dashboard, which feature would be helpful?a. Drill aroundb. Drill downc. Drill throughd. Drill up
How can companies use telemetry to gather information about employees? Do you believe that it is ethical for companies to use telemetry in this manner? Why or why not?
A scatterplot shows relationships between variables. The following scatterplot graphs the relationship between number of users in the system and system response time. Correlation determines the
Describe how companies can analyze the digital footprint left by employees.
Match the analytics type (descriptive, diagnostic, predictive, or prescriptive) and branch of operations (Human Resources, IT Operations, Supply Chain) to the analytics technique used. Analytics
Data visualization should help companies understand how they are performing. The following data visualization was designed to answer this question: “How many thousands of shirts of each color were
How many new employees were hired during the year?” is a question that can be answered by:a. Descriptive analytics.b. Diagnostic analytics.c. Predictive analytics.d. Prescriptive analytics
Assume that a company has standard operating hours of Monday through Friday, 8 a.m. to 5 p.m. What would be the concern if an employee is entering transactions at 3 a.m. on the weekend? How could a
Data visualizations should clearly present information. Evaluate the clarity of the following data visualization, which answers the question: “How far can different modes of transportation go on
Match the Excel menu option (Data Analysis or Solver) to the analytics technique used. Analytics Technique Used Optimization t-test Regression Profit maximization Cost minimization Excel Menu
“Why has the number of minutes of downtime for our websites increased from last year?” is a question that can be answered by:a. Descriptive analytics.b. Diagnostic analytics.c. Predictive
The Regression option of the Excel Analysis ToolPak was used to determine the relationship between total cost and production units. The results are shown below. What is the regression equation? How
“How many active users will be using the enterprise system in three years?” is a question that can be answered by:a. Descriptive analytics.b. Diagnostic analytics.c. Predictive analytics.d.
Select a branch of operations analytics. Decide which KPIs you would like to see on a dashboard. Identify a target audience and design an appropriate dashboard layout. Provide a rationale for your
This chapter presented some forecasts created in Tableau. How are forecasts differentiated from the actual data?a. Bolded lines are used for forecasts.b. Dashed lines are used for forecasts.c.
Evaluate the design of this data visualization for the hiring process. Total Applications: 13 Ghosted: 5 Final Round: 2 Phone Interview: 1 Coding Challenge Received: 5 Ghosted after Coding Challenge:
Why would a company want to evaluate the IT operations KPI of unsolved tickets per IT service desk employee? How could a company use a KPI equal to the number of unsolved tickets divided by the
“Which employees need to go to training to improve their productivity?” is a question that can be answered by:a. Descriptive analytics.b. Diagnostic analytics.c. Predictive analytics.d.
How could a company use a sensitivity report for the Solver Add-In to improve shipping operations?
Apron Outfitters is a manufacturer of aprons, jackets, and vests for a variety of occupations, including golf caddies, chefs, and carpenters. Assume that Apron Outfitters needs to schedule shipments
To complete an optimization in Excel, which feature would you use?a. Data Analysis ToolPakb. Forecast sheetc. Solver Add-Ind. What-if analysis
Companies want to retain good employees as long as possible because hiring and training new employees is expensive and time consuming. Which of the following techniques can help a company determine
Assume that Hertz wants to understand the relationship between different variables, such as miles driven, car age, and annual maintenance costs. Which of the following techniques can help Hertz
Assume that Hertz wants to estimate the annual maintenance costs for its fleet next year. Which of the following techniques can help Hertz make this prediction?a. Control chartb. Forecastingc.
A heat map is an example of which type of visualization?a. Conditional highlightingb. Conditional formattingc. A temperature gauged. Horizontal analysis
Which type of analytics includes classification, regression, and time series analysis techniques?a. Descriptive analyticsb. Diagnostic analyticsc. Predictive analyticsd. Prescriptive analytics
Suggest questions that General Motors might use each of the following predictive analytics techniques to address.a. Classificationb. Regressionc. Time series analysisd. Analysis of base rates
Which predictive analytics technique would a data analyst use to predict product demand using past product demand values?a. Time series analysisb. Regressionc. Classificationd. Benford’s Law
Which type of analytics determines what input is needed to achieve a desired goal?a. Descriptiveb. Diagnosticc. Predictived. Prescriptive
Which type of technique divides leads into those who are likely to purchase and those who are not?a. Classificationb. Decision treec. Regressiond. Sensitivity analysis
Match the Excel menu option (Data Analysis, What-if Analysis) to the analytics technique used. Analytics Technique Used Average of sales for the last five years Goal-seek analysis to determine the
Match the analytics type (descriptive, diagnostic, predictive, or prescriptive) to the analytics technique used. Analytics Technique Used Summarization of last year's sales data Pivot table for drill
The European Union (EU) General Data Protection Regulation requires internet users to explicitly “opt in” to share their personal information other parties, such as advertisers. In the United
Match the marketing data to the marketing mix component (product, price, place, or promotion) that it would be most helpful for analyzing. Marketing Data Competitor price Order fulfillment
Which term refers to the final product distribution points?a. Conversion pointsb. Leadsc. Marketing channelsd. Marketing mix
Match each marketing question to the analytics type (descriptive, diagnostic, predictive, or prescriptive) that can help answer it. Marketing Question Why did unit sales decrease in the Great Lakes
What combines multiple data visualizations and other analyses to track multiple key performance indicators?a. Marketing dashboardb. Ishikawa diagramc. Marketing mixd. Scenario analysis
A customer relationship management (CRM) system can be set up to include information about a (potential) customer from the person’s public social media activity, including likes/dislikes and posts
Match each marketing question to the relevant marketing mix component (product, price, place, or promotion). Marketing Question What marketing channels should we use? Should we use a cost-plus,
Which phrase refers to the key choices that a company makes to bring a product service to market?a. Marketing channelsb. Marketing mixc. Product life cycled. Root cause
What does the target audience for business analytics help to determine?a. Types of charts used.b. Language and terms used.c. Type of report used.d. Types of charts and reports used as well as the
The stock market typically yields a small positive return each day, but intermittently it yields a high negative return on a few days. What type of distribution describes this behavior?a. Negatively
Assume that Keurig Dr Pepper wants to create a data visualization that compares the total number of cans of Dr Pepper sold in U.S. state. Which of the following charts is BEST way to present
Assume that Keurig Dr Pepper launches a new advertising campaign. To understand the impact of the campaign, the company asks a group of customers to provide three words describing the new campaign.
Which of the following statements is true?a. Although bar charts can represent counts of categorical data, histograms are used only for numerical data.b. Although histograms can represent counts of
When the trend is the most important item to communicate, which of the following statements is true?a. Bar charts are preferable to line charts.b. Line charts are preferable to bar charts.c. Bar
Accounting financial statement data, such as sales and net are most likely to be shown as which type of data?a. Interval datab. Ratio datac. Nominal datad. Ordinal data
Why are data visualizations a good way to present large amounts of data?
Which of the following is a data point outside the maximum or minimum value of the expected range of a box plot?a. Outlierb. Medianc. Meand. Variation
The following pie chart shows how frequently each employee’s computer at HackUsNow has been hacked. Evaluate the pie chart assuming that the analyst is trying to answer this question: “Which
Scatterplots are more meaningful if they include which of the following?a. Times series predictionb. Box plotc. Trend lined. Categorical variable
Why is a line chart a good option for visualizing a forecast?
Exploratory, diagnostic analytics includes which type of visualizations?a. Box plotsb. Scatterplotsc. Pivot chartsd. Times series graphs
Examine the data visualization below. Is it a histogram or a bar chart? How can you? Total Sales 2,000,000 1,500,000 1,000,000 500,000 North Total Sales by Region South Region East West

Showing 1 - 100 of 711