Manutan International S.A. is a specialist mail-order business providing industrial and office equipment and supplies to the business-to-business, collective, and public sectors. Based in France, Manutan has built up a pan-European network of 24 subsidiaries in 20 countries, from Portugal to Russia and from Sweden to Italy. Manutan also has a strong online presence with 18 e-ecommerce websites and a workforce of around 1,500 staff. Manutan’s more than 200 catalogues feature over 200,000 items and serve more than 600,000 customers throughout Europe.
While mail-order houses had been in operation in France for many years, they have tended to focus primarily on the consumer market. In 1966, however, Andre Guichard, joined by son Jean-Pierre, set up a company dedicated to providing mail-order services to the business sector. The company’s major innovation was in its choice of goods, that of industrial equipment, especially materials handling equipment.
Manutan quickly recognized the potential of entering other European markets. The company’s first choice was the United Kingdom, where, as in France in the 1960s, the market for mail-order materials handling, lifting, and storage equipment was more of less non-existent. Manutan’s success in the United Kingdom led it to quickly move into a large number of new foreign markets after 1974.
Manutan focused on its mail-order operations until the early 2000s. In 2001, however, the company expanded and established a presence on the Internet, launching its first e-commerce-enabled website. That site later provided the platform for the rollout of 18 websites targeting each of the company’s markets. By 2005, the company had posted more than €1 million in sales through its e-commerce sites.
During the recent global financial crisis, Manutan made a strategic decision not to cut its marketing and commercial investments. On the contrary, Manutan maintained its promotional expenditure, and refocused part of its staff on direct selling, thereby increasing the multi-channel contact with their customers. This strategic insight seems to have paid off: the company recorded revenues of €563 million during the 2010 financial year, an increase of 15.2% over the previous year.
Despite the huge success in European markets, the management of the company in the UK received a number of complaints about salary discrimination against women and ethnic minority groups. The Director of Human Resources Department believes that the salaries are mainly determined on the basis of an employee’s education and experience with no consideration of gender and ethnic background. But he also thinks the best way to clear the allegation is to conduct appropriate statistical analyses. He selects a random sample of 100 employees. For each employee the following information has been gathered:
• Salary: annual Salary in pound sterling (£)
• Education: years of education
• Experience: years of work experience
• Age: age in years
• Gender: female, male
• Nonwhite: whether the employee is white or not
• Married: whether the employee is married or not
• Union: whether the employee is Union member or not
The data is attached to this assignment.
Assume you are the Director of the Human Resources Department. You are required to prepare a report for the Board of Directors which includes the following analysis:
(1) Use descriptive statistics, charts or tables to describe and summarise the key characteristics of the variables.
(2) By using a correlation table, show whether Salary and Education, Salary and Experience are linearly correlated according to the Pearson’s correlation coefficient. The table should show the correlation coefficients and the respective p-value. Interpret the results.
(3) By using “Chi squared” estimation indicate whether there is a statistical association between Gender and Union, show the cross tabulate table with the p-value and interpret the results.
(4) Create dummy variables for Gender, Nonwhite, Married and Union using the following definitions:
• GenderD: 1=female, 0=male
• NonwhiteD: 1=Nonwhite, 0=white
• MarriedD: 1=yes, 0=no
• UnionD: 1=yes, 0=no
(5) Use a two-sample t-test to determine whether there is a significant difference in annual salary between male and female employees.
(6) Use a two-sample t-test to determine whether there is a significant difference in annual salary between white and non-white employees.
(7) Conduct a multiple regression analysis using Salary as the dependent variable and address the following issues:
• Estimate a general model which includes all the variables.
• Carry out correlation analysis. Based on the correlation analysis discuss your model selection process.
• For the final chosen model, fully interpret the model estimation results. Are you able to establish that there are discriminatory employment practices against females and ethnic minority groups at Manutan?
• Carry out diagnostic checking for the final chosen model. Are you satisfied with the final model? What other variables do you think you should have considered as independent variables?
The statistical package SPSS should be used for data analysis.
If you are not familiar with how to use SPSS for data analysis, you may find the following book useful:
• Pallant, J. (2007) SPSS Survival Manual, Berkshire: Open University Press.
(a) Clearly state the hypotheses for the statistical tests you have used and evaluate your results relative to those hypotheses.
(b) Describe and justify the assumptions you have made for the statistical tests
(c) Fully interpret the results
(d) Attach the computer outputs to your written report
3,000 words (for main report, excluding all graphs, tables, appendices and references)
Background information and the questions you are trying to address. Discuss the importance of the issues under investigation by referring to relevant literature (published journal articles).
Describe the source of the data. Using descriptive statistics, charts or tables to describe and summarise the key characteristics of the variables.
Tasks (2) –(7) should be carried out in this section. Subheadings should be used to indicate each part clearly.
Summarize your findings and point out limitations of the results such as what other variables should have been included in the analysis. Make recommendations to the Board of Directors based on the analysis.
There should be evidence of extensive reading relevant to the questions addressed in the report. It will be ideal if there is a linkage between data analysis and the existing literature.
Important tables or charts should be included in the main body of the report. Other information can be attached as appendices.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
