 |
Statistics Tutorials
for
Statistical
Data Analysis:
SAS, SPSS, WINKS, Excel
For more professional statistical results:
WINKS Statistical Software
Affordable. Reliable. Relevant.
Analyze with WINKS.
www.texasoft.com
These tutorials briefly explain the use and interpretation of standard statistical analysis techniques. The examples include how-to instructions for Excel. Although there are different version of Excel in use, these should work about the same for most recent versions. They also assume that you have installed the Excel Analysis Pak which is free and comes with Excel (Go to Tools, Addins... if it is not already installed in your version of Excel.)
Installing the Analysis ToolPak
in Excel
-
For Excel 2007
- Click the Microsoft Office Button
, and then click Excel Options. - Click Add-Ins, and then in the Manage box, select Excel Add-ins.
- Click Go.
- In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
- NOTE: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
- If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
- After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.
- WINKS Software-- a simple, inexpensive alternative to Excel -- easy to use, reads Excel file, and provides much more explanation for results -- to use and affordable statistical software program that will help you analyze, interpret and write-up your results. Download a free trial copy. WINKS reads Excel files, so you can read your Excel data into WINKS and do many more types of analysis than in Excel alone.
- SAS Essentials: Mastering SAS for Research
- provides an introduction to SAS statistical software, the premiere statistical data analysis tool for scientific research. Through its straightforward approach, the text presents SAS with step-by-step examples. SAS Essentials introduces a step-by-step approach to mastering SAS software for statistical data analysis. It's also a valuable reference tool for any researcher currently using SAS. Designed for those new to SAS and filled with illustrative examples, the book shows how to read, write and import data; prepare data for analysis; use SAS procedures; evaluate quantitative data; analyze counts and crosstabulation tables; and compare means using the t-test. The book also provides instruction and examples on analysis of variance, correlation and regression, nonparametric analysis, logistic regression, creating graphs, controlling outputs using ODS, as well as advanced topics in SAS programming.ISBN: 0470461292. Order from publisher -Jossey-Bass/Wiley. Barnes & Noble. Amazon.
- Against All Odds VIDEOS - Now in DVD format -- Teaching Videos from Annenberg/PBS --"This highly engaging primer on statistical methods and inference introduces the practical applications of statistics. Produced by the Consortium for Mathematics and Its Applications and Chedd-Angier." Click here for info
- BeSmartNotes Reference sheets for SAS, SAS ODS, SPSS and WINKS - Click here for info.
- Statistical Analysis Quick Reference Guidebook: With SPSS Examples is a practical "cut to the chase" handbook that quickly explains the when, where, and how of statistical data analysis as it is used for real-world decision-making in a wide variety of disciplines. It contains examples using SPSS Statistics software. In this one-stop reference, the authors provide succinct guidelines for performing an analysis, avoiding pitfalls, interpreting results, and reporting outcomes. Paperback. Sage Publishers ISBN: 1412925606 Order book from Amazon
NOTES:
End of tutorial
See http://www.stattutorials.com/EXCEL
For Excel data files click here
For more information... we recommend:
| Send comments | Back to Tutorial Menu | TexaSoft |