Dex Research Limited conducted a research to investigate consumer characteristics that can be used to predict the amount charged by credit card users. The following multiple regression output is based on a data collected by this research company on annual income, household size and annual credit card charges for a sample if 50 consumers. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9086 0.8181 398.0910 ANOVA Significance F 1.50876E-18 df SS MS F Regression 2 D E Residual 7448393.148 Total 49 42699148.82 Coefficients Standard Error 1304.9048 t Stat P-value Intercept Income ($1000s) Household Size 197.6548 6.6019 3.28664E-08 33.1330 3.9679 7.68206E-11 356.2959 33.2009 10.7315 3.12342E-14 (4 marks) b. Estimate the annual credit card charges for a three-person household with an annual income (2 marks) (1 mark) a. Complete the missing entries from A to H in this output of $40,000. c. Did the estimated regression equation provide a good fit to the data? Explain

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section: Chapter Questions
Problem 22SGR
icon
Related questions
icon
Concept explainers
Question

 

 

Question 5: Week 11 Question 3, (7 Marks)
Dex Research Limited conducted a research to investigate consumer characteristics that can be used to
predict the amount charged by credit card users. The following multiple regression output is based on a
data collected by this research company on annual income, household size and annual credit card
charges for a sample if 50 consumers.
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.9086
A
0.8181
398.0910
ANOVA
df
Significance F
MS
F
Regression
2
D
E
G.
1.50876E-18
Residual
7448393.148
Total
49
42699148.82
Coefficients Standard Error
t Stat
P-value
Intercept
1304.9048
197.6548
6.6019
3.28664E-08
Income ($1000s)
33.1330
3.9679
7.68206E-11
Household Size
356.2959
33.2009
10.7315
3.12342E-14
(4 marks)
a. Complete the missing entries from A to H in this output
b. Estimate the annual credit card charges for a three-person household with an annual income
of $40,000.
(2 marks)
(1 mark)
C.
Did the estimated regression equation provide a good fit to the data? Explain
Transcribed Image Text:Question 5: Week 11 Question 3, (7 Marks) Dex Research Limited conducted a research to investigate consumer characteristics that can be used to predict the amount charged by credit card users. The following multiple regression output is based on a data collected by this research company on annual income, household size and annual credit card charges for a sample if 50 consumers. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9086 A 0.8181 398.0910 ANOVA df Significance F MS F Regression 2 D E G. 1.50876E-18 Residual 7448393.148 Total 49 42699148.82 Coefficients Standard Error t Stat P-value Intercept 1304.9048 197.6548 6.6019 3.28664E-08 Income ($1000s) 33.1330 3.9679 7.68206E-11 Household Size 356.2959 33.2009 10.7315 3.12342E-14 (4 marks) a. Complete the missing entries from A to H in this output b. Estimate the annual credit card charges for a three-person household with an annual income of $40,000. (2 marks) (1 mark) C. Did the estimated regression equation provide a good fit to the data? Explain
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,