I am working on an assignment and I was trying to compare my results with what is given here. https://www.bartleby.com/questions-and-answers/the-sheet-called-housepr-contains-data-on-prices-of-houses-that-have-sold-recently-and-two-attribute/9927f067-cb79-4a9b-85fd-b5fe77442023 I am getting a different Excel output and I cannot figure out why. Can I have some assistance to what I am doing wrong? Or is the solution on here incorrect?

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter4: Polynomial And Rational Functions
Section4.6: Rational Functions
Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.
icon
Related questions
icon
Concept explainers
Topic Video
Question

I am working on an assignment and I was trying to compare my results with what is given here. https://www.bartleby.com/questions-and-answers/the-sheet-called-housepr-contains-data-on-prices-of-houses-that-have-sold-recently-and-two-attribute/9927f067-cb79-4a9b-85fd-b5fe77442023 I am getting a different Excel output and I cannot figure out why. Can I have some assistance to what I am doing wrong? Or is the solution on here incorrect?

 
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.762538
R Square
0.581464
Adjusted R 0.578636
Standard E 57.03166
Observatic
150
ANOVA
df
SS
MS
F
ignificance F
Regressior
1 668781.8 668781.8 205.6139 8.71E-30
Residual
148 481386.4
3252.61
Total
149 1150168
Coefficientsandard Erre
t Stat
P-value Lower 95%Upper 95%ower 95.09 pper 95.0%
Intercept 296.2633 35.29389 8.394182 3.48E-14 226.5183 366.0084 226.5183 366.0084
SqrFoot
28.56961 1.992407 14.33924 8.71E-30 24.63237 32.50685 24.63237 32.50685
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R 0.762538 R Square 0.581464 Adjusted R 0.578636 Standard E 57.03166 Observatic 150 ANOVA df SS MS F ignificance F Regressior 1 668781.8 668781.8 205.6139 8.71E-30 Residual 148 481386.4 3252.61 Total 149 1150168 Coefficientsandard Erre t Stat P-value Lower 95%Upper 95%ower 95.09 pper 95.0% Intercept 296.2633 35.29389 8.394182 3.48E-14 226.5183 366.0084 226.5183 366.0084 SqrFoot 28.56961 1.992407 14.33924 8.71E-30 24.63237 32.50685 24.63237 32.50685
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning