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

Please help me out with this lab, please please help me step

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!