Reading the data into SPSS
1 Start SPSS.
3 Change the
Files of type
4 Select your (rearranged) Excel file and click
5 Check that the box labelled
Read variable names from the first row of data
Statistical Computing with Excel
Table of Contents
Starting Microsoft Excel .1
Formatting a Worksheet.2
Working with Data.4
Formatting Data in a Worksheet .5
Working with Formulas .7
Checking Your Worksheet for Spellin
MIT 201: S TATISTICAL C OMPUTING
Statistical Computing 1
February 6, 2015
C OURSE O UTLINE
This course uses a spreadsheet (Excel), and also a simple statistics package.
The roles of a spreadsheet and a statistics package for statistical applications are
MIT 201: Statistical Computing 1
Assignment 1: Ms Excel Awareness
1. With which symbol does all formulas starts in Excel?
2. How is an active cell indicated in Excel?
3. How can one view a cell comment?
4. How does a cell accepts your typing as its conten