We wish to analyse the relationship between the female employment total, the part-time employment total and five-year employment growth in the Financial and Insurance Services industry.

1. Using ALL relevant simple linear regression tools you have used in this unit, analyse the relationship between the female employment total and the part-time employment total. Step as the followings:(1. What do you expect the relationship to be between female employment total and the part-time employment total? 2. Use Excel to plot a scatter diagram against the part-time employment total vs female employment total. [Insert>Scatter and select unjoined dots] of female employment total (Y) against part-time employment total (X), ]. Comment on how this visual relationship compares with your expectations.3. Based on the scatter plot, comment on whether it is appropriate to fit a regression line to the data. Estimate a model for the relationship between female employment total and part-time employment total by using Excel to produce the simple linear regression output.4. Using the Excel output provided, state the estimated linear regression equation for this data, being sure to define the variables.)

2. Predict the number of females employed when there are 1000 people employed part-time in a region. Using all relevant available information from part (a), discuss the likely validity of this prediction.

3. We now investigate the relationship between female employment total, part-time employment total and Five-year growth.

   1. Generate a regression output of female employment on part-time employment and Five-year growth. Interpret the estimated slope coefficients.

   2. Has the coefficient of determination increased in comparison to your model in (a)? Explain why/why not.

   3. At the 1% level of significance, test if the overall model is significant.

4. This is a general concept question and is not related to the data set provided. Correlation does not imply causality is an important concept when referring to regression. Briefly describe this concept. Provide one example of how it may occur. Your answer in this section does not need to be related to the data set provided for the assignment. Your answer must not exceed 100 words.

900 :: Employed Part-Ti. 500 0 200 2,700 1, 700 1,000 600 400 7,500 1,900 7,600 1,800 500 600 300 100 200 9, 300 3, 400 700 100 3,300 3, 400 0 2, 100 700 0 400 1,500 300 3,000 700 1, 900 1,800 1,600 1,800 400 300 300 3,400 2, 900 500 700 600 300 Employed Employed Tale Ferale 2,4011 2,300 700 200 200 200 3 400 5, 900 13011 2,800 11 2011 1,500 300 600 500 1,200 4,000 31, 400 1,100 19,000 1,00 28, 700 9, 100 900 BU 1,000 1) 1, 900 BI 1, 200 1,000 kico 26,500 TICO 9,000 4, 700 SID 300 1,100 9, 300 9.011 11, 300 DO 400 7 5, 400 1 DU 900 BIO 1,400 1,000 3 TOM 4, 400 Bun 700 011 7, 100 JU 1,300 1910 5,000 010 3,500 1110 4, 300 1110 5, 600 301 800 600 509 300 18:0 7, 600 5 6:0 6,500 10 900 00 1,800 1 000 1,200 400 700 Five-year grorth -1, 300 -100 -200 3,600 300 500 200 900 8, 600 4, 100 13, 900 4, 500 -800 700 1, 100 -600 500 9, 300 4,300 3,000 600 4, 300 3, 200 300 -100 400 1,000 800 -600 300 -1,700 900 400 -300 0 -1,500 200 -400 -200 -2,000 300 -600 100 300 -300 Ezployed Part-Tine Enployed - Iale Employed - Fenale Enploynent Distribution 2.9 1.9 7.0 1.4 9.6 Industry Enploynent Total Agriculture, Forestry and Fishing 354, 500 Mining 233, 300 Manufacturing 852, 800 Electricity, Gas, Water and Waste 164, 600 Construction 1, 174, 100 Wholesale Trade 390, 400 Retail Trade 1, 189, 100 ACCOMModation and Food Services 645, 900 Transport, Postal and Warehousing 583, 200 Information Media and Telecommuni 183, 500 Financial and Insurance Services 486, 300 Rental, Hiring and Real Estate Sex 220, 600 Professional, Scientific and Techr 1, 109,000 Administrative and Support Service 389,000 Public Administration and Safety 849, 400 Education and Training 1,033, 200 Health Care and Social Assistance 1, 731, 900 Arts and Recreation Services 160, 300 Other Services 435, 800 Employed Full-Tine 249, 400 228, 300 746,000 137, 900 995, 800 318, 700 622, 700 334, 600 508, 100 158, 800 393, 300 155, 900 897, 000 254, 500 684, 400 671, 000 967, 500 123, 500 326, 300 84, 700 9, 700 140, 100 17, 700 183, 200 72, 600 614, 200 517, 900 132, 900 46, 100 73,500 58, 400 250, 100 183, 800 142, 800 413,000 794, 000 102, 800 158, 600 223, 100 197, 700 639, 700 119,000 1,032, 600 262, 300 548, 000 381, 400 511, 400 125, 400 234, 500 110, 000 650, 700 207, 800 421, 700 311, 900 390, 300 112, 500 265, 800 111,000 40, 400 246, 500 36, 600 146, 500 129, 100 689, 000 471, 100 129, 700 79,500 232, 300 104, 200 496, 500 230, 400 405, 500 772,100 1, 371, 100 113, 700 219, 100 Five-year grorth 62,200 10, 200 -61, 300 25, 500 143, 700 -6, 400 -33, 800 -182, 100 -31, 000 -22, 300 93, 900 10, 700 85, 900 -20, 200 110, 400 107, 800 251, 700 -67,000 -42, 800 3.2 9.8 5. 3 4.8 1.5 4. O 1.8 9.1 3. 2 7.0 8.5 14. 2 1.3 3.6 900 :: Employed Part-Ti. 500 0 200 2,700 1, 700 1,000 600 400 7,500 1,900 7,600 1,800 500 600 300 100 200 9, 300 3, 400 700 100 3,300 3, 400 0 2, 100 700 0 400 1,500 300 3,000 700 1, 900 1,800 1,600 1,800 400 300 300 3,400 2, 900 500 700 600 300 Employed Employed Tale Ferale 2,4011 2,300 700 200 200 200 3 400 5, 900 13011 2,800 11 2011 1,500 300 600 500 1,200 4,000 31, 400 1,100 19,000 1,00 28, 700 9, 100 900 BU 1,000 1) 1, 900 BI 1, 200 1,000 kico 26,500 TICO 9,000 4, 700 SID 300 1,100 9, 300 9.011 11, 300 DO 400 7 5, 400 1 DU 900 BIO 1,400 1,000 3 TOM 4, 400 Bun 700 011 7, 100 JU 1,300 1910 5,000 010 3,500 1110 4, 300 1110 5, 600 301 800 600 509 300 18:0 7, 600 5 6:0 6,500 10 900 00 1,800 1 000 1,200 400 700 Five-year grorth -1, 300 -100 -200 3,600 300 500 200 900 8, 600 4, 100 13, 900 4, 500 -800 700 1, 100 -600 500 9, 300 4,300 3,000 600 4, 300 3, 200 300 -100 400 1,000 800 -600 300 -1,700 900 400 -300 0 -1,500 200 -400 -200 -2,000 300 -600 100 300 -300 Ezployed Part-Tine Enployed - Iale Employed - Fenale Enploynent Distribution 2.9 1.9 7.0 1.4 9.6 Industry Enploynent Total Agriculture, Forestry and Fishing 354, 500 Mining 233, 300 Manufacturing 852, 800 Electricity, Gas, Water and Waste 164, 600 Construction 1, 174, 100 Wholesale Trade 390, 400 Retail Trade 1, 189, 100 ACCOMModation and Food Services 645, 900 Transport, Postal and Warehousing 583, 200 Information Media and Telecommuni 183, 500 Financial and Insurance Services 486, 300 Rental, Hiring and Real Estate Sex 220, 600 Professional, Scientific and Techr 1, 109,000 Administrative and Support Service 389,000 Public Administration and Safety 849, 400 Education and Training 1,033, 200 Health Care and Social Assistance 1, 731, 900 Arts and Recreation Services 160, 300 Other Services 435, 800 Employed Full-Tine 249, 400 228, 300 746,000 137, 900 995, 800 318, 700 622, 700 334, 600 508, 100 158, 800 393, 300 155, 900 897, 000 254, 500 684, 400 671, 000 967, 500 123, 500 326, 300 84, 700 9, 700 140, 100 17, 700 183, 200 72, 600 614, 200 517, 900 132, 900 46, 100 73,500 58, 400 250, 100 183, 800 142, 800 413,000 794, 000 102, 800 158, 600 223, 100 197, 700 639, 700 119,000 1,032, 600 262, 300 548, 000 381, 400 511, 400 125, 400 234, 500 110, 000 650, 700 207, 800 421, 700 311, 900 390, 300 112, 500 265, 800 111,000 40, 400 246, 500 36, 600 146, 500 129, 100 689, 000 471, 100 129, 700 79,500 232, 300 104, 200 496, 500 230, 400 405, 500 772,100 1, 371, 100 113, 700 219, 100 Five-year grorth 62,200 10, 200 -61, 300 25, 500 143, 700 -6, 400 -33, 800 -182, 100 -31, 000 -22, 300 93, 900 10, 700 85, 900 -20, 200 110, 400 107, 800 251, 700 -67,000 -42, 800 3.2 9.8 5. 3 4.8 1.5 4. O 1.8 9.1 3. 2 7.0 8.5 14. 2 1.3 3.6