95% UCL - Attaching an excel for recovery study

S

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
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
W Xbar R chart LCL and UCL in automotive Statistical Analysis Tools, Techniques and SPC 4
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
TarKEpa 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
E-QCDA Extracting data from Word Doc table to Excel Quality Tools, Improvement and Analysis 6
S Alternate solution to validate Excel Spreadsheets Qualification and Validation (including 21 CFR Part 11) 2
A Nested ANOVA MSA - Excel sheet with bilateral tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P True position with bonus Excel help Manufacturing and Related Processes 8
bryan willemot 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
Q Three year audit program template excel Internal Auditing 1
T Control Excel template Document Control Systems, Procedures, Forms and Templates 5
bryan willemot Looking for NADCAP audit Excel spreadsheets template for vendors, specifically heat treat (Vacuum Furnace) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
A Kanban Excel template Lean in Manufacturing and Service Industries 1
I Excel based Gage R&R VS Minitab calculation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Ashland78 Need IATF 16949 ISO Gap Analysis Excel File Internal Auditing 3
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

Similar threads

Top Bottom