Questions and Answers of Business Analytics Data

Adam is 24 years old and has a 401(k) plan through his employer, a large financial institution. His company matches 50% of his contributions up to 6% of his salary. He currently contributes the
J&G Bank receives an average of 30,000 credit card applications each month. Approximately 60% of them are approved. Each customer charges an average of $2,000 to his or her credit card each
Develop a spreadsheet for calculating the total revenue for the Modern Electronics scenario in Problem 2. Design it so that the price-demand function parameters can easily be changed.Data from
The Schoch Museum is embarking on a five-year fundraising campaign. As a nonprofit institution, the museum finds it challenging to acquire new donors, as many donors do not contribute every year.
Experiment with the portfolio allocation model in Example 11.15 to attempt to find the best solution that maximizes the expected annual return and meets the total weighted risk constraint.Data from
A franchise of a chain of Mexican restaurants wants to determine the best location to attract customers from three suburban neighborhoods. The coordinates of the three suburban neighborhoods are as
ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given here. Develop a model to find the best
For the stockbroker model you developed in Problem 22, use a one-way data table to show how the broker’s commission is a function of the number of calls made.Data from Problem 22A stockbroker calls
For the nonprofit ballet company fundraising model you developed in Problem 23, use a one-way data table to show how the amount varies based on the number of solicitations.Data from Problem 23The
Implement the model you developed in Problem 1 on a spreadsheet and construct a one-way data table to estimate the price for which profit is maximized.Data from Problem 1A manufacturer of kitchen
For the Schoch Museum (Problem 30), use data tables to investigate the impacts of the percentage assumptions used in the model on the cumulative funds raised by the fifth year.Data from Problem 30The
For the engineering admissions situation in Problem 25, apply two-way data tables to analyze the impact on extra funds needed and the number of students who accept scholarships as the acceptance rate
For the ballet company situation in Problem 23, use the Goal Seek tool to find the number of solicitations required to achieve $150,000 in total donations. Data from Problem 23The director of a
For the garage band model you developed in Problem 21, use the Scenario Manager to evaluate profitability for the following scenarios Expected crowd Concessions Expenditure Fixed
For the stockbroker situation in Problem 22, use the Goal Seek tool to find the number of calls needed to achieve a broker commission of $5,000.Data from Problem 22A stockbroker calls on potential
For the gasoline usage situation in Problem 15, apply the Goal Seek tool to find the fuel economy needed to consume 20 gallons per month, with all other data being constant.Data from Problem
Continuing the previous problem, financial data for public companies are available at a number of Web sites.Try importing the data from http://www.google.com/ finance?fstype=ii&q=NYSE:KO
What does it mean that Microsoft’s free Data Mining Add-Ins for Excel represents a “front end” to a “back end” SQL Server Analysis Services (SSAS) server?
Suppose you have a data set that includes all of the professional athletes in a given sport over a given period of time, such as all NFL football players during the 2008–2010 seasons, and you use
Suppose a regression output produces the following 99% confidence interval for one of the regression coefficients: [−32.47, −16.88]. Given this information, should an analyst reject the null
Many people believe that there is a “Friday effect” in the stock market. They don’t necessarily spell out exactly what they mean by this, but there is a sense that stock prices tend to be lower
We hear that teenagers in today’s world spend too much time playing video games. Does this have a significant effect on the grades they earn at school? You could test by this dividing students into
Suppose you have a list of salaries of all professional athletes in a given sport in a given year. For example, you might have the salaries of all Major League Baseball players in 2012. Does it make
Assuming that all else remains constant, what happens to the length of a 95% confidence interval for a population parameter when the sample size is reduced by half? You can assume that the resulting
Create a histogram of the time until first failure for this type of disc player. Then find a 95% confidence interval for the mean time until failure for this type of disc player. Does the shape of
Use Excel to simulate Deming’s red bead experiment, with six workers instead of four. How do the results change when the number of workers is increased to six? What new conclusions, if any, emerge
The site http://cdo.ncdc.noaa.gov/climatenormals/hcs/HCS_51_seq.txt contains monthly data on heating degree-days for states and regions in the U.S. Try importing this data into Excel with a Web
The site http://graphicsweb.wsj.com/php/CEOPAY09.html contains a table of CEO compensation from a Wall Street Journal survey. If you try to import this data into Excel with a Web query, you will fail
The site http://tonto.eia.doe.gov/oog/info/gdu/gaspump.html contains a table of monthly prices of gasoline. Try importing this into Excel with a Web query. (We had no luck, but maybe you will.) Is
Yahoo sites such as http://finance.yahoo.com/q/hp s=AA&a=00&b=29&c=2001&d=00&e=29&f=201 0&g=m contain historical stock prices on public companies and market indexes. Do
The site http://www.stevetheump.com/Payrolls.htm lists payrolls for Major League Baseball teams in several tables. Can you import the data in any (or all) of these tables with Web queries? Does the
Import data of interest into Excel from http://146.142.4.24/cgi-bin/surveymost?eb, a Bureau of Labor Statistics site.
Do a Web search for “Shiller home price data.” Shiller’s indices are leading measures of home prices. Import data of interest into Excel.
Bill Belichick, coach of the New England Patriots, made another somewhat controversial decision in the 2012 Super Bowl game against the New York Giants. Behind by a score of 17 to 15, the Giants had
A customer has approached a bank for a $100,000 one-year loan at a 8% interest rate. If the bank does not approve this loan application, the $100,000 will be invested in bonds that earn a 4% annual
In the SciTools example, we created an Inputs section with the data from the problem statement, and then we cell-referenced these input cells in the tree. Show that you omit the Inputs section and
You have a bowl with 100 pieces of paper inside, each with a person’s name written on it. It turns out that 50 of the names correspond to males and the other 50 to females. You reach inside and
In the 2012 Major League Baseball season, the Baltimore Orioles were ahead after the 7th inning in 74 games, and they won all 74 games. Use an appropriate model to explore how unusual such a streak
The file P03_54.xlsx lists data for 593 movies released in 2011. Obviously, some movies are simply more popular than others, but success in 2011, measured by 2011 gross or 2011 tickets sold, could
Recall that the file Baseball Salaries 2011.xlsx contains data on 843 MLB players in the 2011 season. Using this data set, answer the following questions:a. Find the mean and median of the salaries
The file P02_22.xlsx contains annual trade balances (exports minus imports) from 1980 to 2010.a. Create a times series graph for each of the three time series in this file.b. Characterize recent
The file P02_19.xlsx lists annual percentage changes in the Consumer Price Index (CPI) from 1914 through 2010. Find and interpret the first and third quartiles and the interquartile range for these
The file P02_18.xlsx contains daily values of the Standard & Poor’s 500 Index from 1970 to early 2012. It also contains percentage changes in the index from each day to the next.a. Create a
Recall that the file Baseball Salaries 2011.xlsx contains data on 843 MLB players in the 2011 season. Using these data, create a box plot to characterize the distribution of salaries of all pitchers.
The file DJIA Monthly Close.xlsx contains monthly values of the Dow Jones Industrial Average from 1950 through 2011. It also contains the percentage changes from month to month. (This file will be
The file P02_04.xlsx contains salary data on all Major League Baseball players for each year from 2002 to 2011. (The 2011 sheet is used for examples later in this chapter.) For any three selected
Recall that the file Baseball Salaries 2011 Extra.xlsx contains data on 843 Major League Baseball (MLB) players during the 2011 season. Use StatTools to find the mean, median, standard deviation, and
A researcher is interested in determining whether there is a relationship between the number of room air conditioning units sold each week and the time of year. What type of descriptive chart would
The number of children living in each of a large number of randomly selected households is an example of which data type? Be specific.

Showing 900 - 1000 of 949

1
2
3
4
5
6
7
8
9
10