3) a. Find the correlation coefficient between the "modules studied in the last semester and number of hours spend on reading the books" from your collected data. Find the equation of the regression line between the "modules registered in the current semester and number of hours spend on watching the study related videos" from your collected data. Draw the scatter diagram of "modules are remaining to complete the degree/diploma and number of hours spend on social media" by using EXCEL and give your interpretation.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 24PFA
icon
Related questions
Question
100%

3- Please I want a solution of all sub-part questions with all steps. Many Thanks

ID Nunber Gender Mode of Study on/nnjor in the degree'diploma pıdied last s emeste: registered in this s maining to conpletend onreading the books vatching the study related urs you spend on social me
18f18469 Boy Part Time
19f19799 Girl Full Time
Programming
Data analysis
Software techno logy
Software technology
2
1
3
4
4
1
2
19F19251 Girl Part Time
19F19173 Girl
4
Full Time
4
4
19f19095 Girl
Full Time
Data analysis
Data analysis
4
4
24
2
4
19F19197 Gir
rd Full Time
4
4
4
3
2
19f19155 Girl
Part Time
Data analysis
Data analysis
Accoun ting
Engineering
Accounting
Enginneering
E nginneering
Enginneering
4
4
23
1
19f19301 Gird
Full Time
4
4
2
1
3
19F19741 Gir
19F19250 Girl Part Time
19f19207 Gid
Full Time
4
4
1
3
10
4
4
24
1
4
Full Time
4
3
32
1
1
9
19f19118 Gird Full Time
4
4
3
19f19147 Girl
Full Time
E:
4
4
1
3
19F19202 Girl Full Time
4
3
4
2
18f18048 Girl Full Time
Human Resources
4
2
2
19s18683 Boy Full Time
16F16286 Boy Full Time
20s19880
Software technology
Civil engineering
Human Resources
4
4
4
4
4
4
4
4
22
Girl Full Time
3
3
3
1
1
2
Full Time
Full Time
Ciril engineering
Logistics
Marketing.
Data Analysis
19F19222 Girl
2
2
2
3
L19F19502 Girl
19F1940S Gird
19s1s869 Girl
19s19187 Gird Full Time
4
4
4
1
1
4
Full Time
4
1
3
19
Full Time
12
3
3
1
1
Human Resources
4
4
20
3
1
5
19f19128 Gird
Full Time
Data Analysis
4
4
5
19F19675 Girl
Part Time
Logistics
Logistics
Data analysis
19F19123 Girl Full Time ectronics and Instrumentati
19F19096 Girl Part Time ystems analysis and design
3
4
4
4
4
19f19131
Girl Full Time
4
4
4
1
5
19f19130 Gir Full Time
4
1
9
4
4
3
4
4
6
1
9
19F19078 Girl Part Time
19F19179 Girl Full Time lecommunication Engne eri
Human Resources
4
to
4
4
1
5
4
to
10
3
3
4
19f19118 Girl Full Time
Engineering
Software technology
General management
Software technology
Data analysis
M arketing
4
1
3
4
1919231
Girl Full Time
4
24
1
2
5
19f19227 Girl Full Time
4
4
4
7
4
18S17683 Boy Full Time
19f19393 Boy Full Time
3
4
3
4
4
4
24
1
23
19f19404 Girl
Part Time
4
3
1
1
1
1
19f19282 Gir
Full Time
Data analysis
Software technology
Data analysis
4
4
24
7.
6.
7
19f19099 Girl
Full Time
4
32
1
20s20049 Girl
Full Time
4
1
1
2
Transcribed Image Text:ID Nunber Gender Mode of Study on/nnjor in the degree'diploma pıdied last s emeste: registered in this s maining to conpletend onreading the books vatching the study related urs you spend on social me 18f18469 Boy Part Time 19f19799 Girl Full Time Programming Data analysis Software techno logy Software technology 2 1 3 4 4 1 2 19F19251 Girl Part Time 19F19173 Girl 4 Full Time 4 4 19f19095 Girl Full Time Data analysis Data analysis 4 4 24 2 4 19F19197 Gir rd Full Time 4 4 4 3 2 19f19155 Girl Part Time Data analysis Data analysis Accoun ting Engineering Accounting Enginneering E nginneering Enginneering 4 4 23 1 19f19301 Gird Full Time 4 4 2 1 3 19F19741 Gir 19F19250 Girl Part Time 19f19207 Gid Full Time 4 4 1 3 10 4 4 24 1 4 Full Time 4 3 32 1 1 9 19f19118 Gird Full Time 4 4 3 19f19147 Girl Full Time E: 4 4 1 3 19F19202 Girl Full Time 4 3 4 2 18f18048 Girl Full Time Human Resources 4 2 2 19s18683 Boy Full Time 16F16286 Boy Full Time 20s19880 Software technology Civil engineering Human Resources 4 4 4 4 4 4 4 4 22 Girl Full Time 3 3 3 1 1 2 Full Time Full Time Ciril engineering Logistics Marketing. Data Analysis 19F19222 Girl 2 2 2 3 L19F19502 Girl 19F1940S Gird 19s1s869 Girl 19s19187 Gird Full Time 4 4 4 1 1 4 Full Time 4 1 3 19 Full Time 12 3 3 1 1 Human Resources 4 4 20 3 1 5 19f19128 Gird Full Time Data Analysis 4 4 5 19F19675 Girl Part Time Logistics Logistics Data analysis 19F19123 Girl Full Time ectronics and Instrumentati 19F19096 Girl Part Time ystems analysis and design 3 4 4 4 4 19f19131 Girl Full Time 4 4 4 1 5 19f19130 Gir Full Time 4 1 9 4 4 3 4 4 6 1 9 19F19078 Girl Part Time 19F19179 Girl Full Time lecommunication Engne eri Human Resources 4 to 4 4 1 5 4 to 10 3 3 4 19f19118 Girl Full Time Engineering Software technology General management Software technology Data analysis M arketing 4 1 3 4 1919231 Girl Full Time 4 24 1 2 5 19f19227 Girl Full Time 4 4 4 7 4 18S17683 Boy Full Time 19f19393 Boy Full Time 3 4 3 4 4 4 24 1 23 19f19404 Girl Part Time 4 3 1 1 1 1 19f19282 Gir Full Time Data analysis Software technology Data analysis 4 4 24 7. 6. 7 19f19099 Girl Full Time 4 32 1 20s20049 Girl Full Time 4 1 1 2
3) a.
Find the correlation coefficient between the "modules studied in the last semester and number
of hours spend on reading the books" from your collected data.
b. Find the equation of the regression line between the "modules registered in the current semester
and number of hours spend on watching the study related videos" from your collected data.
C.
Draw the scatter diagram of "modules are remaining to complete the degree/diploma and
number of hours spend on social media" by using EXCEL and give your interpretation.
Transcribed Image Text:3) a. Find the correlation coefficient between the "modules studied in the last semester and number of hours spend on reading the books" from your collected data. b. Find the equation of the regression line between the "modules registered in the current semester and number of hours spend on watching the study related videos" from your collected data. C. Draw the scatter diagram of "modules are remaining to complete the degree/diploma and number of hours spend on social media" by using EXCEL and give your interpretation.
Expert Solution
steps

Step by step

Solved in 6 steps with 3 images

Blurred answer
Knowledge Booster
Linear Equations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt