I have prepared a questionnaire, the table is filled out, and the screen captures for you to collect the data. All you have to do is take all the data from the table that contains 40 students and solve the following questions clearly and in detail, please and question (c) please solve it in Excel and capture a clear screen

Here is the table and data in order

3) a. Find the correlation coefficient between the number of modules studied in the last semester and number of hours spend on reading the books" from your collected data. (10 Marks) b. Find the equation of the regression line between the "number of modules are remaining to complete the degree/diploma and number of hours spend on social media" from your collected data. (7 Marks) Draw the scatter diagram of "number of modules registered in the current semester and number of hours spend on watching the study related videos" by using EXCEL and give your interpretation. (5 Marks) No provide your ID number: Gender Full time Boy/gir /part 1 time Hours spend on Watchi Hours spend on Social media ules ng your How How How How specialization/ man many many many major in the Y modules modul hours degree/diplom mod you es are you a program at register remain spen MEC: you ed in the ing to don studi current comple readi ed in semeste te the ng the rat MEC degree the last : /diplo books sem ma at per este MEC: day : rat MEC study related videos 120f20428 Girl Full time 4 4 8 5 2 4 2 21f22154 Girl computer science Computer science 4 4 4 12 3 Part time 24 2 hours 3 20F20429 Girl 4 4 2 1 h 0 19 4 19F19268 Girl 3 3 16 0 3 7 Girl 4 4 8 1 5 6 7 20f20326 21622133 19f19288 Boy Full time Civil Engineering Full time General management Full time Logistics Part time Data analysis Part time Computer since Full time Information system Full time HR } 1 2 1 6 4 4 7 Boy 4 4 4 0 4 8 20f20703 Boy 4 4 0 2 2 6 9 20f20712 Girl 4 4 4 N 1 7 3 3 2 1 9 20f20712 10 19f18960 Girl Boy Full time Full time HR HR 7 4 3 4 3 WN 3 Half an hour Aroun d 4 hours 2 3-4 3 3 1 41 11 19f18987 12 20f20456 Girl Girl Full time Full time 1 1-2 4 4 4 2 13 16f15926 14 21520980 Girl Boy par time Full time A COM NN 2 2 2 3 4 4 8 15 19f19450 Girl Full time 4 4 6 Non 1 9 Logistics Computer science HR computer science Electronics & Telecommunica tions Electronic and telecommunica tions Civil engineering Civil engineer 16 18f18280 Girl 3 4 00 8 1 Full time 1 10 17 20f20532 Girl 4 4 0-1 Full time I don't know 12 18 20F20466 NN Girl 4 4 2 2-3 hours 0 12 2 hours Full time 19 19f19793 Girl 4 4 7 2 2 hours 5 hours 2 20 21s21245 Girl 4 3 9 N 4 21 20F20324 Girl N 2 4 4 8 3 20 22 20F20442 Girl 4 4 21 2 5 Engineering in Electronics and Instrumentatio Full time n IT - data Full time analytics Computer Full time science HR Full time Full time data analysis Civil par time engineering Logistics par time management Logistics Full time management Logistic Full time management Engineering Girl wo 6 3 2 8 23 24 20F20361 20f20398 4 4 8 11 110 2 1 000 4 Girl 3/4 25 20f20469 4 4 16 1 11 Girl 26 20f20263 4 3 8 1-3 5 10-12 hours 3 Girl 27 20F20274 4 4 4 20 3 5 Girl 10 28 20f20291 4 4 18 8 1-2 hours Boy Full time 12 29 20f20582 2 2 N 0 9 Girl Full time 2 hours Computer Science Computer since in software technology 9 5 30 20F20390 4 8 3 6/5 hours Girl Full time 31 20F20374 Engineering 4 4 4 Girl Full time A lot of time 32 19F19186 3 3 3 2 Electronics and Communication s Engineering Boy par time 10h 33 20F20498 4 4 12 1 hour 3 2 Istudy hours them now I think 1 16 don't know mayb e 1h 16 3 4 1 Logistics management 4 Girl Girl 8 2 34 20F20280 N00 w 4 4 3 4 2 1 35 Girl 20F20334 36 20f20307 par time 9 4 4 N 3 Girl 6 37 20F20312 4 4 8 1 1 Girl Full time par time HR Civil Engineering Managing Full time people IT Full time Computer Full time science General Full time Administration Mechanical Full time Engineering 16 hour 38 20f20393 4 4 23 4 3 Boy 4 39 20F20369 4 4 4 7 Girl 4 hour 1 6 40 20f20488 4 4 24 4 Girl 4