Questions and Answers of Microsoft Excel Data Analysis 7th

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 file named Problem15data.xsls, you are given the number of greeting cards sold by a drugstore during several quarters and the average price charged for cards during the quarter. Determine how
In the file named Problem16data.xlsx, you are given the number of almond-cream croissants sold each day by a bakery. For each day, you are given whether the day was 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).
Use a LAMBDA helper function to create an email list from the addresses in the Problem 11 Data worksheet. Remember that the email addresses need to be separated by a semicolon.
Use a LAMBDA helper function to compute the product of all numbers greater than or equal to 11 in the Problem 9 Data worksheet.Data from in problem 9Use a LAMBDA helper function to return for each
Use a LAMBDA helper function to return for each number greater than or equal to 11 in the Problem 9 Data worksheet, the square of that number, and a blank space otherwise.
Use a LAMBDA helper function to determine the smallest number in each column of the data in the Problem 7 Data worksheet.Data from in problem 7Use a LAMBDA helper function to determine the largest
Use a LAMBDA helper function to determine the largest number in each row of the data in the Problem 7 Data worksheet.
Use a LAMBDA helper function to compute the sum of the squares of all numbers in the Problem 5 Data worksheet.Data from in problem 5Use a LAMBDA helper function to determine whether each number in
Use a LAMBDA helper function to determine whether each number in the data in the Problem 5 Data worksheet is greater than or equal to the average value of the data.
Cell G13 of the Problem 3 Data worksheet contains a formula to compute the distance between two locations on Earth, given their latitude and longitude. Create a LAMBDA function named MILES that
The Problem 2 Data worksheet contains January–April sales data for eight salespeople. If their total sales are at least $110, their bonus is 40 percent of sales; if their total sales are from $100
For the PivotTable example in the Ptcustomers.xlsm file, create a macro that clears any filters on customers.
Modify your Problem 1 macro to enter the team members in a single row, starting in any cell you want.Data from in problem 1Your MBA team members are Wayne, Taylor, Britney, and Katy. Create a macro
The Trendandseasonality.xlsx workbook contains five years of quarterly sales data for a company whose sales exhibit strong seasonality and a well-defined trend in sales. Choose the best result from
The Old Faithful.xlsx workbook contains for the Old Faithful geyser in Yellowstone National Park the duration (in seconds) of eruptions and the time (in minutes) since the last eruption. You are
The Teachers.xlsx workbook contains standardized test scores for students in 5th grade at Walt Whitman Elementary School. You are also given each student’s 5th grade teacher and their 4th grade
In his best-selling book Blink, Malcolm Gladwell relates that hockey players born earlier in the year are more likely to make the National Hockey League than players born later in the year. Use the
Each row of the EyeColor.xlsx workbook contains a person’s eye and hair color. You are interested in determining the relationship between eye and hair color. Choose the best result from Analyze
Each row of the Drug.xlsx workbook tells you for people with the same disease whether their condition improved and whether or not they were given a new drug. You want to know if the drug was
Create bin ranges that are round numbers for the histogram created in the stock return example.
For each of your answers in Problem 1, determine the value consumers place on the 2,000th unit purchased of your game.Data from in problem 1Suppose you are charging $60 for a board game you invented,
Suppose you are charging $60 for a board game you invented, and you have sold 3,000 copies during the last year. The elasticity for board games is known to equal 3. Use this information to determine
On August 9, 2002, Microsoft stock was selling for $48.58 per share. A $35 European call option, expiring on January 17, 2003, was selling for $13.85. Use this information to estimate the implied
Going into the 2003 NBA finals, the rating system described in Chapter 72 rated the San Antonio Spurs three points higher than the New Jersey Nets. Teams play until one team wins four games. The
You need to clean your house today. In the Problem 2 worksheet, you are given data about how long it has taken to clean your house in the past. If you start cleaning at noon, what are the chances
In the Problem 1 worksheet, you are given data about the duration of a machine’s lifetime. Answer the following questions:What is the probability that the machine will last at least 10 hours?What
In the Willy Loman problem, suppose you must visit New York immediately after Denver. What is the solution to the problem?
Suppose that you live in Atlanta and are driving 29 general managers home. Each time you visit an arena, you drop off a GM at his home arena. In what order should you drop off the GMs to minimize the
The file Nbamiles.xlsx is used in Problems 2 and 3. The file gives the distances between each pair of NBA arenas. Suppose you live in New York and want to visit each arena once and return to New
Students at the School of Fine Arts apply to study either English or science. You have been tasked to determine whether the School of Fine Arts discriminates against women in admitting students to
You own a fast-food restaurant and have done some market research in an attempt to better understand your customers. For a random sample of customers, you are given the income, gender, and number of
Contoso Ltd. produces microchips. Five types of defects (labeled 1–5) have been known to occur. The chips are manufactured by two operators (A and B) using four machines (1–4).You are given data
Set up data validation to ensure that a person can enter only dates that are on Monday through Friday.
Set up data validation to ensure that a column of numbers is entered in descending order.
The file named Candybardata.xlsx contains a list of stores where you sell candy bars. The worksheet also contains the types of candy bars you sell at each store and the price charged for each candy
You have been asked to evaluate the quality of care given to heart-attack patients at the Emergency Room (ER) and Chicago Hope (CH). For the last month, you are given the following patient
Using the mortgage payment example in Chapter 17, create spin buttons that allow inputs to vary within the following ranges: Input Amount borrowed Number of months of payments Annual interest
Set up conditional formatting that colors the cell range A1:H8 like a checkerboard, with alternating white and black coloring. The =ROW() function gives the row number of a cell, and the =COLUMN()

Showing 100 - 200 of 878