This week’s assignment is all about Yogurt.? Manufacturing of yogurt, that is.? Filling of those little cups, to be exact. Complete the attached MS Excel file (both worksheets / tabs) as yo

 

This week's assignment is all about Yogurt.  Manufacturing of yogurt, that is.  Filling of those little cups, to be exact.

Complete the attached MS Excel file (both worksheets / tabs) as your assignment this week. No APA formatted report required; just complete the template's questions.

Part 1 of 2

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Week Two Assignment
Assignment: Part 1 – Is my manufacturing process in control? (Statistically speaking…)
Background on Statistical Controls in Manufacturing: A state of statistical control is defined as a process with a constant mean and variance that is not changing over time. Generally speaking, the upper and lower control limits are set at ± three standard deviations from the mean. If a normal probability distribution is assumed, these control limits will include 99.74 percent of the random variation observed.
UCL = Average + 3*Standard-Deviation (Upper Control Limit)
CL = Average (Center Line)
LCL = Average – 3*Standard-Deviation (Lower Control Limit)
Activity: For our hypothetical single-port yogurt filing machine (shown below). See the filing results of the first 100 cups of yogurt and their actual weight after filing. Compute the UCL, CL, and LCL to determine if your process is in control. As a reminder, your process is "in control" if you nearly all of the products produced (99.74% or higher) are within the Upper Control Limit (UCL) and Lower Control Limit (LCL) values. Otherwise, your process is not in control and needs to be triaged.
Sample # Actual Fill (oz) Within Control Limits? Statistical Calculations
1 8.028 FALSE
2 7.986 FALSE Average = oz Tip: Reminder that to calculate the average, you can use Excel's AVERAGE function. Just add the function and select all of the actual fill examples. The same is true with standard deviation, by using Excel's STDEV formula. Select the same actual fill examples.
3 7.985 FALSE Standard Deviation = oz
4 8.036 FALSE
5 8.018 FALSE
6 7.937 FALSE UCL = oz
7 8.026 FALSE Center Line = oz
8 8.050 FALSE LCL = oz
9 7.920 FALSE
10 7.974 FALSE
11 7.890 FALSE Is this process in control? (Yes/No) and Why?
12 8.032 FALSE
13 7.948 FALSE
14 8.013 FALSE Should I keep making yogurt?
15 7.943 FALSE
16 8.069 FALSE
17 7.918 FALSE
18 7.650 FALSE
19 7.895 FALSE
20 7.959 FALSE
21 8.030 FALSE
22 7.845 FALSE
23 7.952 FALSE
24 8.036 FALSE
25 8.004 FALSE
26 7.861 FALSE
27 7.899 FALSE
28 8.036 FALSE
Graph Data (automatically pulls entered values) 29 8.067 FALSE
UCL CL LCL 30 8.037 FALSE
1 0 0.000 0 31 7.959 FALSE
100 0.000 0.000 0.000 32 7.700 FALSE
33 7.844 FALSE
34 7.990 FALSE
35 7.949 FALSE
36 7.991 FALSE
37 7.986 FALSE
38 7.947 FALSE
39 7.890 FALSE
40 8.071 FALSE
41 8.063 FALSE
42 8.048 FALSE
43 7.900 FALSE
44 8.067 FALSE
45 7.834 FALSE
46 7.946 FALSE
47 7.925 FALSE
48 7.977 FALSE
49 8.007 FALSE
50 8.045 FALSE
51 7.875 FALSE
52 7.928 FALSE
53 7.869