Your team have been accepted as interns in productivity commission. Your first job is to conduct an analysis based on various socio-economic variables. Your team is required to process and analyse 515 responses of Australian population response which was collected through a questionnaire on socio-economic variables.

Q4. It is a common perception that socio-economic factors influence life satisfaction. (Week 10)

1. Explore the relationship between financial satisfaction and life satisfaction,
2. Explore the relationship between satisfaction with employment opportunity and life satisfaction
3. Explore the relationship between satisfaction in safety and life satisfaction
4. ) Explore the relationship between satisfaction in the home you live and life satisfaction
5. Use a simple linear regression model to analyze question ( i) to (iv) and report your findings (including all output from Excel and interpretation of results).
6. (V) Use the multiple linear regression model and interpret the result.

Transcribed image text: I Satisfaction in emaployment opportunity 4.580582524 0.155944575 5 1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1) 3.538945584 12.52413585 -1.650275294 0.21160028 9 . B D E G H 1 Life Satisfaction Health Satisfaction Financial satisfaction 2 3 Mean 6.176699029 Mean 5.768932039 Mean 4.78252427 4 Standard Error 0.152360699 Standard Error 0.151672117 Standard Error 0.13852604 5 Median 8. Median 7 Median 5 6 Mode 1 Mode 1 Mode 1 7 Standard Deviation 3.4576145 Standard Deviation 3.441988078 Standard Deviation 3.14365605 8 Sample Variance 11.95509803 Sample Variance 11.84728193 Sample Variance 9.88257338 9 Kurtosis -1.266692587 Kurtosis -1.475594179 Kurtosis -1.40407388 10 Skewness -0.625736469 Skewness -0.398081283 Skewness -0.00657624 11 Range 9 Range 9 Range 10 12 Minimum 1 Minimum 1 Minimum 0 13 Maximum 10 Maximum 10 Maximum 10 14 Sum 3181 Sum 2971 Sum 2463 15 Count 515 Count 515 Count 515 16 Largest(1) 10 Largest(1) 10 Largest(1) 10 17 Smallest(1) 1 Smallest(1) 1 Smallest(1) 0 18 19 How safe you feel ( Satisfaction in Safety) Satisfaction in the home you live 20 21 Mean 6.015533981 Mean 6.28737864 22 Standard Error 0.153336407 Standard Error 0.16034072 23 Median 7 Median 8 24 Mode 1 Mode 1 25 Standard Deviation 3.479756837 Standard Deviation 3.63870994 26 Sample Variance 12.10870764 Sample Variance 13.24021 27 Kurtosis -1.386442989 Kurtosis -1.40228485 28 Skewness -0.476420717 Skewness -0.52643143 29 Range 9 Range 9 30 Minimum 1 Minimum 1 31 Maximum 10 Maximum 10 32 Sum 3098 Sum 3238 33 Count 515 Count 515 34 Largest(1) 10 Largest(1) 10 35 Smallest(1) 1 Smallest(1) 1 1 10 2359 515 10 1 Transcribed image text: I Satisfaction in emaployment opportunity 4.580582524 0.155944575 5 1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1) 3.538945584 12.52413585 -1.650275294 0.21160028 9 . B D E G H 1 Life Satisfaction Health Satisfaction Financial satisfaction 2 3 Mean 6.176699029 Mean 5.768932039 Mean 4.78252427 4 Standard Error 0.152360699 Standard Error 0.151672117 Standard Error 0.13852604 5 Median 8. Median 7 Median 5 6 Mode 1 Mode 1 Mode 1 7 Standard Deviation 3.4576145 Standard Deviation 3.441988078 Standard Deviation 3.14365605 8 Sample Variance 11.95509803 Sample Variance 11.84728193 Sample Variance 9.88257338 9 Kurtosis -1.266692587 Kurtosis -1.475594179 Kurtosis -1.40407388 10 Skewness -0.625736469 Skewness -0.398081283 Skewness -0.00657624 11 Range 9 Range 9 Range 10 12 Minimum 1 Minimum 1 Minimum 0 13 Maximum 10 Maximum 10 Maximum 10 14 Sum 3181 Sum 2971 Sum 2463 15 Count 515 Count 515 Count 515 16 Largest(1) 10 Largest(1) 10 Largest(1) 10 17 Smallest(1) 1 Smallest(1) 1 Smallest(1) 0 18 19 How safe you feel ( Satisfaction in Safety) Satisfaction in the home you live 20 21 Mean 6.015533981 Mean 6.28737864 22 Standard Error 0.153336407 Standard Error 0.16034072 23 Median 7 Median 8 24 Mode 1 Mode 1 25 Standard Deviation 3.479756837 Standard Deviation 3.63870994 26 Sample Variance 12.10870764 Sample Variance 13.24021 27 Kurtosis -1.386442989 Kurtosis -1.40228485 28 Skewness -0.476420717 Skewness -0.52643143 29 Range 9 Range 9 30 Minimum 1 Minimum 1 31 Maximum 10 Maximum 10 32 Sum 3098 Sum 3238 33 Count 515 Count 515 34 Largest(1) 10 Largest(1) 10 35 Smallest(1) 1 Smallest(1) 1 1 10 2359 515 10 1