Calculating the linear regression model using the excel.
Run a regression of Y on X in Excel and turn in the output with a note explaining what the coefficients {correlation coefficient (multiple R), standard error, t-statistic and F-statistic} mean.
|
Family
|
Weekly Expenditure On Recreation (Y)
|
Weekly Income (X)
|
|
1
|
90
|
900
|
|
2
|
60
|
800
|
|
3
|
45
|
600
|
|
4
|
70
|
650
|
|
5
|
30
|
300
|
|
6
|
40
|
350
|
|
7
|
50
|
400
|
|
8
|
55
|
700
|
|
9
|
85
|
950
|
|
10
|
75
|
700
|
|
11
|
90
|
800
|
|
12
|
70
|
750
|
|
13
|
60
|
500
|
|
14
|
40
|
300
|
|
15
|
25
|
250
|
|
16
|
65
|
700
|
|
17
|
60
|
600
|
|
18
|
50
|
450
|
|
19
|
35
|
250
|
|
20
|
35
|
200
|