Business assignment
Dutywriter21700
AnalyticsCasedescriptionISDS361ASoror.docxAnalytics Case description: E-mail checking Outside of Typical Business Hours
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?
Phase 1 (Proposal): Please complete the following tasks for this phase:
a) Describe the problem background and purpose of the study
b) Describe the variables included in the case
c) Use appropriate descriptive statistics to explore and summarize the data, both numerical and graphical. Are there any outlier values? 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.
Phase 2 (Final report): Please complete the following tasks for this phase:
a) Describe the problem background and purpose of the study
b) Describe the variables included in the case. Identify the dependent variable.
c) Outline the statistical methods required to answer the questions
d) Apply the statistical methods to answer these questions
Follow all steps required to conduct a complete analysis
e) Final conclusions, decision-making and recommendations based on the results to XYZ Board of Directors.
Important note: Please follow the grading rubric carefully while preparing your proposal and your final report. Remember to focus on the writing as well – grammar, typos, flow and organization are key components.
Mihaylo College of Business & Economics
Grading Rubric
|
Criteria |
Poor (0 -4) |
Average (4 - 8) |
Excellent (8- 10) |
|
Introduction & Background: a) Purpose, business problem description; b) Description of variables and outline of the statistical methods to be applied (descriptive statistics for Phase 1 and inferential methods for Phase 2) |
a) Purpose unclear and the problem description vague; b) Description of variables and statistical methods incorrect or vague (as relevant to each Phase) |
a) Purpose included but the problem description lacks clarity; b) Outline of variables and statistical methods adequate (1 error at most) but can be improved
|
a) Problem well-defined and covers the scope; b) Variable descriptions and statistical methods accurately and clearly outlined |
|
Methodology: Application of the appropriate statistical methods and analyses (as relevant to each Phase) |
Incorrect statistical method used and incorrect analysis (Does not meet) |
Correct method used but some errors in intermediate steps of the analyses and calculations |
Correct method used, correct steps followed, and correct final answers (meets expectations) |
|
Decision-making: Interpretation of the results, conclusions, and final decision-making in the context of the business problem
|
Conclusion is incorrect and interpretation is incorrect or missing (does not meet) |
Correct interpretation of results but the conclusions are not communicated properly in the business context (meets but can be improved)
|
Correct interpretation of results and conclusions in the context of the business problem (meets expectations completely) |
|
Organization: Development, layout, flow and design |
Points not sequential – hard to follow; layout incorrect; design is incorrect or messy |
Points are sequential; layout is adequate; design and flow are adequate (meet but can be improved) |
Points are well developed, layout is clean, and design is professional |
|
Literacy: Paragraphs, grammar, punctuation, & word choice; Introduction & conclusion |
Several misspellings; grammar and/or word usage errors are disruptive; does not include introduction or conclusion |
Minor errors in spelling, grammar, punctuation, or word choice; introduction and/or conclusion are included but are not well-structured |
Not more than 1 or 2 errors overall ; effective introduction and conclusion |
