This is a calculation assignment, which is based on interpretation data given in other forms of presentations. There are many ways in, which the researchers wish to present their data collected from the field for faster communication of the message that is intended. Most of the statistical analysis of data features on the characteristics of data and how it varies from time to time depending on the variables that have been chosen. Data can be analyzed by drawing of graphs, charts, calculating using hypothesis tests and many more statistical techniques. In this calculation assignment, the major focus will be drawing of histograms to show how the data is represented, and the use of scatter diagrams will also be applied. In addition, a Pareto analysis will be computed to investigate how data is varied.
Scatter diagram Analysis
It is done by plotting the raw data used to give an analytical summary between two variables while drawing a linear correlation between the variables. It can also be done when plotting a regression line. It thus means that the scatter diagram will show how there is a correlation between the variables may be to a certain level of confidence interval. On the other hand, a histogram is like a bar graph but it is slightly different since it uses a range of values and the frequency density. To find the frequency density, one has to divide the frequency with a class width in each category.
Using the excel spreadsheet, the data can be represented in a scatter plot diagram to investigate whether there is any relationship in them. It will investigate whether there is any relationship between the hours of work and the defects caused during working from Monday to Friday. The following is the diagram that is drawn to represent the information using excel.
Histogram construction involves the construction of a frequency table as shown below and finding their relative frequencies within a class interval. This is done as shown below;
For the horizontal axis, 1 represents an interval of 0-5, while 2 represents an interval of 5-9, and 3 represents an interval of 10-15. The y-axis is the frequency density of the data, so that the area under each bar will give the total frequency.
It is a chart just like a bar chart. It is used to analyze data with specific frequencies. While drawing it, it is recommended to decide on the best categories of each group to include. A subtotal in each category is found, which is used to draw the chart
The trend line represents an exponential line that cumulatively represents data variation to show a Pareto analysis representation.