You are required to prepare a report using data analysis

Online tutoring services

Need help with this question or any other SPSS assignment help task? Click on the button below to to hire an expert cheap.

(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

Get Help With a similar task to - You are required to prepare a report using data analysis

Login to view and/or buy answers.. or post an answer
Additional Instructions:
5ECON004W Analysis of Economic and Business Data Assignment Brief 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? Software 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. When writing up your report, you should: (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 Word limit: 3,000 words (for main report, excluding all graphs, tables, appendices and references) Structure of the empirical report: Introduction: 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). Data Description: Describe the source of the data. Using descriptive statistics, charts or tables to describe and summarise the key characteristics of the variables. Data Analysis and results: Tasks (2) –(7) should be carried out in this section. Subheadings should be used to indicate each part clearly. Conclusions and Recommendations 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. References 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. Appendices Important tables or charts should be included in the main body of the report. Other information can be attached as appendices. Due Date: Wednesday 28th April 2021 (Online submission by 1pm) Appendix: Data Set Row Salary Education Nonwhite Gender Experience Married Age Union 1 19388 6 White Male 45 Yes 57 No 2 49898 12 White Male 33 Yes 51 Yes 3 28219 12 White Male 12 Yes 30 No 4 83601 17 White Male 18 Yes 41 No 5 29736 8 White Male 47 Yes 61 Yes 6 50235 16 White Male 12 Yes 34 No 7 45976 12 White Male 43 Yes 61 Yes 8 33411 12 White Male 20 Yes 38 No 9 21716 12 White Female 11 No 29 No 10 37664 18 White Male 19 Yes 43 No 11 26820 18 White Male 33 No 57 Yes 12 29977 16 Nonwhite Female 6 Yes 28 No 13 33959 17 White Female 26 Yes 49 Yes 14 11780 11 White Female 33 Yes 50 No 15 10997 14 Nonwhite Male 0 No 20 No 16 17626 12 White Female 45 Yes 63 No 17 22133 16 White Female 10 No 32 Yes 18 21994 12 White Female 24 Yes 42 No 19 29390 13 White Male 18 Yes 37 No 20 32138 14 White Male 22 Yes 42 Yes 21 30006 16 White Female 27 Yes 49 No 22 68573 16 White Male 14 Yes 36 Yes 23 17694 8 White Female 38 Yes 52 No 24 26795 7 White Male 44 Yes 57 No 25 19981 4 White Male 54 Yes 64 No 26 14476 12 White Female 3 Yes 21 No 27 19452 13 Nonwhite Male 3 No 22 No 28 28168 13 White Male 17 No 36 No 29 19306 9 Nonwhite Female 34 Yes 49 Yes 30 13318 11 White Female 25 Yes 42 Yes 31 25166 12 White Female 10 No 28 No 32 18121 12 White Female 18 Yes 36 No 33 13162 12 Nonwhite Male 6 No 24 Yes 34 32094 12 White Female 14 Yes 32 No 35 16667 12 White Male 4 No 22 No 36 50171 12 White Male 39 Yes 57 Yes 37 31691 12 White Male 13 No 31 No 38 36178 12 White Female 40 Yes 58 No 39 15234 12 White Female 4 No 22 No 40 16817 12 White Female 26 No 44 No 41 22485 12 White Male 22 No 40 No 42 30308 12 White Male 10 Yes 28 No 43 11702 14 White Female 6 Yes 26 No 44 11186 12 White Male 0 No 18 No 45 12285 12 White Female 42 Yes 60 No 46 19284 16 White Male 3 No 25 No 47 11451 12 White Female 8 Yes 26 No 48 57623 15 White Male 31 Yes 52 No 49 25670 13 White Female 8 No 27 Yes 50 83443 17 White Female 5 No 28 No 51 49974 16 Nonwhite Male 26 Yes 48 Yes 52 46646 5 White Male 44 Yes 55 No 53 31702 12 White Female 39 Yes 57 No 54 13312 12 White Female 9 Yes 27 No 55 44543 18 White Male 10 Yes 34 No 56 15013 16 White Male 21 Yes 43 No 57 33389 14 Nonwhite Male 22 No 42 No 58 60626 18 White Male 7 Yes 31 No 59 24509 14 White Female 15 No 35 No 60 20852 12 White Female 38 Yes 56 No 61 30133 10 White Male 27 Yes 43 No 62 31799 12 White Female 25 No 43 No 63 16796 12 White Female 14 Yes 32 No 64 20793 12 White Female 6 No 24 No 65 29407 10 White Male 19 No 35 No 66 29191 12 White Male 9 No 27 No 67 15957 12 White Female 10 No 28 No 68 34484 13 White Female 28 No 47 No 69 35185 14 White Female 12 Yes 32 No 70 26614 12 White Female 19 Yes 37 No 71 41780 12 White Male 9 Yes 27 No 72 55777 14 White Male 21 Yes 41 No 73 15160 8 White Female 45 No 59 No 74 66738 9 White Male 29 Yes 44 No 75 33351 16 White Female 4 Yes 26 No 76 33498 10 White Male 20 Yes 36 No 77 29809 8 Nonwhite Female 29 No 43 No 78 15193 12 White Female 15 No 33 No 79 23027 14 Nonwhite Male 34 Yes 54 Yes 80 75165 15 White Male 12 Yes 33 No 81 18752 11 White Female 45 No 62 Yes 82 83569 18 White Male 29 Yes 53 No 83 32235 12 White Female 38 Yes 56 No 84 20852 12 White Male 1 No 19 No 85 13787 11 White Male 4 Yes 21 No 86 34746 14 White Female 15 Yes 35 No 87 17690 12 Nonwhite Male 14 Yes 32 No 88 52762 18 White Male 7 Yes 31 No 89 60152 16 White Male 38 Yes 60 No 90 33461 16 White Male 7 Yes 29 Yes 91 13481 12 White Male 7 No 25 No 92 9879 12 White Female 28 Yes 46 No 93 16789 13 White Female 6 Yes 25 No 94 31304 16 White Female 26 Yes 48 No 95 37771 15 White Male 5 No 26 No 96 50187 12 White Female 24 Yes 42 No 97 39888 12 White Male 5 No 23 No 98 19227 12 White Female 15 Yes 33 No 99 32786 11 White Male 37 Yes 54 Yes 100 28440 12 White Female 24 Yes 42 No 5

Related Questions

Similar orders to You are required to prepare a report using data analysis
36
Views
0
Answers
Statistics assignment SPSS upload
Scenario: You are interning for the MJK2 consulting firm. Your supervisor has to make a presentation on the demographics and descriptive statistics of a data set from an assessment center. The assessment center results are based on seven competencies of I/O psychologists. Your supervisor has asked you to help and this assignment is your opportunity to demonstrate your skills and help impress the client. Clean the data - in this particular case, remove all of the participants who have missing scores or null values in any of the assessment center competencies. If they did not complete the assessment center process, then they should be removed from the analysis. Report: 1. Report the descriptives for the demographics and assessment center scores. Please use tables, graphs and charts as you see appropriate – what describes the data best and what looks the best? Make sure you include all descriptives that would be helpful for understanding the central tendency, dispersion and distribution. 2. Your boss would also like you to develop some scoring ranges based on the mean, so that individuals can understand what stronger scores on each of these competencies look like. ...
71
Views
0
Answers
Looking for help with basic stats for survey results
Looking for help with basic stats for survey results 155 responses Looking at correlations, p intervals 20 questions, with logic Also some free text responses...
81
Views
0
Answers
Statistical analysis and results of my dissertation
The primary aim of this study was to empirically explore the link between self-stigma and self-esteem of individuals with the presence of a mental illness, offering a novel perspective by exploring the same variables amongst a sample without a mental illness. It was intended that an exploratory comparison of both clinical and non-clinical populations would offer a more detailed perspective on the impact of self-stigma regarding mental illness. In addition to this, there were some further aims of the current study. Self-stigma has been negatively highlighted from previous studies in correlation with help-seeking in mental illness. The study furthermore aimed to observe the link between self-stigma and help-seeking from a therapist in regards to mental illness. According to Corrigan's (2004) study of self-stigma, concerns rose about an individual's loss of self-esteem if they elected to reach out for assistance from a therapist or other mental health professional. There was discovered (Voguel et al., 2006) that self-stigma is significantly different from other arguably similar constructs like self-esteem and public stigma, and that self-stigma anticipates perceptions toward seek...
98
Views
0
Answers
Practical work - Social Stats
Beginners practical work for 1st year in college. Very easy - 4 questions only (they're in French but you can translate them very easily). You need SPSS to complete them, very basic stuff nothing too shabby. I don't feel like doing it because I have all my finals this week and I need to focus on biology....