Assignment: Data Analysis Essay

Assignment: Data Analysis Essay

Assignment Data Analysis Essay


  1. State your results for the sample: the mean, median, mode, range, variance, and standard deviation

Table 1: Descriptive Statistics for the Sample Data

Mean 80
Standard Error 4.633213428
Median 83
Mode 83
Standard Deviation 14.65150732
Sample Variance 214.6666667
Kurtosis 0.694854765
Skewness -1.237868949
Range 45
Minimum 50
Maximum 95
Sum 800
Count 10

Table 1 above indicates the descriptive statistics for the dataset shown. The mean, median, mode, range, variance, and standard deviation are represented in the table as 80, 83, 83, 45, 214.6666667, and 14.65150732, respectively. The result indicates measures of

Assignment Data Analysis Essay
Assignment Data Analysis Essay

central tendency which summarize statistics representing the center points or typical values within the dataset. The above measures show where most values fall within the distribution. They also depict central locations of the dispersal. From the dataset, there is the tendency of the data to gather or cluster around the middle value (Jarman, 2013). In the statistical analysis, the common measures of central tendency include median, mean, and mode as indicated in table 1. The measures determine the locations of the central points by the use of different methods.


Click here to ORDER an A++ paper from our MASTERS and DOCTORATE WRITERS: Assignment: Data Analysis Essay

The best method for the analysis of the data is the use of the Microsoft Excel Analysis Toolpak add-in. The above tool enhances data analysis processes as well as other important calculations. The tool, however, does not default within the Excel; it is usually activated manually from the tile tab within the options section. Excel Toolpak add-in facilitates the analysis processes including the descriptive statistics as well as other statistical tests. From the dataset given, using Toolpak add-in enhances the accuracy of the results. The given data had a normal distribution; it was easier to apply excel to compute descriptive statistics and the general measures of the central tendencies. Also, because the sample size is small it is possible to use the formulas to conduct calculations; however, this may not be accurate due to errors that may be encountered. The use of Microsoft Excel, therefore, provides much easier way of determining the descriptive statistics with much accuracy.

Assignment Data Analysis Essay

One-Sample t-test

Table 2: One-Sample Test
Test Value = 70
t df Sig. (2-tailed) Mean Difference 95% Confidence Interval of the Difference
Lower Upper
students score 2.158 9 .059 10.000 -.48 20.48


Table 2 above indicates one-sample t-test for the data. From the result, the significant value is 0.59, which is greater than 0.05, we, therefore, fail to reject the null hypothesis and conclude that the mean of the sample data is not different from the population mean of 70. Also, from the table, the t-value is 2.158, and the mean difference is 10. The 95% confidence interval of the mean difference is (-0.48, 20.48).

            The result obtained would be useful in the interpretation of the scores. Also, the information would be useful in exploring data in meaningful ways. Through the expression of facts as given in the results, one can gain or make meaningful conclusions from the dataset. Data analysis interprets, organizes, structures and presents information into useful information that gives contexts for the data (Guerrero, 2010). A t-test, therefore, is used for two independent variables presented, that is, having Employ Status being categorical and having two categories and Fitness Hour measured in ratio level. Data analysis results can be used in the decision-making processes and to enhance policy-making.

Given the following students\’ test scores (95, 92, 90, 90, 83, 83, 83, 74, 60, and 50), identify the mean, median, mode, range, variance, and standard deviation for the sample.
Write a 500-750 word summary and analysis discussing the results of your calculations.
1. State your results for the sample: the mean, median, mode, range, variance, and standard deviation
2. Explain which method is best for this data set. Why?
3. Conduct a one-sample t-test and interpret the results (use a population mean of 70).
4. In what situations would this information be useful?