Use the file named Makeup2007.xlsx for questions 1016. What is the average number of units of foundation
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
What is the average number of units of foundation sold by Emilee?
Transcribed Image Text:
G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 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 Date J Product 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 K Units L Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 $167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $199.65 88 $ 265.19
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 0% (2 reviews)
As we have the file named Makeup2007xlsx From the above data we have to tell the average number of u...View the full answer
Answered By
Rishi Anand
Hello and welcome to my profile.Let me introduce myself.I am Laiba Ayyub.I am Master degree holder.I got my Masters degree in Mathematics from Riphah International University Islamabad.I have been a good student.I am teaching many students right now.I taught in a High private school in my city.I also take classes in evening from class 8th to 14th.I am expert in doing maths.I believe in students satisfaction.
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. What is the average dollar size of a foundation sale made by Betsy after the end of 2004? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17...
-
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....
-
Use the file named Makeup2007.xlsx for questions 1016. In transactions in which Ashley sold at least 40 units of lipstick, what is the total dollar amount? G H 4 Trans Number Name 456789 10 11 12 13...
-
1) What are the implications of CICs approach to staffing project teams? Is the company using them as training grounds for talented fast-trackers or as dumping grounds for poor performers? 2) How...
-
An auditor typically selects samples when testing controls. What are some factors that that affect the sample sizes used when testing controls?
-
What is the most significant factor in determining whether fantasy sports games constitute gambling? Explain.
-
What is a compilation unit?
-
During audit planning, an auditor obtained the following information: 1. Management has a strong interest in employing inappropriate means to minimize reported earnings for tax-motivated reasons. 2....
-
6. A carver begins work on a block of granite that measures 20 cm by 10 cm by 5 cm. Granite has a density of 2.7 g/cm. What is the mass of the piece of granite? a. What do you need to calculate...
-
Southwick Company uses normal costing in its job- costing system. Partially completed T- accounts and additional information for Southwick for 2012 are as follows: Required Additional information...
-
Use the file named Makeup2007.xlsx for questions 1016. Create a table that, when you enter a year in your worksheet, contains sales of each product by person during that year. G H 4 Trans Number Name...
-
Three electricians are wiring my new home. Electrician 1 by himself will need 11 days to do the job. Electrician 2 by himself will need 5 days to do the job. Electrician 3 by herself will need 9 days...
-
Open the Color Solution.sln file contained in the VB2017\Chap07\Color Solution folder. The btnDisplay_Click procedure should display the color of the item whose item number is entered by the user....
-
When you are solving for the interest rate, if you keep PV and FV constant, but extend the time period, will the interest rate be higher or lower?
-
Do the present and future value formulas depend upon the cash flows occurring at annual intervals?
-
When cash flows occur at a non-annual interval, what interest rate must you use? What number of periods must you use?
-
Can a cubic be a polynomial? Explain and give an example.
-
You have just received a windfall from an investment you made in a friends business. She will be paying you $22,012 at the end of this year, $44,024 at the end of next year, and $66,036 at the end of...
-
At the end of January 2015, the records of Regina Company showed the following for a particular item that sold at $ 18 per unit: Required: 1. Assuming the use of a perpetual inventory system, prepare...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
Allowing employees to use their own smartphones for work will save the company money. Do you agree? Why or why not?
-
What are the benefits of intelligence-driven prosecution for crime fighters and the general public?
-
What problems does this approach to crime fighting pose?
-
2. The following packets have arrived at a router: Arriving Packet 1: Arriving Packet 2: Arriving Packet 3: Destination IP Address 174.16.9.35 Destination IP Address 104.156.5.44 Destination IP...
-
What experience in your home or work do you have with networking and security? When do you access a network? Give a few examples. What types of security are you aware of or are using? Give a few...
-
the housebuilder for the 120 homes (assume land is roughly 10% of the Total Purchase Price) A range of inputs have been provided for you with some inputs left to populate at your discretion, please...
Study smarter with the SolutionInn App