Find all transactions involving 39 units and sort them in descending order of revenue. Each row gives
Question:
Find all transactions involving 39 units and sort them in descending order of revenue.
Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically update if new data is added.
Transcribed Image Text:
F G 4 Trans Number Name: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zarot 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jon 19 Jen 20 Zaret I Product 4/1/2004 lip gloss 3/10/2004 foundatio 2/25/2005 lipstick 5/22/2006 lip gloss 6/17/2004 lip gloss 11/27/2005 eye liner 3/21/2004 eye liner 12/17/2006 lip gloss 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundatio 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss H Date J Units K L Dollars Location 45 $137.20 south 50 $152.01 midwest 9 $ 28.72 midwest 55 $167.08 west 43 $130.60 midwest 58 $175.99 midwest 8 $ 25.80 midwest 72 $217.84 midwest 75 $226.64 south 24 $ 73.50 east 43 $130.84 east 23 $ 71.03 west 49 $149.59 west 18 $ 56.47 south -8 $ (21.99) east 45 $137.39 east 66 $199.65 south 88 $265.19 midwest 78 $236.15 south 57 $173.12 midwest M N P -SORTBY(data,SEQUENCE(ROWS(data),1,ROWS(data),-1)) Q 1900 Cristina 1899 Hallagan 1898 Zaret 1897 Colleen 1896 Ashley 1895 Emilee 1894 Colleen 1893 Cici 1892 Cici 1891 Betsy 1890 Cici 1889 Emilee 1888 Colleen 1887 Zaret 1886 Cristina 1885 Ashley 1884 Hallagan 1883 Betsy R 38881 eye liner 39024 eye liner 38001 lipstick 38661 lip gloss 38397 foundation 38683 eye liner 38122 lip gloss 38199 foundatior 38771 mascara 38452 foundatior 38518 foundatior 39046 eye liner 38551 eye liner 38463 lip gloss 38573 mascara 38848 lip gloss 38859 lip gloss 38188 lip gloss S T 54 164.4873 midwest 28 85.65683 south 72 217.8359 west 46 140.4089 west 36 109.8426 east 15 47.16102 east 60 181.8703 east 20 61.92386 midwest 92 278.4349 west 39 119.1888 east 16 49.75399 east 76 229.9178 west 24 73.81115 west 61 185.3148 midwest 89 269.1475 south 12 37.83771 west 89 269.3955 west -6 -15.736 east
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 75% (4 reviews)
Answered By
Muhammad Umair
I have done job as Embedded System Engineer for just four months but after it i have decided to open my own lab and to work on projects that i can launch my own product in market. I work on different softwares like Proteus, Mikroc to program Embedded Systems. My basic work is on Embedded Systems. I have skills in Autocad, Proteus, C++, C programming and i love to share these skills to other to enhance my knowledge too.
3.50+
1+ Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Sort the transactions in descending order of units. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will...
-
Sort the data in descending order of units, breaking ties based on dollars in descending order. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...
-
Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically...
-
A fair die is tossed until all the numbers have been seen at least once. Let N be the number of tosses this requires. Find E(N). [Hint: Let N; be the number of tosses until i different numbers have...
-
Would a CPA violate the AICPAs Code by serving a client both as its auditor and legal counsel? Explain your answer.
-
On July 1, 2018, the Foster Company sold inventory to the Slate Corporation for $300,000. Terms of the sale called for a down payment of $75,000 and three annual installments of $75,000 due on each...
-
The company is committed to ethical conduct and has no tolerance for fraud and unethical behavior. There are some concerns about abuses in your department. Do you know anything about the concerns I...
-
Compute the amount and percentage changes for Rivera Companys comparative balance sheets, and comment on the changes from 2013 to 2014. (Round the percentage changes to one decimalplace.) Rivera...
-
KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in...
-
Polly Peyrotte started designing and decorating fine china plates more than 100 years ago. As her artistry caught on, she became famous. She also turned out to have considerable business skills. She...
-
The Lillydata.xlsx file contains information from a market-research survey that was used to gather insights to aid in designing a new blood-pressure drug. Fifteen experts (six from Eli Lilly and...
-
The Product worksheet in the Chapter35data.xlsx file contains sales during April through August of products 1 through 7. Sales for each product are listed in the same column as each month. Rearrange...
-
Match each name below with the following microscopic pictures of that compound in aqueous solution. a. Barium nitrate b. Sodium chloride c. Potassium carbonate d. Magnesium sulfate Which picture best...
-
Our longest uninterrupted economic expansion took place mainly in the decade of the ______. a) 1940s b) 1950s c) 1960s e) 1980s d) 1970s f) 1990s
-
Employment discrimination results in the __________ of our labor force.
-
The main factor in finally bringing us out of the Great Depression was _________.
-
Full employment implies an unemployment rate of about ______ percent.
-
Since the end of World War II there have been _________ recessions.
-
Daimler AG is a globally leading producer of premium passenger cars and the largest manufacturer of commercial vehicles in the world. Its group of businesses includes Mercedes- Benz Cars, Daimler...
-
In a paragraph of approximately 150-200 words, analyze a film or TV/Streaming Show poster of your choosing by focusing on the ways in which representations in the poster are gendered. Include an...
-
How do Porters competitive forces model, the value chain model, synergies, core competencies, and network economics help companies develop competitive strategies using information systems? a) Define...
-
What are the challenges posed by strategic information systems, and how should they be addressed? a. List and describe the management challenges posed by strategic information systems. b Explain how...
-
What ethical, social, and political issues are raised by information systems? a) Explain how ethical, social, and political issues are connected and give some examples. b) List and describe the key...
-
Who' does demand labor from physicians? Explain why. Now, think solely about the healthcare market in which you work or that is of interest to you and concentrate solely on the labor market. Think...
-
You are now ready to evaluate the effectiveness of the interventions and whether your goals for the client have been met. Remember, the nursing process is cyclical and ongoing. The evaluation phase...
-
Exercise 2.8 Consider the following "third-price" auction. There are n 3 bidders. A single object is auctioned and Player i values the object $v,, with v; >0. The bids are simultaneous and secret....
Study smarter with the SolutionInn App