Question

First 6 digits : 215028

Last 6 digits : 028009

....

Please kindly send me the solution on

my email : [email protected]

By excel and manaully .. thanks

Next > < Previous

Sort answers by oldest

• Votes
• Oldest
• Newest

Homework Answers

Answer #1

The data given in the question is;

Median home price, X1 Interest rate, X2 Year, Y 1995 1996 1997 1998 1999 2000 2001 2002 215028 174500 177900 188100 203200 203200 28009 309800 7.9 7.6 7.6 6.9 8.1 7 6.5

Here year is the dependent variable,

Median home price is the first independent variable,X₁ and

Interest rate is the second independent variable,X₂

To get the summary of regression analysis of above data firstly go to the data tab then click on data analysis then a small window will be opened, select the option of regression there, fill all the data carefully and you will get the following result.

ANOVA Significance F df 2 MS Regression Residual Total 14.41280541 7.206403 1.306114 0.349659731 27.58719459 5.517439 42 Coefficients 2018.47122 0.00000142 2.671919683 Upper 95% 2050.863053 2.81985E-05 Standard Error | t Stat IP-value | Lower 95% Intercept X Variable 1 X Variable 2 12.60097341 160.1838 1.8E-10 1986.079386 1.15213E-05 -0.12307 0.906846 1.65333633 3.10343E-05 1.61608 0.167 6.921956021 1.578116656

The regression equation is;

$Y = \beta_0 + \beta_1 X_1 + \beta_2 X_2$

Where,

$\beta_0$is the intercept,

is the slope of year and median home price and

61

$\beta_2$ is the slope of year and interest rate.

Y - 2018.47122 - 0.00000142X1 - 2.671919683X2

Know the answer?

Add Answer to:

First 6 digits : 215028 Last 6 digits : 028009 .... Please kindly send me the solution on my ...

Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Log In

Sign Up

Post as anonymous

Post Your Answer

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.

Similar Homework Help Questions

• Please kindly help me with the solution to this problem Thanks How does 'motive' apply to...

  Please kindly help me with the solution to this problem Thanks How does 'motive' apply to a commercial business, what would 'motives' be in other organizations, and how would their differences impact the methods and manner of accounting and financial reporting for an organization? 1. 2. In what way does this moti e objective of financial reporting called "Accountability?"

• Assembly language.    Can u pls send me a copyable code please. If you can run...

  Assembly language.    Can u pls send me a copyable code please. If you can run it. X86. Asm.    Subject: Assembly language If you know x86 asm then only answer it Use x86 asm version send me a written code please send me with out put please send me a copyable code i promise to give you thumbs up, question: Implement a simple 4 functios calculator for 3 digits entry. The user will enter 2 digits for the first...

• i need solution manual of applied engineering thermodynamics by T D eastop and mcconkey please...

  i need solution manual of applied engineering thermodynamics by T D eastop and mcconkey please send it to me at [email protected]

• What to do if my classmate sent me a text asking to send him my homework,...

  What to do if my classmate sent me a text asking to send him my homework, ‘cause he is struggling to solve it. So I sent it to him. Now I got an email from teacher, saying our homework s are the same. And we both got zero points. Can I do anything about it? Can I say that I didn’t know he copied it?

• please help me with this quizz is my last opportunity in this course! please help me...

  please help me with this quizz is my last opportunity in this course! please help me cl SAD 7 ーSADM2 ←Carin diox.de. _usaret - exmetaica

• can someone please help me write an email for my teacher asking her to proofread my...

  can someone please help me write an email for my teacher asking her to proofread my essay. I was starting to write her an email but I feel like I don't make sense or sounds polite enough. English isn't my first language and I don't feel very confident about it. Thank you in advance for your help!

• My final year project is underground cable fault detecton. kindly guide me about its abstract ,...

  My final year project is underground cable fault detecton. kindly guide me about its abstract , project implementation , the proper list of components required required for it. its objectives , and last also guide specify technical details of final delieverable. can this project can be done with pic microcontroller?

• Can someone please help me write an email to my teacher? On Wednesday she said that...

  Can someone please help me write an email to my teacher? On Wednesday she said that our essay was due on Friday at 1:00 pm. However, I think she made a mistake and she put a different date on Canvas. She put that our essay is due on Saturday at 1:00 pm. I want to email her to tell her about her mistake and that I'm just letting her know so she can let know my classmate and they submit...

• Please send me the solutions for the above 6 questions. Please send it as tomorrow I...

  Please send me the solutions for the above 6 questions. Please send it as tomorrow I have an exam. Thank You. ? 8. Prove that if n is a perfect square, then n + 2 is not a perfect square. 9. Use a proof by contradiction to prove that the sum of an irrational number and a rational number is irrational 17. Show that if n is an integer and n3 + 5 is odd, then n is even using...

• Please help me with 5.4 Question's solution. ***PLEASE PROVIDE A DETAILED SOLUTION FOR MY UNDERSTANDING*** Your...

  Please help me with 5.4 Question's solution. ***PLEASE PROVIDE A DETAILED SOLUTION FOR MY UNDERSTANDING*** Your time & help is highly appreciated. Thanks EXERCISES 5.1 Plot the following data and then calculate and plot a three 5.4 Referring to the data in exercise 1, use Excel's Solver or period moving average. Then calculate and plot a five- period moving average. What do you observe in comparing the plots of the three- and five-period moving averages? trial and error to find...

ADVERTISEMENT

Free Homework Help App

Download From Google Play

Scan Your Homework
to Get Instant Free Answers

Need Online Homework Help?

Ask a Question

Get Answers For Free
Most questions answered within 3 hours.

ADVERTISEMENT

Share Your Knowledge

Post an Article +5 Coins

Post an Answer +5 Coins

Post a Question with Answer +5 Coins

ADVERTISEMENT

Active Questions

• Define the following concepts in your own words: (a) stiffness, (b) strength, (c) strain, (d) ductility,...
  
• In C++ In this homework, you will be tasked with creating functions to manipulate strings that...
  
• An isolated colony represents a pure culture. one rare occasions , however , a colony can...
  
• *****DO NOT ANSWER THIS QUESTION IF YOU DON'T KNOW*******Rights and Duties of Auditors; Minimum 4000 words...
  
• The probability that Janie is wearing sunglasses is 1/4. The probability that she is wearing sunglasses...
  
• Do you believe social media is more of a help or a hindrance in controlling crises...
  
• Two long, parallel wires separated by 2.85 cm carry currents in opposite directions. The current in...
  
• Question # 1. Develop a list of rehabilitation journals that publish articles concerning career counseling for...
  
• Bryant Company has a factory machine with a book value of $85,100 and a remaining useful...
  
• What is the default classification for federal tax purposes of a U.S. eligible entity with one...
  
• 1. How many grams would 4.0x1021 atoms of calcium weigh? 2.. Calculate the percent oxygen in...
  
• Balance Equation K2Cr2O7 + H2C2O4 2H2O 6 K[Cr(C2O4 )2 (H2O)2 ]2H2O + CO2 + H2O
  

ADVERTISEMENT

---

DMCA

• About
• Contact
• Terms of Use
• Privacy Policy
• Academic Honesty Policy

• Homework Answer Scanner App

© 2013-2022 ZuoTi.Pro

user contributions licensed under cc by-sa 4.0

Answer 1

The data given in the question is;

Median home price, X1 Interest rate, X2 Year, Y 1995 1996 1997 1998 1999 2000 2001 2002 215028 174500 177900 188100 203200 203200 28009 309800 7.9 7.6 7.6 6.9 8.1 7 6.5

Here year is the dependent variable,

Median home price is the first independent variable,X₁ and

Interest rate is the second independent variable,X₂

To get the summary of regression analysis of above data firstly go to the data tab then click on data analysis then a small window will be opened, select the option of regression there, fill all the data carefully and you will get the following result.

ANOVA Significance F df 2 MS Regression Residual Total 14.41280541 7.206403 1.306114 0.349659731 27.58719459 5.517439 42 Coefficients 2018.47122 0.00000142 2.671919683 Upper 95% 2050.863053 2.81985E-05 Standard Error | t Stat IP-value | Lower 95% Intercept X Variable 1 X Variable 2 12.60097341 160.1838 1.8E-10 1986.079386 1.15213E-05 -0.12307 0.906846 1.65333633 3.10343E-05 1.61608 0.167 6.921956021 1.578116656

The regression equation is;

$Y = \beta_0 + \beta_1 X_1 + \beta_2 X_2$

Where,

$\beta_0$is the intercept,

is the slope of year and median home price and

61

$\beta_2$ is the slope of year and interest rate.

Y - 2018.47122 - 0.00000142X1 - 2.671919683X2