STA30305 Quantitative Technique Group Written Assignment 2026

STA30305 Group Written Assignment

Module Learning Outcome

The group assignment is to address the learning outcome – Use statistical software/tool to perform data analysis and present the written analysis to real-world decision-making.

Topic cover for this assignment:

o Introduction to Statistics (Part I) & (Part II)
o Numerical Measures for Ungroup Data
o Correlation and Linear Regression
o Introduction to probability

Upon successful completion of this assignment, students will be able to:

o Analyze business problems by using appropriate statistical techniques.
o Interpret findings and effectively report the results of the analysis.
o Develop the concept of correlation and regression, analyze, compute, and interpret the regression output.

This assignment tests your understanding of data collection, summarizing data, correlation and regression analysis, probability and report writing. It also tests your ability to analyze data, to plot appropriate charts and to paste results and charts from Excel into a Word document. In addition, you should be able to discern the appropriateness and purpose of the above techniques.

Instructions

This assignment will be assessed over 100 marks and is worth 40% of the whole module coursework.

The task is to collect data (secondary data) and to use Excel to analyze the data. The students need to apply relevant quantitative techniques to interpret the outputs.

1. This assignment will be done by group of 5 students.
2. The assignment should be submitted in soft copy.
3. Use the cover page and rubric form attached in the assignment folder.
4. The assignment requires using a set of secondary data. Students are required to use appropriate statistical techniques to analyse and interpret the findings.
5. Please use Times New Roman with a font size of 12. The line spacing should be 1.5 and every page should be numbered.
6. All answers must be typed. No handwritten answers will be accepted.
7. All table; charts/graphs and output MUST be proper generated by Microsoft Excel.
8. Assignment submitted should be presentable, neat, and organized in Microsoft Words.
9. The assignment should be submitted latest by (week 11) at the drop box at my Times.
10. The late penalty will take the form of a deduction of 5% of the total marks. While assignments will not be accepted after the 24 hours.

Case Study

Introduction Developer Productivity and Burnout

In today’s digital economy, software developers face increasing workloads, long screen exposure, and tight deadlines, which may affect their stress and burnout levels. Understanding the relationship between work patterns, lifestyle habits, and burnout is essential for organisations to improve employee well-being and productivity.

This case study analyses a dataset of software developers, focusing on factors such as working hours, sleep, caffeine intake, productivity (bugs and commits), and lifestyle behaviours (exercise).

The data set provided includes the following variables:

• Age (years)
• Experience Years
• Daily Work Hours
• Sleep Hours
• Caffeine Intake
• Bugs per Day
• Commitments per Day
• Meetings per Day
• Screen Time (hours)
• Exercise Hours
• Stress Level (score)
• Burnout Level (Low, Medium, High).

You need to select 200 data at random from the given data set uploaded in myTIMES under the name Burnout.xls and answer the following question.

Answer all questions in Parts A, B and C using the 200 selected data.

**Units must be specified clearly in the report (marks will be deducted otherwise).

Part A: Data Analysis [39 Marks]

1. Identify whether the analysis you consider in this survey is a population or sample. Provide a relevant reason. [1 mark]
2. Identify the type of each variable and indicate whether it is qualitative or quantitative and state the level of measurement.[6 marks]
3. By using Excel, construct frequency tables and draw an appropriate graph for ALL the variables. Briefly write a summary for each of the graphs.[12 marks]
4. By using Excel, construct a descriptive statistics table for two quantitative data variables which include QUARTILE 1, QUARTILE 3 and inter -quartile range (IQR) for both variables. [4 marks]
5. Write a report (between 300 and 500 words in length) to summarize the results of your analysis in QUESTION 4. The report should include interpretation of results such as measure of location, measure of dispersion, distribution of the data, comparison of the results whenever possible, the appropriate descriptive summary, and the conclusion.[16 marks]

Part B: Correlation And Regression [32 Marks]

1. Select ONE dependent variable and ONE independent variable from the dataset to investigate their relationship.

Identify the dependent and the independent variable. Use Excel to draw a scatterplot. Add a trend line. Explain your graph.[5 marks]

Use Excel to generate a summary output for regression analysis. From the output, determine the regression equation. [4 marks]

Write a short report based on your results in part (b). Your report must include the strength of the relationship, the amount of variation explained and the significance of the model.  ( marks]

2. Select ANOTHER independent variable (different from Question 1) and repeat the analysis with the same dependent variable.

a) Identify the dependent and the independent variable. Use Excel to draw a scatterplot. Add a trend line. Explain your graph.[5 marks]

Answer

Request Answer of this Assignment