Use the “Descriptive Statistics” Microsoft Excel feature on the data for 0.3 ppm and 0.4 ppm and see if you can reproduce something similar to the two tables below. You may also adjust the number of decimal places using Right Click > Format Cells. Where s = sample standard deviation and x̄ = sample mean. However, given that “Descriptive Statistics” calculates the sample mean and the sample standard deviation, you may easily calculate the Cv / %RSD on Excel. The Coefficient of Variation (Cv) / %Relative Standard Deviation (%RSD) is not calculated by “Descriptive Statistics”. ![]() You may change this to 90% or 99% if you wish by simply deleting “95” and replacing it with the desired value.Ĭlick OK to generate the table below for the 0.2 ppm data which should look like the image shown below. Select any empty cell (Cell B9 in this example) and press the button highlighted below to return to the “Descriptive Statistics” window.Ĭonfidence Level for Mean is set to 95% by default. ![]() Under “Output options”, select the circle next to “Output Range” and then click the button highlighted below. the label).Ĭlick the square below the “X” button to return to the full “Descriptive Statistics” window. With the “Descriptive Statistics” window opened, click the small box next to “Labels in First Row”.Ĭlick the small square to the left of “OK” and select the data points for 0.2 ppm (include the first row, ie. Select “Descriptive Statistics” and click “OK” to open the “Descriptive Statistics” window. Select the “Data” tab and click “Data Analysis”. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |