All Matches

Solution Library

Expert Answer

Textbooks

Search Textbook questions, tutors and Books

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Tutors
Study Help
Hire a Tutor
AI Study Help New

Search
Sign In
Register

study help
business
business analytics data

Questions and Answers of Business Analytics Data

The file P02_18.xlsx contains daily values of the S&P Index from 1970 to early 2012. It also contains percentage changes in the index from each day to the next.a. Create a new variable President that
The file P03_18.xlsx contains the times in the Chicago marathon for the top runners each year (the top 10,000 in 2006 and the top 20,000 in 2007 and 2008).a. Merge the data in these three sheets into
The file P02_43.xlsx contains U.S. Bureau of Labor Statistics data on the year-to-year percentage changes in the wages and salaries of workers in private industries, including both white-collar and
Define data mining and some common approaches used in data mining.
Explain how cluster analysis is used to explore and reduce data.
Apply cluster analysis techniques using XLMiner.
Explain the purpose of classification methods, how to measure classification performance, and the use of training and validation data.
Apply k-Nearest Neighbors, discriminant analysis, and logistic regression for classification using XLMiner.
Describe association rule mining and its use in market basket analysis.
Use XLMiner to develop association rules.
Use correlation analysis for cause-and-effect modeling?
For the Excel file Pharmaceuticals, normalize each column of the numerical data (i.e., compute a Z-score for each of the values) and then compute the Euclidean distances between the following
For the four clusters identified in Example 10.6, find the average and standard deviations of each numerical variable for the schools in each cluster and compare them with the averages and standard
For the Colleges and Universities data, use XLMiner to find four clusters using each of the other clustering methods (see Figure 10.13); compare the results with Example 10.6.
Use the k-NN algorithm to classify the new data in the Excel file Mortgage Defaulters Additional using only credit score and value of loan as input variables.
For the PC Purchase Data, identify association rules with the following input parameters for the XLMiner association rules procedure:a. support = 3; confidence = 90,b. support = 7; confidence = 90,c.
The Excel file Cosmetics Data provides data on purchases of different cosmetic items at a large chain store. Develop a market basket analysis using the XLMiner association rules procedure with the
Explain how to use simple mathematics and influence diagrams to help develop predictive analytic models.
Apply principles of spreadsheet engineering to designing and implementing spreadsheet models.
Use Excel features and spreadsheet engineering to ensure the quality of spreadsheet models.
Develop and implement analytic models for multipletime-period problems.
Describe the newsvendor problem and implement it on a spreadsheet.
Describe how overbooking decisions can be modeled on spreadsheets.
Explain how model validity can be assessed.
Perform what-if analysis on spreadsheet models.
Construct one- and two-way data tables.
Use data tables to analyze uncertainty in decision models.
Use the Excel Scenario Manager to evaluate different model scenarios.
Apply the Excel Goal Seek tool for break-even analysis and other types of models.
Create data tables and tornado charts using Analytic Solver Platform.
Use Excel tools to create user-friendly Excel models and applications.
Develop a spreadsheet model for gasoline usage scenario, Problem 4 in Chapter 1, using the data provided. Apply the principles of spreadsheet engineering in developing your model.
Develop a spreadsheet model for Problem 5 in Chapter 1.Apply the principles of spreadsheet engineering in developing your model. Use the spreadsheet to create a table for a range of prices to help
A company records the following components of fixed and variable costs for a product.Fixed Cost(in dollars): Plaint Maintenance - 15,000 Salaries - 40,000 Depreciation - 100,000 Rent - 8,000
For inventory problems, the cost is a function of the order size. A company has collected the following data for one of its product.Annual requirement, R = 12,000 Ordering cost per order, S = 150
Thomas wants to predict the sales figures of his company for the upcoming year. On the basis of historical data, he concludes that a linear function passes through the observed data points for the
A stockbroker calls on potential clients from referrals.For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty-five percent of those interested are found not
The director of a nonprofit ballet company in a medium-sized U.S. city is planning its next fundraising campaign. In recent years, the program has found the following percentages of donors and gift
Apply the data-validation tool to the Bank Data Excel file with an error alert message box to ensure that a two-digit number is correctly entered under Age, the data entered under ZipCode should not
Insert a spin button in the car lease purchase model to change the discount rate in cell F8 from 1% to 10% in increments of one-tenth.
For the Pro Forma Income Statement model in the Excel file Net Income Models (Figure 11.7), add a scroll bar form control to allow the user to easily change the level of sales from 3,000,000 to
The Excel sheet Travelling Salesman contains data on cost incurred by salesman on travelling from one city to another. Using this data matrix, add list box controls so that manager can choose two
Problem 15 in Chapter 1 posed the following situation:A manufacturer of mp3 players is preparing to set the price on a new model. Demand is thought to depend on the price and is represented by the
Problem 16 in Chapter 1 posed the following situation:The demand for airline travel is quite sensitive to price. Typically, there is an inverse relationship between demand and price; when price
Develop a spreadsheet model for determining value, using the simple valuation function Value = D/(r - g), where r is the discount rate =10% and g is the growth rate = 4% and D is dividend = 1.25. Use
The booking price for motivational seminar (held every week) is charged at $650 per booking, with maximum seats = 100.The total cost for arranging such a seminar comes to $35,000 per week. The
For the Koehler Vision Associates model you developed in Problem 13, use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand.
For the stockbroker model you developed in Problem 10, use data tables to show how the commission is a function of the number of calls made.
For the nonprofit ballet company fundraising model you developed in Problem 11, use a data table to show how the amount varies based on the number of solicitations.
For the garage-band model you developed in Problem 7, define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for the following scenarios:Scenarios for Problem
Think of any retailer that operates many stores throughout the country, such as Old Navy, Hallmark Cards, or Radio Shack, to name just a few. The retailer is often seeking to open new stores and
For the garage-band model in Problem 7, construct a tornado chart and explain the sensitivity of each of the model’s parameters on total profit.
For the new-product model in Problem 9, construct a tornado chart and explain the sensitivity of each of the model’s parameters on the NPV of profit.
• Create Microsoft Excel charts.
• Determine the appropriate chart to visualize different types of data.
• Sort a data set in an Excel spreadsheet.
• Apply the Pareto Principle to analyze data.
• Use the Excel Autofilter to identify records in a database meeting certain characteristics.
• Explain the science of statistics and define the term statistic.
• Construct a frequency distribution for both discrete and continuous data.
• Construct a relative frequency distribution and histogram.
• Compute cumulative relative frequencies.
• Find percentiles and quartiles for a data set.
• Construct a cross-tabulation (contingency table).
• Use PivotTables to explore and summarize data.
• Use PivotTables to construct a cross-tabulation.
• Display the results of PivotTables using PivotCharts.
The Excel file Traveler contains the months of a year and the number of travelers that arrive by flight in the morning (AM) and the evening (PM). Prepare a line chart showing the number of AM and PM
The Excel file Sales contain list of the products in different regions. Sort the list of products in ascending order of the sales volume in Asia. Arrange the regions(from left to right) in ascending
The Excel file Expenditure shows the spending of a country on various sports during a particular year.Create a pie chart and determine the percentage of total spending on tennis.
The Excel file McDonald’s contains the monthly sales data of their burgers in a year. Construct the histogram and predict which type of burger has the highest sale.
Convert the Store and Regional Sales database to an Excel table. Use the techniques described in Example 3.11 to find:a. the total number of units soldb. the total number of units sold in the South
Convert the Purchase Orders database to an Excel table. Use the techniques described in Example 3.11 to find:a. the total cost of all ordersb. the total quantity of airframe fasteners purchasedc. the
The total runs scored by 30 players in a test cricket match in the year 2011 were recorded to determine which score was the highest and which the lowest.The runs are:423, 369, 387, 411, 393, 394,
The Excel sheet Engagement contains the number of rings sold each day of the week in a jewelry store chain in different cities across India. Use sparklines to summarize the data.
A community health-status survey obtained the following demographic information from the respondents:Age Frequency 18 to 29 297 30 to 45 743 46 to 64 602 65 369 Compute the relative frequency and
The Excel sheet Sampling contains the responses on a scale of 1 to 5 from consumers regarding a product.Construct a cluttered pivot table, and show the sampling data in the histogram.
Using the data in the Excel sheet Hardware Store, construct a pivot table and calculate the percentage of sales , the total revenue generated in the month of March and the percentage of sales for the
A marketing researcher surveyed 92 individuals, asking them if they liked a new product concept or not.The results are shown below:Yes No Male 30 50 Female 6 6 Convert the data into percentages. Then
PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small-tractor market. As we noted in the case in Chapter 1, PLE sells their
As noted in the case in Chapter 1, the supply chain worksheets provide cost data associated with logistics between existing plants and customers as well as proposed new plants. Ms. Burke wants you to
Ms. Burke would also like a quantitative summary of the average responses for each of the customer attributes in the worksheet 2014 Customer Survey for each market region as a cross-tabulation (use
Propose a monthly dashboard of the most important business information that Ms. Burke can use on a routine basis as data are updated. Create one using the most recent data. Your dashboard should not
Explain how judgmental approaches are used for forecasting.
List different types of statistical forecasting models.
Apply moving average and exponential smoothing models to stationary time series.
State three error metrics used for measuring forecast accuracy and explain the differences among them.
Apply double exponential smoothing models to time series with a linear trend.
Use Holt-Winters and regression models to forecast time series with seasonality.
Apply Holt-Winters forecasting models to time series with both trend and seasonality.
Identify the appropriate choice of forecasting model based on the characteristics of a time series.
Explain how regression techniques can be used to forecast with explanatory or causal variables.
Apply XLMiner to different types of forecasting models.Forecasting Techniques 9
Search the Conference Board’s Web site to find business cycle indicators, and the components and methods adopted to compute the same. Write a short report about your findings.
The Excel file New Registered Users provides data on monthly new registrations on a Web site for four years. Compare the three-month and twelve-month moving average forecasts using the MAD
Consider the data in the Excel file Internet Users.Use simple linear regression to forecast the data.What would be the forecast for the next three years?
Develop a multiple linear regression model with categorical variables that incorporate seasonality for forecasting the deaths caused by accidents in the U.S.Use the data for years 1976 and 1977 in
The Excel file Census Data provides annual average expenditures and income levels of the people in the U.S. Develop forecasting models for each of the data type. What do your models predict for the
Choose an appropriate forecasting technique for the data in the Excel file Inflation Rates US and find the best forecasting model. Explain how you would use the model to forecast, and how far into
Choose an appropriate forecasting technique for the data in the Excel file Gaussian Response and find the best forecasting model. Explain how you would use the model to forecast and how far into the

Showing 1400 - 1500 of 2834

First
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Last

Services

Sitemap
Fun
Definitions
Become Tutor
Study Help Categories
Recent Questions
Expert Questions

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Campus Ambassador

Secure Payment

Download Our App

© 2024 SolutionInn. All Rights Reserved