Using a Spreadsheet to Analyse Statistics
Member rating:
(2 votes)
| Words:
| Submitted: Thu Jul 11 2002
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Using a Spreadsheet to Analyse Statistics In this tutorial, you will enter data about the number of goals scored by various football teams and you will carry out statistical analysis on the data. 1. Entering the Data 1. Enter the data as shown below. 2. Some of the columns will not be wide enough. To remedy this, re-size the columns or double-click on the intersection between the column headings. See below: Double-click here 3. Highlight the names of the teams and click the Bold button on the Excel toolbar. 2. Using the Format Painter 1. Make the heading "Football Club" blue, bold and change the font to Brush Script (or another font of your choice). Make the font slightly bigger. 2. Make sure cell B2 is still selected and double-click the Format Painter button Format Painter Button 3. Then click once on cells C2 and E2, which also contain column headings. Adjust the width of the...


