All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Search
Search
Sign In
Register
study help
business
microsoft excel data analysis 7th
Questions and Answers of
Microsoft Excel Data Analysis 7th
Write a LAMBDA formula that multiplies two numbers and adds a third number to the product.
Use a LAMBDA helper function to create an array of three rows and seven columns in which each cell is equally likely to be Mon, Tues, Wed, Thur, or Fri.
If a salesperson’s total sales are at least $110, their bonus is 40 percent of sales; if their total sales are from $100 to $109, their bonus is 20 percent of sales. Otherwise, their bonus is 5
Consider two projects with the following cash flows:For what rate of interest will Project 1 have a larger NPV? Project 1 Project 2 Year 1 -$1,000 -$900 Year 2 $400 $100 Year 3 $350 $100 Year
My income in Year 1 is $80,000. I will work for 35 years and then retire. Each year, assume my income increases 5 percent per year, and my income is received at the beginning of the year. After
Greg Winston has gone bankrupt and started a lemonade stand. He has invested $400 in lemonade equipment, and he sells a glass of lemonade for $4. His unit cost of producing a cup of lemonade is
The current annual interest rate is 5 percent, and you are taking out a 20-year loan with a monthly end-of-month payment. If you can afford monthly payments of $3,000 per month, what is the most you
It is April 15, and so far this month, we have sold $35,000 worth of merchandise. Our quota is to sell $72,500 worth of units in April. If we charge a price p for our product, we will sell 800 – 4p
Suppose you are borrowing $500,000 and are making annual payments for 20 years at the beginning of each year. What annual interest rate corresponds to this situation?
To celebrate the Lewis and Clark Expedition, I am traveling 40 miles upstream and then 40miles downstream in a canoe. The speed of the river current is 5 miles per hour. If the trip takes me 5 hours
I am buying 40 pounds of candy. Some of the candy sells for $10 per pound, and some sells for $6 per pound. How much candy at each price should I buy to arrive at an average cost of $7 per pound?
I am managing a conference at my college. My fixed costs are $15,000. I must pay the 10 speakers $700 each, and the college union $300 per conference participant for food and lodging costs. I am
I expect to earn 10 percent per year on my retirement investments. At the end of each of the next 40 years, I want to put the same amount of money in my retirement portfolio. How much money do I need
At the end of each of the next 40 years, I’m going to put $20,000 in my retirement fund. What rate of return on my investments do I need so that I will have $2 million available for retirement in
How could I use Goal Seek to determine a project’s internal rate of return (IRR)?
In our mortgage example, suppose I need to borrow $200,000 for 15 years. If my maximum payments are limited to $2,000 per month, how high an annual interest rate can I tolerate?
Today, you bought five shares of Stock 1 for $30 per share and three shares of Stock 2 for $25 per share. In a month, you will sell all your stock. Use a data table to determine how total profit
When a customer places an order from a catalog, assume that a profit of $50 (not including the cost of mailing the catalog) is earned. Use a data table to determine how the total profit earned from
Currently, a magazine has 5,000 subscribers. Determine how the number of subscribers at the end of Year 6 changes as the number of new subscribers varies between 1,000 and 5,000 and the annual
You are investing in a new Broadway play, Insect in the Light. You are given the following information about the play:The fixed cost of opening the play is $5 million.The average ticket price is
You are thinking of opening a restaurant that will have six four-person tables. Each day the restaurant is open, there are two lunch seatings and three dinner seatings. In addition:The restaurant
You can retire at age 62 and receive $8,000 per year or retire at age 65 and receive $10,000 per year. What is the difference (in today’s dollars) between these two choices as you vary the annual
You are borrowing $200,000 and making payments at the end of each month. For an annual interest rate ranging from 5 percent to 10 percent and loan durations of 10, 15, 20, 25, and 30 years, determine
If you earn interest at an annual rate of x percent per year, then in n years $1 will become (1+ x)n dollars. For annual rates of interest from 1 percent to 20 percent, determine the exact time (in
Assume I have $100 in the bank. Each year, I withdraw x percent (ranging from 4 percent to 10 percent) of my original balance. For annual growth rates of 3 percent to 10 percent per year, determine
If you earn interest at percentage rate r per year and compound your interest n times per year, then in y years, $1 will grow to $(1 + (r / n))ny. Assuming a 10 percent annual interest rate, create a
You have begun saving for your child’s college education. You plan to save $5,000 per year. You want to calculate the amount of money you will have in the college fund after you save for 10 to 15
Find all records in which the product cell is colored yellow.
Find all the unique combinations of name, product, and location occurring during the first three months of 2006.
Find all sales by Jen between August 10 and September 15, 2005.
Find all top-30 sales (by units) occurring in 2005 that involved lip gloss or mascara.
Find all the unique combinations of the product and salesperson’s name.
Find all transactions in which Zaret or Betsy sold either lipstick or foundation.
Find all foundation transactions during the first three months of 2004 for which the per-unit price was larger than the average price received for foundation during the entire time period.
Find all transactions involving sales of at least 60 units during 2004 for which the per-unit price was a maximum of $3.10.
Find the top 20 revenue-generating transactions that involve foundation sales.
Find all transactions that rank in the top 5 percent with regard to units sold.
Find all transactions in which Hallagan sold eyeliner in the West region.
Use the Automatic data type to extract all available information related to the novel of the (19th) century, Les Misérables.
Compare the average monthly rainfall in Las Vegas and Honolulu.
Find the boiling point and density of ammonia.
Find the average body mass index, weight, and age for those suffering with gout.
What is the latitude and longitude of Yosemite National Park?
What is the height of Mt. Kilimanjaro?
What is the exchange rate between China’s currency and US dollars?
For IBM, find the number of employees, latest closing stock price, and price-to-earnings ratio.
What is the function of your ribs?
Find the average distance from Earth of each planet in our solar system.
Find Adele’s birthdate, a list of her albums, and a list of all the tracks on her Greatest Hits album.
Find the US gross, revenue, release date, production budget, and director for the top 10 grossing movies of all time.
Find the latitude and longitude of the cities listed in the Problem 1 worksheet.
How many units were sold by people other than Colleen? Use the file named Makeup2007.xlsx
Determine the total revenue earned by people who have five letters in their names. Use the file named Makeup2007.xlsx
Determine the total units sold by salespeople whose last names begin with C. Use the file named Makeup2007.xlsx
Determine the total revenue earned before December 10, 2005. Use the file named Makeup2007.xlsx
For each product, determine the total number of units and dollar volume sold.Use the file named Makeup2007.xlsx
How many songs that are exactly three minutes long and sung by Britney Spears were played later than 2004?
How many songs at least four minutes long and sung by Mandy Moore were played in 2007 or earlier?
How many songs sung by Barry Manilow were played in 2004?
Create a formula that always yields the number of songs played today.
How many songs were sung by singers whose names contain an e?
How many songs were sung by singers whose last names begin with M?
How many songs were played between June 1, 2004, and July 4, 2006?
How many songs were played before June 15, 2004?
Add a scenario named High Price, in which the Year 1 price equals $15 and the other two inputs remain at their most-likely values.
How many songs were not sung by Britney Spears?
Delete the best-case scenario and run another scenario report.
We bought a stock July 29, 2005, and we sold it December 30, 2005. The stock exchange is closed Labor Day, Christmas, and Thanksgiving. Create a list of dates when the stock exchange was open during
A project begins on December 4, 2005. The project consists of three activities: activity 1, activity 2, and activity 3. Activity 2 can start the day after activity 1 finishes. Activity 3 can start
How many workdays (including holidays) are there between July 10, 2005, and August 15, 2006?
Determine the day that occurs 74 workdays after today’s date (including holidays but excluding the current year’s Christmas, New Year’s Day, and Independence Day).
Suppose 1 dollar can be converted to 1,000 yen, 5 pesos, or 0.7 euros. Set up a worksheet in which the user can enter an amount in US dollars and a currency, and the worksheet converts dollars to the
The Gini index is a commonly used measure of a nation’s income inequality. If the income of n people is listed in increasing order (x1 equals the smallest income and xn equals the largest income),
A lake is currently stocked with 12,230 fish. Each year, the number of births per fish is 1.2, and the number of deaths per fish is 0.7. Show that if 6,115 fish per year are harvested, the number of
The butterfly effect states that if a butterfly flaps its wings in Tahiti, that small event might cause a hurricane to hit Texas. Suppose that weather at Time t is always between 0 and 1 and is
The Fibonacci sequence is defined as follows: F0 = 0, F1 = 1 and for N larger than 1, FN+1 = FN + FN-1. Set up a worksheet to compute the Fibonacci sequence. Show that for large N, the ratio of
An NBA player is to receive a $1,000,000 signing bonus today and $2,000,000 one year, two years, and three years from now. Assuming r = 0.10 and ignoring tax considerations, would he be better off
Set up a worksheet in which a person can enter his or her date of birth, and the worksheet returns the person’s actual age.
Showing 800 - 900
of 878
1
2
3
4
5
6
7
8
9