Analysis of the Data:As practice, use the Excel File "Exercise-4-Data" to replicate the above results. Then answer the following questions.Questions:1. Do the results support the claim of the consulting firm that Big-Five personality dimensions and emotional intelligence can predict stress level of the employees? Why or why not?2. If the finance company adopts the measurement scales of the consulting firm, how will you advise them to use of scores of future job applicants?Background:A finance company hires a large number of employees giving "cold call" to identify potential customers. As the success rate is low (less than 0.5%) and many people receiving calls feel annoying and will be rude, it is a very stressful job. A consulting firm suggests that people with particular personality (scale 1 to 7) and higher level of emotional intelligence (scale from 0 to 40) may be more suitable for this job and will feel lower level of stress (scale from 1 to 3). This consulting firm is willing to demonstrating this possibility by measuring the personality, emotional intelligence and the stress indicators by their standard instruments with a sample of 200 employees of the company by minimal charge. They get the following results:

2. Regression Results: SUMMARY OUTPUT Regression Statistics Multiple R 0.44404189 R Square 0.1971732 Adjusted R Square 0.172214854 Standard Error 0.406129255 Observations 200 ANOVA df SS MS F Significance F Regression 6 7.818291898 1.30304865 7.900090763 1.26863E-07 Residual 193 31.8336076 0.164940972 Total 199 39.6518995 Standard owe Upper Coefficients Error t Stat P-value Lower 95% Upper 95% 95.0% 95.0% Intercept 1.4683544 0.3339503 4.3969251 1.81182E-05 0.8096937 2.1270152 0.8096937 2.1270152 Neuroticism 0.1383638 0.0296719 4.6631199 5.804E-06 0.0798409 0.1968867 0.0798409 0.1968867 Extraversion 0.0006086 0.0339469 0.0179304 0.985712854 -0.0663459 0.0675633 -0.0663459 0.0675633 Openness 0.0070713 0.0340501 0.2076741 0.835702337 0.0600868 0.0742294 -0.0600868 0.0742294 Agreeableness 0.0497471 0.0435887 1.1412830 0.25516627 -0.0362244 0.1357187 -0.0362244 0.1357187 Conscientiousness -0.0585892 0.0401335 1.4598594 0.145954503 -0.1377458 0.0205673 -0.1377458 0.0205673 Emotional Intelligence -0.0167244 0.0072907 -2.2939185 0.022871955 -0.0311042 -0.0023446 6 -0.0311042 -0.0023446 3. Correlation coefficients: Emotional Stress Neuroticism Extraversion Openness Agreeableness Conscientiousness Intelligence Indicators Neuroticism Extraversion -0.120951468 Openness -0.032980671 0.353634147 Agreeableness -0.344699767 0.432164702 0.136124122 Conscientiousness -0.450415622 0.326577583 0.269617782 0.527946097 1 Emotional Intelligence -0.226403548 0.138037854 -0.064659616 0.201763595 0.213283493 Stress Indicators 0.403095334 -0.05634449 -0.00638212 -0.119237218 0.257693865 -0.2418304 4. Descriptive statistics: Emotional Stress Neuroticism Extraversion Openness Agreeableness Conscientiousness Intelligence Indicators Mean 3.5492 4.3469 3.9349 5.0833 5.0851 25.8550 1.5124 Median 3.5 4.33 3.83 5 5.17 26 1.4 Mode 3.33 3.5 4.83 4.67 24 Standard Deviation 1.1145 1.0036 0.9362 0.8378 0.9344 4.1509 0.4463 Range 6 5.33 5.5 5 4.33 21 1.6 Minimum 1.67 1.5 2 2.67 15 1 Maximum 7 7 7 36 2.6 Count 200 200 200 200 200 200 200