Questions and Answers of Microsoft Excel Data Analysis 7th

Use the file named Makeup2007.xlsxHow many units of makeup were sold from January 15, 2004, through February 15, 2005? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 20 21 1 Betsy 2
Using the lemonade example of a data table, create spin buttons that allow the inputs to vary within the following ranges: Input Price Unit cost Low value $2 $0.20 High value $5 $1
A square matrix has the same number of rows and columns. Given a square matrix A, suppose there exists a matrix B whereby AB equals a matrix in which each diagonal entry equals 1, and all other
An m-by-n matrix is a rectangular array of numbers containing m rows and n columns. The following, for example, is a 3-by-3 matrix:Consider two matrices, A and B. Suppose that the number of columns
Find the average dollar amount per transaction by region. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 567 7 8 68 9 10 11 12 13 14 15 16 17 18 19 20 21 22222 23 24 25 45 Emilee 46
For each salesperson, display a breakdown of units sold as well as revenue, showing the results for each product by region. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16
Find the largest transaction (in terms of revenue) for each product. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81
Find the units sold and revenue for each salesperson. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen 86 Jen 87
The following table contains performance reviews for five employees. Use a radar chart to summarize the performance reviews. Person Hard-working Wayne 1 Vivian 5 Greg 10 Collegial 2 6 9.5 Completes
Each year, 250,000 seniors play high-school football, 16,000 college seniors play college football, and 256 seniors are drafted by the NFL. Summarize this data with the appropriate chart.
A company’s profit, revenue, and cost breakdown for a year are given below. Summarize this data in a waterfall chart. Item Revenue Profit Labor Costs Material Costs Overhead
A project consists of five activities. The start time and duration of each activity are given below. Summarize this data in a Gantt chart. Activity A B C D E Start time 0 3 in 5 6 3 Duration 4 6 7 8 6
During its first year of operation, a firm’s revenue was $5 million and expenses were $6 million. For different assumed growth rates in expenses and revenues, plot 10 years of revenues and
Plot the data in Problem 1 on a column chart in which good defensive games are highlighted in green, bad games in red, and other games in orange.Data from in problem 1The Indiana University
A marketing director estimates that the total sales of a product as a function of price will be as shown in the following table. Estimate the relationship between the price and the demand and predict
The brand manager for a new drug believes that the annual sales of the drug, as a function of the number of sales calls on doctors, will be as shown in the following table. Estimate the sales of the
For an airplane manufacturer, the time needed to produce each of the first 10 airplanes in a year is as follows:Estimate the total number of hours needed to produce the next 10 airplanes.
For 12 straight weeks, you have observed sales (in the number of cases) of canned tomatoes at Mr. D’s Supermarket. Each week, you keep track of the following:Was a promotional notice for canned
If you toss two dice, find the probability of each possible total.
If you throw three dice, what is the chance the total is 9?
Of Carver High School students, 20 percent play baseball, 15 percent play basketball, and 5 percent play both. What fraction of students play baseball or basketball?
Let A = Event a Die Comes Up Even and B = Event Die Shows One or Two Dots. Are Events A and B independent?
In the game of craps, you roll two dice. A total of 7 or 11 on the first roll wins. What is the chance you win a game on the first roll?
The following table shows admission statistics for men and women at a large US university. The total number applying for admittance is in parentheses, and the number admitted is not in parentheses.
A roulette wheel contains the numbers 0, 00, 1, 2, ..., 36. Suppose you bet on each of 25 spins that 00 will show. After 25 spins, what is the chance you have won at least once?
What fraction of men and women watch The Bachelor?
A chest has two drawers. Each drawer contains two coins. You know one drawer has two gold coins and the other drawer has one gold and one silver coin. You randomly pick a drawer and a coin; the
Of all the cabs, 85 percent are blue and the rest are green. A cab identified in a hit-and-run accident is identified as green. People can correctly identify the color of a cab 80 percent of the
An urn contains nine balls. Each ball has one of the numbers 1, 2, ..., 9 painted on it. Pull two balls (with replacement) from the urn. What is the chance the two numbers are the same?
Toss a die and let A = Event You Roll an Odd Number and B = Event You Roll a Number > =4. Find P(A|B).
Two engines each have a 0.9 chance of working. The success or failure of the engines is independent. If the engines are in a series, both engines need to work for the system to work. If the engines
A company has one plant in Houston and one in Dallas. Seventy percent of the employees work in Houston and 30 percent work in Dallas. Each year, 3 percent of the Houston employees are involved in an
An MBA student is studying finance and marketing. Assume the student has a 90 percent chance of getting an A in finance and an 80 percent chance of getting an A in marketing. If her performance in
A bowl contains four red balls and six blue balls. Two balls are drawn (without replacement) from the bowl. Given that the second ball is blue, what is the chance the first ball is blue?
Suppose you toss two dice. Let A = Event First Die Shows a 3 and B = Event Total of the Two Dice Is 8. Are events A and B independent?
Of an insurance company’s policyholders, 80 percent are high risk and 20 percent are low risk. Assume nobody has more than one accident in a year. Also assume 10 percent of highrisk people have an
In each year’s NCAA basketball tournament, there are four #16 seeds with a 3 percent chance of beating a #1 seed. Before the tournament started, what is the chance that at least one #16-seed team
Assume one in every 1,000 people is a liar (incapable of telling the truth). Also suppose a lie-detector test is 98 percent accurate. That is, if a person is lying, there is a 98 percent chance the
After throwing two dice, define Event A = Total of the Dice Is Even and Event B = First Die Shows a Five. Are Events A and B independent?
During 40 percent of all weeks, a supermarket cuts the price on macaroni and cheese. During 20 percent of all weeks, the supermarket puts macaroni and cheese on display. Finally, during 15 percent of
You are told two cards have been drawn from a deck of cards and both are hearts. What is the probability that the first card was the two of hearts?
In a drawer, there are two normal quarters and one quarter with two heads. With your eyes closed, you choose one of the coins. Your friend then flips the coin you chose and reports that the coin came
Of an insurance company’s policyholders, 20 percent are high risk, 40 percent are low risk, and 40 percent are intermediate risk. Of the low-risk policyholders, 2 percent have an accident during a
You toss two dice. Let Event A = Total Is 10 and Event B = Event First Die Shows an Odd Number. Are Events A and B independent?
Beer drinkers order an average of 40 pitchers of beer per hour at Nick’s Pub in Bloomington, Indiana. Answer the following questions:What is the probability that at least 100 pitchers are ordered
Suppose that teenage drivers have an average of 0.3 accidents per year. Answer the following questions:What is the probability that a teenager will have no more than one accident during a year?What
I am next in line at a fast-food restaurant in which customers wait in a single line, and the time to serve a customer follows an exponential distribution with a mean of three minutes. What is the
Since 1900, a fraction (0.00124) of all Major League Baseball games have resulted in nohitters. A team plays 162 games in a season. What is the chance that a team pitches two or more no-hitters
An average of 80 customers arrive each hour at the Central Forest coffee shop. What is the probability that at least 150 customers arrive in a two-hour period?
Suppose 10 percent of all staplers are defective. If 60 staplers are sold, what is the chance that at least 10 staplers are defective?
In each year’s NCAA basketball tournament there are four #1 seeds. For a #1 seed to make the Final Four, a team needs to win its first four games. Assume each #1 seed has a 0.7 chance to win each
A factory has five assembly lines. Each assembly line is down (not working) p percent of the time. What must p equal so that there is a 95 percent chance that at least one assembly line is working?
Suppose that each time the Houston Astros play the New York Yankees, the Astros have a 35 percent chance of winning the game. If the Astros play the Yankees 10 times, what is the chance the Astros
In the 17th century, French mathematicians Pierre de Fermat and Blaise Pascal were inspired to formulate the modern probability theory after trying to solve the problem of points. Here is a simple
A student is selling magazines for a school fundraiser. There is a 20 percent chance that a given homeowner will buy a magazine. The student needs to sell five magazines. Determine the probability
When tested for extra sensory perception (ESP), participants are asked to identify the shape on a card. There are 25 cards in all. These 25 cards are divided into five groups of five, with each group
Suppose that in a group of 100 people, 20 have the flu and 80 do not. If you randomly select 30 people, what is the chance that at least 10 people have the flu?
Professional basketball player Kevin Durant is a 90 percent foul shooter. Answer the following questions:If he shoots 100 free throws, what is the probability that he will miss more than 15 shots?How
Suppose that during each year, a given mutual fund has a 50 percent chance of beating the Standard & Poor’s 500 Stock Index (S&P Index). In a group of 100 mutual funds, what is the
Use the airline overbooking data to do the following:Determine how the probability of overbooking changes as the number of tickets sold varies from 100 through 115.Show how the probability of
Suppose that, on average, 4 percent of all CD drives received by a computer company are defective. The company has adopted the following policy: Sample 50 CD drives in each shipment, and accept the
Identify the following random variables as discrete or continuous:Number of games the Seattle Seahawks win next seasonNumber that comes up when spinning a roulette wheelUnit sales of tablet PCs next
Compute the mean, variance, and standard deviation of the number of dots showing when a die is tossed.
Determine whether the following random variables are independent:Daily temperature and sales at an ice cream storeSuit and number of a card drawn from a deck of playing cardsInflation and return on
The current price of a company’s stock is $20. The company is a takeover target. If the takeover is successful, the company’s stock price will increase to $30. If the takeover is unsuccessful,
When a roulette wheel is spun, the possible outcomes are 0, 00, 1, 2, ..., 36. If you bet on a number coming up, you win $35 if your number comes up and you lose $1 otherwise. What is the mean and
A stock currently sells for $40. You have bought one share of the stock at this price. In the next month, there is a 60 percent chance the stock price will double and a 40 percent chance the stock
Suppose you bet on an odd number coming up in roulette. If an odd number comes up, you win $1, and if an odd number does not come up, you lose $1. Find the mean and standard deviation of your profit.
Suppose you can set the mean number of ounces of soda that is put into a can. The actual number of ounces has a standard deviation of 0.05 ounces. Answer the following questions:If you set the mean
The annual demand for a drug is normally distributed with a mean of 40,000 units and a standard deviation of 10,000 units. Answer the following questions:What is the probability that annual demand is
The probability of winning a game of craps is 0.493. If I play 10,000 games of craps and bet the same amount on each game, what is the probability that I’m ahead? Begin by determining the mean and
The weekly sales of Volvo’s Cross Country station wagons are normally distributed with a mean of 1,000 and standard deviation of 250. Answer the following questions:What is the probability that
My time for swimming 100 yards follows a normal random variable with a mean that equals 51 seconds and a standard deviation of 1.5 seconds. If I swim the race in under 49 seconds, I will win the
The federal government wants to charge a Medicare surcharge to Americans 65 or older whose income ranks in the top 2 percent of all American family incomes. If the American family incomes follow a
The voltage held by a voltage regulator follows a normal random variable with a mean that equals 200 volts and a standard deviation that equals 5 volts. A regulator meets the specifications if the
Texas wants to give welfare checks to the poorest 5 percent of all Texas families. If the family income in Texas follows a normal random variable with a mean that equals $50,000 and a standard
A rod meets its specifications if its diameter is between 0.98 and 1.02 inches. The mean diameter of a rod is 1 inch. What should the standard deviation of rods equal for 99 percent of rods to meet
The number of bottles of iced tea sold by a supermarket on a Monday follows a normal random variable with a mean that equals 100 and a standard deviation that equals 12. On a given Monday, what is
Assume the mean daily percentage change in the Dow Jones Industrial Average Index is 1 percent, with a standard deviation of 1.5 percent. Assume there are 252 trading days in a year. What is the
I have 500 potential customers who come to my candy store each day. Seventy percent of the customers buy no pieces of candy, 15 percent buy one piece, 10 percent buy two pieces, and 5 percent buy
In Game 7 of the Boston Celtics–Los Angeles Lakers 2010 NBA finals, the Lakers were favored by seven points. Looking at past NBA games, you will find that bookmakers’ forecasts are unbiased.
A leading cell phone company forecasts that next year it will sell 3 million units of its bestselling phone. In the past, actual sales have been unbiased, with forecast errors having a standard
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.What is the probability that in two
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.What is the probability that in two
Suppose a stock sells for $30 today. The annual volatility of the stock is 35 percent, and analysts predict the expected price of the stock in a year will be $35.You are 95 percent sure that the
If a city has only one hospital, where should it be located?
I am borrowing $100,000 for a 15-year mortgage. The annual rate of interest is 8 percent. How can I determine my monthly mortgage payment?
How should an auto company allocate its advertising budget between different advertising formats?
How should cities transport students to more distant schools to obtain racial balance?
How should a drug company allocate its sales-force efforts among its products?
The tax rate charged to a drug company depends on the country/region in which a product is produced. How can a drug company determine where each drug should be made?
A drug company has $2 billion allocated to purchasing biotech companies. Which companies should it buy?
At a chip-manufacturing plant, four technicians (A, B, C, and D) produce three products (1, 2, and 3). This month, the chip manufacturer can sell 80 units of Product 1, 50 units of Product 2, and at
A computer-manufacturing plant produces mice, keyboards, and video-game joysticks. The per-unit profit, per-unit labor usage, per-unit machine-time usage, and monthly demand are given in the
Jason makes diamond bracelets, necklaces, and earrings. He wants to work a maximum of 160 hours per month. He has 800 ounces of diamonds. The profit, labor time, and ounces of diamonds required to
Shoeco manufactures three types of shoes. Demand for shoes is unlimited, and 40 hours per week of machine time and labor are available. A pair of shoes yields the profit and uses the number of
Woodco produces tables and chairs. The unit profit, the wood used (in square feet), and the number of skilled carpentry hours used to produce a pair of shoes are given in the table below. An integer
The Houston Credit Union is open weekdays 9 a.m. to 5 p.m. Full-time tellers who work the full day (no lunch break) are paid $200 per day. Part-time tellers working 11 a.m.–1 p.m. may be hired for
The Pine Valley Credit Union is trying to schedule bank tellers. The credit union is open 8 a.m.–6 p.m. and needs the number of tellers each hour as shown in the following table. Fulltime tellers
Figure 68-4 shows the number of people in different demographic groups who watched various TV shows and the cost (in thousands of dollars) of placing a 30-second ad on each show. For example, it cost

Showing 500 - 600 of 878