Customers Ratings - Activity I

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 9

CustRate Inc Age Educ Marr

28 58402 43 18 0 SUMMARY OUTPUT


79 89893 83 17 1
35 58034 51 13 1 Regression Statistics
35 62843 40 13 0 Multiple R 0.765052
36 80854 56 13 0 R Square 0.585304
41 86470 65 18 1 Adjusted R 0.577405
43 74518 40 19 1 Standard E 10.89146
35 55958 44 14 0 Observatio 215
18 50279 41 12 1
46 102499 57 20 0 ANOVA
17 62816 43 18 0 df SS MS F
36 79303 76 16 0 Regression 4 35159.49 8789.874 74.09874
83 106960 77 16 0 Residual 210 24911 118.6238
56 89134 76 15 0 Total 214 60070.49
8 39297 35 14 1
58 93130 55 19 1 Coefficients
Standard Error t Stat P-value
48 70350 55 16 0 Intercept -2.41809 4.870639 -0.496463 0.620087
58 92032 67 18 1 58402 0.000482 8.922E-05 5.397598 1.817E-07
49 78536 76 11 1 43 0.230271 0.098968 2.326724 0.020933
35 55760 46 13 1 18 0.130161 0.31107 0.418429 0.676061
45 48631 45 13 0 0 -0.508205 1.494264 -0.340104 0.734118
50 48622 38 14 1
86 102460 80 16 0
32 38090 32 11 0
44 60977 44 16 1
49 65962 39 19 1
44 47447 37 10 1
16 52479 47 16 1
45 51238 55 10 0
50 79284 82 11 1
52 73283 41 14 0
53 78156 64 13 0
26 42190 42 10 0
58 90846 82 15 1
75 88087 71 12 0
54 77947 79 12 1
46 73839 72 10 1
67 79504 70 17 1
79 103551 71 20 0
55 81651 73 11 1
38 76964 73 11 0
41 92002 77 16 1
56 92630 65 17 0
38 81637 62 13 0
41 59079 60 10 0
47 53481 33 13 0
33 61981 31 18 0
22 47444 34 11 0
45 62345 61 10 1
59 90636 71 11 0
39 66924 47 16 0
6 43472 34 14 0
36 63223 41 19 0
83 102024 83 16 1
60 91859 50 20 1
50 51800 32 17 1
68 74147 46 20 0
41 49001 40 15 1
21 63189 52 12 0
45 65693 40 20 1
59 82952 81 14 0
23 65459 37 19 0
47 73623 67 11 1
46 58703 53 10 0
39 75724 52 14 0
69 89721 79 17 1
84 92167 69 18 1
50 84185 75 15 0
45 62827 41 16 0
66 73275 54 15 0
81 97682 73 11 0
68 91359 84 10 1
68 104446 81 16 1
15 32026 38 10 0
24 63546 49 16 1
37 61179 38 17 1
50 71387 56 19 0
64 100364 71 18 1
24 37724 28 10 1
68 84308 60 12 1
38 61819 50 16 1
20 34068 29 13 1
28 54646 30 17 1
57 84758 59 12 1
41 50313 30 19 0
62 73319 64 12 0
19 52824 36 15 0
59 96290 63 20 1
59 94847 82 10 0
73 106430 83 20 1
68 94519 72 17 1
60 79568 44 20 0
33 70571 65 13 1
42 77195 56 18 0
61 94754 67 13 0
57 63482 60 12 1
36 54621 40 18 1
58 98958 83 16 1
17 62514 41 19 1
58 94638 66 12 1
59 77590 65 16 1
56 62972 52 18 1
34 75715 50 18 1
50 66851 48 14 0
26 52452 48 10 1
61 120595 76 16 0
55 81983 79 13 1
41 66972 52 15 0
28 38026 35 17 1
40 93236 76 18 0
39 98003 75 17 1
26 43014 42 12 1
34 57142 41 13 0
55 89995 74 18 1
32 68975 50 16 0
53 76995 78 15 0
31 41771 32 13 1
75 107119 82 17 0
36 79423 60 15 1
33 52455 37 11 0
43 74186 53 18 1
50 88230 76 13 1
49 77681 68 14 0
53 81907 60 20 0
32 74105 53 11 1
71 103295 82 17 1
43 62365 41 20 0
24 50388 34 17 0
29 73826 43 18 0
50 96867 76 20 0
66 81473 59 15 0
46 84895 71 18 1
14 50703 29 17 1
22 50514 35 19 1
65 91143 76 17 1
33 60094 51 11 1
34 72363 40 18 0
55 61569 65 10 1
61 111907 80 13 0
19 50860 39 13 0
69 81328 63 20 0
55 76263 43 18 0
39 52869 34 17 1
76 92165 79 12 1
41 60211 55 14 1
74 88320 74 19 0
49 73401 71 12 0
29 41098 28 18 1
45 46355 52 10 0
64 59752 52 10 1
52 86557 62 13 1
25 50342 46 14 0
61 107203 74 18 0
53 50377 31 14 1
24 72087 57 12 1
27 68073 45 17 1
39 68824 62 10 1
61 84953 42 20 1
76 88289 77 15 0
42 54169 42 20 1
40 47445 50 12 0
64 79659 67 14 0
59 87149 53 20 0
58 85160 65 16 0
86 115642 79 19 0
30 26671 30 10 0
65 99436 83 14 1
57 99677 80 17 0
50 75679 45 20 1
64 86013 76 11 1
49 66922 49 20 0
51 95313 62 15 0
60 102551 69 19 0
47 71334 34 19 0
67 68982 48 16 0
70 89113 74 15 0
68 73545 61 14 1
49 92819 79 11 1
49 78207 84 13 0
46 83274 62 18 0
33 31363 28 11 0
33 57397 48 14 0
45 95774 81 19 0
37 57384 44 19 1
42 63775 63 10 1
80 109560 85 17 0
72 98326 60 20 1
54 73643 64 15 1
48 89103 59 16 0
58 94844 56 17 0
30 65985 39 17 1
56 77875 76 10 0
58 69793 67 13 0
57 74239 42 20 0
55 100675 70 19 1
55 83572 56 17 1
77 99332 63 20 1
44 73084 59 14 0
73 108769 82 15 1
41 59581 45 12 0
54 70716 69 13 0
56 94821 78 14 0
33 62336 37 14 0
62 95083 69 20 0
43 66276 36 19 1
70 108664 79 18 0
56 90094 62 16 1
62 93481 78 20 0
42 83496 62 19 0
39 62503 54 11 1
66 84253 83 17 0
79 105591 76 19 0
36 67780 57 13 1
80 124010 83 19 0
59 74465 63 17 0
45 50544 31 18 0
Significance F
4.542E-39

Lower 95%Upper 95%Lower 95.0%


Upper 95.0%
-12.0197 7.183521 -12.0197 7.183521
0.000306 0.000657 0.000306 0.000657
0.035173 0.425369 0.035173 0.425369
-0.483059 0.743381 -0.483059 0.743381
-3.453885 2.437474 -3.453885 2.437474
EMPLOYEE NUMBER TENURE (YEARS) SALARY ($)
1 15 53,908
2 32 78,230
3 14 55,164
4 20 57,647
5 25 63,111 Rel
6 14 54,991 90,000
7 28 74,571 f(x) = 29
80,000 R² = 0.9
8 30 73,189
9 28 71,859 70,000

10 17 55,978 60,000
11 14 61,676 50,000
12 6 44,865
40,000
13 21 64,676
30,000
14 11 59,101
15 14 58,441 20,000
16 32 81,964 10,000
17 29 76,373 0
18 33 82,860 0 5
19 27 70,019
20 16 58,474
21 26 80,074
22 3 45,594
23 14 63,676
24 9 68,444
25 14 70,306
Relation between salary and tenure Summary
90,000
f(x) = 2945.25873153779 x y=2945.3x suggests that for each year
80,000 R² = 0.920786761781908 tenure, the salary increases by approx
70,000 $2,945.30. This value represents the s
the regression line.
60,000
The R^2value of 0.9208 is quite high,
50,000
that about 92.08% of the variance in s
40,000 be explained by tenure.
30,000 This means the model fits data well, a
20,000 tenure is a strong predictor of salary i
dataset.
10,000
0
0 5 10 15 20 25 30 35
ry

.3x suggests that for each year of


the salary increases by approximately
30. This value represents the slope of
ression line.

2value of 0.9208 is quite high, indicating


out 92.08% of the variance in salary can
ained by tenure.

ans the model fits data well, and


s a strong predictor of salary in this
.

You might also like