Urgent 1

profilestudystudent
DescriptiveStatistics.xlsx
Home>Mathematics homework help>Urgent 1

Mean Median and Mode

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78
8 FEMALE 60 69
9 MALE 88 84
10 MALE 89 68
11 FEMALE 57 38
12 FEMALE 65 70
13 FEMALE 73 89
14 MALE 81 75
15 MALE 65 60
16 MALE 70 77
17 FEMALE 77 70
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80
22 MALE 60 62
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
Mean 73.1 70.7666666667
Mode 77 70
Median 73.5 70
Simple statistical techniques were used to tabulate and analyze the data. The data was analyzed by calculating the measures of central tendencies such as mean median and mode (Ali et al., 2019)
Mean is the average of numbers. It can be calculated by ading all the numbers and divide by the total number of occurances. Therefore it is the quotient between the sum and the count (George & Mallery 2016)
The mean score for the students in highchool is 73.1 marks while the mean in college is 70.0 marks
Mode is th most apperring figure in a data set (Ali et al., 2019). More students scored 77 marks in high school while a majority also scored 70 marks in college.
Median is the midle value of a given data set sorted either in ascending or descending order.
References
Ali, Z., Bhaskar, S. B., & Sudheesh, K. (2019). Descriptive statistics: Measures of central tendency, dispersion, correlation and regression. Airway, 2(3), 120.
George, D., & Mallery, P. (2016). Descriptive statistics. In IBM SPSS statistics 23 step by step (pp. 126-134). Routledge.

Variance

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78
8 FEMALE 60 69
9 MALE 88 84
10 MALE 89 68
11 FEMALE 57 38
12 FEMALE 65 70
13 FEMALE 73 89
14 MALE 81 75
15 MALE 65 60
16 MALE 70 77
17 FEMALE 77 70
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80
22 MALE 60 62
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
Variance 113.1965517241 207.0816091954
Variance is the measure of spread within a data set. It measures hor far the numbers in a data set are far from the mean (Ali et al., 2019)
The data collected from the high school indicates that the more close to the mean as compared to those collcted from college which has a higher variance (George & Mallery, 2016).
The variance of high school is 113.2 while thevariance of college is 207.1. AN indications that the data in college are spaearsed away from the mean as compared to the data from high school.
References
Ali, Z., Bhaskar, S. B., & Sudheesh, K. (2019). Descriptive statistics: Measures of central tendency, dispersion, correlation and regression. Airway, 2(3), 120.
George, D., & Mallery, P. (2016). Descriptive statistics. In IBM SPSS statistics 23 step by step (pp. 126-134). Routledge.

Standard Deviation

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78
8 FEMALE 60 69
9 MALE 88 84
10 MALE 89 68
11 FEMALE 57 38
12 FEMALE 65 70
13 FEMALE 73 89
14 MALE 81 75
15 MALE 65 60
16 MALE 70 77
17 FEMALE 77 70
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80
22 MALE 60 62
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
Standard Deviation 10.6393868115 14.3903304061
Standard deviation is a statistic that measures the dispersion of data relativ to the mean. It is calculated as the squareroot of varince.
The larger the deviation, the the further the points are from the mean in a data set. Therefore the data is more spread.
The standard deviation of highschool is lower as compared to the that of college. Therefore, the data in college are more dispersed as compared to the data in high school.
References
Ali, Z., Bhaskar, S. B., & Sudheesh, K. (2019). Descriptive statistics: Measures of central tendency, dispersion, correlation and regression. Airway, 2(3), 120.
George, D., & Mallery, P. (2016). Descriptive statistics. In IBM SPSS statistics 23 step by step (pp. 126-134). Routledge.

Probability

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78
8 FEMALE 60 69
9 MALE 88 84
10 MALE 89 68
11 FEMALE 57 38
12 FEMALE 65 70
13 FEMALE 73 89
14 MALE 81 75
15 MALE 65 60
16 MALE 70 77
17 FEMALE 77 70
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80
22 MALE 60 62
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
The probability of an event occuring is 1/30 for each of the scenarios
Therefore, the probability that each event will occur is 1/30 * 1/30 =1/90
References
Ali, Z., Bhaskar, S. B., & Sudheesh, K. (2019). Descriptive statistics: Measures of central tendency, dispersion, correlation and regression. Airway, 2(3), 120.
George, D., & Mallery, P. (2016). Descriptive statistics. In IBM SPSS statistics 23 step by step (pp. 126-134). Routledge.