Stastics

Submitted by: Submitted by

Views: 84

Words: 659

Pages: 3

Category: Literature

Date Submitted: 01/09/2014 08:53 PM

Report This Essay

stati Task 1: Variable list Variable | Qualitative or Quantitative | Nominal or Ordinal andDiscrete or Continuous. |

Area | Qualitative | Nominal |

Gender | Qualitative | Nominal |

Satisfaction | Qualitative | Ordinal |

Search | Quantitative | Discrete |

Salary | Quantitative | Continuous |

|

Task 2: HistogramSalary (Thousands)

Frequency

|

In task 2, the histogram comes out to be symmetric. There are no outliers in this histogram as all the salaries are close to each other as all the employees getting salary range from $30k to $60k. In this case histogram is symmetric so central measures that is mean, mode and median are suitable. The mean and median will be very similar and will also lie in the middle of the distribution that is around salary $45k to $50k.

Task 3: Descriptive Statistics

Variable | Mean | Median | Standard deviation |

Area 1 | 50.50 | 51.00 | 4.8792 |

Area 2 | 52.95 | 53.00 | 5.8265 |

Area 3 | 44.21 | 45.00 | 3.9780 |

Area 4 | 44.19 | 44.00 | 4.6866 |

Area 5 | 40.67 | 40.50 | 5.6782 |

Salary (thousands)

Area 4 (marketing/sales) is best because they have the smallest variance in salaries and seem to very consistent and have high mean. Area 2, 5 is too inconsistent as there is large variation in salaries which means inconsistent. Area 1 is consistent but the salary mean is higher than average salary mean.

Task 4: Pivot Table and Bar Chart

Count of ID number | Area |   |   |   |   |   |

Satisfaction | 1 | 2 | 3 | 4 | 5 | Grand Total |

1 | 12 | 8 | 13 | 10 | 4 | 47 |

2 | 25 | 10 | 6 | 14 | 4 | 59 |

3 | 12 | 3 | 4 | 14 | 2 | 35 |

4 | 1 | | 1 | 5 | 2 | 9 |

Grand Total | 50 | 21 | 24 | 43 | 12 | 150 |

Count of ID number | Area |   |   |   |   |   |

Satisfaction | 1 | 2 | 3 | 4 | 5 | Grand Total |

1 | 24.00% | 38.10% | 54.17% | 23.26% | 33.33% | 31.33% |

2 | 50.00% | 47.62% |...