Choosing which columns of a table to graph The series tab in Step 2 of the Chart Wizard provides a convenient way to specify exactly which data you wish to graph. For example, if you highlight all of a table including frequencies and percentage frequencies, and use XY scatter, Excel will graph frequency polygons and percentage frequency polygons all on the same axes. You can use the series tab to remove the frequency polygons.

Textbox In order to insert a textbox, first make sure the Insert Toolbar/Ribbon is showing and then click on the textbox icon, la, click in one corner of where you want the textbox, and drag to the required size. Percentage frequency polygons When creating the polygons, remember to introduce fictitious empty classes at both ends in the table (rows have been arranged so there is room) so that each polygon touches the X axis at both ends. Use Excel's "Scatter graph" option (including connecting lines) to create the polygons. Due to axis-labelling issues, it is inappropriate to use Excel's Line Graph Chart type to produce frequency polygons.

Some extra Excel information is given below. Sorting Data When sorting a number of columns of data by one variable, remember to highlight the whole block of data (all required rows and columns) first. If you just highlight the column for the variable you are sorting by, then the values of this variable will be separated from the cases to which they belong. Paste special When copying and pasting a table, for example into a different worksheet, it is frequently necessary to use the option

While the presentation of the assignment is important, and some marks are designated for presentation, elaborate features are not required. Your work must be easy to read. The quality of the presentation should be worthy of submission to your employer or project manager. Presentation and readability: 10 marks (If your presentation is easy to read, you will get these 10 marks. Ease of reading is assisted by appropriate font size, borders, colour choice and labelling in graphs, and some care in spelling, grammar and punctuation. ) Excel tips Sections 7 and 8 of the Key Information Documents provide technical information about Excel that you may need in completing this assignment.

This assignment is to be submitted using the Moodie assignment submission system. Copy and paste the relevant Excel tables, graphs and comments into a Word document, which should consist of the answers to the 10 questions, numbered and in order. Ensure that all graphs and tables used are well labelled, including titles. The assignment is to be handed in as an electronic copy of the completed Word document or as a pdf document. Do not submit the Excel file in which you completed your working. Be sure to include your name and student ID on the assignment.

The file is arranged so that all the required results needed for the assignment can be obtained from the worksheet labelled Results. The appropriate places for graphs and tables are set out in this worksheet but you need to create your own textboxes. It is recommended that you first create the graphs and tables in the data worksheets, and then copy them to the appropriate places in the Results worksheet. In fact on some computers it is essential that you work in this way, as some networked computers have difficulty dealing with data analysis tools when data is selected from a different worksheet.

Descriptive statistics Due date: Midnight, Monday of Week 5 or as specified by your lecturer. This assignment is marked out of 100 and is worth 10% of the assessment in this unit. You must use Excel to generate the relevant output. The data for this assignment is in the file BUGEN1502_A1_S216.xls. which can be found in the Assessments block in Moodle. The file has two worksheets, labelled Data, and Results.