Questions and Answers of Business Analytics Data

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 2800 - 2900 of 2834