2985277-Statistics-using-Excel

2985277-Statistics-using-Excel - Statistics using Excel...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Statistics using Excel Tsagris Michael BSc in Statistics Emai: mtsagris@yahoo.gr
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Statistics Using Excel Tsagris Michael 2
Background image of page 2
Statistics Using Excel Tsagris Michael Contents 1.1 Introduction. ........................................................................................................... 4 2.1 Data Analysis. ......................................................................................................... 5 2.2 Descriptive Statistics. ............................................................................................. 6 2.3 Z-test for two samples. ........................................................................................... 8 2.4 t-test for two samples assuming unequal variances. ........................................... 9 2.5 t-test for two samples assuming equal variances . ............................................. 10 2.6 F-test for the equality of variances. .................................................................... 11 2.7 Paired t-test for two samples. .............................................................................. 12 2.8 Ranks, Percentiles, Sampling, Random Numbers Generation. ....................... 13 2.9 Covariance, Correlation, Linear Regression. .................................................... 15 2.10 One-way Analysis of Variance. ......................................................................... 18 2.11 Two-way Analysis of Variance with replication . ............................................ 19 2.12 Two-way Analysis of Variance without replication. ....................................... 21 3.1 Statistical Functions. ............................................................................................ 23 3.2 Spearman’s (non-parametric) correlation coefficient. ..................................... 27 3.3 Wilcoxon Signed Rank Test for a Median. ........................................................ 28 3.4 Wilcoxon Signed Rank Test with Paired Data. ................................................. 29 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Statistics Using Excel Tsagris Michael 1.1 Introduction One of the reasons for which these notes were written was to help students and not only to perform some statistical analyses without having to use statistical software such as Splus, SPSS, and Minitab e.t.c. It is reasonable not to expect that excel offers much of the options for analyses offered by statistical packages but it is in a good level nonetheless. The areas covered by these notes are: descriptive statistics , z-test for two samples , t-test for two samples assuming (un)equal variances , paired t- test for two samples , F-test for the equality of variances of two samples , ranks and percentiles , sampling ( random and periodic, or systematic ), random numbers generation , Pearson’s correlation coefficient , covariance , linear regression , one-way ANOA , two-way ANOVA with and without replication and the moving average . We will also demonstrate the use of non-parametric statistics in Excel for some of the previously mentioned techniques. Furthermore, informal comparisons with the results provided by the Excel and the ones provided by SPSS and some other packages will be carried out to see for any discrepancies between Excel and SPSS. One thing that is worthy to mention before somebody goes through these notes is that they do not contain the theory underlying the techniques used. These notes show how to cope with statistics using Excel. 4
Background image of page 4
Statistics Using Excel Tsagris Michael 2.1 Data Analysis If the Excel does not offer you options for statistical analyses you can add this option very easily. Just click on the Add-Ins option in the list of Tools . In the dialog box (picture 2) appeared on the screen select the Analysis ToolPack . Excel will “run” this command for a couple of seconds and if select Tools you will see the option Data Analysis added on the list. Picture 1 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Statistics Using Excel Tsagris Michael Picture 2 2.2 Descriptive Statistics The data used in most of the examples are taken from the SPSS file and refer to car measurements ( cars.sav ). We just copied and pasted the data in a worksheet of Excel . The road is always the same and mentioned already, tha is, by clicking Data Analysis
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course STATISTICS 301 taught by Professor Junaid during the Spring '12 term at University of Karachi.

Page1 / 30

2985277-Statistics-using-Excel - Statistics using Excel...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online