Using the data in the file named Makeupdb.xlsx, how many units of lip gloss did Zaret sell
Question:
Using the data in the file named Makeupdb.xlsx, how many units of lip gloss did Zaret sell during 2004 and 2005?
Transcribed Image Text:
G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 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 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: 28% (7 reviews)
To find out how many units of lip gloss Zaret sold in 2004 and 2005 look at the data in the U...View the full answer
Answered By
Akash M Rathod
I have been utilized by educators and students alike to provide individualized assistance with everything from grammar and vocabulary to complex problem-solving in various academic subjects. I can provide explanations, examples, and practice exercises tailored to each student's individual needs, helping them to grasp difficult concepts and improve their skills.
My tutoring sessions are interactive and engaging, utilizing a variety of tools and resources to keep learners motivated and focused. Whether a student needs help with homework, test preparation, or simply wants to improve their skills in a particular subject area, I am equipped to provide the support and guidance they need to succeed.
0.00
0 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
-
Use the file named Makeup2007.xlsx for questions 1016. How many units of lip gloss did Cici sell in 2004? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 1 Betsy 2 Hallagan 3 Ashley...
-
How many units of lip gloss did Colleen sell outside the West region? G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 Betsy 2 Hallagan 3 Ashley 4...
-
In the Makeupdb.xlsx file, how many dollars worth of lip gloss did Jen sell? 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...
-
A Ltd acquired a 60% shareholding interest in B Ltd in 20x4. B Ltd acquired a 30% shareholding interest in C Ltd in 20x5. A Ltd acquired a 30% shareholding interest in C Ltd in 20x6. For the year...
-
How are the concepts of risk and internal control related?
-
The management of the Esquire Oil Company believes that the wholesale price of heating oil that they sell to homeowners will increase again as the result of increased political problems in the Middle...
-
In 2016, a hacker tricked a Lamps Plus employee into disclosing the tax information of approximately 1,300 other employees, resulting in the filing of a fraudulent income tax return of Lamps Plus...
-
(One Temporary Difference, Future Taxable Amounts, One Rate, Beginning Deferred Taxes) Brennan Corporation began 2010 with a $90,000 balance in the Deferred Tax Liability account. At the end of 2010,...
-
2. A plain concrete cylinder with dimensions of 12" height and 6" diameter is tested using spilt tension test. The failure load was measured to be 70 kN. What is the indirect tensile strength of...
-
1. Case Exhibit 2 presents monthly data of units produced and sold, and actual costs incurred, for 24 months. B Create a scatterplot of costs and units. b. From your scatterplot, estimate the...
-
Create a data table that contains each persons total revenue and units sold. G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 Betsy 2 Hallagan 3 Ashley...
-
The file named Jordan.xlsx gives (hypothetical) starting salaries of all 1984 geography graduates from the University of North Carolina (UNC). What is your best estimate of a typical starting salary...
-
The Bureau of Labor Statistics says that baggage handlers, trash haulers, and coal miners are among the occupations having the highest risk of a debilitating injury or illness. For coal miners...
-
What is the link between greenhouse gas emissions and growth? What is the expected effect on growth from emissions reduction? Why is international burden sharing of greenhouse gas emissions reduction...
-
Mary is a newly licensed pharmacist hired to work at a small independent pharmacy in town. On her first weekend at work as a pharmacist, she is instructed by the owner to complete a controlled...
-
Using the state pharmacy laws and rules from your state, how does your state regulate hospital pharmacies? What are some main differences between the state regulations covering community pharmacy...
-
Lim is a new pharmacist heavily in debt. A couple of Lims patients at the pharmacy who regularly received prescriptions for controlled substances told Lim they could make it worth his while if he...
-
Using the state pharmacy laws and rules from your state, does your state have any drug repository or take-back programs? If yes, describe the details.
-
Enron Corporation was a major U. S. energy company. Its executives engaged in a systematic accounting fraud that resulted in the companys bankruptcy in 2001. In a February 19, 2004, press release,...
-
The Thomas Corporation was organized on Jan. 1, 2020. On Dec. 31, 2021, the corporation lost most of its inventory in a warehouse fire before the year-end count of inventory was to take place. just...
-
Equipment Group produces excavating equipment for contractors. Equipment Group is working on the annual financial statements for its shareholders, who are expecting profits of $121,000,000 for the...
-
Equipment Group produces excavating equipment for contractors. Equipment Group is working on the annual financial statements for its shareholders, who are expecting profits of $121,000,000 for the...
-
Describe the characteristics of companies likely to use a job costing system. Explain how these characteristics differ from companies likely to use a process costing system.
-
Labor Demand Explain/define the following terms and how they relate to labor demand. 1. Short Run - Definition - Marginal productivity - Average productivity - MRP, VMP, and VAP - Individual Market...
-
Minimum Wage Suppose the government passes a law that makes it so firms can't use fringe benefits. In other words, the government will pay for health insurance, PTO, maternity leave, etc.. The...
-
Answer all the questions on this docs on supply and demand all of the an swers are listed on the Google Docs. You just have to read and fill in all the information I've done half of it....
Study smarter with the SolutionInn App