Please answer the 2 essay questions below and each questions needs about 350-500 words.You are tasked with developing a sample of 100 employees from a population of 400 employees. Approximately 60% of the employees are women and 40% of the women are racial/ethnic minorities. Approximately 33% of the male employees are racial/ethnic minorities. Discuss how you might develop a stratified fandom sample and tell me how many racial/ethnic minority females and how many racial/ethnic minority males will eventually be in your sample.Provide a detailed discussion of the advantages and disadvantages associated with using closed and open-ended questions in conducting surveys involving human research subjects.

Directions: a)Enter all your answers into this Word document (immediately following the relevant question) and submit the entire document. IMPORTANT: The name of your Word document MUST begin with your LAST NAME.b)When you use a Template to calculate an answer, copy and paste the results into this document.c)While putting your answers in a different color font is helpful, please DO NOT use red font since this is the color used to provide feedback on your answers.1.The following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts.a.How many variables are in the data set?b.Which of the variables are categorical and which are quantitative?c.For the Exchange variable, show the frequency and the percent frequency for AMEX, NYSE, and OTC. Construct a bar graph similar to Figure 1.4 (in the textbook) for the Exchange variable.d.Show the frequency distribution for the Gross Profit Margin using he five intervals: 0 – 14.9, 15 – 29.9, 30 – 44.9, 45 – 59.9, and 60 – 74.9. Construct a histogram similar to Figure 1.5 (in the textbook).e.What is the average price/earnings ratio?DATA SET FOR 25 SHADOW STOCKSCompanyExchangeTicker SymbolMarket Cap ($ millions)Price/ Earnings RatioGross Profit Margin (%)DeWolfe CompaniesAMEXDWL36.48.436.7North Coast EnergyOTCNCEB52.56.259.3Hansen Natural Corp.OTCHANS41.114.644.8MarineMax, Inc.NYSEHZO111.57.223.8Nanometrics Inc.OTCNANO228.638.053.3Team Staff, Inc.OTCTSTF92.133.54.1Environmental TectonicsAMEXETC51.135.835.9Measurement SpecialtiesAMEXMSS101.826.837.6SEMCO Energy, Inc.NYSESEN193.418.723.6Party City CorporationOTCPCTY97.215.936.4Embrex, Inc.OTCEMBX136.518.959.5Tech/Ops Sercon, Inc.AMEXTO23.220.735.7ARCADIS NVOTCARCAF173.48.89.6Qiao Xing Universal Tele.OTCXING64.322.130.8Energy West Inc.OTCEWST29.19.716.3Barnwell Industries, Inc.AMEXBRN27.37.473.4Innodata CorporationOTCINOD66.111.029.6Medical Action IndustriesOTCMDCI137.126.930.6Instrumentarium Corp.OTCINMRY240.93.652.1Petroleum DevelopmentOTCPETD95.96.119.4Drexler Technology Corp.OTCDRXR233.645.653.6Gerber Childrenswear, Inc.NYSEGCW126.97.925.8Gaiam, Inc,OTCGAIA295.568.260.7Artesian Resources Corp.OTCARTNA62.820.545.5York Water CompanyOTCYORW92.222.974.22.People often wait till middle age to worry about having a healthy heart. However, recent studies have shown that earlier monitoring of risk factors such as blood pressure can be very beneficial (The Wall Street Journal, January 10, 2012). Having higher than normal blood pressure, a condition known as hypertension, is a major risk factor for heart disease. Suppose a large sample of individuals of various ages and gender was selected and that each individual’s blood pressure was measured to determine if they have hypertension. For the sample data, the following table shows the percentage of individuals with hypertension.a.Develop a side-by-side bar chart with age on the horizontal axis, the percentage of individuals with hypertension on the vertical axis, and side-by-side bars based on gender.b.What does the display you developed in part (a), indicate about hypertension and age?c.Comment on differences in gender.AgeMaleFemale20 - 3411.0%9.0%35 – 4424.0%19.0%45 – 5439.0%37.0%55 – 6457.0%56.0%65 – 7462.0%64.0%75 +73.3%79.0%3.The department of transportation’s study on driving speed and miles per gallon for midsize automobiles resulted in the data below.a.Plot the speed and miles per gallon using a scatter plot with speed on the horizontal axis.b.Compute the sample mean and standard deviation for each variable.c.Compute the sample correlation coefficient. Is there a positive or negative correlation between these two variables? Comment.Speed (Miles per Hour)30504055302560255055Miles per Gallon282525233032213526254.The U.S. Census Bureau serves as the leading source of quantitative data about the nation’s people and economy. The following cross-tabulation shows the number of households (1,000s) and the household income by the highest of level of education for the head of the household (U.S. Census Bureau website, 2013). Only households in which the head has a high school diploma or more are included.a.Develop a joint probability tableb.What is the probability of the head of one of these households having a master’s degree or more education?c.What is the probability of a household headed by someone with a high school diploma earning $100,000 or more?d.What is the probability of one of these households having an income below $25,000?e.What is the probability of a household headed by someone with a bachelor’s degree earning less than $25,000?f.Is household income independent of educational level?Highest Level of EducationHousehold IncomeUnder $25,000$25,000 to $49,999$50,000 to $99,999$100,000 and OverTOTALHigh School Graduate988099709441348232,773Bachelor’s Degree248441647666781722,131Master’s Degree6851205301940949003Doctoral Degree7916042210761737TOTAL13,12815,49920,54816,46965,644

Create a research question using the General Social Survey dataset that can be answered using categorical analysisUse SPSS to answer the research question. Post your response to the following:What is your research question?What is the null hypothesis for your question?What research design would align with this question?What dependent variable was used and how is it measured?What independent variable is used and how is it measured?If you found significance, what is the strength of the effect?Explain your results for a lay audience and further explain what the answer is to your research question.Be sure to support your Main Post and Response Post with reference to the week’s Learning Resources and other scholarly evidence in APA Style.Respond to at least one of your colleagues’ posts and comment on the following:Do you think the variables are appropriately used? Why or why not?Does the analysis answer the research question? Be sure and provide constructive and helpful comments for possible improvement.As a lay reader, were you able to understand the results and their implications? Why or why not?ResourceFrankfort-Nachmias, C., & Leon-Guerrero, A. (2018). Social statistics for a diverse society (8th ed.). Thousand Oaks, CA: Sage Publications. Chapter 9, “Bivariate Tables” (pp. 235-268)Chapter 11, “The Chi-Square Test and Measures of Association” (pp. 269-302)Document: Chi Square Scenarios (PDF)Use these scenarios to complete your Assignment for this week.DatasetsDocument: Data Set 2014 General Social Survey (dataset file)Use this dataset to complete this week’s Discussion.Note: You will need the SPSS software to open this dataset.Document: Data Set Afrobarometer (dataset file)Use this dataset to complete this week’s Assignment.Note: You will need the SPSS software to open this dataset.Document: High School Longitudinal Study 2009 Dataset (dataset file)Use this dataset to complete this week’s Assignment.Note: You will need the SPSS software to open this dataset.Required MediaLaureate Education (Producer). (2016a). Bivariate categorical tests [Video file]. Baltimore, MD: Author.Note: The approximate length of this media piece is 5 minutes.In this media program, Dr. Matt Jones demonstrates bivariate categorical tests using the SPSS software.