Excel Computing Task

Excel Computing Task

TABLE OF CONTENTS
MAIN BODY...................................................................................................................................3
Question 1...................................................................................................................................3
Question 2...................................................................................................................................4
Question 3...................................................................................................................................5
Question 4...................................................................................................................................7
Question 5...................................................................................................................................8
Question 6...................................................................................................................................8
Question 7...................................................................................................................................9
Question 8.................................................................................................................................10
Question 9.................................................................................................................................12
REFERENCES..............................................................................................................................14

MAIN BODY
Question 1
A
Reality,
pregnant or
not pregnant?
Test
result,
1 or 2?
Mean 1.45 1.57
Standard Error 0.05 0.04976
Median 1 2
Mode 1 2
Standard Deviation 0.5 0.49757
Sample Variance 0.25 0.24758
Kurtosis -1.998737639 -1.9571
Skewness 0.204081633 -0.2871
Range 1 1
Minimum 1 1
Maximum 2 2
Sum 145 157
Count 100 100
Confidence
Level(95.0%) 0.099210845 0.09873
B
By using the above analysis it is clear that the relationship between the two variables is
the difference between the sample means. This is particularly because of the reason that both the
variable that is reality and test result are wide (Black, 2019). Thus, because of this reason the
difference between the sample means is correct for the present study.
C
Reality,
pregnant or
not pregnant?
Test
result, 1
or 2?
Mean 1.53 1.45
Standard Error 0.050161356 0.05
Median 2 1

Mode 2 1
Standard Deviation 0.501613558 0.5
Sample Variance 0.251616162 0.25
Kurtosis -2.026035575 -1.99874
Skewness -0.122055094 0.204082
Range 1 1
Minimum 1 1
Maximum 2 2
Sum 153 145
Count 100 100
Confidence
Level(95.0%) 0.09953101 0.099211
D
With the above output it is clear that the relation between the variables involves the
analysis of two variables that is the difference between the sample mean is being undertaken.
The reason underlying this fact is that the descriptive statistics is being calculated and in this
only the difference in sample mean can be included.
E
Out of both the version, the test which is better is the version 1 because in this case that
standard deviation and mean are less and this provides for a good and wider view to the
company.
Question 2
A
which country
Number
of tests
Mean 1.5 2831.21
Standard Error 0.050251891 139.317
Median 1.5 2528
Mode 1 1323
Standard Deviation 0.502518908 1393.17
Sample Variance 0.252525253 1940923
Kurtosis -2.041237113 -1.67112
Skewness -6.86594E-18 0.169977
Range 1 3985
Minimum 1 1011