How uncertain is our estimate?
If most resampled means stay close to 51.5 MPa, the estimated mean is fairly stable. If they spread widely, our estimate is less precise. Bootstrap confidence intervals use that spread.
Learn bootstrap confidence intervals and randomization tests with a ready-to-run practice dataset, the original 120 manufacturing records, or data you paste from your own work.
Resampling means repeatedly rebuilding samples with a computer. We use the patterns in those rebuilt samples to measure uncertainty or test a claim when a textbook distribution is not our best starting point.
You normally have one real sample: perhaps 120 tensile-strength results, 40 customer wait times, or 25 fill weights from a packaging line. That sample gives one mean, one median, or one pass rate. The uncomfortable question is: if we collected another reasonable sample from the same process, how much might the answer move?
Collecting thousands of new physical samples would be slow, expensive, and—if your test destroys the specimen—a little hard on the budget. Resampling lets the computer create many rehearsal samples from the evidence already available. It calculates the statistic for each rehearsal, then studies how those answers vary.
Think of it as letting your dataset audition for the same role thousands of times. Some rows appear repeatedly; some miss a particular audition. The computer is fast, does not ask for overtime, and never complains about running sample number 9,999.
Imagine that these eight measurements are the only specimens tested today. Their mean is 51.5 MPa. That number is useful, but it is not carved into a steel billet. A different set of eight specimens would probably give a slightly different mean.
Start with the observed values.
Draw eight values with replacement.
Calculate the new sample mean.
Repeat thousands of times and compare the means.
If most resampled means stay close to 51.5 MPa, the estimated mean is fairly stable. If they spread widely, our estimate is less precise. Bootstrap confidence intervals use that spread.
A randomization test builds results under a stated null claim. If our real result sits deep in the simulated tail, ordinary chance under that claim becomes a weak explanation.
Classical formulas are excellent when their assumptions fit. Resampling is especially helpful for awkward statistics, questionable normality, or when seeing the simulated logic makes the uncertainty easier to understand.
You tested one coil per heat and want uncertainty in the average Charpy energy. Resampling individual coil rows may be wrong if coils from the same heat are dependent; the heat may need to be the sampling unit.
You record 30 customer wait times. A few “large latte, six modifications” orders create a skewed distribution. Bootstrapping the median can estimate a typical wait without pretending the times form a perfect bell curve.
You compare a Standard and New process. Shuffling group labels asks what mean differences would occur if the labels did not truly matter—like swapping team jerseys and checking whether the scoreboard still looks unusually one-sided.
The 120 rows you actually measured. It is your evidence and the source of every resample.
A computer-generated sample made according to a rule. Bootstrap draws rows with replacement; randomization imposes the null hypothesis.
The statistic from thousands of resamples. Its spread, percentiles, or extreme tails answer the question.
Data → apply resampling rule → calculate statistic → repeat many times → interpret distribution
After a row is drawn, it goes back into the pool before the next draw. A row can appear zero, one, or several times. The resample stays the same size as the original sample.
No. It reveals what the observed data imply under a specific resampling rule. A biased, dependent, or unrepresentative sample remains problematic.
Not always. It depends on what confidence interval you are calculating, the sample size, and the method used.
| Situation | Does the raw data need to be normal? | Why? |
|---|---|---|
| Small sample, for example n < 30 | Approximately yes for a classical t-based interval | The method relies more heavily on the population being approximately normal. |
| Large sample, for example n ≥ 30 | Usually no | The Central Limit Theorem often makes the sampling distribution of the mean approximately normal. |
| Very skewed data or major outliers | Be careful | Even n = 30 may not be enough. |
| Bootstrap confidence interval | No normality assumption is required | The sampling distribution is estimated by resampling the observed data. |
The key distinction is that a standard confidence interval for the mean does not necessarily require the raw data to be normally distributed. What matters is whether the sampling distribution of the mean is approximately normal.
For example, individual Charpy values could be right-skewed:
80, 95, 110, 115, 125, 140, 160, 220, 310, …
If you repeatedly took samples of 50 specimens and calculated the mean of each sample, those means would tend to form a more nearly normal distribution because of the Central Limit Theorem.
Suppose two rolling practices have an observed mean Charpy difference of about 31 J.
Randomization or permutation test: start with the null hypothesis that the two groups are equivalent. Combine the observations, shuffle the A/B labels, split them back into groups of the original sizes, calculate the mean difference, and repeat thousands of times. This creates a null distribution.
Bootstrapping: preserve the groups and repeatedly sample with replacement from each group. Calculate the statistic each time. This creates a bootstrap distribution that describes the precision and uncertainty of the estimate.
| Feature | Randomization | Bootstrapping |
|---|---|---|
| Main purpose | Hypothesis testing | Estimation and uncertainty |
| Typical output | p-value | Confidence interval or standard error |
| Main question | Could this happen by chance under H₀? | How variable is my estimate? |
| Sampling | Usually without replacement | With replacement |
| Group labels | Usually shuffled | Usually preserved |
| Creates | Null distribution | Sampling distribution |
Suppose the observed data are:
| Practice A | Practice B |
|---|---|
| 200 | 150 |
| 210 | 160 |
| 220 | 170 |
The observed difference in means is 50 J. The randomization test asks: if A and B really had no effect, could a 50 J difference arise just by randomly assigning these observations to two groups?
First remove the labels:
200, 210, 220, 150, 160, 170
Then randomly assign three observations to A and three to B. Every original observation appears exactly once in that randomization.
Valid: A = [200, 160, 170] B = [210, 220, 150]
Not valid: A = [200, 200, 170]
The second assignment is invalid because the original dataset contained only one 200 J observation. Without replacement means that once an observation is assigned during one randomization, it cannot be selected again in that same randomization. Bootstrap sampling is different: repeated values are allowed.
Begin with the observed difference:
Dobserved = 31 J
Assume the null hypothesis is true:
H₀: μA = μB
Shuffle the group labels thousands of times. After each shuffle, calculate:
D* = x̄A* − x̄B*
For a two-sided test, count randomized differences at least as extreme as the observed result in either direction:
|D*| ≥ |Dobserved|
Suppose 10,000 randomizations produce:
| Result | Number of randomizations |
|---|---|
| −31 < D* < +31 | 9,720 |
| D* ≥ +31 | 145 |
| D* ≤ −31 | 135 |
| Total | 10,000 |
Extreme results = 145 + 135 = 280
p = 280 / 10,000 = 0.028
If A and B truly had no difference, about 2.8% of random label assignments produced a difference at least as extreme as the 31 J result observed.
A one-sample randomization test follows the same broad idea, but there are no A/B group labels to shuffle. Suppose:
H₀: μ = 180 J
Sample: 185, 190, 175, 200, 195
The sample mean is 189 J, so the observed difference from the null value is 9 J. One possible one-sample method is a sign-randomization test. First calculate the deviations from 180:
+5, +10, −5, +20, +15
Keep the magnitudes but randomly flip their signs. For example:
+5, −10, +5, −20, +15
This randomized set has a mean deviation of −1 J, corresponding to a randomized sample mean of 179 J. Repeating the sign randomization creates a null distribution centered around the hypothesized value.
Yes. That objection is correct.
If we simply reorder:
185, 190, 175, 200, 195
into:
200, 175, 195, 185, 190
the mean does not change. Reordering one sample cannot create a useful null distribution. A one-sample randomization procedure must randomize something other than the observation order.
In a sign-randomization approach, the signs attached to the deviation magnitudes change. For example, the magnitudes 5, 10, 5, 20, and 15 could become:
+5, −10, +5, −20, +15
−5, +10, −5, +20, +15
Those different sign patterns produce different means.
No. Minitab uses a different approach.
Sample: 185, 190, 175, 200, 195 x̄ = 189 H₀: μ = 180
Minitab first shifts every observation by the same amount so the adjusted sample mean equals the hypothesized mean. The required shift is:
180 − 189 = −9
The null-adjusted data become:
176, 181, 166, 191, 186 adjusted mean = 180
Minitab then repeatedly resamples with replacement from this null-adjusted sample, keeping the original sample size. Each resample produces a new mean, building a null distribution centered around 180.
176, 176, 191, 181, 191 → mean = 183
166, 181, 166, 186, 176 → mean = 175
| Bootstrap confidence interval | Minitab 1-sample randomization |
|---|---|
| Starts with the original data | Starts with the original data |
| Keeps the center at x̄ | Shifts the data so the center equals μ₀ |
| Samples with replacement | Samples with replacement |
| Builds a distribution around x̄ | Builds a distribution around μ₀ |
| Estimates uncertainty or a confidence interval | Tests H₀ and calculates a p-value |
In short, Minitab uses bootstrap-style resampling after first forcing the data to represent the null hypothesis.
Minitab’s 2-sample randomization test follows the classic permutation logic. Suppose:
| Practice A | Practice B |
|---|---|
| 210 | 175 |
| 195 | 182 |
| 220 | 168 |
| 205 | 190 |
| 215 | 177 |
x̄A = 209 x̄B = 178.4 Dobserved = 30.6 J
H₀: μA − μB = 0
Minitab pools all observations, randomly reallocates them into two groups while preserving the original group sizes, and calculates a new difference in means.
| Randomized A | Randomized B |
|---|---|
| 210 | 195 |
| 175 | 220 |
| 182 | 205 |
| 190 | 215 |
| 177 | 168 |
D* = x̄A* − x̄B*
Repeating this process thousands of times creates a distribution centered near zero, representing differences expected under the null hypothesis. For a two-sided test, Minitab counts the proportion satisfying:
|D*| ≥ 30.6
That proportion is the randomization p-value.
Yes. In ordinary nonparametric bootstrapping, if the original sample size is n = 6, every bootstrap resample also contains six observations. Those observations are selected with replacement.
Original sample: [100, 110, 120, 130, 140, 150]
| Sample | Six selected observations | Mean |
|---|---|---|
| Original | 100, 110, 120, 130, 140, 150 | 125.0 |
| Bootstrap #1 | 100, 100, 120, 140, 140, 150 | 125.0 |
| Bootstrap #2 | 110, 110, 110, 130, 150, 150 | 126.7 |
| Bootstrap #3 | 100, 120, 120, 120, 130, 140 | 121.7 |
Every resample contains exactly six selections, but some original observations may appear several times while others may not appear at all. Do not confuse these numbers:
n = 6 → observations inside each bootstrap resample
B = 1,000 → number of separate bootstrap resamples
You create 1,000 separate samples of six observations each and usually calculate one statistic from each sample. Keeping the resample size at six approximates how the statistic would vary across repeated studies having the same sample size as the original study.
The practice set was organized around five Minitab resampling methods:
| Method | Practice Variable(s) | Core Question |
|---|---|---|
| Bootstrapping for 1-Sample Function | Strength_MPa | What is the 95% confidence interval for the average strength? |
| Bootstrapping for 2-Sample Means | Strength_MPa + Group | Is the New process mean higher than Standard? |
| Randomization Test for 1-Sample Mean | Strength_MPa | Is the average strength different from 51 MPa? |
| Randomization Test for 1-Sample Proportion | PassFail | Is the pass rate greater than 90%? |
| Randomization Test for 2-Sample Means | Strength_MPa + Group | Is the New process statistically different from Standard? |
Use 1,000 or 5,000 resamples to start. Higher numbers of resamples give smoother resampling distributions.
These methods in Minitab fall under resampling statistics. They are powerful because they do not rely as heavily on normal-distribution assumptions as many traditional t-tests and z-tests. They use repeated random sampling or simulation to estimate uncertainty, significance, or confidence intervals.
Bootstrapping repeatedly:
“Function” simply means the statistic you care about: mean, median, standard deviation, percentile, capability metric, and so on.
It is used when you want confidence intervals, robust estimates, small-sample analysis, or non-normal-data analysis.
For example, instead of assuming normality for 25 Charpy tests, bootstrap resampling takes repeated samples from those 25 observations, estimates the mean each time, and creates an empirical confidence interval.
This uses the same concept but compares the mean of Group A with the mean of Group B. Both groups are repeatedly resampled.
It is used to estimate the difference between process means, the confidence interval for that difference, and the stability of the difference.
This is a simulation-based hypothesis test. It asks whether a sample mean is significantly different from a target without relying on a theoretical t-distribution in the same way as the classical test.
This tests whether a proportion differs from a target proportion. A proportion can represent pass/fail, good/bad, defect/no defect, yield, scrap rate, or acceptance rate.
This tests whether two groups truly differ. It repeatedly shuffles group labels, recalculates the difference, and builds a null distribution.
| Method | Main Purpose | Mental Model | Typical Output |
|---|---|---|---|
| Bootstrapping | Estimate uncertainty / confidence intervals | “What values are plausible?” | Confidence intervals; estimate variability |
| Randomization Test | Test statistical significance | “Could this happen by chance?” | p-values; significance evidence |
Bootstrapping answers this question:
But instead of collecting new real-world samples, we repeatedly resample from the data we already have.
Suppose you collected only five yield-strength observations:
| Coil | Yield Strength |
|---|---|
| C1 | 71 |
| C2 | 69 |
| C3 | 74 |
| C4 | 73 |
| C5 | 68 |
Bootstrapping says:
This is the most important concept. From the original data:
a bootstrap sample might be:
Another might be:
Some values repeat and some disappear because sampling is with replacement. After selecting a value, it goes back into the pool.
Your original sample is treated as the best estimate of the real population. Bootstrapping simulates thousands of alternate realities based on your observed process variation.
| Function | Meaning |
|---|---|
| Mean | Average |
| Median | Middle value |
| Standard deviation | Variation |
| Percentile | Distribution location |
| Maximum | Worst case |
| Cpk | Capability |
| Correlation | Relationship strength |
Usually, a confidence interval. For example:
| Statistic | Result |
|---|---|
| Mean YS | 71.2 ksi |
| 95% CI | 69.8–72.5 ksi |
Meaning:
Suppose coiling-temperature measurements are 610, 618, 605, 622, and 611. The question is:
Bootstrap:
Strength_MPa.Strength_MPa; Function = Mean; Number of resamples = 1,000 or 5,000.Instead of estimating one mean, we estimate the difference between two means.
Bootstrap repeatedly:
This builds a distribution of mean differences.
| Group | Mean Strength |
|---|---|
| Standard | 51.2 |
| New | 53.8 |
But is that real, or random variation? Bootstrap helps estimate uncertainty around that difference.
Standard group: original 51, 52, 50, 53, 49 → possible bootstrap sample 51, 51, 53, 49, 50 → mean = 51.0.
New group: original 54, 55, 53, 52, 56 → possible bootstrap sample 55, 55, 53, 52, 54 → mean = 53.8.
Repeat thousands of times. Values such as 2.8, 2.1, 3.4, 1.9, and 2.6 form the bootstrap distribution of mean differences.
| Confidence Interval | Interpretation |
|---|---|
| Does not cross 0 | A meaningful difference is supported by the interval. |
| Crosses 0 | The uncertainty includes “no difference.” |
| Fully positive | New process likely improves strength. |
| Fully negative | New process likely worsened strength. |
Why zero? Because:
means there is no difference between the group means.
Strength_MPa and Group.Strength_MPa; Corresponding groups = Group; First sample = Standard; Second sample = New.Now we move from estimating uncertainty with bootstrap to testing significance with randomization testing. This is a major conceptual shift.
This is fundamentally a hypothesis test, but performed using simulation instead of relying only on theoretical distributions.
Suppose target yield strength = 51 MPa and the sample is 53, 52, 54, 51, 55. The observed mean is 53 MPa.
Now the question becomes:
The randomization distribution represents what random variation alone would produce if the null hypothesis were true.
The p-value answers how unusual the observed result is under H0. A small p-value means the observed result is rare in the simulated null world; a large p-value means random variation could readily explain it.
Strength_MPa.Strength_MPa; Test mean = 51.The key is this:
Suppose the target mean is:
and the observed sample mean is:
Now the question becomes:
Because samples naturally vary. Even if the true process mean is 51, one sample may average 49, another 52, another 50.5, and another 53 because of random process and sampling variation.
So we need a way to determine how much variation is “normal.”
Imagine a dartboard whose target center is 51. Darts naturally scatter around the center. If one dart lands at 53, is that normal scatter or evidence that the aim has shifted?
You need to know how wide the natural scatter normally is. That is what resampling estimates.
It builds the distribution of expected random variation under the null hypothesis — the null distribution.
Suppose Minitab simulates 5,000 samples under:
and generates means such as 50.8, 51.2, 50.5, 51.7, 49.9. Most are near 51 because under H0, 51 is assumed true.
Then compare the real mean, 53, and ask:
| Outcome | Interpretation |
|---|---|
| 53 is rare in the null distribution | 53 is unusually far from 51 → evidence against H0. |
| 53 is common in the null distribution | Normal variation could readily explain it → insufficient evidence against H0. |
Randomization testing is basically:
We are resampling the original dataset, but in a way that simulates what random samples would look like under the null hypothesis. That subtle distinction is the whole trick.
| Method | What Gets Resampled? |
|---|---|
| Bootstrap | Original dataset directly |
| Randomization test for 1-sample mean | Modified / recentered version of the original data |
So bootstrap directly resamples the original data with replacement.
Before resampling, the data is shifted/recentered to align with the target mean. Then resampling/simulation occurs.
For example, suppose:
The data are centered at 53, but under H0 they should be centered at 51. So Minitab first transforms the data.
| Original | Recentered |
|---|---|
| 53 | 51 |
| 52 | 50 |
| 54 | 52 |
| 51 | 49 |
| 55 | 53 |
Then it repeatedly samples from the recentered data, computes means, and builds the null distribution.
The recentering step exists because:
Without recentering, the simulation would still reflect your observed sample mean instead of the hypothesized mean. That would break the logic of the test.
Suppose:
If we directly resample the original data, simulated samples will naturally center around 53, not 51. The simulation would represent a world where the true mean is 53, which contradicts the null hypothesis.
Then the test would effectively ask:
which is meaningless. Of course 53 is common if reality is centered at 53.
where:
| Original | Recentered |
|---|---|
| 53 | 51 |
| 52 | 50 |
| 54 | 52 |
| 51 | 49 |
| 55 | 53 |
Recentering changes the center, but preserves the spread, variability, shape, skewness, outliers, and process behavior.
Visually, it simply slides the whole distribution from a center of 53 to a center of 51 while leaving the shape the same.
This is a significance test for the difference between two means.
| Group | Mean Yield Strength |
|---|---|
| Standard MP | 51 MPa |
| New MP | 54 MPa |
The question is:
Under H0, group labels should not matter. That is the entire philosophy of the test.
A 1-sample randomization test needed recentering because there was a target mean. A 2-sample randomization test usually does not need that same recentering step. Under H0, both groups are treated as coming from the same population, so instead we shuffle the group labels.
Original data:
| Value | Group |
|---|---|
| 51 | Standard |
| 50 | Standard |
| 52 | Standard |
| 55 | New |
| 54 | New |
| 53 | New |
The null distribution represents:
Then compare the observed difference, +3 MPa, and ask:
If H0 is true, group membership is meaningless. Therefore, randomly reassigning labels should produce equally plausible datasets.
If randomized differences resemble the observed difference, the observed difference is not unusual. If the observed difference is much larger than what randomization usually produces, that is evidence the groups differ.
Strength_MPa and Group.Strength_MPa; Corresponding groups = Group; First sample = Standard; Second sample = New.Now we move from means to proportions. This is extremely important in quality engineering because many industrial problems are naturally pass/fail, defect/no defect, cracked/not cracked, downgraded/not downgraded, or accepted/rejected.
Suppose historical pass rate = 90%, so the target proportion is:
Now suppose 100 pipes are tested and only 83 pass:
The question is:
For a two-sided question:
For a deterioration question:
Under H0, the process still has a 90% pass probability. The randomization procedure simulates what pass/fail outcomes would naturally look like if that were true.
With proportions, the outcomes are binary. If:
then each simulated observation has a 90% probability of Pass and a 10% probability of Fail.
For 100 pipes, one simulation might produce 91 Pass / 9 Fail; another 88 / 12; another 93 / 7. These results build the null distribution of pass rates.
Then compare the actual 83% and ask:
| Result | Meaning |
|---|---|
| Small p-value, e.g. 0.002 | Only a very small proportion of null simulations are this poor → evidence the process degraded. |
| Large p-value, e.g. 0.28 | The observed result is not especially unusual under the target process. |
PassFail, containing Pass and Fail.PassFail; Event = Pass; Test proportion = 0.90.Select what you want to do, the statistic, and the number of groups.
A 1-sample bootstrap estimates the uncertainty around one statistic calculated from one sample—for example a mean, median, or another supported function. It answers: “If this sample represents the process, how much could my statistic change from sample to sample?”
A lab tests 30 tensile specimens and obtains an average strength. Testing another 5,000 physical sets would destroy a heroic amount of steel. The bootstrap reuses the 30 observed results in 5,000 computer-built samples to estimate how stable the mean is. It saves specimens—not standards of evidence.
Practice question: What is the 95% bootstrap CI for overall mean Strength_MPa?
Each bootstrap sample draws 120 strength values with replacement. Minitab calculates the mean. Repeating this creates a distribution of plausible sample means.
A 2-sample bootstrap estimates uncertainty in the difference between two independent population means. It answers: “How large might the true New − Standard mean difference be, given the sampling variation in both groups?”
The groups remain separate because we are estimating their difference, not pretending they are one population.
A rolling mill compares average yield strength under a Standard practice and a New practice. A CI of 0.6 to 3.0 MPa for New − Standard says the plausible mean improvement is positive but modest. It does not say every New coil beats every Standard coil—the coils did not sign that contract.
Practice question: What is the 95% bootstrap CI for New mean − Standard mean?
Bootstrap within each group, keeping 60 New and 60 Standard observations. Compute New − Standard each time. If the confidence interval excludes zero, a zero population difference is not supported at the matching two-sided level.
This test evaluates whether the mean of one population is reasonably consistent with a claimed value, μ₀. Unlike a confidence interval, it starts by temporarily assuming the null claim is true and asks: “Would our observed mean be unusual in that null world?”
A filler is supposed to average 500 mL. Your sample averages 503 mL. The test asks whether a 3 mL departure is surprisingly large if the true mean really is 500 mL. It does not ask whether 503 mL is economically painful—that decision belongs to engineering, finance, and perhaps the person buying all that extra product.
Practice question: Is overall mean Strength_MPa different from 51 MPa?
Under H₀, the population mean is μ₀. A shift-based randomization test recenters every observation by subtracting the observed mean and adding μ₀. Resamples from that null-centered data show means expected when H₀ is true.
H₀: μ = 51 MPa H₁: μ ≠ 51 MPa
This test is for a binary outcome—Pass/Fail, Yes/No, Defect/No Defect—and checks whether the population event proportion agrees with a claimed value p₀. It compares the observed event rate with rates generated when p₀ is assumed true.
A supplier promises at least 98% on-time delivery. In 100 deliveries, 99 were on time. That sounds excellent, but the test asks whether 99% is convincingly above 98% or merely one lucky extra truck. A nice-looking percentage and strong statistical evidence are not always the same guest.
Practice question: Is the overall Pass proportion greater than 90%?
Pass/Fail is binary. Under H₀: p = 0.90, the computer generates samples of 120 independent Bernoulli outcomes with a 90% chance of Pass. The right-tail p-value is how often the simulated pass proportion is at least the observed 92.5%.
H₀: p = 0.90 H₁: p > 0.90
This test evaluates whether the means of two independent populations differ. It asks: “If the group label truly had no relationship with the response, how often would random label assignments produce a difference at least this large?”
Suppose operators were randomly assigned either a New setup or Standard setup, and cycle time was recorded. Shuffling the setup labels creates the “setup does not matter” world. If the real difference is far into the tail, the labels appear to matter. If all New trials happened on night shift, however, the shuffle cannot separate setup from shift—statistics owns no time machine.
Practice question: Is New mean Strength_MPa higher than Standard mean?
Under H₀, the group labels are exchangeable because both groups come from populations with the same mean. Shuffle the 120 New/Standard labels, keep 60 observations in each group, and calculate New − Standard. This breaks the observed group relationship while preserving all measured strengths.
H₀: μNew − μStandard = 0 H₁: μNew − μStandard > 0
This is the same fictitious dataset supplied with the original lesson: 60 Standard and 60 New records. Pass means Strength_MPa ≥ 47. Defect is a separate fictitious quality field and is not used by the five exercises.
| SampleID | Group | ProductionDate | Strength_MPa | PassFail | Defect |
|---|
Minitab is the main tool for this lesson, but Excel is useful for checking the mechanics. Excel does not have a single built-in “bootstrap” or “randomization test” command, so the formulas below assemble one resample at a time. That is excellent for learning and small demonstrations; for formal work, use Minitab’s dedicated procedures and record the resample count and seed.
| Function | Syntax | Purpose | When to use it |
|---|---|---|---|
AVERAGE | =AVERAGE(number1,[number2],...) | Calculates a sample or resample mean. | Use for the one-sample mean and both two-sample mean procedures. |
MEDIAN | =MEDIAN(number1,[number2],...) | Calculates the middle value. | Use when bootstrapping a median or another 1-sample location statistic. |
STDEV.S | =STDEV.S(number1,[number2],...) | Calculates sample standard deviation. | Use to describe the original data and compare spread before interpreting a resampling result. |
COUNTIF | =COUNTIF(range,criteria) | Counts outcomes meeting a condition. | Use to calculate Pass counts and observed proportions. |
ROWS | =ROWS(array) | Returns the sample size. | Use so a resample automatically contains the same number of observations as the source sample. |
INDEX | =INDEX(array,row_num,[column_num]) | Returns observations at randomly generated row positions. | Use with RANDARRAY to draw bootstrap samples with replacement. |
RANDARRAY | =RANDARRAY([rows],[columns],[min],[max],[whole_number]) | Generates random row positions or random sorting keys. | Use to build bootstrap draws, Bernoulli trials, or shuffled labels. Results recalculate unless values are frozen. |
SORTBY | =SORTBY(array,by_array1,[sort_order1],...) | Randomly reorders labels when sorted by random keys. | Use to create one permutation for a two-sample randomization test. |
FILTER | =FILTER(array,include,[if_empty]) | Returns values assigned to a selected group. | Use after shuffling labels to calculate each permuted group mean. |
LET | =LET(name1,name_value1,calculation) | Names intermediate arrays inside one readable formula. | Use to keep resampling formulas understandable and auditable. |
PERCENTILE.INC | =PERCENTILE.INC(array,k) | Returns a percentile from simulated statistics. | Use the 0.025 and 0.975 percentiles for a two-sided 95% percentile bootstrap interval. |
If Strength_MPa is in D2:D121, enter this in H2:
=LET(x,$D$2:$D$121,n,ROWS(x),draw,INDEX(x,RANDARRAY(n,1,1,n,TRUE)),AVERAGE(draw))
Fill the formula down to H5001. Each row is one bootstrap mean. Then calculate the 95% percentile interval with =PERCENTILE.INC(H2:H5001,0.025) and =PERCENTILE.INC(H2:H5001,0.975). Pressing Calculate again rebuilds the random results, so paste values if you need to preserve a run.
With group labels in B2:B121 and strengths in D2:D121, enter:
=LET(y,$D$2:$D$121,g,$B$2:$B$121,gp,SORTBY(g,RANDARRAY(ROWS(g))),AVERAGE(FILTER(y,gp="New"))-AVERAGE(FILTER(y,gp="Standard")))
This shuffles only the group labels and returns one New − Standard difference under the null. Fill down for many permutations, then count results at least as extreme as the observed difference to estimate the p-value.
To test H₀: μ = 51 MPa, use:
=LET(x,$D$2:$D$121,mu0,51,shifted,x-AVERAGE(x)+mu0,n,ROWS(x),AVERAGE(INDEX(shifted,RANDARRAY(n,1,1,n,TRUE))))
The data are shifted so their mean equals the null mean before sampling with replacement. Repeat the formula to build the null distribution.
For H₀: p = 0.90, use:
=AVERAGE(--(RANDARRAY(ROWS($E$2:$E$121),1)<0.90))
Each random number below 0.90 acts like a Pass under the null. Repeating the formula builds the reference distribution for the pass proportion.
| Question | Exact Minitab path | Choose it when… |
|---|---|---|
| Estimate one mean, median, or other statistic | Calc → Resampling → Bootstrapping for 1-Sample Function | You want a confidence interval for one population function. |
| Estimate a difference between independent means | Calc → Resampling → Bootstrapping for 2-Sample Means | You want a confidence interval for Group 1 − Group 2. |
| Test one population mean | Calc → Resampling → Randomization Test for 1-Sample Mean | You have one continuous sample and a claimed null mean. |
| Test one population proportion | Calc → Resampling → Randomization Test for 1-Sample Proportion | You have binary outcomes and a claimed event proportion. |
| Test a difference between independent means | Calc → Resampling → Randomization Test for 2-Sample Means | You want to test whether two group means differ by shuffling labels under the null. |
Which option should you choose? Start with the decision, not the menu: use Bootstrapping to estimate uncertainty with a confidence interval; use a Randomization Test to test a null claim with a p-value. Then identify one sample versus two independent groups and continuous versus binary data.
Pick the strongest answer, then submit. Explanations appear after you submit.