logo

Excel Computing Task

   

Added on  2023-06-14

13 Pages2064 Words398 Views
Statistics and Probability
 | 
 | 
 | 
Excel Computing Task
Excel Computing Task_1

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
Excel Computing Task_2

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
Excel Computing Task_3

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
Excel Computing Task_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Regression Analysis for Margin Prediction
|14
|1990
|464

Dataset summary
|11
|1699
|1

Question 2 Question 4 Question 6 Mean 1.4137931 Mean 1.82758621 Mean 2.34482759 Standard Error 0.09307608 Standard Deviation 0.50123001 Standard Deviation 0.50123001 Standard Deviation 0.50123001 Samp
|1
|1138
|72

Analysis of Manufacturing Industries in Terms of Employees, Sales, and Revenue
|6
|1080
|134

Data Analysis Report on Surat Temperature
|12
|2014
|29

Evaluation of the Macroeconomic Performance of Australia and USA
|25
|4066
|453