Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A researcher is investigating the linear relationship between household annual water bill ($), the number of people per household and the capacity of a backyard

A researcher is investigating the linear relationship between household annual water bill ($), the number of people per household and the capacity of a backyard water tank (litres) of that household. Only households with water tanks were sampled. The researcher took a random sample and used Excel to create the following regression output.

image text in transcribed
SUMMARY OUTPUT Regression Statistics Multiple R 0.732 R Square 0.535 Adjusted R Square 0.403 Standard Error 1982.209 Observations 10 ANOVA df SS MS F Significance F Regression 2 31691171.26 15845586 4.033 0.068 Residual 7 27504078.74 3929154 Total 9 59195250 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 1420.522 1474.821 0.963 0.368 -2066.875 4907.920 People per household 344.191 140.846 2.444 0.045 11.144 677.238 Backyard water tank capacity (litres) -0.219 0.114 -1.911 0.098 -0.489 0.052

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus

Authors: Howard Anton, Irl C Bivens, Stephen Davis

10th Edition

1118404009, 9781118404003

More Books

Students also viewed these Mathematics questions

Question

Detailed note on the contributions of F.W.Taylor

Answered: 1 week ago

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago