Need in 8 hours.
600 word report. please see the template and i need in that format.
PM608 Statistical Analysis
Scenario
The effectiveness of Covid-19 vaccination has been studied. First, prior to it being approved through clinical trials. However, with the rolling out of the vaccination by countries, the effectiveness studies have moved outside of lab-controlled environment.
While the vaccination cannot cure Covid-19, the use of it is linked to some level of prevention and in reduction in more severe symptoms such as hospitalisation and death.
As of now two major studies have been conducted to measure the real-world effectiveness of the vaccines and compared the data from clinical trial results. Both studies have shown that the real world roll out can mirror the same result obtained during clinical trials. The studied vaccines performed well in preventing severe covid-19 and deaths in adults.
The data presented to you are taken from United Kingdom during the peak of second wave of Covid-19. As UK’s peak approached, we became one of the first few countries to roll out the use of vaccine. Two separate data sets are given where:
· the first data set related to the onset of the peak and roll out of the vaccine in a small scale.
· The second data set represent the peak of the second wave and smooth roll out of vaccines to more vulnerable adults.
Your task is to analyse the study data and write your recommendations for the director of NHS in a short, non-technical report (approx. 600 words only) on how effective vaccine was in preventing deaths during the peak of second wave. Your results should be clear enough to allow the director to understand the role vaccine in preventing Covid-19 related death in the UK.
Whatever your recommendations are – they must be clearly supported by your calculations using the supplied study data.
Assessment Approach
You should include a full numerical summary of the data in the study. You should include an explanation of the factors, treatments and any lurking variables which may be present in the study and any future research. You should highlight any possible errors in measurement, data anomalies or outliers and describe their effect on your conclusions. You should describe any correlation between the variables, if present.
You should summarize any findings in the form of clear, supported
recommendations that allow the Director to decide policy for the future.
Any calculations must only use the methods and techniques described to you on this course.
You must produce a maximum of 2 graphical representations of the given data from the following options:
1. Histogram
2. Box Plot
3. Modified Box Plot
4. Cumulative Relative Frequency
[For example, you may choose: 1 Box Plot and 1 CRF – or – 1 Modified Box Plot and 1 Histogram but no more than 2 in total]
You must also conduct the following two tests (with the given limits in brackets).
1. Linear Regression (with a maximum of 2 correlations, 2 scatter plots and 2 residual plots)
2. 2 Sample Confidence Interval (with a maximum of 2 [2 sample] intervals)
a. Note: depending on circumstance or purpose, there is no ‘best’ confidence level, your choice of confidence level must be justified based on your purpose.
You should comment on the validity and meaning of any test you conduct in the context of the test result.
All calculations and statistical tests must be conducted using Microsoft Excel. Use of any other software is not permitted.
After submission, any spreadsheets you use (your .xls or .xlsx files) must be available to your tutor upon request however your report only requires the output graphs and tables printed within a Microsoft Word ( x) file, in an Appendix.
Data
Table 1 a: Before Full Vaccine rollout
Table 1B: After the full vaccine rollout
date
Daily cases per Million
Daily Deaths per million
Total vaccinations
Date
Daily cases per Million
Daily Deaths per million
Total vaccinations
2020-12-01
197.883
8.841
2021-01-01
783.76
9.017
2020-12-02
238.054
9.5
2021-01-02
848.196
6.524
2020-12-03
219.2
6.07
2021-01-03
808.669
6.671
1380430
2020-12-04
240.18
7.389
2021-01-04
863.883
6.011
2020-12-05
228.407
5.821
2021-01-05
895.61
12.917
2020-12-06
254.695
3.387
2021-01-06
917.148
15.277
2020-12-07
216.605
2.771
2021-01-07
773.922
17.036
2020-12-08
181.594
8.782
2021-01-08
999.778
19.543
2020-12-09
243.875
7.814
2021-01-09
881.11
15.174
2020-12-10
308.853
7.565
2021-01-10
806.749
8.313
2677971
2020-12-11
319.38
6.216
2021-01-11
678.448
7.756
2843815
2020-12-12
316.008
7.624
2021-01-12
669.256
18.268
3067541
2020-12-13
271.834
2.111
86465
2021-01-13
698.783
22.989
3356229
2020-12-14
298.752
3.416
2021-01-14
715.527
18.371
3678180
2020-12-15
272.244
7.419
2021-01-15
819.343
18.84
4023705
2020-12-16
370.929
8.973
2021-01-16
607.385
19.045
4322456
2020-12-17
520.943
7.8
2021-01-17
566.95
9.999
4514802
2020-12-18
418.725
7.184
2021-01-18
551.409
8.826
4723443
2020-12-19
399.504
7.873
2021-01-19
490.477
23.634
5070365
2020-12-20
529.036
4.78
675286
2021-01-20
571.671
26.771
5437284
2020-12-21
491.4
3.152
2021-01-21
556.789
19.001
5849899
2020-12-22
541.454
10.131
2021-01-22
591.155
20.54
6329968
2020-12-23
577.462
10.967
2021-01-23
493.38
19.822
6822981
2020-12-24
573.972
8.43
2021-01-24
441.464
8.958
7044048
2020-12-25
480.932
8.357
2021-01-25
326.124
8.709
7325773
2020-12-26
510.035
3.094
2021-01-26
295.673
23.986
7638543
2020-12-27
476.387
5.087
1005073
2021-01-27
371.941
25.305
7953250
2020-12-28
607.854
5.234
2021-01-28
422.405
18.165
8369438
2020-12-29
781.077
6.715
2021-01-29
427.301
18.297
8859372
2020-12-30
736.565
14.397
2021-01-30
343.073
17.667
9468382
2020-12-31
821.454
14.148
2021-01-31
310.671
8.65
9790576
| Kaplan International Pathways
| 1
| kaplanpathways.com
| Kaplan International Pathways
| 3
| kaplanpathways.com
· PM608
· Introduction to Advanced Statistics
· Statistical Analysis Task and Report
· Class/Group (e.g. Group A)
· Module Tutor Name
· Student ID Number
· Date of Submission
· Word count (not needed for this assignment)
I confirm that this assignment is my own work.
Where I have referred to academic sources, I have provided in-text citations and included the sources in the final reference list.
1. Statistical Tests and Calculations
1.1 Full Numerical Summary
1.2 Graphical Summary
1.3 Regression Analysis
1.4 Two-Sample Confidence Interval
2. Comments and Critique
2.1 Quality Check
2.2 Comment and Critique on Regression Analysis
2.3 Comment and Critique on Two-Sample Confidence Interval
3. Recommendations and Findings
*Provide a summary of recommendations and findings to the director of NHS. This should not contain any statistical jargon. *
| Kaplan International Pathways
| 1
| kaplanpathways.com
| Kaplan International Pathways
| 2
| kaplanpathways.com
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
