Statistics Assignment: Data Analysis, Outliers and Variance

This assignment delves into the analysis of a dataset representing time spent watching television. It calculates the standard deviation and variance using both manual methods and Excel. The assignment identifies an outlier in the data and discusses its impact on the distribution. It also explains the importance of additional data collection or techniques to handle outliers to improve the consistency of the data. References to statistical texts are included. The assignment provides a practical application of statistical concepts, demonstrating how to analyze data, calculate key statistical measures, and interpret the results in the context of a real-world scenario. This assignment helps students understand data analysis using statistical concepts.

The data collected in first module are the values of time in minutes I spend watching television is as
shown below:
Day1 73 Minutes
Day2 80 Minutes
Day3 65 Minutes
Day4 20 Minutes
Day5 69 Minutes
Day6 75 Minutes
Day7 72 Minutes
Day8 73 Minutes
Day9 68 Minutes
Day10 70 Minutes
Frequency distribution table of the above data:
Time Frequency
20
Minutes
1
65
Minutes
1
68
Minutes
1
69
Minutes
1

70
Minutes
1
72
Minutes
1
73
Minutes
2
75
Minutes
1
80
Minutes
1
The calculation of standard deviation in Excel is as shown below:
Therefore, the standard deviation is 16.85 minutes.
The calculation of standard deviation in Excel is as shown below:
Therefore, the variance is 283.83 minutes. It can be also calculated by squaring the standard deviation
as shown below:
The distribution of the data is not normal because there exists an outlier value which is 20 minutes.
Therefore, more collection of data might be needed or a technique can be used to deal with outlying
values which will make our data more consistent.