14. Create a one variable Data Table from what you just copied and pasted giving the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
14. Create a one variable Data Table from what you just copied and pasted giving the total sales for each department, and the Largest Sale from each department. Start your Criteria range in cell A1. 15. On the Data table Sheet. Create a 2 variable data table starting in Cell A20 giving the Average Sales for each department by Gender. Start your Criteria Range in cell A15. 16. On the Employee Sales sheet, in Cell A52, create a formula to calculate the Average sales by Males. Use the criteria range in cells A47:A48. 17. On the Employee Sales sheet, in cell C52, create a formula to calculate the Total sales by Females. Use the criteria range in Cells C47:C48. C D E G 5 6 Employee Last Name First Name Gender Department 7 03467 Lorenz Alvaro M Small Appliances 808467 Brooks Arnold M Small Appliances Total Sales $6,377.46 $6,534.35 Ron Baker Head lookup Ron Baker Ron Baker Ron Baker OK Sales OK Sales Head Nested IF Sales lookup Sales Nested OK Sales OK Sales 901340 Snyder Brett M Small Appliances $ 11,447.40 Ron Baker Ron Baker Above Average Sales Above Average Sales 10 04070 Underwood David M 11 64483 Munsell Eddie M Small Appliances $3,420.97 Ron Baker Small Appliances $ 6,330.19 Ron Baker OK Sales OK Sales Ron Baker Ron Baker OK Sales OK Sales 12 25447 Hewitt Erica F Small Appliances $ 8,209.89 Ron Baker Ron Baker Average Sales Average Sales 13 00654 Brolick Ernest M Large Appliances $ 20,107.54 David Burk David Burk Excellent Sales Excellent Sales 14 00210 Radden Eugene M 15 03489 Headly Frank M Large Appliances $22,267.74 David Burk Large Appliances $ 21,300.33 David Burk Excellent Sales Excellent Sales David Burk David Burk Excellent Sales Excellent Sales 16 65780 Riley Hector M Large Appliances $ 22,733.23 David Burk David Burk Excellent Sales Excellent Sales 17 14498 Norris Jack M Large Appliances $ 24,294.10 David Burk David Burk Excellent Sales Excellent Sales 18 09531 Dawson James M Large Appliances $ 24,281.34 David Burk David Burk Excellent Sales Excellent Sales 19 07864 Gossick Jeff M Large Appliances $ 24,502.07 David Burk David Burk Excellent Sales Excellent Sales 20 35448 Hancock Joanni F Large Appliances $22,226.69 David Burk David Burk Excellent Sales Excellent Sales 21 02346 Foster Joe M Audio 5 1,748.53 Paul Keith Paul Keith Low Sales Low Sales 22 06548) Faux John M Computers $ 2,296.79 Timothy Stephens 23 32485 Timothy Stephens Low Sales Low Sales Kune Juan M Audio 24 00967 Verley Judy F Audio $ $ 1,423.42 Paul Keith 951.19 Paul Keith Paul Keith Low Sales Low Sales Paul Keth Low Sales Low Sales 25 66789 Lamore Kathi F Audio $ 1,025.14 Paul Keith Paul Keith Low Sales 20 25799 Low Sales Porter Om F Audio $ 1,239.27 Paul Keth Paul Keith 27 00505 Faust Low Sales Linda Low Sales " Audio $ 1,893.67 Paul Keith 28 0654 Paul Keth Burk Louise F Computers 29 05487 Fox Ayrin M Computers 30 00325 Mills Marco M Computers 31 32087 Maria Computers 32 03587 Cook Melissa ' Small Appliances 33 17456 Matthews Miguel M 34 02347 Goldstein Mitch M Computers Computers > Employee Sales Department Head Sales Low Sales Average Sales Average Sales 5 9.484.44 Timothy Stephens Timothy Stephens Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 813156 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales Average Sales 1916.41 Timothy Stephens Timothy Stechens Low Sales Data Table Low Sales Average Sales Average Sales Low Sales G H Average Sales Average Sales Low Sales Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Computers $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Average Sales Small Appliances S 8,131.56 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales $ 1,916.41 Timothy Stephens Timothy Stephens Low Sales 5 14,317.26 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 1,921 24 Paul Keth Paul Keith $ 11,403.55 Stephanie Givens Stephanie Givens $ 8,041,70 Stephanie Givens Stephanie Givens $ 4,728.39 Stephanie Givens Stephanie Givens Low Sales Above Average Sales Average Sales Low Sales Above Average Sales Average Sales OK Sales OK Sales Low Sales Low Sales Low Sales OK Sales $ 1,662.00 Paul Keth 5 1,74886 Paul Keith Small Appliances 5 6,136.23 Ron Baker Paul Keith Paul Keith Ron Baker $ 9,510.22 Stephanie Givens Stephanie Givens Average Sales $ 3.172.59 Stephanie Givens Stephanie Givens OK Sales 59,498.65 Stephanie Owens Stephanie Givens Average Sales $9.350 10511 Low Sales OK Sales Average Sales OK Sales Average Sales C D 29 05487 Fox Lynn M Computers 30 00325 Mills Marco M Computers 31 32087 Salcito Maria F 32 03587 Cook Melissa F 33 32486 Matthews Miguel M Computers 34 02347 Goldstein Mitch M Computers 35 06455 Gonzales Patrick M Computers 36 63508 Scott Paul M Audio 38 37 87851 06879 39 01279 Edwards Richard M Eberly Roberta F Electronics Electronics Harris Ronald M Electronics 40 45676 McMains Steven M Audio 41 00657 Stanton Susan F Audio 42 00104 Skelton Theresa 43 03483 Prutt Vince 44 03589 Owen Wame 45 36445 Patel Tony 523 M Electronics Electronics M Electronics 40 47 Gender 48 M Gender F 49 50 51 Mae Sa 52 53 54 Female Sales 14. Create a one variable Data Table from what you just copied and pasted giving the total sales for each department, and the Largest Sale from each department. Start your Criteria range in cell A1. 15. On the Data table Sheet. Create a 2 variable data table starting in Cell A20 giving the Average Sales for each department by Gender. Start your Criteria Range in cell A15. 16. On the Employee Sales sheet, in Cell A52, create a formula to calculate the Average sales by Males. Use the criteria range in cells A47:A48. 17. On the Employee Sales sheet, in cell C52, create a formula to calculate the Total sales by Females. Use the criteria range in Cells C47:C48. C D E G 5 6 Employee Last Name First Name Gender Department 7 03467 Lorenz Alvaro M Small Appliances 808467 Brooks Arnold M Small Appliances Total Sales $6,377.46 $6,534.35 Ron Baker Head lookup Ron Baker Ron Baker Ron Baker OK Sales OK Sales Head Nested IF Sales lookup Sales Nested OK Sales OK Sales 901340 Snyder Brett M Small Appliances $ 11,447.40 Ron Baker Ron Baker Above Average Sales Above Average Sales 10 04070 Underwood David M 11 64483 Munsell Eddie M Small Appliances $3,420.97 Ron Baker Small Appliances $ 6,330.19 Ron Baker OK Sales OK Sales Ron Baker Ron Baker OK Sales OK Sales 12 25447 Hewitt Erica F Small Appliances $ 8,209.89 Ron Baker Ron Baker Average Sales Average Sales 13 00654 Brolick Ernest M Large Appliances $ 20,107.54 David Burk David Burk Excellent Sales Excellent Sales 14 00210 Radden Eugene M 15 03489 Headly Frank M Large Appliances $22,267.74 David Burk Large Appliances $ 21,300.33 David Burk Excellent Sales Excellent Sales David Burk David Burk Excellent Sales Excellent Sales 16 65780 Riley Hector M Large Appliances $ 22,733.23 David Burk David Burk Excellent Sales Excellent Sales 17 14498 Norris Jack M Large Appliances $ 24,294.10 David Burk David Burk Excellent Sales Excellent Sales 18 09531 Dawson James M Large Appliances $ 24,281.34 David Burk David Burk Excellent Sales Excellent Sales 19 07864 Gossick Jeff M Large Appliances $ 24,502.07 David Burk David Burk Excellent Sales Excellent Sales 20 35448 Hancock Joanni F Large Appliances $22,226.69 David Burk David Burk Excellent Sales Excellent Sales 21 02346 Foster Joe M Audio 5 1,748.53 Paul Keith Paul Keith Low Sales Low Sales 22 06548) Faux John M Computers $ 2,296.79 Timothy Stephens 23 32485 Timothy Stephens Low Sales Low Sales Kune Juan M Audio 24 00967 Verley Judy F Audio $ $ 1,423.42 Paul Keith 951.19 Paul Keith Paul Keith Low Sales Low Sales Paul Keth Low Sales Low Sales 25 66789 Lamore Kathi F Audio $ 1,025.14 Paul Keith Paul Keith Low Sales 20 25799 Low Sales Porter Om F Audio $ 1,239.27 Paul Keth Paul Keith 27 00505 Faust Low Sales Linda Low Sales " Audio $ 1,893.67 Paul Keith 28 0654 Paul Keth Burk Louise F Computers 29 05487 Fox Ayrin M Computers 30 00325 Mills Marco M Computers 31 32087 Maria Computers 32 03587 Cook Melissa ' Small Appliances 33 17456 Matthews Miguel M 34 02347 Goldstein Mitch M Computers Computers > Employee Sales Department Head Sales Low Sales Average Sales Average Sales 5 9.484.44 Timothy Stephens Timothy Stephens Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 813156 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales Average Sales 1916.41 Timothy Stephens Timothy Stechens Low Sales Data Table Low Sales Average Sales Average Sales Low Sales G H Average Sales Average Sales Low Sales Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Computers $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Average Sales Small Appliances S 8,131.56 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales $ 1,916.41 Timothy Stephens Timothy Stephens Low Sales 5 14,317.26 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 1,921 24 Paul Keth Paul Keith $ 11,403.55 Stephanie Givens Stephanie Givens $ 8,041,70 Stephanie Givens Stephanie Givens $ 4,728.39 Stephanie Givens Stephanie Givens Low Sales Above Average Sales Average Sales Low Sales Above Average Sales Average Sales OK Sales OK Sales Low Sales Low Sales Low Sales OK Sales $ 1,662.00 Paul Keth 5 1,74886 Paul Keith Small Appliances 5 6,136.23 Ron Baker Paul Keith Paul Keith Ron Baker $ 9,510.22 Stephanie Givens Stephanie Givens Average Sales $ 3.172.59 Stephanie Givens Stephanie Givens OK Sales 59,498.65 Stephanie Owens Stephanie Givens Average Sales $9.350 10511 Low Sales OK Sales Average Sales OK Sales Average Sales C D 29 05487 Fox Lynn M Computers 30 00325 Mills Marco M Computers 31 32087 Salcito Maria F 32 03587 Cook Melissa F 33 32486 Matthews Miguel M Computers 34 02347 Goldstein Mitch M Computers 35 06455 Gonzales Patrick M Computers 36 63508 Scott Paul M Audio 38 37 87851 06879 39 01279 Edwards Richard M Eberly Roberta F Electronics Electronics Harris Ronald M Electronics 40 45676 McMains Steven M Audio 41 00657 Stanton Susan F Audio 42 00104 Skelton Theresa 43 03483 Prutt Vince 44 03589 Owen Wame 45 36445 Patel Tony 523 M Electronics Electronics M Electronics 40 47 Gender 48 M Gender F 49 50 51 Mae Sa 52 53 54 Female Sales
Expert Answer:
Related Book For
Basic Statistics For Business And Economics
ISBN: 9780073521473
8th Edition
Authors: Douglas Lind, William Marchal, Samuel Wathen
Posted Date:
Students also viewed these finance questions
-
Please provide code for a unit test program to test the following functions: def addition(x, y): return x + y def subtraction(x, y): return x - y def multiplication(x, y): return x * y def...
-
Define variable. Also discuss variable initialization.
-
Exhibit 14.12 presents data from a recent year on market-to-book ratios, ROCE, the cost of equity capital, and price-earnings ratios for seven pharmaceutical companies. (Note that price-earnings...
-
Provide the codification references to support your answers Scope Questions 1. Which entities are subject to the Interim Reporting guidance within the Codification? 2. Does the Foreign Currency...
-
Describe the various forms of sterilization.
-
Sophia is a contestant on a game show and has selected the prize that lies behind door number 3. The shows host tells her that there is a 50 percent chance that there is a $15,000 diamond ring behind...
-
Miguel is an accounting manager for Bronx Shoes Company. In designing the coding scheme for the companys accounting system, Miguel is considering assigning numbers A10 through A99 for all asset...
-
You are planning to purchase the stock of Ted's Sheds Inc. and you expect it to pay a dividend of $3 in 1 year, $4.25 in 2 years, and $6.00 in 3 years. You expect to sell the stock for $100 in 3...
-
Interview three franchisees to better understand their relationship with the franchisor.
-
You are considering an investment in a clothes distributor. The company needs $100,000 today and expects to repay you $120,000 in a year from now. What is the IRR of this investment opportunity?...
-
Suppose Pepsicos stock has a beta of 0.57. If the risk-free rate is 3% and the expected return of the market portfolio is 8%, what is Pepsicos equity cost of capital?
-
Hubbard Industries is an all-equity firm whose shares have an expected return of 10%. Hubbard does a leveraged recapitalization, issuing debt and repurchasing stock, until its debt-equity ratio is...
-
Should firms such as Aereo (see opening profile) be allowed to provide access to television broadcasts without their approval? Consider both sides of the argument to make a more convincing argument.
-
Consider an item you have recently returned. Identify the steps the company would have to go through to return the product back up the supply chain from where you have returned it. What costs do you...
-
The National Collegiate Athletic Association (NCAA) and the National Federation of State High School Associations (NFHS) set a new standard for non-wood baseball bats. Their goal was to ensure that...
-
For the periodic processes shown below: a. Schedule the processes using an RMS policy. b. Schedule the processes using an EDF policy. In each case, compute the schedule for an interval equal to the...
-
For the periodic processes shown below: a. Schedule the processes using an RMS policy. b. Schedule the processes using an EDF policy. In each case, compute the schedule for an interval equal to the...
-
For the given periodic process execution times and periods (P1 has the highest priority), show how much CPU time of higher-priority processes will be required during one period of each of the...
Study smarter with the SolutionInn App