Solving for Y using linear regression on HP17bii+
04-03-2020, 11:54 PM
Post: #1
 Trulyrc Junior Member Posts: 5 Joined: Apr 2020
Solving for Y using linear regression on HP17bii+
Hello!

How do I solve this equation on the HP 17bii+?

You have a bldg with 15,000 SF; what is the price PSF of this bldg based on sales:

Sale 1. 12,000 SF; price PSF is $68.33 Sale 2. 14,000 SF; price PSF is$59.64
Sale 3. 16,000 SF; price PSF is $52.81 Sale 4. 18,000 SF; price PSF is$47.22

I know how to make the lists (one for SF and one for price PSF), but how do I add the bldg's 15,000 SF after that, to solve for its price PSF?

04-04-2020, 12:00 AM
Post: #2
 Gene Moderator Posts: 1,250 Joined: Dec 2013
RE: Solving for Y using linear regression on HP17bii+
04-05-2020, 02:51 AM
Post: #3
 Trulyrc Junior Member Posts: 5 Joined: Apr 2020
RE: Solving for Y using linear regression on HP17bii+

However, the missing explanation is how to input the SF of the subject bldg, after having entered the two lists of sales.
How do you add that into the HP 17bii+ to then solve for Y?
04-05-2020, 01:28 PM (This post was last modified: 04-05-2020 01:29 PM by Gene.)
Post: #4
 Gene Moderator Posts: 1,250 Joined: Dec 2013
RE: Solving for Y using linear regression on HP17bii+
Example 1 of the PDF shows how to do that.

In your problem, the SF would be X and the Price per SF is Y. Those are the same as the X and SALES in the example 1 of the PDF.

One you have entered your two lists as SF and PSF (perhaps, whatever you name them), then if you understand example 1 in the PDF you will know how to solve this problem.

Simple change X in the PDF to SF and SALES in the PDF to PSF and substitute those when working through the problem.

Note: You do not add the new SF to the previous SF list. You enter the SF for which you wish to predict a PSF just like the example showed for predicting Sales and X.

Work the PDF and make sure you understand how to predict Sales given a time period X and how to predict a time period X given a Sales value. Once you have that, you know how to work this.

Hope that helps.
04-05-2020, 02:12 PM
Post: #5
 Trulyrc Junior Member Posts: 5 Joined: Apr 2020
RE: Solving for Y using linear regression on HP17bii+
Definitely helped; I GOT IT! Thank you!
04-05-2020, 03:50 PM
Post: #6
 Gene Moderator Posts: 1,250 Joined: Dec 2013
RE: Solving for Y using linear regression on HP17bii+
Great. Sorry it was unclear! :-)

That's the purpose of this forum. We all need help, myself included!
04-07-2020, 08:50 PM
Post: #7
 Trulyrc Junior Member Posts: 5 Joined: Apr 2020
RE: Solving for Y using linear regression on HP17bii+
No need to apologize! It was my hiccup in my mind... I thought those extra steps were for forecasting into the future only. But I guess in this case it's sort of a forecast as well. Makes sense now!
Thank you ever so much for helping me through that...thanks for this forum!!
04-07-2020, 11:22 PM
Post: #8
 Gene Moderator Posts: 1,250 Joined: Dec 2013
RE: Solving for Y using linear regression on HP17bii+
Great. Return the favor by staying part of the community here and you'll find ways to help others. :-)
04-14-2020, 03:33 PM
Post: #9
 Trulyrc Junior Member Posts: 5 Joined: Apr 2020
RE: Solving for Y using linear regression on HP17bii+
Will do; I'm not going anywhere! Thanks again :-)
 « Next Oldest | Next Newest »

User(s) browsing this thread: 1 Guest(s)