Statistical Functions in Excel

Macros are Excel s version of functiOTis, or user-written code, that Excel can execute. The programming language used by Excel is called Visual Basic (VB). 

In Excel 2003, code can be inserted by going to Tools Macro Visual Basic Editor (Alt + Fll). In Excel 2007 or newer, code can be inserted by going to the View Ribbon and selecting the Macro icon and then View Macro. For both versions of Excel, in the window that appears, enter the name of the function that you desire to create (or edit) and press Create (Edit). If a new function is being created then, in the new window that opens, replace Sub with Public Function. This will allow the new code to be directly accessed from the spreadsheet by typing = FunctionName(Required Parameters). Below, some sample code has been provided that implements the Michaelis-Menten equation. 

Public Function MichaelisMenten (Concentration, vmax, KM) As Double 

Macros may contain viuses. It is usualy safe to disable macros, but iF Ihe macros are legitanale, you fright lose same functianaltv. 

---

These are examples of useful statistics functions in Excel, they are not by any means the only ones. 

Table 8.2 lists some common statistical functions in Excel. Most of these functions as written only work on newer versions of Excel (2010 or newer). A detailed explanation of the functions and differences can be found in Sect. 2.4 Common Statistical Distributions. 

---