QAB105 Quantitative Analysis for Business Semester 2 2019
Written Assignment: Computer Application Project
(worth 25% of the overall assessment)
Only typed assessments in a Word document will be marked. Equation, symbols, could be hand-written. You have to copy and paste Excel outputs (plots, tables etc) into your main assignment which is the word document. Any answer in the Excel document, but not in the main document will NOT be marked.
As this is an individual assessment item, students should submit their individual assignment. All assignments submitted will go through a matching process. If found to have cheated/ plagiarised, all submissions involved would receive a mark of zero for this assessment item.
This Assignment consists of 4 parts
A sociologist theorised that people who watch television frequently are exposed to many commercials, which in turn lead them to buy, resulting in increasing debt. To test this belief, a researcher plans to survey a sample of families across the country.
Part 1 [2 marks]
(a) What type of survey method could the researcher use and why?
(b) What sampling method could the researcher use to select his/her sample and why?
(c) What kind of issues the researcher may face in this data collection?
Suppose the researcher collected data from 400 randomly selected families. For each family, the total debt (in $) and the number of hours the television is turned-on per week (TV hours) were recorded. The data are stored in file Assignment Data set_TVDEBT.XLS available in the Written Assignment folder. Using this data and EXCEL, answer the questions below.
Part 2 [8 Marks]
Firstly, the researcher wishes to use the graphical descriptive methods and numerical descriptive measures to present the data for the two variables.
(c) Prepare a numerical summary report for the two variables; the total debt and the TV hours by including the summary measures, such as mean, median, variance, standard deviation, smallest and largest values, and the three quartiles, for each variable.
Notes: Use QUARTILE.EXC command to generate the three quartiles.
(d) Based on your histograms in part (b) and descriptive summary measures in part (c),
comment on the shape of the distribution of the two variables.
Part 3 [10 Marks]
Secondly, the researcher wishes to investigate the association between the two variables.
Part 4 [5 marks]
(a) Based on your answers above, write a brief research report on the relationship between total debt and TV hours (not more than 250 words).
END OF WRITTEN ASSIGNMENT
QAB105, S2, 2019 Page 2