Using a Spreadsheet to Analyse Statistics

Authors Avatar

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 columns again, as necessary.  

4. Deselect the Format Painter button.

The Format Painter is also available in other Microsoft Office applications, such as Word, Publisher and Access.

3. Sorting the Data

You notice that the teams are not listed in alphabetical order and you decide that you want to put this right.

Join now!

1. You must first select columns B and C

It is very important that you do this. If you just sort the list of team names, the teams will be rearranged but the goals scored won’t.  That would make your data incorrect.

2. From the Data menu, select Sort.

3. Sort by Column B (the teams list) and do an Ascending sort (A-Z)

The teams should now be listed in alphabetical order and the number of goals scored for each team should be correct.

4. The MAX and MIN Functions

...

This is a preview of the whole essay