Question: Please help me out with this lab, please please help me step by step in how to create that and find the answers LAB 3
Please help me out with this lab, please please help me step by step in how to create that and find the answers

LAB 3 Observation Hydrocarbon Level Purity Number x (%) The table shows different observations to y (%) 0.99 90.01 check Hydrocarbon level versus oxygen purity 1.02 89.05 1.15 91.43 1.29 93.74 Through Correlation technique find if there is 1.46 96.73 OO OO J a UI A W N E a relationship between these two. 1.36 94.45 0.87 87.59 (find correlation coefficient) 1.23 91.77 1.55 99.42 You need to do this relationship analysis inside the MS-Excel 1.40 93.65 and you must use following formula to reach Correlation Coefficient. 11 1.19 93.54 12 1.15 92.52 n(Exy) - (Ex)(Zy) I = 13 0.98 90.56 VInEx2 -(Ex)] [nEy2 -(Zy)?] 14 1.01 89.54 15 1.11 89.85 Explain about obtained " r" 16 1.20 90.39 17 1.26 93.25 18 1.32 93.41 All calculations must be shown inside your excel file 19 1.43 94.98 20 0.95 87.33
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
