Assignment: Preventing Workplace DiscriminationWhen it comes to discrimination and harassment, legal compliance should be the minimum standard that leadership teams set for their organizations. It is important to foster a culture where it is widely understood that these violations are completely unacceptable. However, even in workplaces where proactive policies and procedures are in place to prevent problems, it only takes one individual to infringe upon another’s rights. When these instances occur, it is the responsibility of HR professionals to have a solid understanding not only of their companies’ policies, but also the legal requirements for how to proceed.In this Assignment, you will respond to a set of questions on the historical significance of antidiscrimination laws, HR’s role in handling discrimination, and the benefits of diversity and diversity programs. You will review case studies and scenarios from the lens of an HR professional and apply HR practices to address the discrimination and harassment issues found within them.To prepare for this Assignment:Review this week’s Learning Resources, including the three case studies/scenarios that you will use to complete this week’s Assignment: “Case 3-1 English Only: One Hotel’s Dilemma,” the John and Amala Scenario, and the Melvin, Julie, and Tina ScenarioSubmit your responses to the following prompts. Select one of the following antidiscrimination legislations:Equal Pay Act of 1963Title VII of the Civil Rights Act of 1964Age Discrimination in Employment Act of 1967Vietnam Era Veterans’ Readjustment Assistance Act of 1974Pregnancy Discrimination Act of 1978Americans with Disabilities Act of 1990Civil Rights Act of 1991Uniformed Services Employment and Reemployment Rights Act of 1994Veterans Benefits Improvement Act of 2004Title II of the Genetic Information Nondiscrimination Act of 2008Lilly Ledbetter Fair Pay Act of 2009Based on the legislation you selected, explain the impact of this historically significant legislation on HR practices. Specifically, in 150 words (2 paragraphs):What is significant about this legislation?What are the behaviors that led to this legislation being adopted?What penalties may be assessed for violating it?Illustrate the role of HR in addressing discriminatory behaviors. Specifically, in 150 words (2 paragraphs):Define two types of discrimination.For each type of discrimination, provide an example of how an HR manager could implement measures to prevent the discrimination or address the discrimination if it were to occur.For the following question, refer to the “Case 3-1 English Only: One Hotel’s Dilemma” PDF (also located in this week’s Learning Resources).Does this policy violate Title VII of the Civil Rights Act? Why or why not? (75 words, or 1 paragraph)For the following question, consider the “John and Amala Scenario” PDF (also located in this week’s Learning Resources):Based on this scenario, identify at least three inappropriate or illegal behaviors that Mr. Brian exhibited in this interview. For each behavior, explain why it was inappropriate or illegal and how he could have avoided or corrected his mistake. (150 words, or 2 paragraphs)For the following questions, consider the “Melvin, Julie, and Tina Scenario” PDF (also located in this week’s Learning Resources):Explain whether Tina’s behavior is considered bullying and what, if any, legal consequences may be applicable. What changes would you, as an HR representative, recommend to improve the atmosphere in this work environment? (75–150 words, or 1–2 paragraphs)What constitutes sexual harassment in the workplace? What are some potential consequences of this type of behavior occurring within an organization, and how can HR play a role in addressing and preventing sexual harassment? Provide specific examples to support your answer. (75–150 words, or 1–2 paragraphs)Explain at least four components of diversity in addition to race and culture. Describe some groups or characteristics that may be represented in today’s workplace, as well as the benefits they can bring to an organization. (150 words, or 2 paragraphs)Analyze the use of diversity programs and their effectiveness within organizations. In your analysis, describe the benefits and challenges of implementing a diversity program and the importance of having a set of guiding best practices. Are there better ways to promote diversity in an organization than diversity programs? Provide one or two examples of alternatives and explain your rationale for selecting them. (150–225 words, or 2–3 paragraphs)Note: For each prompt, be sure to reference at least one scholarly source to support your answer. Use the Walden Undergraduate Paper Template, provided in this week’s Learning Resources, to complete this Assignment.

Question 1: Part A: Use the Excel file titled, General-Electric and upload it into SPSS. Complete the following tasks and copy your results in a word document and submit your report. This file contains GE’s daily stock market data covering the period of 12/13/2010 to 12/11/2018. The file contains a total of 2013 daily transaction records including date, opening price of the GE stock for the day, highest price, lowest price, closing price, closing price adjusted for dividends, and the number of stocks traded (volume) Use the      explore command in SPSS and explain whether the trading volume of the      stock is normally distributed. Make sure to discuss, Skewness, kurtosis,      results from the test of normality as well as the Q-Q plots. Select      a random Sample of exactly 125 observations. Then run the descriptive      command and calculate the mean and standard deviation of the sample.      Repeat this process (i.e., selection of a random sample and descriptive      command) exactly 75 times. Hint: Use      SPSS syntax to repeat the command. List both values (mean and the standard      deviation) in a new excel file with proper column headings. Upload      the newly created excel file into SPSS and create a histogram of both the      calculated means and standard deviations. Run the      explore command similar to what you did in step 1 for both variables and      make your observations. Does the Central Limit Theorem (CLT) apply to both      measurements?  Suppose you believe that the true average      daily trade volume for General Electric stock is 49,829,719 shares. Based      on a recent sample you have also calculated a standard deviation of      21,059,637 shares. Considering a 95% confidence level, what is the minimum      required sample size if you like your sampling error to be limited to      10,000,000 shares. What sample size would offer a sampling error of not      more than 20,000,000 shares? Given      the information in item (5) above conduct a one-population test of      hypothesis for the mean and determine if the null hypothesis should be      rejected or not rejected. Compare      your findings in items (5) and (6) above and argue if you can make a      generalization. Is      there a statistically significant difference between the average trading      volume in 2017 and 2018? Hint: While technically, this can be carried out      as a paired sample t-test since volume data are reported for the same      stock, we will treat this as independent samples. Complete your      calculations by hand assuming M2017=46108055, S2017=34099055,      n2017=251, M2018= 87241844, S2018=50977722,      n2018=238. Repeat      the test, this time by using SPSS. Hint:      Create a new grouping variable for 2017 and 2018 and use it to run your      test.