Questions and Answers of Microsoft Excel Data Analysis 7th

The data in the Dow.xlsx file contains the values of the Dow Jones Industrial Average for January 2–August 10, 2010. Create a line sparkline to show the ups and downs of the market. 879 6 E 8
Use win/loss sparklines to capture the market’s ups and downs. Again, use the Dow.xlsx file. 879 6 E 8 City 9 New York 10 Rochester 11 Utica 12 Syracuse 13 Buffalo 14 Ossining 15 Ithaca 16
The Goals.xlsx file shows the percentage amount by which bank branches met or failed to meet their goals each month. Summarize this data with win/loss sparklines. 879 6 E 8 City 9 New York 10
The Delldata.xlsx file contains monthly returns for the Standard & Poor’s stock index and for Dell stock. The beta of a stock is defined as the slope of the least-squares line used to predict
The Delldata.xlsx file contains monthly returns for the Standard & Poor’s stock index and for Dell stock. The beta of a stock is defined as the slope of the least-squares line used to predict
If you believe a recession is coming, would you rather invest in a high-beta stock or a low beta stock?The Delldata.xlsx file contains monthly returns for the Standard & Poor’s stock index and
What percentage of the variation in home value is explained by variation in house size?
You are going to build a 500-square-foot addition to your house. How much do you think your home value will increase as a result? 123 2 4 5 6 7 8 9 10 11 A B Square Footage Value 2000 2200 2400 3000
During a month in which the market goes up 5 percent, you are 95 percent sure that Dell’s stock price will increase between which range of values?
We know that 32 degrees Fahrenheit is equivalent to 0 degrees Celsius, and that 212 degrees Fahrenheit is equivalent to 100 degrees Celsius. Use the trend curve to determine the relationship between
The Betadata.xlsx file contains the monthly returns on the Standard & Poor’s index, as well as the monthly returns on Cinergy, Dell, Intel, Microsoft, Nortel, and Pfizer. Estimate the beta of
A 3,000-square-foot house is selling for $500,000. Is this price out of line with typical realestate values in Bellevue? What might cause this discrepancy?
The Electiondata.xlsx file contains for several elections the percentage of votes Republicans gained from voting machines (counted on election day) and the percentage Republicans gained from absentee
For which company does exponential growth have the worst fit with its revenue growth?
For which company does exponential growth have the best fit with its revenue growth?
The Dailydow.xlsx file gives daily values for the Dow Jones Industrial Average Index during the period 1996–2010. What is the R-squared value when you predict tomorrow’s Dow Jones from today’s
The Oldfaithful.xlsx file gives the duration between eruptions of the Old Faithful geyser and the length of the next eruption. Suppose it has been four minutes since the last eruption. You are 95
For each company, fit an exponential trend curve to its sales data. A1 1 2 3 4 5 6 7 8 10 11 12 13 14 15 16 A Dell sales Year 1 2 3 4 5 6 7 8 9 10 11. x ✓ fx B fx Dell
A drug can be produced by using a 400-degree, 300-degree, or 200-degree oven. You are given the pounds of the drug yielded when various batches are baked at different temperatures. Answer the
The Impalas.xlsx file contains the prices of 2009, 2008, 2007, and 2006 Impalas during 2010. From this data, what can you conclude about how a new car loses its value as it grows older?
The Problem7data.xlsx file contains Google’s annual revenues during the years 2005–2013. Use this data to estimate Google’s CAGR and predict Google’s 2014 revenue.
The Moore.xlsx workbook gives the number of transistors per integrated circuit for the years 1974–2014. The famous Moore’s Law states that chip capacity doubles approximately every two years. Is
Use the fax-machine data to model the relationship between the cumulative fax machines produced and the total production cost.
Use the fax-machine data to model the relationship between the cumulative fax machines produced and the average production cost per machine.
The Dow.xlsx file contains the monthly returns of the 30 stocks that make up the Dow Jones Industrial Average. Find the correlations between each pair of stocks. Then, for each stock, use conditional
NFL teams play 16 games during the regular season. Suppose the standard deviation of the number of games won by all teams is 2, and the correlation between each pair of the numbers of games a team
Determine the relationship between yield, size, temperature, and pressure. Fizzy Drugs wants to optimize the yield from an important chemical process. The company thinks the number of pounds
Discuss the interactions between pressure, size, and temperature. Fizzy Drugs wants to optimize the yield from an important chemical process. The company thinks the number of pounds produced each
What settings for temperature, size, and pressure would you recommend? Fizzy Drugs wants to optimize the yield from an important chemical process. The company thinks the number of pounds produced
The file named Countryregion.xlsx contains the following data for several underdeveloped countries/regions:Infant mortality rateAdult literacy ratePercentage of students finishing primary schoolPer
The file named Baseball96.xlsx gives the runs scored, singles, doubles, triples, home runs, and bases stolen for each Major League Baseball team during the 1996 season. Use this data to determine the
Resolve our drug example assuming that a minimum demand of 200 units for each drug must be met. Report for patient XX_XX_XX Drug Amitriptyline Citalopram Clomipramine Escitalopram Imipramine
The file named Cardata.xlsx provides the following information for 392 different car models:CylindersDisplacementHorsepowerWeightAccelerationMiles per gallon (MPG)Determine an equation that can be
The file named Priceads.xlsx contains weekly unit sales of a product as well as the product price and advertising expenditures. Explain how advertising and product price influence unit sales.Price
The file Teams.xlsx contains the runs scored, hit-by-pitcher, walks, singles, doubles, triples, and home runs for Major League Baseball teams during the 2000–2006 seasons. Solve the following
A hitter’s on-base percentage (OBP) is calculated as follows:(Hit-by-Pitcher + Walks + Hits ) / (At Bats + Hit-by-Pitcher + Walks + Sacrifice Flies)A hitter’s slugging percentage (SLG) is the
The file named NFLinfo.xlsx contains the following data for NFL teams during the 2003– 2006 seasons:Margin Number of points by which a team outscores its opponentNYP/A Yards gained passing per pass
The file named Qbinfo.xlsx lists quarterback ratings for NFL quarterbacks during the 2009 season. The quarterback rating is based on the quarterback’s completion percentage, the percentage of
In the file named Problem13data.xlsx, you are given weekly cookie sales at a supermarket. You are also told for each week whether there was a price cut and whether the product was on display. Explain
A drug company is trying to determine how pressure, temperature, and container size influence product yield for a new drug. In the file named Problem14data.xlsx, you are given the yield on several
In the worksheet titled GreetingCard there are some cost and revenue numbers for a companythat sells greeting cards. Information about the costs/revenues of the company will be enteredin cells B1:B7.
You are given the number of almond cream croissants soldeach day by the French Rivera Bakery (corner of Chimney Rock and Rivera). You are also given whether the day is sunny or cloudy. Develop an
For patients of four cardiologists, you are given the number of days the patients stayed in the hospital after open-heart surgery. Answer the following questions:Is there evidence that the doctors
You believe that pressure (high, medium, or low) and temperature (high, medium, or low) influence the yield of a production process. Given this theory, determine the answers to the following
You are trying to determine how the particular sales representative and the number of sales calls (one, three, or five) made to a doctor influence the amount (in thousands of dollars) that each
Answer the questions in Problem 2 using the new data in the Problem 3 worksheet.Problem 2You are trying to determine how the particular sales representative and the number of sales calls (one, three,
The file named Coupondata.xlsx contains information on the sales of peanut butter for weeks when a coupon was issued (or not) and advertising was done (or not) in the Sunday paper. Describe how the
The file named Ch56data.xlsx contains quarterly revenues for GM, Ford, and GE. Construct a four-quarter moving average trend curve for each company’s revenues. Describe what you learn from each
Are the events A and Not A mutually exclusive?
Can mutually exclusive events be independent?
Assume every adult is a man or a woman. Suppose 10 percent of all adults watch The Bachelor. Assume that 80 percent of The Bachelor’s viewers are women and 50 percent of all adults are men. Compute
In our flood-engine example, you are told that an engine had problems. What is the probability the engine had prior flood damage?
Use the BINOM.DIST function to verify that the BINOM.INV function yields the correct answer to my Village Deli example.
I make 55 percent of my free throws. If I shoot 400 free throws, what is the chance that I make between 200 and 300 free throws inclusive?
What hourly arrival rate would ensure that the chance that at least 150 customers arrive at Central Forest in three hours would equal 0.5?
The Problem10data.xlsx file gives the number of touchdown passes thrown by each NFL quarterback in 2014. Determine the Z-score for each quarterback, and use conditional formatting to highlight all
The file named USC.xlsx contains the USC football team’s margins of victory for the years 2005–2009 and the bookmaker’s forecast (before the game) for the USC margin of victory. Does this data
For the period January 2, 2021, through the current date, import daily stock data for Walmart, Facebook, and CVS.
Import and chart monthly Bitcoin prices for the years 2014 to the present.
Import all possible weekly exchange rate combinations between the Mexican peso, the US dollar, and the euro, starting with the beginning of 2021.
Resolve this chapter’s drug-distribution example, assuming that demand in the West region increases to 13,000.
How can the AutoSum feature be used to help set up transportation problems?
You may have noticed the Value Of option next to Max and Min in the Solver Parameters dialog box. Consider the chapter’s example. If you enter 90,000 in the Value Of section of the dialog box and
Use Solver to determine the minimum number of coins needed to make change for 92 cents.
An oil company is considering 12 drilling projects. The NPV and money needed to complete each project are given in the file named Problem7data.xlsx. Fifty-million dollars can be spent on completing
I want to fill a backpack with items that will give me maximum benefit on a hiking trip. The weight in pounds and benefit for each item are given in the file named Problem8data.xlsx. The backpack can
You manufacture expensive necklaces for world royalty. You have enough workers to make three different necklaces. The sales price for each necklace, the available jewels, and the number of jewels
I am borrowing $15,000 to buy a new car. I am going to make 60 end-of-month payments. The annual interest rate on the loan is 10 percent. The car dealer is a friend of mine, and he will allow me to
Solve the retirement-planning problem, assuming that withdrawals occur at the end of each year and contributions occur at the beginning of each year.
In the retirement-planning example, suppose that during Year 1, your salary is $40,000 and your salary increases 5 percent per year until your retirement. You want to save the same percentage of your
Solve our mortgage example assuming that payments are made at the beginning of each month.
In the mortgage example, suppose that you want your monthly payment to increase by $50 each month. What should each month’s payment be?
The file named Nfl01.xlsx contains scores for every regular season game during the 2001 NFL season. Rate the teams.
For the 2004 season, devise a method to predict the actual score of each game.
True or false: An NFL team could lose every game and be an above-average team.
The file named Nba01_02.xlsx contains scores for every game during the 2001–2002 NBA season. Rate the teams.
The file Nba02_03.xlsx contains scores for every regular season game during the 2002–2003 NBA season. Rate the teams.
The file named Worldball.xlsx contains all the scores from the 2006 World Basketball Championships. Rate the teams. Who were the best three teams?
Our method of rating teams works fine for football and basketball. What problems arise if you apply these methods to hockey or baseball?
The file NFL2012data.xlsx contains scores of all the NFL 2012 regular-season games. Rate the teams. Even though the Colts were 10–6, your ratings have the Colts as well below the average team. Can
Use the Winters method to forecast one-quarter-ahead revenues for Apple.
Use the Winters method to forecast one-quarter-ahead revenues for Amazon.com.
Use the Winters method to forecast one-quarter-ahead revenues for Home Depot.
Use the Winters method to forecast total revenues for the next two quarters for Home Depot.
Use a Forecast Sheet to forecast 2016 passenger miles using data through 2015. Compute the MAPE for your forecasts.
How can you use the techniques outlined in this chapter to predict the daily sales of pens at Staples?
If you had several years of data, how would you incorporate a trend in the analysis?
Find the optimal solution to the warehouse problem if three warehouses are allowed.
A box must enclose 4 cubic feet of volume. You must choose the height, length, and width of the box. Top and bottom sides of the box cost 30 cents per square foot, and the other four sides of the box
Suppose you throw a shotput from a height H with an initial velocity V at an angle θ. If H = 5 feet and V = 100 feet per second, what angle will cause the shotput to travel the most distance? Assume
The workbook Problem6data.xlsx contains cumulative units of fax machines produced and the unit cost of producing a fax machine. Let y = Unit Cost of a Fax Machine and x = Cumulative Units of Fax
Use Evolutionary Solver to solve Problem 4 in Chapter 70, “Using Solver for capital budgeting.”Data from in Problem 4 in Chapter 70Jill is trying to determine her class schedule for the next
“Warehouse location and the GRG Multistart and Evolutionary Solver engines,” in which we locate two warehouses with the additional assumption that each warehouse can ship at most 120,000 units.
The file Problem6data.xlsx contains data on 13 one-hour meetings involving 10 people. A 1 indicates the people involved in each meeting. Meetings 6 and 7 cannot be at the same time, and of course, a
Solve the assignment-of-workers example assuming that worker satisfaction is twice as important as the bosses’ ratings.
If you draw two cards (without replacement) from a deck of cards, what is the chance that both are clubs?
Use the monthly stock returns in the Volatility.xlsx file to determine estimates of annual volatility for Intel, Microsoft, and GE.
The file Lawdata.xlsx gives the LSAT scores and law school GPAs for 15 law-school students. Based on this data, you are 95 percent sure the correlation between LSAT score and GPA is between which two
On September 25, 2000, JDS Uniphase stock sold for $106.81 per share. On the same day, a $100 European put expiring on January 20, 2001 sold for $11.875. Compute an implied volatility for JDS
Change the chapter example to create a spider plot in which each input varies up to 80 percent of its base value (in increments of 20 percent).

Showing 100 - 200 of 914