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: 40% (5 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?
-
Southern Exposure Ltd. begins operations on January 2, 2016. During the year, the following transactions affect shareholders equity: 1. Southern Exposures articles of incorporation authorize the...
-
It has been found time and time again that the relationship between age and life satisfaction is nonlinear: younger people are satisfied, and then dissatisfaction creeps in, in middle age, and then...
-
The blade divides the jet of water having a diameter of 3 in. If one-fourth of the water flows downward while the other three-fourths flows upwards, and the total flow is Q = 0.5 ft3/s, determine the...
-
Deer & Co is a leading manufacturer of construction equipment, engines, gas turbines and diesel-electric locomotives. [Deer & Co] also provides financing and related services through its Financial...
-
The shareholders of X Ltd. will vote at the forthcoming annual meeting on a proposal to establish a bonus plan for X Ltd. management, based on firm earnings. Proponents of the plan argue that...
-
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...
-
Floyd Industries stock has a beta of 1.30. The company just paid a dividend of $0.95, and the dividends are expected to grow at 4.5 percent per year. The expected return on the market is 11 percent,...
-
Provide a brief bio of the leader and a brief overview of the change or crisis they led the organization or movement through. Discuss their leadership style during this change/crisis using one of the...
-
Write a C++ function named Ifsr that accepts feedback path and initial states as unsigned integers and the number of random bits to be printed as arguments. The function will print the random bits by...
-
Newfoundland Hapset will be remitted to _____
-
The Z Energy Corp. has a new investment opportunity that generates cash flows of $6 million per year (in expectation) forever. The managers of Z Energy are not sure what the required rate of return...
-
Define an interface TwoStrings Oper declaring a function apply which takes two strings and returns a string. Then, define four classes implementing this interface, where the operation on strings...
-
Suppose that the Cobb-Douglas production function is q = L0.75K0.25. a. What is the average product of labor, holding capital fixed? b. What is the marginal product of labor? c. What are the APL and...
-
San Carlos Bank and Trust Company uses a credit-scoring system to evaluate most consumer loans that amount to more than $2,500. The key factors used in its scoring system are found at the conclusion...
-
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?
-
Diplomatic Security Service provides Airport Transportation and Surveillance Service to Foreign Diplomats in Guyana. The company has two support departments - Information Systems and Equipment...
-
Q1: A disparity of bargaining power between the parties to a contract may result in unfair terms but a court is not likely to consider the contract unconscionable. Group of answer choices a. True b....
-
Life Tool Manufacturing has a system in place to recall products that prove to be dangerous at some time after manufacture and distribution. This represents which element of the due care theory?...
Study smarter with the SolutionInn App