Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A researcher wants to examine the relationship between the annual electricity costs ($000) per house , the number of solar panels on a house and

A researcher wants to examine the relationship between the annual electricity costs ($000) per house , the number of solar panels on a house and the number people per house.EXCEL was used to create the following multiple linear regression output.

Regression Statistics

Multiple R0.97

R Square0.94

Adjusted R Square0.93

Observations10

Coefficients Standard Error t Stat P-value Lower95%Upper95%

Intercept 1.22 0.175 7.03 0.00 0.81 1.63

Age -0.15 0.02 -10.27 0.00 -0.19 -0.12

People per house 0.07 0.03 2.63 0.03 0.01 0.14

A)Write down the 95% confidence interval to estimate the population coefficient of People per house.Do NOT interpret.

B)Test for a positive linear relationship between annual electricity cost and people per house, giving hypotheses and using a 1% level of significance.

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

Interconnection Networks

Authors: J C Bermond

1st Edition

1483295273, 9781483295275

More Books

Students also viewed these Mathematics questions