Statistics: Mean and Method
Air Force Assignment 1. Use appropriate descriptive statistics to summarize the training time data for each method. What similarities or differences do you observe from the sample data?
Descriptive analysis in excel has been used to come up with relevant figures of the given data samples which is tabulated below: Descriptive Statistics | Current | Proposed | Mean | 75.06557 | 75.42623 | Standard Error | 0.505094 | 0.32091 | Median | 76 | 76 | Mode | 76 | 76 | Standard Deviation | 3.944907 | 2.506385 | Sample Variance | 15.5623 | 6.281967 | Kurtosis | -0.06933 | 0.58694 | Skewness | -0.22053 | -0.28749 | Range | 19 | 13 | Minimum | 65 | 69 | Maximum | 84 | 82 | Sum | 4579 | 4601 | Count | 61 | 61 |
Analysis of descriptive statistics shows that both the current and the proposed plan have almost similar mean completion hours which stand at 75.06 and 75.42 for the current and proposed respectively. Both the plans have exact same median and mode. However, the standard deviation in the current plan (3.94) is higher than that in the proposed plan (2.56), which is ultimately leading to the higher variance in the current plan. This suggests that the completion hours are more dispersed the mean value in the current plan, hence the mean does not give the true picture of data distribution whereas in the proposed plan, data for completion hours is comparatively more congregated.
2. Use the methods of Chapter 10 to comment on any difference between the population means for the two methods. Discuss your findings.
On chapter 10, interval estimation is used to reject or accept the hypothesis made about the two means. In this case, the hypothesis will be as follows:
Ho: μ1 - μ2 =0 Ha :μ1 -μ2 ≠ 0 Where μ1 is the sample mean for current method and μ2 is the sample mean for proposed method. Since we do not have data on the sample variances of the two data sample provided, we use T-test in excel for two samples with unequal
Descriptive analysis in excel has been used to come up with relevant figures of the given data samples which is tabulated below: Descriptive Statistics | Current | Proposed | Mean | 75.06557 | 75.42623 | Standard Error | 0.505094 | 0.32091 | Median | 76 | 76 | Mode | 76 | 76 | Standard Deviation | 3.944907 | 2.506385 | Sample Variance | 15.5623 | 6.281967 | Kurtosis | -0.06933 | 0.58694 | Skewness | -0.22053 | -0.28749 | Range | 19 | 13 | Minimum | 65 | 69 | Maximum | 84 | 82 | Sum | 4579 | 4601 | Count | 61 | 61 |
Analysis of descriptive statistics shows that both the current and the proposed plan have almost similar mean completion hours which stand at 75.06 and 75.42 for the current and proposed respectively. Both the plans have exact same median and mode. However, the standard deviation in the current plan (3.94) is higher than that in the proposed plan (2.56), which is ultimately leading to the higher variance in the current plan. This suggests that the completion hours are more dispersed the mean value in the current plan, hence the mean does not give the true picture of data distribution whereas in the proposed plan, data for completion hours is comparatively more congregated.
2. Use the methods of Chapter 10 to comment on any difference between the population means for the two methods. Discuss your findings.
On chapter 10, interval estimation is used to reject or accept the hypothesis made about the two means. In this case, the hypothesis will be as follows:
Ho: μ1 - μ2 =0 Ha :μ1 -μ2 ≠ 0 Where μ1 is the sample mean for current method and μ2 is the sample mean for proposed method. Since we do not have data on the sample variances of the two data sample provided, we use T-test in excel for two samples with unequal