Nov 16, 2026 | 565 words | 6 min read
4.1.3. PCA: Histograms and Outliers#
In engineering practice, data visualization is more than a stylistic choice. It is a key tool for quality control and evidence-based decision-making, helping engineers identify defects, understand variability, and communicate technical findings clearly.
A Materials Engineer and a Biomedical Engineer are evaluating a titanium alloy batch for knee replacement assemblies. Because this is a medical implant, material reliability is a critical safety requirement. The team tested 100 specimens from one production run and must confirm that the batch meets the required Compressive Strength threshold of 1060 MPa. Before building the histogram, they reviewed the pre-calculated descriptive statistics to understand the data’s center and spread.
Statistic |
Value |
|---|---|
Minimum |
1055.73 MPa |
Maximum |
1107.57 MPa |
Range |
51.84 MPa |
Mean |
1081.87 MPa |
Median |
1082.95 MPa |
Standard Deviation |
15.25 MPa |
Required Files#
Download the assignment template and save it as 4_1_3_alloystrength_username.xlsx.
Reminder
Rename your files with your Purdue username by replacing “template” in the filename. Then fill out any required information in the template, such as your name, email, and course details.
Instructions#
A histogram is an appropriate choice for visualizing the distribution of a continuous numerical dataset. Review PCMs: Data Analysis and Histograms in Excel as needed.
In Table 3, use formulas to calculate the number of bins and the bin width. Enter the calculated values as they are. Do not round the bin width in the table; you will round it when you set up the histogram in step 3.
Create a histogram of the specimen compressive strength data to visualize its distribution.
Adjust the histogram to better match the engineering context.
Add an underflow bin below 1060 MPa so that the bin edges begin at a clean, whole number and all specimens below the threshold are grouped into a single bin.
Set the number of bins to your calculated value.
Remove decimal places from your bin intervals.
Format the chart for a technical presentation:
Descriptive title: Compressive Strength Distribution: Titanium Knee Implants
X-axis label: Compressive Strength [MPa]
Y-axis label: Number of Specimens
Gradescope Submission#
Save Deliverables: Ensure all required assignment files are saved and named exactly as specified in the assignment instructions. If a template file name contains the word
template, replace only that word with your Purdue username. When a task lists more than one deliverable, such as a workbook and a report, submit each deliverable to its own matching Gradescope assignment instead of combining them into one upload.Navigate to Gradescope: Log in to Gradescope. From your Dashboard, open the assignment.
Upload your work: Select the Upload submission method. Drag and drop all required files (or a compressed
.zipfolder) into Gradescope, and select Upload.Confirm Submission: When your upload is successful, you will see a confirmation message on your screen and receive an automated email receipt.
Add Team Members (if applicable): If this is a team assignment, add all team members to the submission. Each teammate should confirm they can see the submission in their own Gradescope account. For help, visit Gradescope’s documentation on adding team members.
Review Autograder Results: Wait a few minutes for the autograder to evaluate the relevant files. Scroll down to view any failed test cases. If you need assistance interpreting the output or errors, ask your teaching team.
Resubmit if Necessary: You can edit your files and select Resubmit as many times as you need before the assignment deadline. Only your final, active submission is graded. (Note: If you need to resubmit, you must upload all required files for the assignment again).
For a detailed walkthrough, review the official Gradescope Submission Guide.