Use the file named Makeup2007.xlsx for questions 1016. What is the average dollar size of a foundation
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
What is the average dollar size of a foundation sale made by Betsy after the end of 2004?
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: 66% (3 reviews)
As we have the file named Makeup2007xlsx From the above data we have to tell the average dollar size ...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
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
In view of the information provided below provide suggestions for the efficient management of trade debtors. INFORMATION MANAGEMENT OF TRADE DEBTORS Debtor management is central to the effective cash...
-
Why would an auditor need to use an outside specialist when performing an audit? Identify specific accounts or assertions where a specialist might be needed.
-
The following information was available for The Gibson Group Inc. (TGGI) for 2016: 1. Class A common shares, 10 votes per share, unlimited authorized, 7,530,000 issued and outstanding on January 1,...
-
We hypothesize that those who more strongly identify with a political party are more engaged and will therefore be more likely to vote. Run a set of logistic regression models using the ANES recoded...
-
Plastic Products, LLC, manufactures plastic beverage bottles. The division that manufactures water bottles for the North American market has two plants that operate 24 hours a day, 365 days a year....
-
7 If the Total Current Liabilities OMR 74,500 and the Total Liabilities is OMR 85,000, then what would be amount of Non-Current Liabilities? of a. OMR 74,500 b. None of these c. OMR 85,000 d. OMR...
-
Modify the sentence-generator program of Case Study so that it inputs its vocabulary from a set of text files at startup. The filenames are nouns.txt, verbs. txt, articles.txt, and prepositions.txt....
-
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...
-
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...
-
Find the length of the altitude to the hypotenuse. Round decimal answers to the nearest tenth. 13.21 83 it 30 is
-
Two firms are bidding for a $100 million contract in an all-pay auction. The bidding continues over many rounds, and each firm must incur a non-recoverable cost equal to 1% of the total value of the...
-
Illustrate the different steps required for the insertion of 58 followed by the deletion of 40 in the following AVL tree. 55 40 50 65 60 60 57 70 70
-
3 undamaged, the suit is returned to the customer. If either (or both) of the parts is (are) damaged, the suit goes to customer relations (Server 5). Assume that all travel times are negligible (0),...
-
Saginaw Incorporated completed its first year of operations with a pretax loss of $677,500. The tax return showed a net operating of $826,500, which the company will carry forward. The $149,000...
-
General Average Problem You've just learned about the concept of general average. Try applying it to the following hypothetical: A cruise ship docks close to Rome for three days, giving the...
-
What are the differences between an isoquant and an indifference curve?
-
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...
-
What are the components of IT infrastructure? List and describe the components of IT infrastructure that firms need to manage.
-
University of Pittsburgh Medical Center: Demand for additional servers and storage technology was growing by 20 percent each year. UPMC was setting up a separate server for every application; servers...
-
Quantas Airways: Needs to keep costs low while providing a high level of customer service. Management had to decide whether to replace its 30-year-old IT infrastructure with newer technology or...
-
Jennifer purchased a home for $1,000,000 in 2016. She paid $200,000 cash and borrowed the remaining $800,000. This is Jennifer's only residence. Assume that in year 2024, when the home had...
-
business plan describing company with strengths and weaknesses. Any gaps in plan. Recommendations for improvement of the plan.
-
You wish to buy a car today for $35,000. You plan to put 10% down and finance the rest at 5.20% p.a. for six years. You will make equal monthly payments of $_______.
Study smarter with the SolutionInn App