Essay on EXCEL Statistical Functions

Submitted By EvanLi
Words: 651
Pages: 3
Open Document
Handy EXCEL statistical functions
All EXCEL functions begin with an equal sign and all EXCEL descriptive statistical functions have at least one range of cells as its argument.
Example: Numerical data is in cells C3:C209. This is the cell range.
=average(C3:C209) will compute the average of all the numbers in C3:C209.
The cell range in this example is C3:C209. The colon is used to denote the cell range.
Univariate descriptive
=average( cell range )
=geomean( cell range)
=median( cell range )
=stdev( cell range )
=count( cell range )
=quartile( cell range, q)
=percentile( cell range, p)
=max( cell range)
=min(cell range)

computes the arithmetic mean computes the geometric mean -antilog of log data mean computes the median computes the standard deviation computes the sample size (n) computes 1st, 2nd, 3rd or 4th quartile (q=1,2,3 or 4). will not work for q > 4.
Gives the 100pth percentile for the data in cell range
0 <= p <= 1 gives the maximum in the cell range gives the minimum in the cell range

Bivariate descriptive
=correl( y cell range, x cell range) computes the Pearson correlation (r) between y & x
=slope( y cell range, x cell range) computes the slope (b) for y = a + b X
=intercept( y cell range, x cell range) computes the intercept (a) for y = a + b X
Gaussian
=normsdist(cell)

=normsinv(cell)

gives the percentile (as a decimal) for a Z score. cell=Z score
Ex: normsdist(1.96)= 0.975. gives the Z score for a percentile. Cell=percentile (as a decimal)
Ex: normsinv(0.975) = 1.96

=normdist(y, mean, SD, cumulative indicator) If cumulative indicator equals 1, gives the percentile (as a decimal) for y where y has a Gaussian distribution with mean and SD. If cumulative indicator equals 0, gives the Gaussian density for y, f(y).
EXCEL mathematics functions
=log10( cell) computes the base 10 log value of cell
=ln(cell)
computes the base e log value of cell
=exp(cell)
computes the antilog (base e) of cell ( ecell )
=10^cell
computes the antilog (base 10) of cell (10cell)
= sqrt(cell) computes the square root of cell
There are many other functions in EXCEL – this is only a small sample.

*functions that produce p values
=TDIST( t, df, 2) – two sided p value for t statistic where df is the degrees of freedom
=CHIDIST( χ2, df ) Chi-Square Distribution, where χ2 is the chi square value and df is the degrees of freedom.
=CHITEST (observed freq range, expected freq range) returns p-value for testing observed versus expected frequencies. Does NOT compute expected frequencies
=FDIST(F, numerator df , denominator df ) - Gives p
Show More

Related Documents: Essay on EXCEL Statistical Functions

Essay about Excel Notes

Excel Notes 12/13/12 Each worksheet in a workbook has 16,384 columns and 1,048,576 rows for a total 17,179,869,180 cells. If you prefer using the keyboard instead of the mouse, you can press the ALT key on the keyboard to display a Key Tip badge, or keyboard icon, for certain commands. Entering text in a cell means left-aligned. In Excel, you can enter numbers into cells to represent amounts. A number can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e If a…

Words 1080 - Pages 5

P2: Making Decisions And Looking Up. Values

JWBT166-Sengupta August 4, 2009 10:20 Malloy CHAPTER 5 Making Decisions and Looking Up Values ne reason Excel is so useful is that it can do an enormous number of complex calculations accurately and fast. But if it could do only straightforward calculations, then it would not be half as useful as it is. A significant part of its usefulness or power comes from the fact that in Excel you can write formulas to make various kinds of decisions equally quickly and accurately. What do we mean by…

Words 2436 - Pages 10

Essay on Presentation: Percentile and Word Document

significance (in your word document) Now open an excel work book. Enter the data on output of the 20 employees in the Excel workbook you have just opened. It will appear as shown below: Type the words Mean, Median, and Mode in the cells immediately below the last cell containing the data. Click on the formulas ribbon either go to more functions, and then statistical to find the Mean, Mode and Median or enter in the formula bar each function and the range of data to find the relevant average…

Words 1240 - Pages 5

Laparoscopic Cholecystectomy Essay

preoperatively. Statistical Analysis The data will be entered into Microsoft excel® sheet. Data will be summarized using frequency distribution and descriptive analyses. Chi square test will be used to find the association of categorical variables and Fischer exact test will be used when frequency of a cell will be <5. T-test or Mann-Whitney test will be used to find the significance difference of continuous variables. The P value <0.05 will be considered significant. All statistical analyses 14 will…

Words 1623 - Pages 7

6073 ASSIGNMENT 2 Essay

the relationship among values that are assigned to the attributes for a variable. There are four levels of measurement. Knowing the different levels of measurement helps to decide how to interpret the data from variables as well as deciding the statistical analysis that is appropriate on the values that are assigned. These four levels are nominal, ordinal interval, and ration. The lowest level is nominal and the highest is ratio. The most basic level of measurement is the nominal level. In nominal…

Words 840 - Pages 4

It Consultation for Mr. Green Essay

performance with direct access and kernel improved to support the systems with multiple heterogeneous graphic cards for better performance (Brenner, 2010). It is designed with a calculator which has multiple functions that can enable Mr. Green to be more accurate in the accounting functions of the business. The Windows 7 blog has the tracing tools that can be used to ensure the performance in many areas on the operating system and help to locate inefficient code path and control performance regressions…

Words 799 - Pages 4

Continuous Probability Notes Essay

Chapter 6: Continuous Probability Distributions Study Modules (PPT presentations): Introduction to Continuous Probability Distributions Normal Probability Distribution Discrete Distributions Excel Tutorial: Computing Normal Probabilities Java Applet: Normal Distribution Areas Normal Approximation to Binomial Probabilities Continuous Random Variables: A continuous random variable can assume ____any value_______________ in an interval on the real line or in a collection of intervals…

Words 778 - Pages 4

Essay on Quality Associates, Inc.

Quality Associates, Inc. Case Study Case Synopsis In this case, we have Quality Associates, Inc. a consulting firm advising its client about sampling and statistical procedures that can be used to control their manufacturing process. Their client has offered samples to be analyzed, so they can quickly learn whether the process is operating satisfactorily or corrective actions needs to be taken. The numbers given in the case were as follows: assumed population standard deviation is equal…

Words 984 - Pages 4

Essay on ts r intro

. . . . . . . . . . . . . . . . . . 4.5 Prediction of ARIMA–Models . . . . . . . . . . . . . . . 17 17 17 18 19 20 A Function Reference . . . . . . . . . . . . . . . . . . . . . . . . . 22 1 Chapter 1 Getting started 1.1 Downloading and Installing R R is a widely used environment for statistical analysis. The striking difference between R and most other statistical software is that it is free software and that it is maintained by scientists for scientists. Since its introduction in 1996…

Words 4462 - Pages 18

Introduction To STATA Essay

Introduction to STATA ECONOMICS 375 Brian Phelan Fall 2014 This handout provides a very brief introduction to STATA, a convenient and versatile econometrics package. In the past 20 years, STATA has become one of the leading statistical programs used by economic researchers. STATA was written by economists so it is more intuitive for researchers in our field. It is fast and relatively easy to use. STATA‟s speed advantage comes from the fact that all data is loaded into RAM. Subsequently, the amount…

Words 5756 - Pages 24