Microsoft Excel Data Analysis And Business Modeling 7th Edition Wayne Winston - Solutions

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 City 9 New York 10 Rochester 11 Utica 12 Syracuse 13 Buffalo 14 Ossining 15 Ithaca 16
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 Me FL S 698 306 437 Monday Tuesday Wednesday Thursday
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 Rochester 11 Utica 12 Syracuse 13 Buffalo 14 Ossining 15 Ithaca 16 Me FL S 698 306 437 Monday Tuesday
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 monthly return for a stock from the monthly return for the market.I usedslope1.763768666paste
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 monthly return for a stock from the monthly return for the market.I usedslope1.763768666paste
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 for Dell stock. The beta of a stock is defined as the slope of the least-squares line used to
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 3200 3600 2900 C 238139.3695 259711.9508 300953.668 369965.7313 340091.2955 405425.021 345131.0331 D
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 Fahrenheit and Celsius temperatures. When you create your initial chart, you must indicate that the
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 each stock.
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 ballots (counted after election day). Suppose that during an election, a Republican obtained 49
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 values? Does this high R-squared value mean that the market is easy to
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 percent sure that the length of the next eruption is between ____ and ____ minutes.Minutes between
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 sales C Sales 69 159 258 389 546 890 2014 2873 3475 5296 7759 D E LL F G H
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 following questions:Does the temperature appear to influence the process yield?What is the range of pounds
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 this data consistent with Moore’s Law?
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 formatting to highlight the three stocks most correlated with that stock. (Of course, you should
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 wins in two consecutive seasons is 0.5. If a team goes 12 and 4 during a season, what is your best
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 produced each time the process is run depends on the size of the container used, the pressure, and the
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 time the process is run depends on the size of the container used, the pressure, and the temperature.
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 each time the process is run depends on the size of the container used, the pressure, and the
The file named Countryregion.xlsx contains the following data for several underdeveloped countries/regions:Infant mortality rateAdult literacy ratePercentage of students finishing primary schoolPer capita GNPUse this data to develop an equation to predict infant mortality. Are there any outliers in
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 effects of singles, doubles, and other activities on run production.
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 Nortriptyline Trimipramine Venlafaxine Drug Fluoxetine Fluvoxamine Mirtazapine Paroxetine Sertraline Drug
The file named Cardata.xlsx provides the following information for 392 different car models:CylindersDisplacementHorsepowerWeightAccelerationMiles per gallon (MPG)Determine an equation that can be used to predict MPG. Why do you think all the independent variables are not significant?
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 Ads:
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 problems:Use this data to build a model that predicts how many runs a team will score based on the
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 total bases (home runs gets credit for four bases, triples get three, doubles, two, and singles, one)
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 attemptYR/A Yards gained per rushing attemptDNYP/A Yards gained passing by opponents 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 passes that result in a touchdown, the yards made per pass attempt, and the percentage of passes that are
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 how the price and display affect cookie sales. During a week in which the product is on display and
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 batches of the new drug, as well as the pressure, temperature, and product yield for each batch.
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. That information isOrder Quantity – the number of cards purchased by the company.Unit Cost –
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 equation to forecast daily almond cream croissant sales. Provide the equation. Explain how the day of
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 have different discharge policies?You are 95 percent sure that a patient of Doctor 1 will stay in the
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 problems:Use the data in the Problem 1 worksheet to determine how temperature, pressure, or both influence
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 doctor prescribes of your drug. Use the data in the Problem 2 worksheet to determine the answers to the
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, or five) made to a doctor influence the amount (in thousands of dollars) that each doctor
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 coupon and advertising influence peanut butter sales.Rep 1Rep 2Rep 3Rep
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 trend curve.
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 the probability that a given woman or man is a viewer of The Bachelor.
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 outliers.
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 indicate that the bookmaker’s forecasts are unbiased? If USC is favored by 10 points, estimate the
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 run the Solver, you will find a solution (there are many!) that has a total cost of $90,000. Find
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 the projects. What projects should be undertaken?
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 hold at most 26 pounds. At least one drink (water or Gatorade) and at least one protein (cheese or
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 needed to make each necklace are given in the file named Problem9data.xlsx. Which necklaces maximize
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 make the monthly payment for Months 1–30 equal to one-half the payment for Months 31–60. What is
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 salary each year you work. What percentage of your salary should you save?
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 you explain this anomaly?
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 cost 20 cents per square foot. How would you build the cheapest possible 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 that after a given time, the y coordinate of the shotput will equal H + V * SIN(θ) * Time – 0.5
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 Machines Produced. Use Solver’s GRG Multistart feature to find the power curve y = axb that best fits
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 semester. A semester consists of two seven-week half semesters. Jill must take four courses during each
“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 person cannot attend two meetings at once. What is the minimum number of hours needed to schedule
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 values?
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 Uniphase stock based on this information. Use a T-bill rate of 5 percent.
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

Microsoft Excel Data Analysis And Business Modeling 7th Edition Wayne Winston - Solutions

Step by Step Answers