Assessment Task Information
Assessment title:
Statistical Report
Module Name:
Advanced Statistics
Module Code:
PM608E
Tutor’s Name:
Assessment will be set in:
Cycle 3 Week 11
Assessment is due in:
Cycle 3 Week 15
Assessment weighting:
30%
Assessment Task Instructions:
Core Task:
You will have to produce a statistical report from a collection of given datasets.
You will have to work in Excel for many of the tasks, but you will then need to transfer data into a Microsoft Word document for your final report.
You will have approximately one month to complete the report and you will have to update your tutor with your progress on a weekly basis.
Structure:
Example: Three parts to be completed, as follows:
Part 1: You will have to demonstrate skills in finding the measures of location and spread and creating charts. You will also need to compare scores on different datasets.
Part 2: You will have to demonstrate skills in creating scatter graphs, finding correlation and regression coefficients, and interpreting these results.
Part 3 You will have to demonstrate skills in random sampling, constructing grouped frequency tables, graphing data sets, and calculating confidence intervals.
Theory and/or task resources required for the assessment:
Part 1 (30 marks): For the data given in Table 1 (below) on product sales:
• For the scores on “Mango Blue” find the minimum, maximum, range, lower quartile, median, upper quartile, interquartile range, mean, mode, and standard deviation. (5 marks)
• For the scores on “Papaya Red” find the minimum, maximum, range, lower quartile, median, upper quartile, interquartile range, mean, mode, and standard deviation. (5 marks)
• Plot suitable bar charts of this data, both individually and combined. (5 marks)
• Plot another, different, suitable chart that can be used to compare these data. (5 marks)
• Using all the available resources compare and contrast the two sets of data. (10 marks)
Part 2 (30 marks): For the data given in Table 2 (below) on dosage and recovery time:
• Plot a scatter graph of these data and comment on what you notice. (5 marks)
• Calculate Pearson’s r to find if there is a correlation and discuss your results. (10 marks)
• Conduct a Linear Regression analysis and discuss your results. (10 marks)
• What can you conclude about this data based on your analysis? (5 marks)
Part 3 (40 marks): Table 3 (below) gives the heights of 500 adult men. You may assume that these values are from a normally distributed population, but you may not assume or use the population variance.
• Construct a grouped frequency table for the whole set of data, with a class width of 1cm. Use this to construct a suitable graph for this data. What do you notice? (10 marks)
• Take a random sample of size n = 20, describing your method. (5 marks)
• Find a 95% confidence interval for the mean height of the population this data has been drawn from and discuss your method and your result. (15 marks)
• Find a 99% confidence interval for the mean height of the population this data has been drawn from. Discuss whether this should be preferred over the 95% interval. (10 marks)
Assessment reference style: Not applicable
.
Expected word count: Not applicable
Learning Outcomes Assessed:
The following learning outcomes are assessed in this task:
• Critique original research data sets relevant to their field of study selecting appropriate statistical methods
• Discuss the relevance, validity and reliability of statistical methods in the context of experimental design
• Evaluate and interpret scientific information and data, both qualitative and quantitative, relevant to applications of their subject area
Submission Requirements:
You must type your assessment in Arial font 12, with single spacing.
You must submit the assessment electronically via the VLE module page. Please ensure you submit it via Turnitin.
Assessments submitted after the submission deadline may incur penalties or may not be accepted.
Assessment Mark:
Marks will be awarded for:
• accuracy of the calculations you make;
• comments and annotations;
• formatting/presentation
Assessment Feedback:
Your tutor will mark the assessment and provide you with feedback. You can use this feedback to guide your further learning on the module.
Table 1:
Average sales per week (000’s)
Mango Blue
Papaya Red
17
13
20
17
19
11
16
14
12
24
15
12
17
15
23
14
13
19
20
21
14
25
18
24
12
24
17
26
21
14
14
11
22
16
12
17
16
18
18
23
23
22
21
18
17
14
23
20
21
15
17
20
Table 2: Dosage of trial drug and patient muscle recovery times
Dosage (micrograms)
Recovery time (minutes)
6
16.1
1
20.3
11
18
15
14.1
8
16.2
14
23.5
5
17.1
8
15.7
10
17.7
12
16.2
7
15.6
16
27
1
26.7
9
18.4
10
14.7
6
21.2
3
23.6
8
17.7
5
15.4
9
18.9
16
13.8
19
14.3
2
15.3
4
17.4
10
17.1
4
15.9
5
17.9
10
15.8
9
15.8
10
15.6
7
16.9
15
12.8
12
16.1
3
21
18
14.9
1
23.3
2
18.9
18
13.8
7
20.4
17
12
11
18.6
14
12.1
15
11.6
6
17.3
16
17
3
19.7
Table 3: Heights of 500 adult men
181.1
183.7
184.7
185.2
185.7
186.3
186.7
187.2
187.7
188.4
189.2
181.5
183.7
184.7
185.2
185.7
186.3
186.7
187.2
187.7
188.4
189.3
181.8
183.7
184.7
185.2
185.7
186.3
186.7
187.3
187.7
188.4
189.3
181.9
183.8
184.7
185.2
185.7
186.3
186.7
187.3
187.7
188.4
189.3
181.9
183.8
184.7
185.2
185.7
186.3
186.7
187.3
187.7
188.4
189.3
182.0
183.8
184.7
185.2
185.7
186.3
186.7
187.3
187.7
188.5
189.3
182.1
183.8
184.7
185.2
185.7
186.3
186.7
187.3
187.8
188.5
189.4
182.4
183.8
184.7
185.2
185.7
186.3
186.8
187.3
187.8
188.5
189.4
182.4
183.9
184.8
185.4
185.7
186.3
186.8
187.3
187.8
188.5
189.5
182.5
183.9
184.8
185.4
185.7
186.4
186.8
187.3
187.8
188.5
189.5
182.7
184.0
184.8
185.4
185.8
186.4
186.8
187.3
187.8
188.5
189.6
182.7
184.0
184.8
185.4
185.8
186.4
186.8
187.3
187.8
188.5
189.6
182.7
184.0
184.8
185.4
185.8
186.4
186.8
187.3
187.8
188.5
189.6
182.7
184.0
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.5
189.6
182.8
184.0
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.5
189.6
182.8
184.1
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.5
189.7
182.8
184.2
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.6
189.7
182.9
184.2
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.6
189.7
182.9
184.2
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.6
189.9
182.9
184.2
184.8
185.4
185.8
186.4
186.8
187.4
187.9
188.6
190.1
182.9
184.2
184.8
185.4
185.8
186.4
186.9
187.4
187.9
188.6
190.1
183.0
184.3
184.8
185.4
185.9
186.4
186.9
187.4
187.9
188.6
190.2
183.1
184.3
184.8
185.5
185.9
186.5
186.9
187.4
187.9
188.6
190.3
183.1
184.3
184.9
185.5
185.9
186.5
186.9
187.4
188.1
188.7
190.3
183.1
184.5
184.9
185.5
185.9
186.5
186.9
187.4
188.1
188.7
190.3
183.1
184.5
184.9
185.5
185.9
186.5
186.9
187.4
188.1
188.7
190.4
183.1
184.5
184.9
185.5
185.9
186.5
186.9
187.5
188.1
188.7
190.5
183.1
184.5
184.9
185.5
186.0
186.5
186.9
187.5
188.1
188.7
190.5
183.2
184.5
184.9
185.5
186.0
186.5
186.9
187.5
188.1
188.8
190.5
183.2
184.5
184.9
185.5
186.0
186.5
186.9
187.5
188.2
188.8
190.5
183.2
184.5
185.0
185.5
186.0
186.5
187.0
187.5
188.2
188.8
190.5
183.2
184.5
185.0
185.5
186.0
186.5
187.0
187.5
188.2
188.8
190.6
183.3
184.5
185.0
185.5
186.0
186.5
187.0
187.5
188.3
188.8
190.8
183.3
184.5
185.0
185.5
186.0
186.6
187.0
187.5
188.3
188.8
190.9
183.3
184.5
185.0
185.5
186.1
186.6
187.0
187.5
188.3
189.0
191.0
183.4
184.6
185.0
185.5
186.1
186.6
187.0
187.6
188.3
189.0
191.4
183.4
184.6
185.1
185.6
186.1
186.6
187.0
187.6
188.3
189.0
191.7
183.4
184.6
185.1
185.6
186.1
186.6
187.0
187.6
188.3
189.0
191.7
183.6
184.6
185.1
185.6
186.1
186.6
187.0
187.6
188.3
189.1
192.3
183.6
184.6
185.1
185.6
186.1
186.6
187.0
187.6
188.3
189.1
192.5
183.6
184.6
185.1
185.6
186.1
186.6
187.2
187.6
188.4
189.1
183.6
184.6
185.1
185.6
186.1
186.7
187.2
187.6
188.4
189.1
183.6
184.7
185.1
185.6
186.1
186.7
187.2
187.6
188.4
189.2
183.7
184.7
185.1
185.6
186.3
186.7
187.2
187.6
188.4
189.2
183.7
184.7
185.2
185.6
186.3
186.7
187.2
187.6
188.4
189.2
183.7
184.7
185.2
185.7
186.3
186.7
187.2
187.6
188.4
189.2