Question: For this data set, run a regression line in excel using the data/ data analysis tab. a. State the equation for the line of best

For this data set, run a regression line in excel using the data/ data analysis tab.

a. State the equation for the line of best fit and explain what the slope coefficient means.

b. What is the R^2 value and what does it mean?

c. Solve the equatiob by setting X=0 and ansser. What is another name for the value/answer that you just found?

d. Do you require an adjusted R^2? Why or why not?

DATA SET:

Hospital Room Size (square footage)

Electricity Bill

3117

186.435

1086

74.73

4276

250.18

4019

236.045

857

62.135

3114

186.27

1132

77.26

3427

203.485

690

52.95

4806

279.33

4052

234.86

173

21.515

1948

119.14

209

23.495

1175

76.625

3223

189.265

3950

229.25

4778

274.79

3089

181.895

1524

95.82

4082

236.51

276

36.18

478

47.29

1482

102.51

3933

237.315

1533

105.315

4095

246.225

4791

284.505

2893

180.115

1950

128.25

2263

145.465

4344

259.92

2805

175.275

4329

123.225

896

37.4

4671

131.775

146

18.65

1910

89

622

30.55

1422

50.55

2241

71.025

564

29.1

2972

89.3

123

18.075

2740

83.5

1342

48.55

246

21.15

1213

45.325

3558

103.95

2782

84.55

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Identifying Relationships Between Variables In this assignment, you will be analyzing the cost of living in any U.S. city and creating a scatterplot to identify the relationships between variables....

Q:

Prior to beginning work on this assignment, read Chapter 4 of your textbook, including the "Cost of Living Brief Case" at the end of Chapter 4 on page 143, and access the NumbeoCost of Living(Cost of...

Q:

Identifying Relationships Between Variables https://www.numbeo.com/cost-of-living/ Sharpe, N. D., De Veaux, R. D., & Velleman, P. F. (2019). Business statistics (4th edition) analyzing the cost of...

Q:

Go to the Numbeo Cost of Living https://www.numbeo.com/cost-of-living/ web page. In the "Select City" search box, type Chicago and when it appears in the drop-down menu select it. A summary, along...

Q:

PA & Compensation Management (a) Using the following data set, calculate the line of best fit using the least-squares (regression/correlation analysis) method. The evaluated points for each...

Q:

Student Name Jack Anne Harry Sharon John James Jill Adam Brandon Brett Brady Charles Darren The following data was collected by a teacher who gave a test. He wonders if there is a relationship...

Q:

The Browne's Town housing Scheme operates a Laundromat, solely for the purpose of providing laundering services to Tenants in residence. You have been hired as an accountant , to analyze the cost of...

Q:

The Browne's Town housing Scheme operates a Laundromat, solely for the purpose of providing laundering services to Tenants in residence. You have been hired as an accountant , to analyze the cost of...

Q:

Curve-fitting Project - Linear Model (due at the end of Week 5) Instructions For this assignment, collect data exhibiting a relatively linear trend, find the line of best fit, plot the data and the...

Q:

Curve-fitting Project - Linear Model (due at the end of Week 5) Instructions For this assignment, collect data exhibiting a relatively linear trend, find the line of best fit, plot the data and the...

Q:

On 1st January 2019, RTID Ltd purchased 100 bonds at 100 from SUFC ltd at par value. The bonds are redeemable at par and bear interest at 5% per annum in arrears. The market rate on equivalent bonds...

Q:

Assume you were recently hired by Caffe DAmore, the company that formulated the worlds first flavored instant cappuccino and now manufactures several lines of flavored cappuccino mixes. Given the...

Q:

what the correct answer is b. Comment briefly on the comparative values of these three companies. What is the major cause of the differences among these three valuations? (Select the best choice...

Q:

Today, Malorie takes out a 30-year loan of $200,000, with a fixed interest rate of 3.8% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest...

Q:

9-14 What goals was the ERP system used to achieve at WIM? Critically analyze how these goals helped WIM to overcome obsctacles they had faced earlier. Welding Industries Malaysia (WIM) is the only...

Q:

4. What are the challenges posed by enterprise applications and how are enterprise applications taking advantage of new technologies?

Q:

9-9 Office Depot is a global supplier of office supply products and services in 59 countries. The company tries to offer a wider range of office supplies at lower cost than other retailers by using...