Home > Excel Help Portal > Excel for Statisticians

# Excel for Statisticians

## The ExcelUser portal offers links to help pages created by top Excel web sites. This section discusses using statistics inMicrosoft Excel.

1. Excel Statistical Functions: Implications of Statistical Function Improvements for Analysis ToolPak This article describes the affect of numeric improvements in Microsoft Office Excel 2003 statistical functions on Analysis ToolPak (ATP) tools. Most ATP tools call Excel statistical functions in the process of calculating results. In many cases... KB#829208. Keywords: Analysis ToolPak, Statistics, Errors, Formulas, Error Message, Comments, CORREL, COVAR, RAND, CRITBINOM, NORMINV, VLOOKUP, GAMMAINV, LINEST

2.
3. Excel Statistical Functions: BINOMDIST This article describes the BINOMDIST function in Microsoft Office Excel 2003, illustrates how to use the function, and compares the results of the function for Excel 2003 with its results for earlier versions of... KB#827459. Keywords: Ratio, Statistics, Format, Formulas, BINOMDIST, COMBIN, SQRT

4.
5. Excel Statistical Functions: POISSON This article describes the POISSON function in Microsoft Excel, illustrates how to use the function, and compares the results of the function for Excel 2003 with the results of POISSON when it is used in earlier versions of... KB#828130. Keywords: Ratio, Statistics, Format, Errors, Formulas, EXP, NEGBINOMDIST, SQRT, FACT

6.
7. Excel FAQ - Functions and Formats =ROUND(A1/5,0)*5 =ROUND(A1/0.25,0)*0.25 =VLOOKUP(A2,Sheet2!A2:B100,2,FALSE) =SUM(LARGE(A:A,{1,2,3,4,5})) Enter the items down A1:A100. In B1:B100 enter formula =RAND(). Sort the list by B column; top 20 rows is your selection. Press F9 for new B numbers and repeat for a new selection. If the cells... Keywords: Add-In, Analysis ToolPak, AutoFilter, Criteria, Sorting, Fonts, Format, Outline, Formulas, Links, VBA, Validation, ROUND, VLOOKUP, RAND, SUBTOTAL, CELL, MID, LINEST, INTERCEPT, LOGEST, FORECAST

8.
9. How to call Excel Functions from Within Microsoft Access 2000 This article shows you how to use Automation to call Microsoft Excel functions from within Microsoft Access. Microsoft Excel has some functions that Microsoft Access does not have, for example, statistical functions and add-in functions. By... KB#198571. Keywords: Add-In, Microsoft Access, VBA, Macro, Object, LCM

10.
11. How to Determine Top/Bottom Used Cells in a Sparse Array This article discusses how you can determine the beginning and end used rows of a range by using the IF, ISBLANK, MAX, MIN, and ROW functions. The results can provide information to other functions and can help you to determine variable ranges.... KB#142526. Keywords: Arrays, Errors, Formulas, ROW, MIN, MAX

12.
13. Excel Filters -- AutoFilter Tips AutoFilter Tips Some tips and techniques for working with AutoFilters, and some workarounds for problems you may encounter. Limits to Dropdown Lists Count of Filtered Records in Status Bar Filter for Text in a Long String AutoFilter Basics Limits to Dropdown Lists An AutoFilter dropdown list will... Keywords: AutoFilter, Criteria, Formulas, LEFT, SUBTOTAL, COUNT, COUNTA

14.
15. Testing your spreadsheets - tips on good design Spreadsheets may contain hidden errors. These can present a degree of risk whenever decision making is based upon your calculations. Follow these steps to reduce the risk of errors occurring. Errors are easier to detect if the spreadsheet is well designed. It is best to create three distinct and... Keywords: Months, Format, Errors, Formulas, Links, Macro, Files, AVERAGE

16.

18.
19. How to use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000 This article describes how to use the SUBTOTAL function with AutoFiltered lists in Microsoft Excel 2000. You can use the SUBTOTAL function to dynamically count or display other information about records in a list that has AutoFilter turned on.... KB#244789. Keywords: AutoFilter, Macro, SUBTOTAL, AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT

20.
21. How to Create a Dynamic Named Range on a Worksheet in Excel In Microsoft Excel, you may have a named range that must be extended to include new information. This article describes a method to create a dynamic defined name. Note The method in this article assumes that there are no more than 200 rows of... KB#830287. Keywords: Sales, Formulas, Defined Name, OFFSET, RAND, COUNT, COUNTA

22.
23. Index of Help for Excel functions, graphs and testing A function is a special key word which can be entered into a cell in order to perform a process to some data which is appended within brackets. = FunctionName(Data) The data (or argument in proper terminology) often includes a range of cells. Excel automatically recognises the names of these... Keywords: Years, Formulas, Links, Toolbar, AVERAGE, COUNT, COUNTA

24.
25. Count Text or Numeric Entries with COUNTA instead of COUNT Yes, Paul, this is frustrating. I will bet you are a recent Lotus 1-2-3 user. In Lotus, of course, @COUNT(A1:A100) would work, but alas in Excel, the COUNT() function only counts numeric entries. These small changes are one of the frustrating challenges in switching from Lotus to Excel. It would be... Keywords: VBA, Web, COUNT, COUNTA, VLOOKUP

26.
27. Counting Cells with specific content To count the number of numeric cells in a column, use =COUNT(A1:A99).To count the number of alpha or numeric cells in a column, use =COUNTA(A1:A99).You can combine functions in a formula: =SUM(A1:A99)/COUNTA(A1:A99) MrExcel.com provides examples of Visual Basic procedures for illustration only,... Keywords: VBA, Web, COUNT, COUNTA

28.
 Excel User's Home ExcelUser Blog Site Map Contact Excel for Business Excel Dashboards Excel Solutions Exploring Excel BI for Excel Business Tools Excel Catalog Affiliate Program Excel Help Portal

ExcelUser, Inc.
http://www.ExcelUser.com