Trimester T1 2020 Unit Code HI6007 Unit Title Statistics for Business Decisions Assessment Type Assessment 2 Assessment Title Group Assignment Holmes Institute
Purpose of the assessment (with ULO Mapping)
Students are required to show the understanding of the principles and techniques of business research and statistical analysis taught in the course.
Purpose:
This assignment aims at Understand various qualitative and quantitative research methodologies and techniques, and other general purposes are:
Please read below information carefully and respond all questions listed.
The higher education department of Holmes Institute recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019. The data are stored in file STUDYMAJOR.xls.
(2 marks) Note: Questions 2 to 6 are related.
Sociologists argued that women on average earn less than men as women often choose to work less hours. They further suggest that the choice of hours worked may be driven by various factors such as age, childcare needs, occupation choice and flexibility. To investigate the relation between hours worked and income earned by Australian men and women, a researcher plans to survey a sample of individuals across the country. Briefly explain (using no more than 250 words in total for this question)
(2 marks)
Suppose a researcher has collected data from a sample of 65 individuals using the sampling method you have proposed in (b). For each individual, the hours worked per week and yearly income (measured in ‘000’s dollars) were recorded. The data are stored in file HOURSWORKED.xls.
First, the researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below.
Frequency tables
Location 
Occupation 

Location category 
Frequency 
Occupationcategory 
Frequency 

Location group A 
5 
Occupation group 1 
4 

Location group B 
7 
Occupation group 2 
26 

Location group C 
12 
Occupation group 3 
15 

Location group D 
25 
Occupation group 4 
12 

Location group E 
10 
Occupation group 5 
5 

Location group F 
6 
Occupation group 6 
3 
Using Excel and the data in the frequency tables above, answer the following questions.
occupation category. (3 marks)
Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on each of the two variables: hours worked per week and yearly income, as stored in file HOURSWORKED.xls.
the number of class intervals (K) as 7. (2 marks)
intervals (or class width). (2 marks)
Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and yearly income.
Notes: Use QUARTILE.EXC command to generate the three quartiles. (3 marks)
Finally, the researcher considers using regression analysis to establish a linear relationship between the two variables – hours worked per week and yearly income.
the linear model. (4 marks)
(2 marks)
Marking criteria 
Weighting 
1. Student Enrolment analysis: a) Appropriate graphical technique for comparing the values b) Appropriate graphical technique for comparing the percentage values 
4 marks 2 marks 2 marks 
2. Analysis of Research Methodology: a) Appropriate Survey Method b) Appropriate Sampling Method c) Variable Selection d) Demerit of the methodology 
8 marks 2 marks 2 marks 2 marks 2 marks 
3. Analysis of Frequency Distribution: a) Graphical Technique b) Graphical Chart 
6 marks 3 marks 3 marks 
4. Graphical Descriptive Methods: a) Number of Class Intervals b) Width of Class Interval c) Histogram 
7 marks 2 marks 2 marks 3 marks 
5. Numerical Descriptive Measures a) Summary statistics b) Correlation Coefficient 
5 marks 3 marks 2 marks 
6. Yearly Income Analysis a) Choosing dependent and independent variables b) Graphical presentation of the relationship c) Estimated Regression Line d) Coefficient of Determination 
10 marks 2 marks 2 marks 4 marks 2 marks 
Excellent 
Very Good 
Good 
Satisfactory 
Unsatisfactory 

Analysis of Student Enrolment 
Demonstration of outstanding knowledge on descriptive techniques 
Demonstration of very good knowledge on descriptive techniques 
Demonstration of good knowledge on descriptive techniques 
Demonstration of basic knowledge on descriptive techniques 
Demonstration of poor knowledge on descriptive techniques 
Analysis of Research Methodology 
Demonstration of outstanding knowledge on Research Methodology 
Demonstration of very good knowledge on Research Methodology 
Demonstration of good knowledge on Research Methodology 
Demonstration of basic knowledge on Research Methodology 
Demonstration of poor knowledge on Research Methodology 
Graphical Techniques 
Demonstration of outstanding knowledge on Graphical Techniques 
Demonstration of very good knowledge on Graphical Techniques 
Demonstration of good knowledge on Graphical Techniques 
Demonstration of basic knowledge on Graphical Techniques 
Demonstration of poor knowledge on Graphical Techniques 
Graphical Descriptive Methods 
Demonstration of outstanding knowledge on Graphical Descriptive Methods 
Demonstration of very good knowledge on Graphical Descriptive Methods 
Demonstration of good knowledge on Graphical Descriptive Methods 
Demonstration of basic knowledge on Graphical Descriptive Methods 
Demonstration of poor knowledge on Graphical Descriptive Methods 
Analysis Numerical Descriptive Measures 
Demonstration of outstanding knowledge on Numerical Descriptive Measures 
Demonstration of very good knowledge on Numerical Descriptive Measures 
Demonstration of good knowledge on Numerical Descriptive Measures 
Demonstration of basic knowledge on Numerical Descriptive Measures 
Demonstration of poor knowledge on Numerical Descriptive Measures 
Estimation and testing significance level 
Demonstration of outstanding knowledge on correlation and regression analysis 
Demonstration of very good knowledge on correlation and regression analysis 
Demonstration of good knowledge on correlation and regression analysis 
Demonstration of basic knowledge on correlation and regression analysis 
Demonstration of poor knowledge on correlation and regression analysis 
Follow Us