NORMDIST function

-

Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
Important This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.
For more information about the new function, see NORM.DIST function.
Syntax
NORMDIST(x,mean,standard_dev,cumulative)
The NORMDIST function syntax has the following arguments:
X Required. The value for which you want the distribution.
Mean Required. The arithmetic mean of the distribution.
Standard_dev Required. The standard deviation of the distribution.
Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Popular posts from this blog

Data analytics services market in India to triple by 2015

-
The data analytics services market in India is set to grow three times and is expected to touch $1.15 billion in 2015, an over 67 per cent increase from $375 million in 2010, according to a report on analytics outsourcing by Avendus Capital, a leading financial services firm. India alone accounted for over 70 per cent of the total global data analytics outsourcing market ($500-550 million) in 2010. Analytics outsourcing helps companies get their analytics needs met without having to take on the responsibility of another new process. And for those who don’t already know what data analytics is, it is the science of examining raw data for the purpose of drawing business-related conclusions about the information, and for modelling and predicting business outcomes. According to the report, over the last decade, India has matured as the preferred outsourcing destination for IT and ITeS services, due to a number of factors that include increase in data generation, cost savings, operation
Read more

Text Analytics Platforms Part 1

-
Text analytics is still largely an immature science, and embraces several different approaches. Natural language processing (NLP) includes dozens of techniques for accomplishing tasks such as language translation, document categorization and tagging, extraction of meaningful terms and so on. Text mining on the other hand is primarily concerned with the extraction of meaningful metrics from unstructured text data so they can be fed into data mining algorithms for pattern discovery. Some suppliers have applied text analytics to very specific business problems, usually centering on customer data and sentiment analysis. This is an evolving field and the next few years should see significant progress. Other suppliers provide NLP based technologies so that documents can be categorized and meaning extracted from them. Text mining platforms are a more recent phenomenon and provide a mechanism to discover patterns which might be used in operational activities. Text is used to generate extra
Read more

Web Analytics Market Update, 2012

-
Image
 SUMMARY Four vendors command the bulk of the Web analytics market, but others continue to innovate. This document describes the market's dynamics and profiles the leaders. Overview Demand for Web analytics tools continues to expand, even as the number of top-tier global vendors has shrunk to four. This update explains the market dynamics and provides an overview of the leading vendors. Key Findings For large or Web-channel-centric organizations, Adobe, Google, IBM and Webtrends represent the top tier of global vendors to evaluate. The Web analytics market has expanded to include additional digital channel optimization products. New vendors are emerging with specialized offerings, but they have not yet achieved significant market share. Recommendations Find out the requirements of marketing, content development, Web operations and customer support teams before evaluating analytics vendors. Set a budget for tools and customization services that is in line w
Read more