Scribd
Upload
67 views6 pages

Data Analysis of Wages Over Years

This document contains an analysis of wage data for 15 years. It includes a table with years of experience (X) and corresponding wages (Y). It then performs a linear regression analysis to model the relationship between years (X) and wages (Y). The linear regression results in an equation of Y=116.381 + 19.56071X with an R^2 value of 0.9898, indicating a strong linear fit to the data.

Uploaded by

Ikram Ul Haq
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
67 views6 pages

Data Analysis of Wages Over Years

This document contains an analysis of wage data for 15 years. It includes a table with years of experience (X) and corresponding wages (Y). It then performs a linear regression analysis to model the relationship between years (X) and wages (Y). The linear regression results in an equation of Y=116.381 + 19.56071X with an R^2 value of 0.9898, indicating a strong linear fit to the data.

Uploaded by

Ikram Ul Haq
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

ASSIGNMENT

GROUP MEMBERS

DATA ANLYSIS

ANNUM WAHEED
ROLL NO
REEMA BIBI
ROLL NO
SUBMITTED TO
SIR NASEER SHEZADA
GOVERNMENT COLLEGE OF MANAGEMENT SCIENCES
DATE
8
11

DATA ANLYSIS
ANNUM WAHEED
11
REEMA BIBI

7
SIR NASEER SHEZADA
AGEMENT SCIENCES
2013

X(YEARS) Y(WAGES) x
1
140
2
148
3
180
4
195
5
200
6
235
7
260
8
280
9
290
10
330
11
325
12
340
13
360
14
400
15
410
120
MEAN

4093

y
-7
-6
-5
-4
-3
-2
-1
0
1
2
3
4
5
6
7

-132.867
-124.867
-92.8667
-77.8667
-72.8667
-37.8667
-12.8667
7.133333
17.13333
57.13333
52.13333
67.13333
87.13333
127.1333
137.1333

xy
x^2
930.0667
749.2
464.3333
311.4667
218.6
75.73333
12.86667
0
17.13333
114.2667
156.4
268.5333
435.6667
762.8
959.9333
5477

y^2
17653.55
15591.68
8624.218
6063.218
5309.551
1433.884
165.5511
50.88444
293.5511
3264.218
2717.884
4506.884
7592.218
16162.88
18805.55

Y^
135.9417
155.5024
175.0631
194.6238
214.1845
233.7452
253.306
272.8667
292.4274
311.9881
331.5488
351.1095
370.6702
390.231
409.7917

280 108235.7

4093

49
36
25
16
9
4
1
0
1
4
9
16
25
36
49

8 272.8667
xy^2

29997529
b1

19.56071
R^2

b0

116.381

varb1

0.302665

seb1

0.55015

t*b1

35.55523 H0 REJECT

varb0

25.02032

sebb0

5.002032

t*b0

23.26674 H0 REJECT

CI b1 U

20.66101

CI b1 L

18.46041

0.989821 U^2

84.74625

900
800
700
600
500
400
300
200
100
0
1

10 11 12

e
4.058333
-7.50238
4.936905
0.37619
-14.1845
1.254762
6.694048
7.133333
-2.42738
18.0119
-6.54881
-11.1095
-10.6702
9.769048
0.208333

e^2
X^2
16.47007
56.28572
24.37303
0.141519
201.2007
1.574427
44.81027
50.88444
5.892178
324.4287
42.88691
123.4215
113.854
95.43429
0.043403
1101.701

1
4
9
16
25
36
49
64
81
100
121
144
169
196
225
1240

Y^
Y(WAGES)
X(YEARS)

12 13 14 15

You might also like