### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads by category
- Using Goal Seek on Multiple Cells
- Brent's Method; Update and Examples
- The angle between two vectors, Python version
- Frame Analysis with Excel - 3, Continuous beam or frame
- Fitting high order polynomials

### Recent Comments

More circle fitting… on Fitting 3D circles to scattere… dougaj4 on 3DFrame update Mounir Soufi on 3DFrame update dougaj4 on Concrete ULS spreadsheet … Michael Perlini on Concrete ULS spreadsheet … lori on Year 10 Report dougaj4 on Fitting 3D circles to scattere… dougaj4 on Numerical Integration; Tanh-Si… maurizio nardò on Numerical Integration; Tanh-Si… dougaj4 on Fitting 3D circles to scattere… Soren Hauch on Fitting 3D circles to scattere… Year 10 Report | New… on Fine as a Bee’s win… Year 10 Report | New… on Reynardine Year 10 Report | New… on George Gently, Matty Groves, a… Year 10 Report | New… on Reinforced Concrete – UL…

# Tag Archives: statistics

## xlwings – dataframes and statistics

Another data conversion option offered by the latest xlwings release is Pandas dataframes and dataseries. This post will look at how to pass an Excel range as a dataframe or dataseries in a User Defined Function (UDF), and some simple … Continue reading

Posted in Excel, Link to Python, Maths, Newton, Python Pandas, UDFs, VBA
Tagged dataframes, dataseries, Excel, Pandas, Python, statistics, UDF, VBA
1 Comment

## 1 Million Page Views

At some time in the next couple of hours or so the number of page views here will pass the 1 million mark, so congratulations in advance one millionth page viewer. I thought it would be interesting to see where … Continue reading

## Daily Download 13: The ALGLIB maths library and Excel

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, complex numbers, Cubic splines, Excel, Matrix Functions, statistics, UDF, VBA
7 Comments

## 2010 in review

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers The Louvre Museum has 8.5 million visitors per year. … Continue reading

## ALGLIB Statistics Functions

I have recently imported all the ALGLIB statistics functions into VBA, and written interface functions where required, so that all the functions may now be used as User Defined Functions (UDFs) on the spreadsheet. A spreadsheet including full open source code … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, math functions, statistics, UDF, VBA
4 Comments

## Chart Trend Lines and the Linest Function

At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading