Question: Construct a regression model using all of the independent variables. Test all the significance of the overall regression model using a=0.05 Interpret the meaning of

  1. Construct a regression model using all of the independent variables.
  2. Test all the significance of the overall regression model using a=0.05
  3. Interpret the meaning of the regression coefficient for the rooms, crew, children, and frequency variables.
  4. Using the p-values, identify which independent variable are significant with a=0.05
  5. Construct a regression model using only the significant variable found in part of d and predict average age of employees that use social media, hours per day, and compare to relationship status.
ID Age Gender SM Usage/Week Years in Organization Relationship Status
y y1 y2 y3 y4 y5
1 28 0 10 5 0
2 35 1 5 8 1
3 22 0 15 2 0
4 45 1 8 20 2
5 30 0 12 7 0
6 40 1 6 15 1
7 25 1 8 3 1
8 32 1 7 10 2
9 28 0 12 4 0
10 37 0 9 12 1
11 29 1 3 6 2
12 33 1 10 8 2
13 26 0 14 3 0
14 41 1 7 18 0
15 31 0 8 5 1
16 27 0 11 4 0
17 36 1 5 13 2
18 24 1 9 2 0
19 38 1 12 16 1
20 30 0 8 7 1
21 34 1 6 10 2
22 23 0 14 3 0
23 39 0 7 14 1
24 29 1 10 6 2
25 42 1 8 12 2
26 32 1 11 5 0
27 26 0 9 8 0
28 44 0 6 19 1
29 33 1 13 4 0
30 27 1 8 11 2
31 35 0 10 13 0
32 28 1 7 6 1
33 37 1 12 8 1
34 30 0 8 3 2
35 34 0 9 10 0
36 23 1 14 5 1
37 39 1 6 16 2
38 29 1 10 7 2
39 42 0 8 2 0
40 32 0 12 14 0
41 26 0 7 6 1
42 44 0 9 8 0
43 33 1 11 3 2
44 27 0 6 10 0
45 35 1 13 5 1
46 28 1 8 16 1
47 37 0 7 7 2
48 30 0 11 2 0
49 25 1 9 14 1
50 41 0 10 6 2
51 31 0 12 67 2
52 29 0 8 3 0
53 24 1 10 22 0
54 43 0 5 8 1
55 28 1 15 14 0
56 36 0 7 4 2
57 26 1 9 11 0
58 33 0 8 5 1
59 27 1 13 13 1
60 38 1 11 7 2
61 30 1 6 9 0
62 35 0 9 2 1
63 23 0 14 17 2
64 42 1 8 6 2
65 29 1 9 5 0
66 26 0 10 14 0
67 35 1 6 3 1
68 25 0 11 15 0
69 37 0 13 8 2
70 31 1 7 11 0
71 34 1 5 4 1
72 22 1 12 15 1
73 40 0 8 7 2
74 28 1 9 13 0
75 41 0 10 6 1
76 33 0 7 9 2
77 27 1 11 20 2
78 45 1 5 5 0
79 32 1 14 12 0
80 29 0 8 14 1
81 36 0 10 4 0
82 28 1 7 9 2
83 39 1 12 15 0
84 31 0 8 6 1
85 24 1 9 18 1
86 37 1 14 10 2
87 30 0 6 5 0
88 25 0 11 10 1
89 35 1 9 14 2
90 29 1 13 6 2
91 38 1 7 8 0
92 23 0 10 4 0
93 40 0 8 11 1
94 32 0 6 5 0
95 27 0 12 16 2
96 44 1 9 8 0
97 34 0 7 3 1
98 26 1 13 14 1
99 36 1 8 6 2
100 30 0 11 10 0
Y1 = age of respondant
Y2 = 0 for Male; 1 for Female
Y3 = SM usage weekly
Y4 = Years in organization
Y5 = 0 for Single; 1 for Married; 2 for relationship

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 Finance Questions!