1. Use the first tab named Lot-to-Lot Verifi.
2. Complete the tasks listed below within the first tab.
3. Save your completed Excel file with your name in the file name.
4. Submit your completed Excel file via email as instructed.
Tasks
Data Entry
Enter the provided lot numbers and corresponding test results for the new lot (SQCB222B) and the previous lot (SQCB222A) in the designated columns.
Ensure accurate entry of data, including lot numbers and test results.
Calculation
Calculate the mean, standard deviation, and coefficient of variation (CV) for each lot’s test results.
Use appropriate Excel functions for calculations.
Comparison
Compare the mean, standard deviation, and CV between the current and previous lots.
Identify any significant differences or trends between the lots.
Conclusion
Using a qc lot-to-lot variability of CV 150 mg/dL, Protein > 30 mg/dL, pH Level 8.0, and Specific Gravity 1.030.