Quantitative Analysis for Business: Written Assignment: Computer Application Project

Instructions:
Semester 2 2018

Written Assignment: Computer Application Project
(worth 25% of the overall assessment)
DUE DATE: 11:59PM (Darwin time), 5 October 2018

 All numerical calculations and graphs/plots should be done using EXCEL as much as possible.
 Only typed assessments in a Word document will be marked. Equations, symbols could be hand-
written. You have to copy and paste Excel outputs (eg, 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.
 The completed assignment (word document) must be submitted electronically via “Written
Assignment Submission Point: Word Document ONLY” under Written Assignment folder.
 The Excel file used for estimations must be submitted electronically via “Excel Workbook
Submission Point” under Written Assignment folder.
 You are required to keep a hard copy of the submitted assignment to re-submit, in case the original
submission is lost for some reason.

Important Notice:
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

Income can have significant effects on people’s spending patterns. Research studies have
revealed that consumer expenditure is influenced by various factors such as their income,
gender, age and level of education. In order to investigate the relationship between food
expenditure and take home pay in Australia, a researcher plans to survey a sample of individuals
across the country.

Part 1 [3 marks=1+1+1]

Briefly explain
(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 a researcher has collected data form a sample of 150 individuals for this study. For each
individual, the weekly take-home pay and weekly food expenditure were recorded. The data are
stored in file FOODEXP.XLS. Using this data set and EXCEL, answer the questions below.

Part 2 [5 Marks = 1 + 2 + 1 + 1 marks]

First, the researcher wishes to use the graphical descriptive methods and numerical descriptive
mesures to present the data for the two variables.

(a) The researcher decides to use 8 class intervals such as 100<X≤225, 225<X≤350,
350<X≤475, ….., 975<X≤1100 for weekly take-home pay variable and class intervals
0<X≤50, 50<X≤100, 100<X≤150, …. , 350<X≤400 for weekly food expenditure variable.
Explain how the researcher would have decided on 8 class intervals.
(b) Draw a histogram for each variable using appropriate BIN values from part (a).
(c) Prepare a numerical summary report for the two variables; weekly take-home pay and
food expenditure by including summary measures such as mean, median, range, 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 skewness of the distribution of the two variables.

QAB105, S2, 2018

Page 1

Part 3 [8 Marks = 1+1+2+2+2 marks]

Second, the researcher wishes to investigate the association between the two variables.

(a) Explain what could be the independent variable (X) and the dependent variable (Y).
(b) Using an appropriate plot, investigate the relationship between weekly take-home
pay and weekly food expenditure. On the same plot, fit a linear trend line.
(c) Using Excel, compute a numerical summary measure to measure the strength and the
direction of the linear relationship between weekly take-home pay and weekly food
expenditure. Interpret this value.
(d) Display the regression summary table. Using the summary results, estimate the Least
Squares Regression equation and interpret the intercept and slope coefficient
estimates of the estimated linear regression model.
(e) Using the regression summary output table, conduct a hypothesis testing to conclude
whether there is a linear relationship between weekly take-home pay and weekly
food expenditure. Use .

Part 4 [4 marks]