ASSESSMENT DESCRIPTION: The title of the mini research is ‘Expenditure Patterns of International…

ASSESSMENT DESCRIPTION: The title of the mini research is ‘Expenditure Patterns of International…

ASSESSMENT DESCRIPTION:
The title of the mini research is ‘Expenditure Patterns of International Students in Australia (ExPat Survey, T1 2019)’. Students need to follow the steps given below.
a. Forming groups: Students will be formed as groups (3-4 students) by the lecturer between week 3 and 4. Students MUST enroll in a group within this time frame in order to participate in this assignment task.
b. Prepare the survey questionnaire and data collection: Under the supervision of your lecturer design a survey questionnaire with 10 questions by week 5. The contents of the questionnaire must be as follows.
a. No of Categorical questions – 4 (Gender, country, type of studies etc..)
b. No of expenditure related questions – 5 (monthly rent expenditure, monthly internet expenditure, monthly entertainment expenditure etc..)
c. Monthly average income
 Logistics: Group members need to print 20 copies of the questionnaire and prepare for the data collection·
 Sampling: Select a random sample of 20 international students from your city (sample size = 20)·
 Data collection: Group members need to meet randomly selected 20 students and collect data using the printed survey questionnaire.·
c. Data filtering: After completing the data collection transfer them into an excel sheet.
d. Data analysing: The data set must be analysed with the help of Microsoft Excel (making tables, drawing graphs and finding descriptive statics etc.
e. Reporting and documentation: Your findings need to be reported according to the format given below
Reporting Format
1. Title page
Design a title page with an appropriate name for your business report, group members name, and student IDs.
2. Executive summary
Here you need to summarise the whole report findings into a smaller paragraph (need to do at the end)
3. Table of contents
Table of contents needs to be generated electronically in Microsoft Word.
4. Introduction
Give a brief introduction to your population and aims and objectives of the report
5. Method of data collection
Briefly describe your survey questions, nature of your variables, your respondents, sampling strategy and method of data collection. Include your data set in a form of a table with this section or as an appendix.
6. Summary of the data set
Give appropriate graphical and numerical summaries that describe your variables (Microsoft Excel can be used for this task). Also, provide a brief discussion under each of your data summaries based on your judgments and compare your results with similar studies.
7. Descriptive data analysis
Select any four numerical variables from your data set and prepare a summary of descriptive statistics using Microsoft Excel for each of them. Interpret your key findings (mean, variance and standards deviation etc) and provide justifications with a brief discussion supported by appropriate references.
8. Simple linear regression analysis
 Find out the linear relationship between any three expenditure items and monthly income.·
 Develop a scatter diagram with the help of Microsoft Excel and discuss about the casual relationship between those two variables by observing the overall trend of·
your plots of coordinates.
 Estimate the functional relationship (simple linear regression) between the same set of variables with the help of Microsoft Excel. Provide a brief discussion on your·
findings.
 Predict the expenditure for any given level of income that is NOT available in your data set.·
9. Conclusion and recommendations
Provide a brief overview of your collective findings and previous discussions in the report.
Finally, provide several recommendations by connecting to your aims, objectives and overall findings.
10. List of references
Minimum five references are required for this assignment task (read ‘general notes for referencing’ below)