HP Forum Archive 14

[ Return to Index | Top of Index ]

stat pac for Excel Message #1 Posted by Jim Kimes on 7 June 2004, 11:19 a.m. I find the regression application for the HP 19B II really easy to use and helpful, enabling me to do forecasting for exponential, power and logarithmic curves as well as linear. It returns the formulas for these curves. Howver, I do find the process slow and cumbersome. I don't think the standard MS Excel offers what I'm talking about so I'm looking for a reasonably priced stat pac that will do this that works as an Excel Add-in. Has anybody had any experience with exactly what I'm talking about here? I've researched several packages on the I-net but none of them actually address the applications I need. It wouldn't necessarily have to be an Excel Add-in but I think it would be easier to work with. Thanks.

Re: stat pac for Excel Message #2 Posted by Chan Tran on 7 June 2004, 12:29 p.m., in response to message #1 by Jim Kimes Excel from version 5 and up has an addin for regression. However, I think it's only for linear. I guess you can write and addin or VBA program to do this in Excel. I think I will do just that...

Re: stat pac for Excel Message #3 Posted by Miki Mihajlovic on 7 June 2004, 12:42 p.m., in response to message #2 by Chan Tran As a matter of fact the Excel regression add-in has 5 standard types: Linear, Log, Polynomial, Power and Exponential. There is also the sixth type - moving average but that can't give you the equation. 1234

Re: stat pac for Excel Message #4 Posted by Jim Kimes on 7 June 2004, 7:48 p.m., in response to message #3 by Miki Mihajlovic If this is true, how do I access these other regression methods? I've loaded every applicable add-in I have and I still don't see these capabilities.

Re: stat pac for Excel Message #5 Posted by Miki Mihajlovic on 7 June 2004, 10:27 p.m., in response to message #4 by Jim Kimes Create a plot of your X vs Y. Right click on the points on the graph (so that they are selected) and choose Add Trendline. You should see six Trend/Regression types. I don't think that you actually need to activate any add-ins for this. 1234

Re: stat pac for Excel Message #6 Posted by Jim Kimes on 15 June 2004, 3:00 p.m., in response to message #3 by Miki Mihajlovic I have loaded every add-in available and I can access correlation and regression but I see nothing like you're talking about. I need more detail.

Re: stat pac for Excel Message #7 Posted by Jim Kimes on 7 June 2004, 7:46 p.m., in response to message #2 by Chan Tran I don't have VBA skills. Wish I did.

Re: stat pac for Excel Message #8 Posted by Namir on 7 June 2004, 10:55 p.m., in response to message #1 by Jim Kimes Excel allows you to perform linear and multiple lieaner regression using the Regression add-in. The Regression Wizard offers you a dialog box that has many options. The regression add-in offers the ANOVA table and confidence intervals for the regression coefficients. You can transform your dat aand create new columns that enter into linear or multiple regression. Excel also allows you to access statistical functions such as CORREL, SLOPE, INTERCEPT to calculate R, the slope, and the intercept. Other functions are also available to obatin the coefficients and statistics for multiple linear regression. Consult a good Excel book like the Excel (version) Bible or Excel (version) Inside Out ... or even check the Excel online help!

Re: stat pac for Excel Message #9 Posted by Jim Kims on 10 June 2004, 11:17 a.m., in response to message #8 by Namir I never found within Excel exactly what I was looking for so I took the equations for the four different types of regression, linear, exponential, power and logarithmic and built my own solver. I tested it using my HP-14 and it works fine. Not as slick as a macro but is OK. Thanks all.

[ Return to Index | Top of Index ]

Go back to the main exhibit hall