In the Makeupdb.xlsx file, what was the average number of lipstick units sold by Jen in the
Question:
In the Makeupdb.xlsx file, what was the average number of lipstick units sold by Jen in the East region?
Transcribed Image Text:
G H 4 Trans Number Name 5 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 26 Emilee Date K Product Units 4/1/2004 lip gloss 3/10/2004 foundatior 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 foundatior 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara lip gloss 12/6/2006 1 M 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 12 $38.08 west 28 $ 86.51 midwest 25 $77.31 midwest 24 $ 74.62 west
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 87% (8 reviews)
Answered By
GERALD KAMAU
non-plagiarism work, timely work and A++ work
4.40+
6+ Reviews
11+ 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
-
For the data in the file named Tablemakeuptemp.xlsx (in this chapters Templates folder), determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the East region....
-
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...
-
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 Emilee 567 7 8 68 9 10...
-
QUESTION 9 The output expression for an AND-OR-Invert circuit having one AND gate with inputs A, B and C and one AND gate with inputs D, E and Fis O(A+B+C)(D+E+F) O (A+B+C)(D+E+F) ABC + DEF...
-
What precedent was set in the Ernst & Ernst vs. Hochfelder case described in the chapter? What actions would be necessary to change the precedent?
-
At the beginning of the current fiscal year, the balance sheet of Hughey Incorporated showed stockholders' equity of $ 3 5 0 , 0 0 0 . During the year, liabilities increased by $ 1 7 , 0 0 0 to $ 1 6...
-
Why do the terms of the attorney-client relationship need to be established in writing?
-
Iridium Technologies manufactures a variety of flash memory chips at its main foundry in Anam, Korea. Some chips are sold by Iridium to makers of electronic equipment while others are embedded into...
-
Problem #3: The tangent plane of f(x,y) = 3xy - 4xy5 at the point (1,1) can be expressed in the form z = ax + by + c. (a) What is the value of b? (b) What is the value of c? Problem #3(a): Problem...
-
Futoshiki is a Sudoku-like Japanese logic puzzle that is very simple, but can be quite challenging. You are given an n x n grid, and must place the numbers 1, . . . n in the grid such that every row...
-
The Sorticons.xlsx file contains annual investment returns with an up arrow used to indicate good years, a horizontal arrow used to indicate average years, and a red arrow used to indicate bad years....
-
The Sortday.xlsx file contains hours worked on different days of the week. Sort the data so that the Monday data is followed by the Tuesday data, and so on.
-
Propose a mechanism for each of the following reactions: a. b. c. d. Br -, CH _CH3 0 H20 ( HOCH,CH,CH2 CHCH SCH2CH CH,CH-SH + --> CHCH2CCH3 N 2. HCI, H20
-
What factors related to brand and product names might influence a companys international product strategy?
-
How do we calculate the firms free cash flow, and the free cash flow to equity?
-
What issues pertaining to law and culture may affect international product strategy?
-
Bespoke suits in Vietnam, Italian leather goods, Moroccan rugs, and crystal glass in the Czech Republicall these products are substantially cheaper in these countries than the rest of the world....
-
What are the main methods of estimating the continuation value of the firm at the end of the forecast horizon?
-
Suppose the act of giving is viewed as an economic good. How can the price of charitable donations be measured? Does the quantity demanded decrease as the price of giving increases?
-
A random sample of 10 houses heated with natural gas in a particular area, is selected, and the amount of gas (in therms) used during the month of January is determined for each house. The resulting...
-
The balance in Preston Companys finished goods inventory account was $650,000 at the beginning of March. Cost of goods manufactured for the month totaled $445,000, and cost of goods sold totaled...
-
Yamamoto, Inc., had the following activity for the year ended December 31. Required: Prepare an income statement for year ended December 31. Sales revenue $3,050,000 $ 575,000 $ 330,000 Selling...
-
Brenner Company expects to incur $3,000,000 in manufacturing overhead costs this year. During the year, it expects to use 50,000 direct labor hours at a cost of $600,000 and 80,000 machine hours....
-
Christmas Anytime Issues $700,000 of 5% bonds, due in 15 years, with Interest payable semiannually on June 30 and December 31 each year. Calculate the issue price of a bond and complete the first...
-
The following selected transactions relate to liabilities of United Insulation Corporation. United's fiscal year ends on December 31. 2024 January 13 Negotiated a revolving credit agreement with...
-
During the current year, the Town of Mashpee had a number of transactions that affected net position of its town golf course, which is operated as an enterprise fund. "You are provided with the...
Study smarter with the SolutionInn App