How Do You Do Descriptive Statistics In MS Excel 2007?
“Statistical Techniques in Business and Economics” describes descriptive statistics as methods used to organize, summarize and present data in an informative way. These statistics can be computed and generated using Excel 2007 as long as you have installed the Data Analysis ToolPak or add-in. The software generates statistical conclusions, such as the mean, median, mode, standard deviation, standard error, kurtosis, sample variance, skewness, range, minimum, maximum, sum and data count. The results can help you make more informed decisions. Install the Microsoft Office Analysis ToolPak. Click the “Microsoft Office Button” and then “Excel Options.” Click “Add-ins” and then “Excel Add-ins” located in the Manage box. Click “Go.” Select “Analysis ToolPak” in the Add-ins Available box and click “OK.” If you do not see the Analysis ToolPak option, click “Browse” to locate it. Click “Yes” to install it if a prompt signifies that it is not installed on your computer. Collect the data you would
