Assessment Criteria / Marks Awarded / Marks Available
1 / Sampling of Data / 10
2 / Tabulation of data to include frequency distributions / 10
3 / Statistical calculations with spreadsheet details, showing cell references. / 15
4 / Graphical representation of data to show a variety of methods / 15
5 / Test a statistical hypothesis using a t-test. / 15
6 / Investigation of relationships using a scatter graph, correlation and regression / 15
7 / Written account to summarise the findings, to include an interpretation of the statistical measures and graphs / 10
8 / Presentation and quality of English, to include contents and introduction / 10
Additional Comments from Second marker or External Examiner (if required) :

DATA

Available separately:

  1. An Excel spreadsheet containing a database of 310 employees from two departments in two branches of a companywhich includes variables measuring the results of a series of survey questions on a scale from 1 (low satisfaction) to 10 (high satisfaction).
  1. An Excel spreadsheet which will generate an individual set of Random Number Tables.

Note: All tasks are to be completed and clearly labelled under the following headings.

TASK 1

Generate a set of random number tables from the Excel spreadsheet provided, so that each student has a different set of random number tables.

Highlight and copy the numbers generated in the spreadsheet, and use Paste Valuesfrom the Paste menu in Excel to copy them into a new spreadsheet. Save.

This will ensure that you have a fixed set of numbers to use in your assignment.

Use the saved random number tables to randomly select a sample of 30 employees from the 310 records. Use the data in this sample of 30 employees for Tasks 2 to 5.

TASK 2

Using the columns of data in your sample, select suitable variables and demonstrate the following statistical applications to analyse the data:

  • tables showing frequency distributions,
  • calculations with their associated formulae showing cell references, row andcolumn headings,
  • graphical representation of the data using a minimum of three graphs eg. Bar chart, histogram and cumulative frequency curve.

TASK 3

Use suitable data to test a statistical hypothesis using a t-test. Comment on the reliability.

TASK 4

Using suitable data investigate the relationship between two variables using a scatter graph with appropriate correlation and regression calculations.

TASK 5

Summarise your findings in a written account.

GUIDANCE

  • A contents page and a short introduction should be included in the assignment.
  • Students are advised to explain the analytical methods within each task.
  • All calculations and graphs should be produced on Excel and pasted into a Word document.
  • To improve the presentation of the assignment, copy spreadsheet work from Excel into Word usingCopy, Paste Special and then select Picture.
  • Copy and paste the set of random numbers table used for the sample of 30 employees into the appendix of the assignment.

1