Introduction
In this assignment I am going to show statistical data of employs of different departments in two branches of a company. With the help of excel spreadsheet I will produce table of random numbers for the students in a way that each student have a different set of random number table.
By using the columns of data I will show tables of frequency distribution and calculation and their formulas. Graphical representation of data which contains bar chart histogram and cumulative frequency curve will also be shown. T-test is also there which shows the reliability.

Task 1 Summery of statistics

Calculations

Mean | 6.59 | 5.753333333 | 5.183333333 | 5.096666667 | Median | 6.8 | 5.6 | 4.75 | 5.15 | Mode | 1.56543483 | 1.11656287 | 0.979473234 | 1.071088178 |

Mean is the ‘normal’ average which is calculated by adding all the observations and then dividing with the number of observations.
Median is usually the middle value which is often used when the values are uneven.
Mode is the most common value or can be a said a value which is repeated again and again.

Formulas

Mean | =AVERAGE(D3:D32) | =AVERAGE(E3:E32) | =AVERAGE(F3:F32) | =AVERAGE(G3:G32) | Median | =MEDIAN(D3:D32) | =MEDIAN(E3:E32) | =MEDIAN(F3:F32) | =MEDIAN(G3:G32) | Mode | =STDEV(D3:D32) | =STDEV(E3:E32) | =STDEV(F3:F32) | =STDEV(G3:G32) |

Values above show that the mean of values is 6.59. Whereas median is 6.8 and mode is 1.56.

Task 2 Graphical representation of the operation and administration (Bar Chart)

Variables

Department | Birmingham | London | Administration | 3 | 12 | Operations | 8 | 6 | It can be seen that there are two departments named as Administration and Operation of two cities London and Birmingham. In London number of employees in administration sector is 12 and in operation sector that number is half which is 12. If we see in Birmingham the average number of employees in comparison to London is less. In Birmingham the number of employees in administration sector is 3 which are very less in the same department of London. And in operation sector the number of employees is 8 which is again less than London. As London is a big city the average number of employees in every department is more than Birmingham.

As seen from the bar chart graph number of employees against Branch of two cities in different departments which are administration and operations. In London both in administration and operation the number of employees are more than Birmingham as an average.

Task 3 T-test

Work Satisfaction | Working Conditions | T-Test: Two-Sample Assuming Equal Variances | | | 7.7 | 6.5 | | | | 0.020455811 | 6.4 | 5.9 | | Variable 1 | Variable 2 | 5.6 | 4.5 | Mean | 6.503333333 | 6.14 | 5.6 | 4.5 | Variance | 2.404471264 | 1.365931034 | 8.4 | 6.8 | Observations | 30 | 30 | 6.3 | 7.2 | Pooled Variance | 1.885201149 | | 6.3 | 5.3 | Hypothesized Mean Difference | 0 | | 7.1 | 8.2 | df | 58 | | 7.2 | 6.9 | t Stat | 1.024877656 | | 7.3 | 4.6 | P(T<=t) one-tail | 0.154838258 | | 5.4 | 5.6 | t Critical one-tail | 1.671552763 | | 5.4 | 5.6 | P(T<=t) two-tail | 0.309676516 | | 4.8 | 5.4 | t Critical two-tail | 2.001717468 | | 8.4 | 7.4 | t Stat | 1.024877656 | | 8.4 | 7.4 | 8.5 | 6.4 | 8.5 | 6.4 | 8.5 | 6.4 | 7.3 | 5.6 | 8.3 | 7.4 | 3.2 | 3.6 | 7.7 | 5.6 | 3.8 | 5.3 | 3.8 | 5.3 | 3.8 | 5.3 | 6.8 | 4.7 | 6.8 | 4.7 | 6.8 | 4.7 | 6.8 | 4.7 | 6.8 | 4.7 |

This indicates that as t-state is greater than t-critical 1-tail so h1 is accepted and ho is rejected.

Task 4 Correlation and Regression

Variables Work Satisfaction | Working Conditions | 7.7 | 6.5 | 6.4 | 5.9 | 5.6 | 4.5 | 5.6 | 4.5 | 8.4 | 6.8 | 6.3 | 7.2 | 6.3 | 5.3 | 7.1 | 8.2 | 7.2 | 6.9 | 7.3 | 4.6 | 5.4 | 5.6 | 5.4 | 5.6 | 4.8 | 5.4 | 8.4 | 7.4 | 8.4 | 7.4 | 8.5 | 6.4 | 8.5 | 6.4 | 8.5 | 6.4 | 7.3 | 5.6 |