Question: In the Summary worksheet use a CountIF to determine the # of batches for each Product #. In the Summary worksheet use a SumIF to

In the Summary worksheet use a CountIF to determine the # of batches for each Product #.
In the Summary worksheet use a SumIF to Total the # of Defects for each Employee # and an AverageIF to do an average # of defects for each Employee #.

Batch: A unique number that identifies each batch or group of products produced.

Product: A unique number that identifies each product.

Machine: A unique number that identifies each machine on which products are produced.

Employee: A unique number that identifies each employee producing products.

Batch Size: The number of products produced in a given batch.

Num Defect: The number of defective products produced in a given batch.

In the Summary worksheet use a CountIF to

4 5 6 7 8 9 10 11 12 13 14 15 B PRODUCT # 10 20 30 30 20 20 30 10 10 30 20 30 10 F. NUM DEFECTIVE 15 10 13 12 5 9 20 14 16 18 4 8 5 7 21 15 6 9 0 15 12 16 30 30 10 10 10 10 20 10 20 BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 30 30 20 MACHINE # 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 6 7 8 5 6 5 7 5 8 6 7 8 6 7 5 6 8 6 7 8 7 5 8 6 D EMPLOYEE # 1003 1005 1002 1004 1003 1001 1002 1003 1001 1005 1003 1004 1002 1003 1001 1001 1001 1004 1003 1002 1005 1003 1004 1002 1005 1001 1002 1003 1004 1005 1004 1005 1003 1002 1004 1001 1003 1002 1004 1002 1002 1002 1002 1003 1001 1004 1002 1005 1004 1005 E BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 20 20 30 30 30 10 10 20 30 30 8 12 6 8 5 18 15 4 13 5 18 11 23 14 3 9 1 15 19 3 20 10 30 10 10 20 44 20 30 12 45 46 47 48 49 50 51 52 53 54 20 30 20 20 30 30 10 51 52 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 7 5 6 7 7 6 5 7 6 7 8 8 6 7 5 6 7 6 7 8 6 1001 1002 1003 1004 1005 1002 1001 1003 1002 1004 1003 1005 1004 1001 1002 1001 1002 1003 1004 1002 1005 1004 1005 1003 1001 1005 5000 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 13 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 74 75 76 Production Data Summary D B C 1 # of Batch's of each 2 Product # Product # 3 10 4 20 5 30 6 7 Total # Average # 8 Employee Defects of Defects 9 1001 10 1002 11 1003 12 1004 13 1005 14 15 16 17 18 19 20 21 22 23 24 25 26 Production Data Summary 4 5 6 7 8 9 10 11 12 13 14 15 B PRODUCT # 10 20 30 30 20 20 30 10 10 30 20 30 10 F. NUM DEFECTIVE 15 10 13 12 5 9 20 14 16 18 4 8 5 7 21 15 6 9 0 15 12 16 30 30 10 10 10 10 20 10 20 BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 30 30 20 MACHINE # 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 6 7 8 5 6 5 7 5 8 6 7 8 6 7 5 6 8 6 7 8 7 5 8 6 D EMPLOYEE # 1003 1005 1002 1004 1003 1001 1002 1003 1001 1005 1003 1004 1002 1003 1001 1001 1001 1004 1003 1002 1005 1003 1004 1002 1005 1001 1002 1003 1004 1005 1004 1005 1003 1002 1004 1001 1003 1002 1004 1002 1002 1002 1002 1003 1001 1004 1002 1005 1004 1005 E BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 20 20 30 30 30 10 10 20 30 30 8 12 6 8 5 18 15 4 13 5 18 11 23 14 3 9 1 15 19 3 20 10 30 10 10 20 44 20 30 12 45 46 47 48 49 50 51 52 53 54 20 30 20 20 30 30 10 51 52 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 7 5 6 7 7 6 5 7 6 7 8 8 6 7 5 6 7 6 7 8 6 1001 1002 1003 1004 1005 1002 1001 1003 1002 1004 1003 1005 1004 1001 1002 1001 1002 1003 1004 1002 1005 1004 1005 1003 1001 1005 5000 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 13 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 74 75 76 Production Data Summary D B C 1 # of Batch's of each 2 Product # Product # 3 10 4 20 5 30 6 7 Total # Average # 8 Employee Defects of Defects 9 1001 10 1002 11 1003 12 1004 13 1005 14 15 16 17 18 19 20 21 22 23 24 25 26 Production Data Summary

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

Suppose you have n rooms that you would like to connect in a communication network in one of the dormitories of Flash University. You have modeled the problem using a connected, undirected graph, G,...

A B D E Percent of Portfolio Portfolio Target Portfolio Summary Number of Average Investment Type Investments Yield # Bond Fund Domestic Stock Fund 5 International Stock Fund - Individual Stock 7 8...

Please show all work in excel thanks! Portfolio Summary- portfolio worksheet Investment Type Number of Investments Average Yield Percent of Portfolio Portfolio Target Bond Fund Domestic Stock Fund...

using this file http://www.flatworldknowledge.com/sites/all/files/ManzoExcel_1.0_Chapter_3_Skills_Test.xlsx please show all work in excel, thank you! 1. Set the Freeze Panes command so that Rows 1...

Open the starter file listed above before you begin this test. Open the starter file before you begin this test. 1 . 2 . 3 . 4 . 5 . 6 . 7 . Set the Freeze Panes command so that Rows 1 and 2 and...

E F D B A Percent of Portfolio Portfolio Target 1 Portfolio Summary Number of Average Investment Type 2 Investments Yield 3 Bond Fund 4 Domestic Stock Fund 5 International Stock Fund 6 Individual...

help.. COMBINED CASH BUDGET LAB 7 Now that the operating budgets are complete, Tonia and Tara prepare a combined cash budget for the upcoming year. Based on the forecasted cash balances each month,...

I need help with #13-#28 PLEASE!!!!! how do I share the excel link file? 1 Start Excel. Download and open the file named Excel_Ch10_Prepare_Expansion Analysis_20f2.xlsx. Grader has automatically...

Grader - Instructions Excel 2019 Project YO19_Excel_Ch10_Prepare - Expansion Analysis Part B 1.0 Project Description: Bary Cheney, the Golf Course Manager at the Red Bluff Golf Course & Pro Shop, has...

Step Instructions Points Possible 1 0 Start Excel. Download and open the file named e06c1DirecoWarketing.xlsx. Save it as e06c1DirectMarketing_LastFirst.xlsx. Note: You must save the file name...

Read the Data Characteristics for Business Intelligence Demonstrate understanding of the business value of data governance. Analyze the effects of data quality. Encapsulate the processes of data...

What is a group? What is a work team?

E2.17 A spring develops a force f represented by the relation f = kx2, where x is the displacement of the spring. Determine a linear model for the spring when xo = 12.

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...