#Descriptive statistical calculations how to#

Tabulate the data as shown below with the replicate measurements in vertical form. The measurements were obtained in replicate (n = 5). As an example, we will use the “Descriptive Statistics” feature on the data for 0.2 ppm.

#Descriptive statistical calculations how to#

How to Use the Descriptive Statistics FeatureĪlthough the example below shows fluorescence intensity (FI) data from a spectrofluorometry experiment, the descriptive statistics feature may be used for data obtained from other analytical techniques such as UV-Vis spectroscopy and HPLC. With the Add-ins window opened, click the small square next to “Analysis ToolPak” and click “Ok”.Īfter step 4, the “Data Analysis” button should now be available under the “Data” tab. Select “Excel Add-ins” on the drop-down menu next to “Manage” and then click “Go…” to open the “Add-Ins” window. With the “Excel Options” window opened, click “Add-Ins” With Microsoft Excel opened, go to the “Files” and click “Options” to open the “Excel Options” window. In order to access this feature, you may need to enable it first. “Data Analysis” is typically disabled on most computers. One may access this feature by clicking the “Data Analysis” button under the “Data” tab on Microsoft Excel 2010. The likes of the sample mean, sample standard deviation and confidence levels can be determined using this feature. The descriptive statistics feature on MS Excel is a useful tool for performing statistical analyses for sets of experimental data. First, we examine how you can enable this feature before moving on to understand how best you can use this useful feature Below, we outline how you can maximize your understanding of descriptive statistics as found in Excel. Though Microsoft Excel descriptive statistics is not limited to pharmaceutical calculations, it does play an important role for the pharmacy student who advances onto postgraduate study.