Nov 16, 2026 | 583 words | 6 min read
4.1.2. PCA: Descriptive Statistics and Logical Functions#
Engineers frequently analyze performance data to determine whether systems meet required specifications.
You are given the results from battery life tests for a prototype drone sensor. Each trial measures how long the sensor remained active during testing. Your task is to summarize the dataset using descriptive statistics and apply logical functions to determine whether the sensor meets the required performance standard.
Required Files#
Download the assignment template and save it as 4_1_2_batterylife_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#
Part A - Descriptive Statistics#
Using Excel built-in functions, calculate the following values for the battery life dataset:
Mean battery life
Median battery life
Mode (if one exists)
Range of the dataset
Standard deviation (sample)
Place your results in the designated summary cells using appropriate Excel built-in functions. Review PCMs: Data Analysis and Histograms in Excel as needed. Do not type data values directly into your formulas.
Part B - Logical Functions#
Engineers must determine whether the sensor meets the minimum performance requirement. The sensor must operate for at least 80 minutes during a test.
In the column labeled Requirement Met, use an IF function that returns:
PASSif the battery life is greater than or equal to 80 minutes.FAILif the battery life is less than 80 minutes.
Your formula should reference the appropriate cell containing the battery life value. Copy the formula down the column so that every trial is evaluated.
Part C - Counting Results#
Using Excel built-in functions, determine:
The number of trials that passed the requirement
The number of trials that failed the requirement
Hint
Use the =COUNTIF function. Do not count these values manually.
Expected Value Check#
After completing your calculations:
The mean battery life should be approximately 81-83 minutes.
The standard deviation should be approximately 7-9 minutes.
The number of trials that pass should be double the number of trials that fail.
If your results differ significantly, review your formulas and references.
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.