Course:<\/strong> STATS1900 Business Statistics You will use a provided workplace injury dataset to carry out basic exploratory data analysis, produce suitable graphs and summary statistics, and write short, focused comments that interpret your results in business language for a non-technical manager.<\/p>\n [1][2]<\/p>\n Each time an employee is injured, the organisation incurs direct costs (such as medical expenses and compensation) and indirect costs (including lost productivity and disruption). Managers need simple, clear statistical summaries of injury data so they can identify patterns, prioritise safety interventions and monitor their impact over time. In this assignment you work with a simplified dataset from a company that wishes to review its recent safety performance.<\/p>\n [2][3]<\/p>\n The data file Employee_Injury_Data.xlsx<\/strong> (available on the LMS) contains 150 records, where each row corresponds to one injury incident. The variables are:<\/p>\n You must base all analysis on a random sample of 100 cases drawn from these 150 incidents, which reflects typical practice in safety monitoring where organisations often work with sampled or partial data. You will use Excel (or equivalent approved software) to generate the sample and conduct the analysis.<\/p>\n [3]<\/p>\n All subsequent tasks must be based on your sample of 100 cases. Do not regenerate the sample.<\/p>\n Using the list of variables given above, create a short table in your report that:<\/p>\n Present your answer in a clear, labelled table and use one or two brief sentences to justify your classification where it might not be obvious.<\/p>\n Make sure your commentary uses plain language that a safety manager with limited statistical training could follow.<\/p>\n [4][5]<\/p>\n Write a short concluding paragraph (approximately 150\u2013200 words) that draws together your main findings from Tasks 2\u20134 into a clear summary for a senior manager. You should:<\/p>\n [6][2]<\/p>\n Up to five bonus marks may be awarded if your assignment displays:<\/p>\n High-level work will demonstrate that you can apply conceptual understanding of descriptive statistics and exploratory data analysis to a realistic business context. In particular, strong submissions will:<\/p>\n [5][4]<\/p>\n The further a submission deviates from these expectations (for example, incorrect methods, missing commentary, unclear figures), the lower the mark is likely to be.<\/p>\n Injury cost data from the company\u2019s sample show a highly skewed distribution, with many relatively low-cost incidents and a small number of very expensive cases that disproportionately drive total spending. A histogram of costs typically reveals a long right tail, so the median is often a better indicator of a \u201ctypical\u201d injury than the mean since it is less affected by extreme outliers (Devore, 2020). When costs are broken down by site, the city operation may report more incidents in total, yet the interstate site could exhibit higher average costs and greater variability, which suggests different risk profiles and possibly more severe events in particular settings. Side-by-side boxplots help a manager see at a glance where cost distributions are wider, where medians are higher and where extreme losses occur. The pivot table of injury types by site tends to show that a small number of common injury categories, such as sprains from manual handling or slips and trips, account for much of the incident count.<\/p>\n [1][3]<\/p>\n Targeting these leading injury types at the specific sites where they cluster is more efficient than treating all risks as equal, because safety resources then align with the main sources of harm. A concise conclusion might recommend focused training in manual handling at the rural site, improvements to housekeeping and floor surfaces in the city site, and review of specific equipment or processes at the interstate site. Managers should also recognise that these results are based on a sample, so follow-up analysis of the full dataset or additional years of data may be warranted to confirm trends before large investments. Nevertheless, the assignment illustrates how basic descriptive statistics and Excel tools can yield actionable insights for safety decision-making without advanced modelling (Devore, 2020).<\/p>\n [6]<\/p>\n [2]<\/p>\n [6]<\/p>\n [1]<\/p>\n <\/p>\n Type:<\/strong> Online discussion post and peer response In the week following submission of the minor assignment, you will reflect on how statistical results can be communicated effectively to non-technical decision-makers. Your initial post should describe one key numerical or graphical finding from your injury data analysis (for example, skewness of costs, site differences, or a dominant injury type) and explain how you would present that result to a frontline manager in no more than three sentences. You should then comment on the limitations of your analysis and suggest one additional piece of data or analysis that could strengthen future safety decisions.<\/p>\n In your replies to at least two classmates, you will compare communication strategies, identify where wording could be clearer or more accurate, and suggest specific adjustments that retain statistical integrity while improving accessibility. The goal is to practice translating statistical output into concise, decision-ready insights, which is a core graduate skill in business analytics.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" STATS1900 Business Statistics \u2013 Minor Assignment (Workplace Injury Data) \u2013 2026 1. Assessment Overview Course: STATS1900 Business Statistics Assessment title: Minor Assignment \u2013 Exploratory Data\u2026<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13684,13685,13686,13687],"tags":[13688,13689,13690,13691,13692,13693],"class_list":["post-139439","post","type-post","status-publish","format-standard","hentry","category-business-analytics-and-statistics","category-business-statistics","category-statistical-analysis","category-statistics-data-analytics","tag-business-statistics-injury-data-assignment","tag-descriptive-statistics-safety-performance","tag-excel-exploratory-data-analysis-business-course","tag-pivot-table-injury-types-by-site","tag-stats1900-minor-assignment-instructions","tag-workplace-injury-cost-histogram-boxplot"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/139439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=139439"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/139439\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=139439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=139439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=139439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nAssessment title:<\/strong> Minor Assignment \u2013 Exploratory Data Analysis of Workplace Injuries
\nAssessment type:<\/strong> Individual assignment (computer-based data analysis and written report)
\nWeighting:<\/strong> 10% of final grade
\nTotal marks:<\/strong> 25 marks (plus up to 5 bonus marks for overall quality)
\nDue:<\/strong> Week 4, Friday 5.00pm (see LMS for exact date and time)
\nSubmission:<\/strong> Electronic submission via LMS (single PDF report plus Excel file)<\/p>\n2. Context and Dataset<\/h2>\n
\n
3. Tasks and Instructions<\/h2>\n
Task 0: Random Sample (1 mark)<\/h3>\n
\n
Task 1: Variable Classification (2 marks)<\/h3>\n
\n
Task 2: Costs of Injuries \u2013 Histogram and Comments (5 marks)<\/h3>\n
\n
\n
Task 3: Descriptive Statistics and Boxplots by Site (5 marks)<\/h3>\n
\n
\n
\n
Task 4: Pivot Table \u2013 Injury Types by Site (5 marks)<\/h3>\n
\n
\n
\n
Task 5: Conclusion and Recommendation (2 marks)<\/h3>\n
\n
\n
\n
Bonus: Overall Presentation and Professionalism (up to 5 marks)<\/h3>\n
\n
4. General Assessment Criteria<\/h2>\n
\n
5. Expected Report Structure and Formatting<\/h2>\n
\n
\n
6. Sample Answer Content (High-Level, SEO\/AI-Friendly)<\/h2>\n
7. Suggested References \/ Learning Resources (APA 7th)<\/h2>\n
\n
\n
\n
\n
\n
\n
8.<\/h2>\n
\n
11. Next Assessment \/ Discussion Activity<\/h2>\n
STATS1900 Business Statistics \u2013 Discussion Post (Week 5): Communicating Statistical Findings<\/h3>\n
\nWeighting:<\/strong> 5% of final grade
\nLength:<\/strong> Initial post 250\u2013350 words; at least two replies of 100\u2013150 words each
\nDue:<\/strong> Week 5 (see LMS for exact deadlines)<\/p>\n