This is the assessment of Statistics need to do as the was is done in the assessment sample and half of the work is done by me the excel report are done by me just need to do others things as shown in the sample and the wording for the assessment is
Marshall hrt
exceldrafts.docxSection 1
Comment as x increases , y increases
Section 2
|
sample |
139 |
|
|
|
|
|
|
|
|
|
|
|
|
Count of risk level (r or s)? |
Column Labels |
|
|
|
|
|
Row Labels |
L |
P |
Grand Total |
|
|
|
r |
14 |
55 |
69 |
|
|
|
s |
|
31 |
31 |
|
|
|
Grand Total |
14 |
86 |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
sample |
139 |
|
|
|
|
|
|
|
|
|
|
|
|
Count of risk level (r or s)? |
Column Labels |
|
|
|
|
|
Row Labels |
L |
P |
Grand Total |
|
|
|
r |
20.29% |
79.71% |
100.00% |
|
|
|
s |
0.00% |
100.00% |
100.00% |
|
|
|
Grand Total |
14.00% |
86.00% |
100.00% |
|
|
|
|
|
|
|
|
|
Section 3
|
sample |
139 |
|
|
|
|
|
|
|
|
|
|
Row Labels |
Count of High risk ? |
Average of return |
StdDev of return |
|
|
n |
74 |
0.034621622 |
0.003267535 |
|
|
y |
26 |
0.033461538 |
0.09478153 |
|
|
Grand Total |
100 |
0.03432 |
0.047714826 |
|
|
sample |
139 |
|
|
|
|
|
|
|
|
|
|
|
|
Row Labels |
Count of do you support proposed change? |
|
|
|
|
|
no |
82 |
|
|
|
|
|
yes |
119 |
|
|
|
|
|
Grand Total |
201 |
|
|
|
|
|
|
|
|
|
|
|
annual contribution
174810 243670 152740 163910 172210 157720 54990 202760 73040 190400 31116.2 31433.4 14052.1 22947.4 25314.9 18611 5609 23317.4 11467.3 31987.200000000001
Income
annual contribution
