statistic assessment

Statistics_1PreExamTask.doc1.docx

Home >Mathematics homework help >statistic assessment

Section D: Data Visualisation

The following data set and questions are to be prepared prior to the exam. Process the information in EXCEL and then you can bring 2 A4 double sided pages from your EXCEL workbook into the exam.

This will be assessed as part of the Exam.

Question 9 : Using EXCEL

There are eight students who participate in tests for nine subjects. Each of the subjects has been marked from 0 to 100. The students’ performances in each subject that have been tested are shown in the following table:

Database	69	70	84	78	79	80	90	60
Java	64	74	58	83	55	72	67	59
C++	70	68	87	68	91	64	76	88
Physics	57	76	78	72	71	45	51	90
Mathematics	80	71	67	90	34	66	45	76
English	34	56	67	48	26	76	59	34
Chemistry	45	56	43	23	76	45	33	43
Networks	56	45	34	23	67	56	64	72
Security	96	30	56	46	75	54	34	45
Students	A	B	C	D	E	F	G	H

Examine the scores in the nine subjects taken by the eight students to a target audience. The target audience is of your choice: i.e. a lecturer, a student or their parents etc a. Frame the problem you are solving (this may require 1 or 2 questions) and nominate the target audience (1 mark) b. Interrogate your data in EXCEL. (2 marks) c. Produce 3 charts that best represent a data visualisation for your problem. (3 marks) (This is to be completed before exam and printed EXCEL spreadsheets brought into the exam)