\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch % NOTE: do NOT define \bar -- it is the built-in LaTeX accent used by \bar{x}, % \bar{y} (sample means). Redefining it made those render as the word "bar". \newcommand\barunit{\unit{bar}} \end{aligned}\end{align} \]

Nov 16, 2026 | 573 words | 6 min read

5.2.1. ICA: Semiconductor Quality Control#

In microelectronics fabrication, the gate oxide layer acts as the physical barrier separating a transistor’s gate from its conductive channel.

  • The Safety Threshold: To ensure high-frequency performance and prevent quantum tunneling leakage, a semiconductor design team specifies a minimum gate oxide thickness of \(90.0 \text{nm}\). Any wafer with a gate oxide falling below \(90.0 \text{nm}\) is a catastrophic structural failure, causing device short-circuits and rendering the processor useless.

  • The Quality Investigation: A process control team is evaluating two deposition machines (Tool 1 and Tool 2) that grow this microscopic oxide layer. To gather statistical process data, the engineers grew gate oxides on trial silicon wafers using both tools and recorded their final thickness measurements in nanometers.

  • The Problem: While both tools appear to produce the same average thickness of \(100.0 \text{nm}\), Tool 2 suffered from an unstable gas flow drift during deposition. You must use Excel statistical and charting tools to evaluate which machine is truly safe for production.

Required Files#

Download the activity template.

Instructions#

Download the provided Excel spreadsheet template and complete the following tasks.

Part A: Summary Statistics and High-Precision Shape Diagnosis#

Before calculating failure risks or modeling the process, verify that your measurements are approximately normally distributed (symmetric, bell-shaped).

  1. Provide a numerical snapshot of both tools. Use Excel’s built-in functions to calculate the required summary statistics. Format these values in Table 1: Baseline Parameter, including units.

  2. For a dataset to be modeled using a standard normal distribution, both its skewness and kurtosis must fall within the stable range of \(-2.0000\) to \(2.0000\). Calculate the following metrics in Table 2: Process Distribution Shape using Excel’s built-in functions for both tools. Leave each value with 4 decimal places.

    • Skewness: =SKEW()

    • Kurtosis: =KURT()

Part B: Creating and Formatting Technical Histograms#

You will now construct two professional histograms to visually analyze how the raw measurements are spread across the deposition intervals.

Formatting Constraints for the Histogram

  • Bin Width: manually override Excel defaults to use a width of 2.0 nm.

  • Underflow Bin: set an underflow bin at 90.0 nm. This isolates all wafers that fail the safety requirement into a single bar on the far left.

  • Chart Title and Axis Labels: use descriptive labels that are appropriate for technical presentation.

View Sample Histograms
Histogram of Tool 1 gate oxide thickness measurements

Fig. 5.5 Histogram of Tool 1 gate oxide thickness measurements#

Histogram of Tool 2 gate oxide thickness measurements

Fig. 5.6 Histogram of Tool 2 gate oxide thickness measurements#

Part C: Relative vs. Theoretical Probability Calculations#

You will now program Excel to calculate both the relative failure rate (counting actual occurrences) and the theoretical failure rate (using continuous normal curves) to compare their precision.

  1. In Table 3: Relative Probability Calculations, calculate the Failing Wafer Count using the =COUNTIF() function to count how many wafers in each of your datasets failed to meet the safety limit.

    • Cross-reference this number with your histograms from Part B. The first bar, the underflow bin, should have the same count.

  2. Calculate the relative probability of failure by dividing your count of failing specimens by the total number of trials. Use cell referencing. Format the cell as a percentage with two decimal places.

  3. In Table 4: Theoretical Probability Calculations, enter the algebraic formula to calculate the z-score for both datasets (standardize your safety limit of \(x = 90 \text{nm}\)). Use cell referencing and format the cell with two decimal places.

\[ Z = \frac{x-\mu}{\sigma} \]
  1. Download and open Z-table. Locate the cumulative left-tail area for both z-scores. Enter both values into “Theoretical Failure Prob (Z-Table)” and format the cells as a percentage with two decimal places.

  2. Use =NORM.S.DIST() and =NORM.DIST() to calculate the remaining probabilities in the table. Use cell references and format the cells as a percentage with two decimal places. Verify that these match your manual lookup for both Tool 1 and Tool 2.