Your Status: Logged out Log in

Using a Spreadsheet to Analyse Statistics  

Member rating: 5 out of 10 stars (2 votes) | Words: | Submitted: Thu Jul 11 2002

Page Preview
Preview
Previous 1 of 11 Next

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...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 147,187 others
Register Now
OR

Receive email updates for this category



  • Simply tell us your email address and receive a weekly Study Help Email for FREE
  • Receive 3 FREE essay views with each email
  • Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk