Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help, I'm stuck! If you could include the excel charts for reference, that would be much appreciated! Thank you in advance! Using the Excel

Please help, I'm stuck! If you could include the excel charts for reference, that would be much appreciated! Thank you in advance!

Using the Excel date file in TA3: Pivot Tables & Decision Support, you will create 2 different charts that visually depict the Batch Error data and its associated factors. Instructions

Whether or not you succeeded with TA3: Pivot Tables & Decision Support , you will use that source data to create 2 different Excel charts (like a bar chart and line chart) that depict the batch error data and its associated factors. The choice of which 2 charts is up to you.

  1. You should create a new column called batch error rate - this will be the batch errors divided by the size of the batch. This new column should really be the basis of your Charts (not simply the raw number of batch errors). .
  2. You chart should really have a Chart title and a legend (not to mention colors etc.)
  3. Please provide a short document explaining why you selected these 2 particular types of charts and what they show.
  4. You will submit 2 files to the assignment folder: Your EXCEL worksheet containing the labeled charts and an accompanying WORD documentimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
bal76744_plugint03_002-016.ind x + C G Search Google or type a URL E 1. Production Errors Established in 2002, t-shirts.com has rapidly become the place to find, order, and save on T-shirts. One huge selling factor is that the company manufactures its own T-shirts. How- ever, the quality manager for the production plant, Kasey Harnish, has noticed an unac- ceptable number of defective T-shirts being produced. You have been hired to assist Kasey in understanding where the problems are concentrated. He suggests using a PivotTable to perform an analysis and has provided you with a data file, T3_Tshirt Production_Data.xls. The following is a brief definition of the information within the data file: A. Batch: A unique number that identifies each batch or group of products produced. B. Product: A unique number that identifies each product. C. Machine: A unique number that identifies each machine on which products are produced. D. Employee: A unique number that identifies each employee producing products. E. Batch Size: The number of products produced in a given batch. F. Num Defect: The number of defective products produced in a given batch. B 9 AENG 10 - 11/27/2019 Document11 - Word Sign in - 0 X Hile Home Insert Design layout Reterences Share Mailings Review PRODUCT View Help MACHINE BATCH NUM DEFECTIVE Tell me what you want to do EMPLOYEE BATCH SIZE 3333 500 5555 10000 2222 5000 4444 1000 3133 1000 1111 50DX 2222 10000 3333 10000 1111 5000 3555 500 3333 500 1444 1000 2222 5000 3333 10000 1111 10000 1111 5000 500 500 3333 500 2222 1000 5555 10000 3333 10000 4444 10000 2222 5000 3355 1000 1111 1000 2222 3000 3333 10000 4444 500 5555 10000 500 Page 1 of 2 464 words E English (United States) EDES- 1e ax N P W - + 100% 10:58 AM 11/27/2019 E - Document11 - Word Table Tools Sign in - 0 X File Home Insert Design Layout References Mailings Review View Help Design Layout Tell me what you want to do Share 4444 3355 3333 2222 4444 1111 3333 2222 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 2222 2222 2222 2222 3333 1111 500 2222 3555 1414 3555 10000 500 5000 1000 1000 3000 Page 1 of 2 464 words & English (United States) BE - + 100% ce o ox N P W ES - 90 ENG 11/21/2019 Document11 - Word Table Tools Sign in - 0 X Hile Home Insert Design layout References Mailings Review View Help layout Tell me what you want to do Share Design 5555 1111 2222 3333 1000 5000 500 10000 500 50DX 1000 1000 5000 500 5555 2222 1111 3333 2222 1444 3333 5555 4444 1111 2222 1111 2222 3333 10000 3000 1000 1000 5000 10000 500 500 10000 2222 5855 4444 3555 3333 1111 3355 500 10000 5000 1000 500 300 10000 3000 Page 2 of 2 464 words E English (United States) 88 E- ce o ox N P W - + 100% 10:59 AM 3 . 0 - ENG bal76744_plugint03_002-016.ind x + C G Search Google or type a URL E 1. Production Errors Established in 2002, t-shirts.com has rapidly become the place to find, order, and save on T-shirts. One huge selling factor is that the company manufactures its own T-shirts. How- ever, the quality manager for the production plant, Kasey Harnish, has noticed an unac- ceptable number of defective T-shirts being produced. You have been hired to assist Kasey in understanding where the problems are concentrated. He suggests using a PivotTable to perform an analysis and has provided you with a data file, T3_Tshirt Production_Data.xls. The following is a brief definition of the information within the data file: A. Batch: A unique number that identifies each batch or group of products produced. B. Product: A unique number that identifies each product. C. Machine: A unique number that identifies each machine on which products are produced. D. Employee: A unique number that identifies each employee producing products. E. Batch Size: The number of products produced in a given batch. F. Num Defect: The number of defective products produced in a given batch. B 9 AENG 10 - 11/27/2019 Document11 - Word Sign in - 0 X Hile Home Insert Design layout Reterences Share Mailings Review PRODUCT View Help MACHINE BATCH NUM DEFECTIVE Tell me what you want to do EMPLOYEE BATCH SIZE 3333 500 5555 10000 2222 5000 4444 1000 3133 1000 1111 50DX 2222 10000 3333 10000 1111 5000 3555 500 3333 500 1444 1000 2222 5000 3333 10000 1111 10000 1111 5000 500 500 3333 500 2222 1000 5555 10000 3333 10000 4444 10000 2222 5000 3355 1000 1111 1000 2222 3000 3333 10000 4444 500 5555 10000 500 Page 1 of 2 464 words E English (United States) EDES- 1e ax N P W - + 100% 10:58 AM 11/27/2019 E - Document11 - Word Table Tools Sign in - 0 X File Home Insert Design Layout References Mailings Review View Help Design Layout Tell me what you want to do Share 4444 3355 3333 2222 4444 1111 3333 2222 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 2222 2222 2222 2222 3333 1111 500 2222 3555 1414 3555 10000 500 5000 1000 1000 3000 Page 1 of 2 464 words & English (United States) BE - + 100% ce o ox N P W ES - 90 ENG 11/21/2019 Document11 - Word Table Tools Sign in - 0 X Hile Home Insert Design layout References Mailings Review View Help layout Tell me what you want to do Share Design 5555 1111 2222 3333 1000 5000 500 10000 500 50DX 1000 1000 5000 500 5555 2222 1111 3333 2222 1444 3333 5555 4444 1111 2222 1111 2222 3333 10000 3000 1000 1000 5000 10000 500 500 10000 2222 5855 4444 3555 3333 1111 3355 500 10000 5000 1000 500 300 10000 3000 Page 2 of 2 464 words E English (United States) 88 E- ce o ox N P W - + 100% 10:59 AM 3 . 0 - ENG

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers And Executives

Authors: Cheryl Jones, Steven A. Finkler, Christine T. Kovner, Jason Mose

5th Edition

0323415164, 9780323415163

More Books

Students also viewed these Finance questions