The following data was collected by a particular company to determine if a relationship between the number of people in a household and weekly food expenditures exists. Regression analysis is done using this data, and the following Excel see attached image Household Number in Household Weekly Food Expenses 1 2 $95 2 3 $137 3 5 $165 4 2 $105 5 4 $227 6 4 $240 7 5 $185 a. Interpret the correlation coefficient and the coefficient of determination.

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter11: Data Analysis And Displays
Section11.4: Two-ways Tables
Problem 12E
icon
Related questions
Question

The following data was collected by a particular company to determine if a relationship between the number of people in a household and weekly food expenditures exists.

Regression analysis is done using this data, and the following Excel see attached image

Household

Number in Household

Weekly Food Expenses

1

2

$95

2

3

$137

3

5

$165

4

2

$105

5

4

$227

6

4

$240

7

5

$185

a. Interpret the correlation coefficient and the coefficient of determination.  

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
0.713
0.508
0.410
43.393
Observations
7
ANOVA
df
SS
MS
Significance F
Regression
1
9738.25
9738.25
5.17
0.07
Residual
9414.60
1882.92
Total
6 19152.86
Coefficientsandard Errc
t Stat
P-value
Lower 95% Upper 95%
Intercept
51.779
52.358
0.989
0.368
-82.810
186.369
Number in Household
31.662
13.922
2.274
0.072
-4.127
67.450
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.713 0.508 0.410 43.393 Observations 7 ANOVA df SS MS Significance F Regression 1 9738.25 9738.25 5.17 0.07 Residual 9414.60 1882.92 Total 6 19152.86 Coefficientsandard Errc t Stat P-value Lower 95% Upper 95% Intercept 51.779 52.358 0.989 0.368 -82.810 186.369 Number in Household 31.662 13.922 2.274 0.072 -4.127 67.450
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
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
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning