The XYZ company is revisiting its policy regarding expecting its employees to check their work email outside of typical business hours. The head of Human Resources (HR) feels that checking e-mail outside of business hours could be related to their experienced stress levels. On the one hand, it could be the case that being on top-of work email will have employees worry less about their career stability and as a result they become less stressed. On the other hand, it would be the case that employees are unable to disengage from work and spend quality time with their families and as a result they become more stressed. As a result, HR sent out surveys and collected data on how frequently employees check their emails outside of typical business hours as well as their experienced stress levels. Survey questions were based on a scale from 1-7, where 1 indicates very low frequency of checking e-mails as well as low stress level (NEVER) and 7 indicates very high frequency of checking e-mails as well as high stress level (ALWAYS). The Excel file E-mail checking.xlsx has the sample data. XYZ company would like you (as a junior business analyst) to use this sample data and answer the following questions: Is there a relationship between e-mail checking outside of office hours and perceived stress level? If you would hear that company had plans to mandate employees to check e-mails SOMETIMES outside of typical business hours. This would map to 4 on 1-7 scale. Would you recommend going forward with that policy? Why or why not? How and to what extent this policy would impact the employees’ perceived stress level? Phase 1 (Proposal): Please complete the following tasks for this phase: a) Describe in your own words the problem background and purpose of the study, b) Describe the variables included in the study, c) Summarize the data using Excel and discuss key Summary Descriptive Statistics, d) Summarize the data graphically using Excel by i) generating Box Plots and ii) Histograms for each variable. Discuss the generated Box Plots and briefly comment on the shape of the generated Histogram e) Are there any outlier values? If present, what do you think is the source of outlier value? How it should be handled? Remember to interpret the findings accurately and present them in a clear and coherent way as a summery report. Phase 2 (Final report): Please add the following to your Phase 1 Report (including any improvements suggested in the feedback for Phase 1) complete the following tasks for this phase: a) Identify which variable will be used as the dependent variable and which variable will be the independent variable.b) Use Hypothesis Testing to address the study main objective. List your Hypothesis. c) Apply statistical methods in Excel to answer these questions Follow and report all steps required to conduct a complete analysis d) Final conclusions, decision-making and recommendations based on the results to XYZ Board of Directors.

Phase 2: Please add the following to your Phase 1 Report and complete the following tasks for this phase:
a) Identify which variable will be used as the dependent variable and which variable will be
the independent variable.
b) Use Hypothesis Testing to address the study main objective. List your Hypothesis.
c) Apply statistical methods in Excel to answer these questions Follow and report all steps
required to conduct a complete analysis
d) Final conclusions, decision-making and recommendations based on the results to XYZ
Board of Directors

Survey Respondent Email Checking Frequency Perceived Stress
1 4.04 5.78
2 4.54 5.76
3 3.76 4.47
4 5.15 6.62
5 2.92 5.20
6 4.00 5.07
7 5.03 7.00
8 4.40 6.55
9 5.32 7.00
10 3.54 4.26
11 4.92 6.19
12 4.81 5.65
13 3.90 5.81
14 4.10 6.60
15 3.55 5.74
16 3.03 5.02
17 2.88 4.91
18 5.57 6.97
19 4.22 5.70
20 4.12 4.98
21 3.63 5.45
22 4.83 6.13
23 2.14 4.87
24 3.15 5.95
25 4.21 5.88
26 4.46 5.38
27 2.39 4.97
28 4.16 5.10
29 5.33 5.69
30 4.49 5.74
31 4.08 5.53
32 3.16 5.39
33 4.89 5.78
34 4.72 6.03
35 5.07 6.99
36 3.27 4.50
37 4.71 4.99
38 1.97 3.97
39 4.66 6.64
40 3.80 5.59
41 3.76 4.72
42 4.15 6.06
43 3.62 5.97
44 2.99 4.33
45 3.94 5.32
46 4.69 6.18
47 4.59 6.50
48 2.41 4.34
49 3.57 4.87
50 3.43 5.28

Please refer to the Excel file for full data. Thank you!

Question

karenojeda01 karenojeda01

09-05-2024
Business

Answered

The XYZ company is revisiting its policy regarding expecting its employees to check their work email outside of typical business hours. The head of Human Resources (HR) feels that checking e-mail outside of business hours could be related to their experienced stress levels. On the one hand, it could be the case that being on top-of work email will have employees worry less about their career stability and as a result they become less stressed. On the other hand, it would be the case that employees are unable to disengage from work and spend quality time with their families and as a result they become more stressed. As a result, HR sent out surveys and collected data on how frequently employees check their emails outside of typical business hours as well as their experienced stress levels. Survey questions were based on a scale from 1-7, where 1 indicates very low frequency of checking e-mails as well as low stress level (NEVER) and 7 indicates very high frequency of checking e-mails as well as high stress level (ALWAYS). The Excel file E-mail checking.xlsx has the sample data. XYZ company would like you (as a junior business analyst) to use this sample data and answer the following questions: Is there a relationship between e-mail checking outside of office hours and perceived stress level? If you would hear that company had plans to mandate employees to check e-mails SOMETIMES outside of typical business hours. This would map to 4 on 1-7 scale. Would you recommend going forward with that policy? Why or why not? How and to what extent this policy would impact the employees’ perceived stress level? Phase 1 (Proposal): Please complete the following tasks for this phase: a) Describe in your own words the problem background and purpose of the study, b) Describe the variables included in the study, c) Summarize the data using Excel and discuss key Summary Descriptive Statistics, d) Summarize the data graphically using Excel by i) generating Box Plots and ii) Histograms for each variable. Discuss the generated Box Plots and briefly comment on the shape of the generated Histogram e) Are there any outlier values? If present, what do you think is the source of outlier value? How it should be handled? Remember to interpret the findings accurately and present them in a clear and coherent way as a summery report. Phase 2 (Final report): Please add the following to your Phase 1 Report (including any improvements suggested in the feedback for Phase 1) complete the following tasks for this phase: a) Identify which variable will be used as the dependent variable and which variable will be the independent variable.b) Use Hypothesis Testing to address the study main objective. List your Hypothesis. c) Apply statistical methods in Excel to answer these questions Follow and report all steps required to conduct a complete analysis d) Final conclusions, decision-making and recommendations based on the results to XYZ Board of Directors.

Phase 2: Please add the following to your Phase 1 Report and complete the following tasks for this phase:
a) Identify which variable will be used as the dependent variable and which variable will be
the independent variable.
b) Use Hypothesis Testing to address the study main objective. List your Hypothesis.
c) Apply statistical methods in Excel to answer these questions Follow and report all steps
required to conduct a complete analysis
d) Final conclusions, decision-making and recommendations based on the results to XYZ
Board of Directors

Survey Respondent Email Checking Frequency Perceived Stress
1 4.04 5.78
2 4.54 5.76
3 3.76 4.47
4 5.15 6.62
5 2.92 5.20
6 4.00 5.07
7 5.03 7.00
8 4.40 6.55
9 5.32 7.00
10 3.54 4.26
11 4.92 6.19
12 4.81 5.65
13 3.90 5.81
14 4.10 6.60
15 3.55 5.74
16 3.03 5.02
17 2.88 4.91
18 5.57 6.97
19 4.22 5.70
20 4.12 4.98
21 3.63 5.45
22 4.83 6.13
23 2.14 4.87
24 3.15 5.95
25 4.21 5.88
26 4.46 5.38
27 2.39 4.97
28 4.16 5.10
29 5.33 5.69
30 4.49 5.74
31 4.08 5.53
32 3.16 5.39
33 4.89 5.78
34 4.72 6.03
35 5.07 6.99
36 3.27 4.50
37 4.71 4.99
38 1.97 3.97
39 4.66 6.64
40 3.80 5.59
41 3.76 4.72
42 4.15 6.06
43 3.62 5.97
44 2.99 4.33
45 3.94 5.32
46 4.69 6.18
47 4.59 6.50
48 2.41 4.34
49 3.57 4.87
50 3.43 5.28

Please refer to the Excel file for full data. Thank you!

Answer :

Other Questions