finance and accounting
The credit data file CREDIT12.XLS represents a random sample of 118 data records for individuals applying for credit at a well-known store. The file is available on the Excel sheet and the meaning of the field variables is given overleaf.
Attempt the following tasks, showing your working when appropriate:
1 Based on this sample, and clearly showing workings, appropriate graphics and your response to blank values in the data, calculate the following:
(a) the probability of randomly picking two men under 40 from the sample
(b) given that we’re picking from men in the sample, the probability of picking a
man whose job income is between £2,000 and £3,000 per month
(c) a sub-sample group of five unmarried men under 35 are to share their more detailed views of credit in a focus group. Calculate how many different ways are there of putting these groups of five together from this sample?
2 Assume that Total Income is the sum of Job Income and Additional Income.
(a) produce frequency dis