# 95% UCL - Attaching an excel for recovery study

#### stanleythomas

##### Registered
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

• F Ratio.xlsx
296.4 KB · Views: 86
Xbar R chart LCL and UCL in automotive Statistical Analysis Tools, Techniques and SPC 4
IATF16949 audit requirement - Auditor request UCL and LCL must be show Xbar-R, IATF 16949 - Automotive Quality Systems Standard 7
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
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
Extracting data from Word Doc table to Excel Quality Tools, Improvement and Analysis 6
Alternate solution to validate Excel Spreadsheets Qualification and Validation (including 21 CFR Part 11) 2
Nested ANOVA MSA - Excel sheet with bilateral tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
True position with bonus Excel help Manufacturing and Related Processes 8
Wanted: in need of start up Lock out Tag out program in Excel or Word, your help is much appreciated Occupational Health & Safety Management Standards 3
Three year audit program template excel Internal Auditing 1
Control Excel template Document Control Systems, Procedures, Forms and Templates 5
Looking for NADCAP audit Excel spreadsheets template for vendors, specifically heat treat (Vacuum Furnace) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
Kanban Excel template Lean in Manufacturing and Service Industries 1
Excel based Gage R&R VS Minitab calculation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Need IATF 16949 ISO Gap Analysis Excel File Internal Auditing 3
List of FAA Part 145 Repair Stations in MS Excel format? Federal Aviation Administration (FAA) Standards and Requirements 0
Csv, excel format - audit trail file of HPLC system ( Empower, openlab, EZchrom or any other ) Qualification and Validation (including 21 CFR Part 11) 0
Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7