# 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

Don't use plagiarized sources. Get Your Custom Essay on
Data were collected on annual income, household size, and annual credit card charges for a sample of 50 consumers.
Just from \$13/Page

Unformatted Attachment Preview

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

attachment

Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

### Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors: