Data Analysis: Descriptive Statistics and Assumption Testing

Correlation: Descriptive Statistics and Assumption Testing

Frequency distribution table

Histogram

Descriptive statistics table

Measurement scale

The minimum and maximum of Mean annual sick days per employee was 2 and 12.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of Mean annual sick days per employee was 7.126214, 7, 7 and 1.89 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of Mean annual sick days per employee is 0.124923 and 0.14225. The assumptions for parametric statistical testing were met here.

Simple Regression: Descriptive Statistics and Assumption Testing

Frequency distribution table

Histogram

Descriptive statistics table

Measurement scale

The minimum and maximum of lost time hours was 10 and 360.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of lost time hours was 188.0045, 190, 190 and 71.72542 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of lost time hours is -0.50122 and -0.08198. The assumptions for parametric statistical testing were met here.

Multiple Regression: Descriptive Statistics and Assumption Testing

Frequency distribution table

Histogram

Descriptive statistics table

Measurement scale

The minimum and maximum of Decibel was 103.38 and 140.9871.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of Decibel was 124.8359, 125.721, 127.315 and 6.898657 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of Decibel is -0.31419 and -0.41895. The assumptions for parametric statistical testing were met here.

Independent Samples t Test: Descriptive Statistics and Assumption Testing

Frequency distribution table

Histogram

Descriptive statistics table

Measurement scale

The minimum and maximum of Group A Prior Training Scores was 50 and 91. The minimum and maximum of Group B Revised Training Scores was 75 and 97.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of Group A Prior Training Scores was 69.79, 70, 80 and 11.04556 respectively. Similarly, mean, median, mode and standard deviation of Group B Revised Training Scores was 84.77, 85, 85 and 5.19 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of Group A Prior Training Scores is -0.77667598 and -0.086798138. It also shows that the Kurtosis and skewness of Group B Revised Training Scores is -0.352537913and 0.144084526. The assumptions for parametric statistical testing were met here.

Dependent Samples (Paired-Samples) t Test: Descriptive Statistics and Assumption Testing

Frequency distribution table.

Histogram

Descriptive statistics table

Measurement scale

The minimum and maximum of both Pre-Exposure μg/dL and Post-Exposure μg/dL was 6 and 56.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of Pre-Exposure μg/dL was 32.85714, 35, 36 and 12.26615 respectively. Similarly, mean, median, mode and standard deviation of Post-Exposure μg/dL was 33.28571, 36, 38 and 12.46996 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of Pre-Exposure μg/dL is -0.57604 and -0.42511. It also shows that the Kurtosis and skewness of Post-Exposure μg/dL is -0.65421 and -0.48363. The assumptions for parametric statistical testing were met here.

ANOVA: Descriptive Statistics and Assumption Testing

Frequency distribution table.

Histogram.

Descriptive statistics table.

Measurement scale

The minimum and maximum of air was 3 and 14. Similarly, the minimum and maximum of soil was 6 and 13. The minimum and maximum of water was 3 and 12. Similarly, the minimum and maximum of training was 3 and 8.

Measure of central tendency

The analysis shows that mean, median, mode and standard deviation of air was 8.9, 9, 11 and 3.059068 respectively. Similarly, mean, median, mode and standard deviation of soil was 9.1, 9, 8 and 1.744163 respectively. The mean, median, mode and standard deviation of water was 7, 6, 6 and 2.575185 respectively. Similarly, mean, median, mode and standard deviation of training was 5.4, 5, 5 and 1.187656 respectively.

Evaluation

The Descriptive Statistics shows that the Kurtosis and skewness of Air is -0.6283 and -0.36085. It also shows that the Kurtosis and skewness of soil is 0.11923 and -0.492002. Similarly, the Kurtosis and skewness of water is -0.23752 and 0.760206. Moreover, the Kurtosis and skewness of training is 0.253747 and 0.159183. The assumptions for parametric statistical testing were met here.

References

Linoff, G. S. (2010). Data Analysis Using SQL and Excel. John Wiley & Sons.

Whigham, D. (2007). Business Data Analysis Using Excel. OUP Oxford.

Nirel, R., Adar, S. D., Dayan, U., Vakulenko-Lagun, B., Golovner, M., Levy, I., . . . Peretz, A. (2018). Fine and Coarse Particulate Matter Exposures and Associations with Acute Cardiac Events among Participants in a Telemedicine Service: A Case-Crossover Study. Environmental Health Perspectives, 126(9), 097003. doi:10.1289/ehp2596