MS Excel to study Correlation between Humidity & Differential Pressure

Ajit Basrur

Staff member
Admin
#1
I need help with MS Excel spreadsheet to study a correlation between Humidity values and Differential Pressure in a cleanroom.

In the attached Excel spreadsheet, I am interested to see if the Humidity in ambient manufacturing area (column D) and Humidity in cleanroom (column K) had any effect on the Differential Pressures (column R).

Can some one help me with this chart?

Thanks in advance,
 

Attachments

Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

Ajit,

Before looking at correlations and ultimately at regression models, it is always good to review the time based behavior of the variables.

Attached are time series plots of the three variables. It is easy to see that there is a very strong correlation between the two humidity variables. The Mfg RH usually leads the CR RH with the exception of the initial portion of the plot. On the other hand, while there appears to be a rough negative correlation between humidity and differential pressure, it was anomalous in several ways. When plotted over time on an individuals chart, it was remarkably stable. With the exception of one shift, differential pressure randomly fluctuates about a stable mean, and does follow the RH. Is it possible that the differential pressure was adjusted once (manually/automatically) in response to a major shift in RH rather than passively following the RH?
 

Attachments

Ajit Basrur

Staff member
Admin
#3
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

Thank you very much Miner. This is very helpful.

Yes, certain tasks were done on the air handler that could have caused the shift in RH.

Can you share the native files? Is this in Minitab?

Thanks again, Miner. Appreciate your inputs.
 

v9991

Trusted Information Resource
#4
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

Miner...:agree:
with little more effort, we could create the other control charts as well!!...however here's one with other charts.
 

Attachments

Ronen E

Problem Solver
Staff member
Moderator
#5
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

study a correlation between Humidity values and Differential Pressure in a cleanroom.
see if the Humidity in ambient manufacturing area (column D) and Humidity in cleanroom (column K) had any effect on the Differential Pressures (column R).
(Emphasis added)

Correlation does not necessarily indicate causality. Generally and theoretically, it could be the other way around, or both could be an effect of another factor. I recommend making sure you're able to at least hypothesise a physical explanation for any assumed causality.

[Inspired by Bev D's signature :)]
 

v9991

Trusted Information Resource
#6
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

:topic:

Correlation does not necessarily indicate causality. Generally and theoretically, it could be the other way around, or both could be an effect of another factor. I recommend making sure you're able to at least hypothesis a physical explanation for any assumed causality.
extending the same ...

IF you don't have hypothesis before analyzing the data; THEN don't proceed without evaluating the adequacy of data to prove the sufficiency/completeness of 'inference' / 'understanding'...
 

Miner

Forum Moderator
Staff member
Admin
#7
Re: Need help with MS Excel to study correlation between Humidity & Differential Pres

Can you share the native files? Is this in Minitab?

Thanks again, Miner. Appreciate your inputs.
Yes, I can. It is in Minitab 17. Are you able to open v 17 files? I can save then as v 16 or v 15 also if necessary.
 

Attachments

Thread starter Similar threads Forum Replies Date
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
V Excel Templates for MSA Study as per 4th Edition Manual Excel .xls Spreadsheet Templates and Tools 11
U Excel .xls spreadsheet for Line Balancing (Time and Motion Study) needed Excel .xls Spreadsheet Templates and Tools 1
J Type 1 Gage Study Excel Template Excel .xls Spreadsheet Templates and Tools 5
J Attribute R&R Study for 10 Operators - .xls Excel form or advice wanted Excel .xls Spreadsheet Templates and Tools 5
H TPPS ( torque process potential study) - How to & need Excel .xls Spreadsheet Capability, Accuracy and Stability - Processes, Machines, etc. 1
B Any ideas on setting up Capability Study spreadsheet in Excel? (CPK/CMK formulae) Excel .xls Spreadsheet Templates and Tools 4
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 5
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 9
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
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
C Excel date format from Denmark to USA Excel .xls Spreadsheet Templates and Tools 6
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
QSM_Rick Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
N Gantt Chart / Time Tracker in Excel - Combining Tasks on the Same Line Excel .xls Spreadsheet Templates and Tools 2
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
T Where can I get a PPAP workbook in Excel .xls with links? APQP and PPAP 1
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3

Similar threads

Top Bottom