Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

df SS MS F Significance F Regression 2 3907.938 1953.969 19.043 0.000 Residual 10 1026.062 102.606 Total 12 4934 Coefficients Standard Error t Stat P-value

image text in transcribedimage text in transcribed
df SS MS F Significance F Regression 2 3907.938 1953.969 19.043 0.000 Residual 10 1026.062 102.606 Total 12 4934 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 87.764 17.263 5.084 0.000 49.300 126.229 Opening times (hours) 0.923 0.191 4.840 0.001 0.498 1.348 Temperature (degrees 0.254 0.592 0.429 0.677 -1.065 1.573 a) Interpret the coefficient of opening times. b) Using the 5% significance level, test whether this is a significant linear relationship between electricity bill and opening times; give hypotheses, your reasoning, decision and conclusion.The owner of a store wants to investigate the multiple linear regression between annual electricity bill ($000) with store opening times (hours) and the temperature outside (degrees Celsius) . A random sample was taken (given below), and Excel was used to create the following multiple linear regression output. Electricity bill ($000) Opening times (hours) Temperature (degrees Celsius) 134 51 30 123 40 45 178 90 40 156 55 35 145 45 30 178 90 42 156 55 34 134 50 30 167 60 38 156 50 35 134 50 30 124 40 24 178 90 40 SUMMARY OUTPUT Regression Statistics Multiple R 0.890 R Square 0.792 Adjusted R Square 0.750 Standard Error 10.129 Observations 13 ANOVA

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

Negative Binomial Regression

Authors: Joseph M Hilbe

2nd Edition

1139005960, 9781139005968

More Books

Students also viewed these Mathematics questions

Question

A speculative attack cannot occur in countries with exchange rates.

Answered: 1 week ago

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago

Question

6. What information processes operate in communication situations?

Answered: 1 week ago