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 |
Assignment Service Australia | CDR Writing Help | TAFE Assignment Help | Perth Assignment Help | Melbourne Assignment Help | Darwin Assignment Help | Adelaide Assignment Help | Assignment Help Victoria | Sydney Assignment Help | Canberra Assignment Help | Brisbane Assignment Help | CDR for Australian immigration | Assignment For Australian History
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services