Statistics for Data Analysis Using Microsoft Excel

Today business research is based on the manipulation of large amounts of data from the Internet, company sources, public sources, and others. Business analytics must extract useful information from a big data set and to make a decision. Whether you are analyzing a client's data or company's data to make decisions, your tools have to be able to handle the tasks you perform with that information. The goal of this paper is to illustrate the use of Excel's Analysis ToolPak for developing complex statistical analysis. MS Excel is widespread, user-friendly, easy to learn, and powerful. Therefore, the purpose of this paper is to show how free Analysis ToolPak add-in works and what it can do. In one hand Analysis ToolPak is powerful, but in the other hand it has some weaknesses that we should be aware of.