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 with AI-Powered 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

Mechanical Vibrations Modeling And Measurement

Authors: Tony L. Schmitz , K. Scott Smith

1st Edition

119669

Students also viewed these Mathematics questions

Question

Determine fxx yy + when 2(a; 7)

Answered: 1 week ago