Data were collected on annual income, household size, and annual credit card charges for a sample of 50 consumers.

ME International Bank is trying to investigate consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and annual credit card charges for a sample of 50 consumers. Question 1 Use the attached data file to Develop an estimated regression equation with annual income and household size as the independent variables. Comment on whether the estimated regression equation provide a good fit to the data.The predicted annual credit card charge for an average customer. Question 2 Provide a brief summary report for your manager indicating Summary statistics of consumer characteristics evident from the data set.An overview of which of the two independent variables is a better predictor of annual credit card charges. The
predicted annual credit card charge for an average customer.
assignment_3__1_.docx

worksheet_in_assignment_3__1_.xlsx

Unformatted Attachment Preview

BUS482.PC: QUANTITATIVE METHODS IN BUSINESS
Scenario
ME International Bank is trying to investigate consumer characteristics that can be used to predict the amount charged
by credit card users. Data were collected on annual income, household size, and annual credit card charges for a
sample of 50 consumers.
Data File
Question 1
Consumer.xlsx
[5 Marks]
Use the attached data file to
a) Develop an estimated regression equation with annual income and household size as the independent
variables.
b) Comment on whether the estimated regression equation provide a good fit to the data.
Question 2
[5 Marks]
Provide a brief summary report for your manager indicating
a) Summary statistics of consumer characteristics evident from the data set.
b) An overview of which of the two independent variables is a better predictor of annual credit card charges.
c) The predicted annual credit card charge for an average customer.
Gender
Nationality
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Expatriate
Expatriate
Expatriate
Expatriate
Emirati
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Emirati
Emirati
Emirati
Emirati
Emirati
Emirati
Expatriate
Expatriate
Expatriate
Expatriate
Expatriate
Emirati
Expatriate
Emirati
Expatriate
Expatriate
Expatriate
Income
($1000s)
54
30
32
50
31
55
37
40
66
51
25
48
27
33
65
63
42
21
44
37
62
21
55
42
41
54
30
48
34
67
50
67
55
52
62
64
22
29
39
35
39
54
23
27
26
Household
Size
3
2
4
5
2
2
1
2
4
3
3
4
1
2
3
4
6
2
1
5
6
3
7
2
7
6
1
2
5
4
2
5
6
2
3
2
3
4
2
1
4
3
6
2
7
Amount
Charged ($)
4,016
3,159
5,100
4,742
1,864
4,070
2,731
3,348
4,764
4,110
4,208
4,219
2,477
2,514
4,214
4,965
4,412
2,448
2,995
4,171
5,678
3,623
5,301
3,020
4,828
5,573
2,583
3,866
3,586
5,037
3,605
5,345
5,370
3,890
4,705
4,157
3,579
3,890
2,972
3,121
4,183
3,730
4,127
2,921
4,603
Female
Female
Female
Female
Female
Emirati
Emirati
Emirati
Expatriate
Expatriate
61
30
22
46
66
2
2
4
5
4
4,273
3,067
3,074
4,820
5,149
…
Purchase answer to see full
attachment