How to Multiple Regression Forecast Using HP 17BII?

12222016, 05:46 AM
Post: #1




How to Multiple Regression Forecast Using HP 17BII?
I was able to pick up my HP 17BII from eBay. Now I am trying to learn how to use it. I've pretty much got the hang of how to use it but now I am experimenting on how to properly do Multiple Linear Regression with 23 variables. I am not quite sure how the programming works on it, but I am willing to learn. The reason why I wanted the 17BII, the programming functions that comes with it and its solver function.


12222016, 08:38 AM
Post: #2




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 05:46 AM)AraragiMonogatari Wrote: I was able to pick up my HP 17BII from eBay. Now I am trying to learn how to use it. I've pretty much got the hang of how to use it but now I am experimenting on how to properly do Multiple Linear Regression with 23 variables. I am not quite sure how the programming works on it, but I am willing to learn. The reason why I wanted the 17BII, the programming functions that comes with it and its solver function. Hi, The 17B series has SOLVE only (but this SOLVE is the most efficient on HP calculators), no programming capability installed. I guess you're not the first who want to make multiple regression on 17Bxx, so I think the experts will be help you in this issue soon. Anyway: what kind of regression function you want to fit to your data? Please post here the function. Thanks, Csaba 

12222016, 09:38 AM
Post: #3




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 08:38 AM)Csaba Tizedes Wrote: Hi,Browsing through the old forum, I've heard of this mythical "Let and Get" function that the 17B can do. For the regression function, the basic independent variable and is it even possible to calculate for the RSquared? 

12222016, 02:34 PM
Post: #4




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 05:46 AM)AraragiMonogatari Wrote: I was able to pick up my HP 17BII from eBay. Now I am trying to learn how to use it. I've pretty much got the hang of how to use it but now I am experimenting on how to properly do Multiple Linear Regression with 23 variables. I am not quite sure how the programming works on it, but I am willing to learn. The reason why I wanted the 17BII, the programming functions that comes with it and its solver function. Advanced features of the 17BII (similar to same features in the 19B/19BII and 27S) are described in detail in the manual "HP27S/19B Technical Applications" which is included as a part of the MoHPC Document set, which can be purchased here: http://www.hpmuseum.org/cd/cddesc.htm. This manual includes detailed documentation on the Solver's Let and Get functions with many examples. The Document set is not expensive and easily worth the low cost, as it includes hundreds of HP manuals and documents, including the 17BII manual too. Bob Prosperi 

12222016, 10:21 PM
Post: #5




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 05:46 AM)AraragiMonogatari Wrote: I was able to pick up my HP 17BII from eBay. Now I am trying to learn how to use it. I've pretty much got the hang of how to use it but now I am experimenting on how to properly do Multiple Linear Regression with 23 variables. I am not quite sure how the programming works on it, but I am willing to learn. The reason why I wanted the 17BII, the programming functions that comes with it and its solver function. Note sure you can do multiple regression (Z =a + b*X + c*Y) with this calculator. 

12222016, 10:24 PM
Post: #6




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 09:38 AM)AraragiMonogatari Wrote:(12222016 08:38 AM)Csaba Tizedes Wrote: Hi,Browsing through the old forum, I've heard of this mythical "Let and Get" function that the 17B can do. Use the 17Bii+ manual. This will be help how can you use the statistics on your calc. The two calculator is very similar and the menu structure is same. Link: http://www.hp.com/ctg/Manual/c00363348.pdf You can calculate R^2 of course. Can you post here the multiple regression function what you want to use?! Csaba 

12232016, 10:24 AM
Post: #7




RE: How to Multiple Regression Forecast Using HP 17BII?  
12232016, 01:02 PM
Post: #8




RE: How to Multiple Regression Forecast Using HP 17BII?
(12222016 10:24 PM)Csaba Tizedes Wrote: You can calculate R^2 of course. Yhat, SD, tvalue, Rsquared, VIF, and the basic Multiple Regression Formula, if possible? And to get the summation of each variable comparison is helpful. Like the one found in the simple linear regression. 

12232016, 02:04 PM
Post: #9




RE: How to Multiple Regression Forecast Using HP 17BII?
The HP17BII manual mentions ONLY linear regression. You need other machines or software like Excel to do multiple linear(ized) regression.
There is a trick to transform multiple regression to linear regression: y = a + b*x + c*z y  a = b*x + c*z (y  a) / z = c + b *(x/z) You assume a, calculate values for Y=(ya)/z and X=(x/z), and then do a linear regression between Y and X. You repeat this process by varying the value of "a" until you maximize Rsquare. Namir 

12232016, 02:30 PM
Post: #10




RE: How to Multiple Regression Forecast Using HP 17BII?
You need three lists: One for X1, one for X2 and one for Y values.
Than you can make SOLVE equations for summations and for b1, b2 and a. If you have these (b1, b2, a) coefficients, you can calculate predicted Y values. And you can calculate other properties of coefficients (standard deviation, etc...) Study the SOLVE in the 17BII+ manual and you can see this is really easy to do. Csaba 

12232016, 05:16 PM
Post: #11




RE: How to Multiple Regression Forecast Using HP 17BII?
(12232016 02:04 PM)Namir Wrote: The HP17BII manual mentions ONLY linear regression.Speaking of linear regression, there is a page for the 17BII+ on HP's website that deals with the topic. Furthermore, while the solver in the HP17BII is powerful, calculation speed is not fast  particularly with complex solver equations. Your patience will be rewarded. Alan 

12252016, 11:55 PM
Post: #12




RE: How to Multiple Regression Forecast Using HP 17BII?
If anyone has succeeded to implement multiple linear regression involving two independent variables using the HP17BII, I like to hear the details from you!
Namir 

« Next Oldest  Next Newest »

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