Week 4 Homework
- 1752 Words
- 7 Pages
- Report
Week 4 Homework
Week 4 Homework
Introduction
Excel is the Microsoft Office series software that can use to evaluate the statistical results by using different statistical techniques. Through this we can understand the data by using the accurate statistical techniques which can helpful for the student or researcher to examine the data easily. Descriptive statistical helpful for the people to understand the nature of the data and examine the characteristics of the data. In the given data of family size different variables are used for defining the involving factors.
Discussion
Descriptive Summary of Family Size
Family Size
Mean
5.171717172
Standard Error
0.224751818
Median
5
Mode
4
Standard Deviation
2.23625235
Sample Variance
5.000824572
Kurtosis
-0.447334906
Skewness
0.283136247
Range
9
Minimum
1
Maximum
10
Sum
512
Count
99
The average mean of family size group is 5.1717 which the overall average values of all the participants which defined their total number of family members.
The average standard deviation of family size group is 2.236 which is the overall average standard deviation of all the participants. This value also defines that how far is from the average values.
The range of the family size is 9. This value can be acquired by using the range formula which is defined as:
Range = Maximum - Minimum
Range = 10 - 1
Range = 9
The median defines the center most value of the overall data and mode describes the highest repetitive values that used in any data. The mode value is 4 because the number of family sizes of mostly respondents is 4. The sample variance defines the fluctuation in the data that how the values are changing. The Skewness defines the shape of the data either it is positively or negatively skewed.
Independent t-test
Independent t test is a statistical technique which is also known as Student t-test. This test function is to compare the two different groups and their intensity such as in this case we compare the male and female GPA.
In Excel sheet we select two columns one is for Male GPA value and other is from Female GPA values.
Male GPA
Female GPA
0.143
1.36
1.6
1.5
3.5
0.2
0.6
0.3
1
0
1.5
0
2
2.2
0.8
0.42
1.27
0
0
0.5
1
1.5
1.8
0
1.6
0.72
1.3
0
1.4
0
1
0.33
0.3
0.28
0.25
1.09
0.7
1.88
0.09
3.86
1.5
3.32
1.4
2.82
1.7
2.65
1.87
4.12
1
3.98
1.8
3.39
1.9
3.77
1.23
3.81
0.5
3.46
3.1
4.33
0.64
4.21
1
3
0.5
2.7
2
3.65
1.5
2.76
3
4
0.2
4.05
2.5
3.24
0.3
3.94
1.2
4.06
1.3
3.62
0.08
3.56
0
2.8
2
3.75
1.25
2.89
1
3.1
0.8
2.79
0.6
3.24
1.6
2.45
2.96
Go to Data-Data Analysis-Descriptive Statistics- Independent t-test (two sample assuming equal variance). When the window is open select Male GPA in Variable 1 and Female GPA in Variable 2.
Check labels and then OK
t-Test: Two-Sample Assuming Equal Variances
Male GPA
Female GPA
Mean
1.210673469
2.3712
Variance
0.652947224
2.229549551
Observations
49
50
Pooled Variance
1.449375204
Hypothesized Mean Difference
0
df
97
t Stat
-4.795458143
P(T<=t) one-tail
2.93118E-06
t Critical one-tail
1.660714611
P(T<=t) two-tail
5.86235E-06
t Critical two-tail
1.984723136
The mean value of Male GPA is 1.210. This mean value is the total number of male respondents who have participated in this data collection survey.
The mean value of Female GPA is 2.3712. This mean value is the total number of female respondents who have participated in this data collection survey.
The mean value of Male GPA is less than the Female GPA because the female acquired good position in their results and secured the good GPA as compared with Male participants.
The value of t-statistics is 4.795 which define the significance level of overall respondents who have participated in data collection survey.
Graphical Representation
The two tailed significance level of the t-statistics 5.86235E-06. This value covers the maximum and minimum range of the overall respondents. It is a two tail test that must lies on both ...