Microsoft office Excel 2007 is one of the most user friendly and popular spreadsheet program to work on. It is sub set of Microsoft Office which is developed for MAC Operating System X and Microsoft Windows like XP, Vista and 7. It aids the user by providing ample services like graphing tolls, featured calculations, programming language like VB (Visual Basic for applications) and an outstanding pivot table. Since 1993, 5 platforms of Microsoft office were released like Microsoft office 2003, Microsoft office 2007 and Office 2010. In this excerpt in lime light will be the MS Excel 2007 and its certain usage.
Economics and Business related firms make use of “Descriptive statistics”, which stands for methods used to summarize, organise and present data in a manner that is informative. Well, you may reckon, how can MS Excel 2007 aid you with this? The answer to your dilemma is these “Descriptive Statistics” can be generated and also computed using your MS Excel 2007. But, to allow your MS Excel 2007 to withstand the service you need to download and install the “Data Analysis ToolPak or an add-in”. This will allow the user to cover a dozen of areas. It helps to generate the statistical conclusion like mean, mode, median, standard variance, standard deviation, range, maximum, minimum, skew ness, kurtosis, standard error, data count and sum. Such type of result by your machine helps to reduce your efforts towards mathematical or analytical calculations and thus, aid you by making your “Descriptive Statistics” more informative and precise.
How can you tackle with and make your Descriptive Statistics with MS Excel 2007? Well, you can do so, by simply following the below mentioned steps.
Before proceeding further you need to Install the Data Analysis Toolpak on your system and then enable it from the “Add-ins” which can be found in the “Excel Add-ins”.
The Data Analysis ToolPak will be used later to interpret and arrange the data. But, before that you need to collect all the data which you desire to analyse.
Under the MS office bar which you can find under the “All Programs” category, you can find the MS Excel 2007. Click on “MS Excel 2007” to open a new spreadsheet in order to proceed further.
Now you are required to put the data values in the cells which must match and remain below the label mentioned by you for the data values you are entering. For example, a banker longing to analyse the currency rate under global rate.
Once you have hit the data values in the cells, save them by clicking on “File” tab and then on “Save” tab. A dialogue box prompted will ask you to enter the file name and then click on the save tab.
Click on the “Tools” tab and then on “Data Analysis” tab, which can be found under the “Data” tab and click on “OK” to confirm.
Click on the “Descriptive Statistics” tab and click on “Ok” to confirm. Perform whatever operation you long to do. Choose the output cell where you want the result to be displayed and put it in the output range box. Finally, click on the “Summary Statistics” and click on “OK” to confirm.