Statistics: Data Analysis and Presentation. Fr Clinic II. Overview. Tables and Graphs Populations and Samples Mean, Median, and Standard Deviation Standard Error & 95% Confidence Interval (CI) Error Bars Comparing Means of Two Data Sets Linear Regression (LR). Warning.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Fr Clinic II
Table 1: Average Turbidity and Color of Water Treated by Portable Water Filters
4 5 12
Consistent Format, Title, Units, Big Fonts
Differentiate Headings, Number Columns
Mean = Sum of values divided by number of samples
= 5.2 NTU
Median = The middle number
Rank - 1 2 3 4 5 6
Number - 1 3 3 6 8 10
For even number of sample points, average middle two
= (3+6)/2 = 4.5
Excel: Mean – AVERAGE; Median - MEDIAN
n = number of data points
Excel: variance – VAR
1.96Standard Deviation, s
Excel: standard deviation – STDEV
Standard Deviations from Mean
Create Bar Chart of Name vs Mean. Right click on data. Select “Format Data Series”.
Right-click on data point and use “trendline” option. Use “options” tab to get equation and R2.
ŷi = Predicted y values, from regression equation
yi = Observed y values
R2 = fraction of variance explained by regression (variance = standard deviation squared)
= 1 if data lies along a straight line