Question: 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

Create a data table that contains each person’s total revenue and units sold.

G H 4 Trans Number Name 5 6 7 8 9 10

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

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The data table that contains each persons total revenue and units sold Trans Number Name Units Date ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!

Use the data in the file named Makeupdb.xlsx to create a data table that shows the average per-unit revenue generated by each person for sales in which the average per-unit price exceeded $3.30. G H...

5) Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at the bottom of the database listing, row 37 columns E, F, G. The...

You have decided that you are now an expert in project cost estimating, and you want to hold some public classes or workshops on this topic. You completed some training in the past, which has given...

You can find the data for this chapters problems in the file Makeupsubtotals.xlsx. Use the Subtotal command for the following computations: Create a consolidated worksheet that gives the largest...

I NEED HELP ASAP PLEASE!!!! At the end of the first month of opening your business, you calculate the actual operating costs of the business and the income you earned. You also notice and document...

File Home Insert Draw Page Layout A1 Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Xfx...

In the Makeupdb.xlsx file, what was the average number of lipstick units sold by Jen in the East region? G H 4 Trans Number Name 5 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina...

In the Makeupdb.xlsx file, how many dollars worth of lipstick were sold by Colleen or Zaret in the East 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...

In the file Makeupdb.xlsx, find all the unique combinations of name, product, and location occurring during the first three months of 2006. G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16...

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...

Vacek is paid a monthly commission on a graduated basis of 7-% on net sales of $7000, 9% on the next $8000, and 11% on any additional sales. If sales for April were $21,500 and sales returns were...

This problem fits an ARIMA model to the logarithms monthly one-month T-bill rates in the data set Mishkin in the Ecdat package. Run the following code to get the variable: library(Ecdat)...