95% UCL - Attaching an excel for recovery study

#1
Attaching an excel for recovery study. A sample was serially diluted from 2 fold to 512 fold, expected vs measured was plotted. I would like to calculate F-Ratio and 95% LCl and UCL (hope its not same as alpha, SD and n).


The image pasted was from a presentation by some article and LCL and HCL were not from my excel data at all

I am trying to understand how to calculate F ratio and LCL and UCL from these dilutions

Also I am not sure how to obtain a straight line like shown in the image

I would greatly appreciate your feed back and help.
Thanks,
Stan
 

Attachments

Elsmar Forum Sponsor
Thread starter Similar threads Forum Replies Date
B IATF16949 audit requirement - Auditor request UCL and LCL must be show Xbar-R, IATF 16949 - Automotive Quality Systems Standard 7
L UCL/LCL calculations using Sbar and sigma Statistical Analysis Tools, Techniques and SPC 2
E Questions regarding Cpk Calculation - Should we be using LSL/USL or LCL/UCL? Capability, Accuracy and Stability - Processes, Machines, etc. 5
J Can someone help me get the UCL AND LCL for this problem? Statistical Analysis Tools, Techniques and SPC 2
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
L Cpk after Data Transformation - How to Transform LCL /UCL to get Capability Report Capability, Accuracy and Stability - Processes, Machines, etc. 8
B UCL minus LCL = 6 Sigma-hat = 6*RBar/d2? Statistical Analysis Tools, Techniques and SPC 7
K Almost embarrassed to ask... SPC UCL/Data Range Quality Tools, Improvement and Analysis 4
K How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits) Statistical Analysis Tools, Techniques and SPC 18
K Calculating UCL (Upper Control Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 14
V How to calculate for LCL and UCL for Schedule Deviation Quality Tools, Improvement and Analysis 2
D How do I draw Graph a Mean & Range Chart & FIND CL UCL UCL for this data on Excel Statistical Analysis Tools, Techniques and SPC 4
J What Control Chart should we use for factors without UCL? Statistical Analysis Tools, Techniques and SPC 22
Q UCL (Upper Control Limit) Calculations - Sample Problem Statistical Analysis Tools, Techniques and SPC 11
W When to change UCL and LCL - SPC Software Statistical Analysis Tools, Techniques and SPC 4
D Self define the UCL and LCL instead of by Calculation Statistical Analysis Tools, Techniques and SPC 12
C Control chart for operators - Data for Setting Mean, UCL and LCL Statistical Analysis Tools, Techniques and SPC 6
T EWMA Chart - Data needed to Calculate EWMA, UCL, and LCL Values Statistical Analysis Tools, Techniques and SPC 5
W How to Set Rules to Review SPC Center Line, UCL and LCL? Statistical Analysis Tools, Techniques and SPC 15
B What is the difference between UCL, LCL and Cp, Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
I Calculation of UCL and LCL for SPC charts (Xbar-s) with sub-group sample of 32 pcs. Statistical Analysis Tools, Techniques and SPC 1
L One sided Control Chart with only UCL or LCL Statistical Analysis Tools, Techniques and SPC 2
M How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL Statistical Analysis Tools, Techniques and SPC 73
J Cumulative Count of Conforming Control Chart (CCC) - Calculating UCL and LCL Statistical Analysis Tools, Techniques and SPC 8
C I need help verifying formula's in a database for LCL UCL Cp Cpk PPk Statistical Analysis Tools, Techniques and SPC 14
A When or how often should we update SPC (UCL and LCL) Control Limits? Every month? Statistical Analysis Tools, Techniques and SPC 7
M How to count the UCL for MEWMA (Multivariate Exponentially Weighted Moving Average) Statistical Analysis Tools, Techniques and SPC 3
K Attaching calibration due dates to gages - Sloppy technicians IATF 16949 - Automotive Quality Systems Standard 17
V Attaching Labels to Batch Records Document Control Systems, Procedures, Forms and Templates 4
M List of FAA Part 145 Repair Stations in MS Excel format? Federal Aviation Administration (FAA) Standards and Requirements 0
V Csv, excel format - audit trail file of HPLC system ( Empower, openlab, EZchrom or any other ) Qualification and Validation (including 21 CFR Part 11) 0
J Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
T EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Ed Panek Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 10
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2

Similar threads

Top Bottom