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

For the data in the file named Tablemakeuptemp.xlsx (in this chapter’s Templates folder), determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the East region.

E 3 Trans Number 34567 8 600 9 10 11 12 23

E 3 Trans Number 34567 8 600 9 10 11 12 23 13 14 56 15 16 17 18 19 20 21 22 F Name 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 Date H Product 38078 lip gloss 38056 foundation 38408 lipstick 38859 lip gloss 38155 lip gloss 38683 eye liner 38067 eye liner 39068 lip gloss 38903 eye liner 38936 lip gloss 38320 mascara 38309 lip gloss 38595 lip gloss 38353 eye liner 38980 foundation 38089 mascara 38837 mascara 38595 lip gloss 38287 eye liner G Units K Location Dollars 45 137.2045583 south 50 152.0073031 midwest 9 28.71948312 midwest 55 167.0753225 west 43 130.6028724 midwest 58 175.9909741 midwest 8 25.80069218 midwest 72 217.8396539 midwest 75 226.6423269 south 24 73.50234217 east 43 130.8353684 east 23 71.03436769 west 49 149.5927969 west 18 56.47199923 south -8 -21.99304472 east 45 137.3903759 east 66 199.6543347 south 88 265.1875515 midwest 78 236.1469779 south

Step by Step Solution

★★★★★

3.40 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the ... 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!

Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically...

Find all transactions where Ava was the salesperson or magazines were sold. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure...

Sort the data in descending order of units, breaking ties based on dollars in descending order. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...

Can someone please guide me through the last question titled Exercise 2 going for 2 where you have to use the AND OR and ABS formulas I can't wrap my head around doing it. MIS 204 - Lab 3 This lab...

need help with the formulas for the 4 questions. AutoSave Off Problem Set 01 (1) - O Search Thomas Pontarelli TP File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri...

The MakeupSales.xlsx file gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this file to perform...

Can you show the formulas for the Total number of returned lip gloss and Number of transactions sold by Jen or Ashley. I am completely lost because the information goes all the way down to the last...

L4 x y f A B D E F G H K M N o Q Problem: The data below contains information about the sales of makeup products. For each transaction, you are given the following information: 1. Name of salesperson...

please can you help me with a formuar to calculate: -Revenue of mascara -Average units foundation sold per transaction by market when units more than 10. I will figure the rest out. thank you. 1 2 3...

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

An exam is given to students in an introductory statistics course. What is likely to be true of the shape of the histogram of scores if: a. the exam is quite easy? b. the exam is quite difficult? c....

For the fiscal year ended March 31, 2017, a company reported earnings per share of $1.95 and cash dividends per share of $0.30. During fiscal 2018, the company had a 3-for-2 stock split. In the...