Investigate the wealth of KDS customers and whether or not they have applied for and were granted credit with KDS, a survey using a self-completion questionnaire was employed.

BQ7803 Foundations of Data Analysis and Reporting

Survey 1: (Quantitative Data Analysis Assignment)

In order to investigate the wealth of KDS customers and whether or not they have applied for and were granted credit with KDS, a survey using a self-completion questionnaire was employed. The questionnaire contained questions on age, years in work, type of occupation and level of education amongst other things.
The relevant data are contained in the Credit.sav file; the specification of the variables is presented at the end of this document. The assignment comprises the following two parts.

Part 1
You are required to:
a.provide a graph representing JOBINC and interpret the information the graph conveys,
b.comment on the summary statistics describing the main features and distribution characteristics of JOBINC, and
c.using JOBINC or any other ratio variable, carry out significance tests on two and more than two population means.

Part 2
Develop the best model to explain/predict JOBINC. State fully the assumptions underlying the estimation procedures used and identify any estimation problems that arise when these assumptions break down.

The focus must be on interpretation of results and clearly stating and explaining any underlying assumptions. Formulae are not required! Avoid including irrelevant and unnecessary information in your assignment; supporting information may be placed in appendices.

Data-set: Credit.sav

The Centre for Business Research was commissioned by a department store in Kingston to assess the profile of customers who applied for account facilities. A random sample of 2260 credit applicants was drawn from the database and a postal survey resulted in 113 useable responses. The variables and their specification included in the survey are presented below.

ColumnVariableHow the variables were measured
C1idIdentification
C2classIndicates whether applicant granted credit
where: 1 = credit granted and 0 = credit not granted
C3sexIndicates whether applicant is male or female
where: 1 = male and 0 = female
C4ageApplicants age in years
C5jobyrsApplicants number of years in current job
C6jobincApplicants monthly income from current job
C7jobstatIndicates job status of applicants
where: 1 = management; 2 = supervisory and 3 = other
C8educNumber of years schooling
C9addincApplicants additional monthly income
C10totbalApplicants total debt balances
C11totpayApplicants total outgoings
C12spincApplicants spouses monthly income
C13mstatusIndicates applicants marital status
where: 1 = married and 0 = not married
C14homesIndicates whether applicants are home owners or not
where: 1 = owns home and 0 = does not own home