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?
-
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory pool. The pool's value on this date was $660,000. The 2018 and 2019 ending inventory valued at...
-
While the electromagnetic interaction between the photons and the charged electrons and positrons kept them in equilibrium with each other during the early universe, show that the direct...
-
TJs, Inc., makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing...
-
If a proton gains 6 x 10-12 J of electrical potential energy as it moves from point A to point B, what is the voltage difference between points A and B, and which point is at the higher potential?
-
1. If MII sues CP in a state trial court for the losses it incurred, what would CPs likely defense be? 2. Discuss the significance of the fact that the original lease did not have an arbitration...
-
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.
-
Saturated refrigerant-134a vapor at 34C is to be condensed as it flows in a 1-cm-diameter tube at a rate of 0.1 kg/min. Determine the rate of heat transfer from the refrigerant. What would your...
-
Why did the Great Recession lead to the decline of the Great Moderation consensus? Given events, why is it predictable that a new consensus has not emerged?
-
What is a per se violation?
-
An agency cannot conduct a search without a warrant. (True/False)
-
State administrative agency operations prevail over federal agency actions. (True/False)
-
The Administrative Procedure Act provides for judicial review of most agency actions. (True/False)
-
Paula Romanov is the credit manager of Pinnacle Inc. She is considering whether to extend credit to Mak Inc., a new customer. Pinnacle sells most of its goods on credit but is very careful in...
-
Draw two scatterplots, one for which r = 1 and a second for which r = 21.
-
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....
-
SE appliances manufactures refrigerators in Richmond, Charlotteand Atlanta. Refrigerators then must be shipped to meet demand inWashington, New York, and Miami. The table below lists shippingcosts,...
-
Muscle FitnessMagazine surveyed 76 adults ages 18-25regarding their exercise programs. The following results wereobtained 30 were using Zumba dance 29 were using Yoga 26 men responded to the survey...
-
Question 2 (5 points) A warehouse has interior dimensions 75 feet long by 30 feet wide by 15 feet tall. What is the warehouse's interior volume measured in cubic meters?
Study smarter with the SolutionInn App