To prepare for this Assignment:Review the Learning Resources and the media programs related to t tests.For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Builder: Hypothesis Testing for Independent Samples t-test, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane.Also, review the t test scenarios found in this week’s Learning Resources and consider the three different approaches of t tests:Independent sample t testPaired sample t testOne sample t testBased on each of the three research scenarios provided, open the High School Longitudinal Study dataset or the Afrobarometer dataset from this week’s Learning Resources using SPSS software, then choose and run the appropriate t test.Once you perform your t test analyses, review Chapter 11 of the Wagner text to understand how to copy and paste your output into your Word document. For this Assignment:Write a 2 to 3-paragraph analysis of your t test results for each research scenario and include the SPSS syntax and output. Do not forget to evaluate if the t test assumptions are met, justify the selection of type of t test, and report the effect size. Based on your results, provide an explanation of what the implications of social change might be.Assignment Format of the 2-3 paragraph analysis:Research scenario 11) t test results and include the SPSS syntax and output. 2) address if the t test assumptions are met,3) justify the selection of type of t test,4) report the effect size.,5) Based on your results provide an explanation of what the implications of social change might be.Repeat for scenario 2 and then repeat for scenario 3.Use proper APA format, citations, and referencing for your analysis, research questions, and output.

The Excel spread sheet and pdf is for Experience 2 Application only.EXPERIENCE 3 ASSISGNMENT Suppose you are representing the employees at a large corporation during contract negotiations. You have a list of the salaries of all the employees at the corporation (The salaries include the many lower level employees and the few high paid management employees) and you plan to find a measure of center (e.g. mean, median, or mode).a. Which measure or center would you use to represent the employees in an effort to support your claim that the average salary of lower level employees is much lower than the national average (for lower level employees) and thus should be increased?meanmodemedianb. Why is this the better choice?Suppose you wish to invest money safely and are trying to decide between stock options in two companies. The average rates of return are the same for both companies but, one company has a much larger standard deviation of its rates of return. a. Which company should you invest in?The company with the smaller standard deviationThe company with the larger standard deviationb. Why is this the better choice? Describe the shape of the distribution for the following and justify your answer:a. The distance people travel to work on a typical day - The horizontal axis is the distance traveled in a person's daily commute. The vertical axis is frequency (number of people with that distance for their daily commute). Shape of distribution:skewed leftuniformskewed rightsymmetricJustification:b. Number of hours of sleep for each night of the week (weekdays only) - The horizontal axis is the day of the week (Monday to Friday) and the vertical axis is the amount of sleep in hours for that night. Shape of distribution:symmetricuniformskewed leftskewed rightJustification:c. Age of first heart attack - The horizontal axis is age. The vertical axis is frequency (number of people who had their first heart attack at that age). The population is people in the US who have had at least one heart attack. Shape of distribution:uniformsymmetricskewed leftskewed rightJustification:d. Scores on the Graduate Requirement Exam - This is a standardized test for people entering graduate school. The horizontal axis would be the person's total score. The vertical axis would be frequency (number of people with that score). The population would be all GRE test takers for a given year. Shape of distribution:symmetricskewed rightuniformskewed leftJustification:EXPERIENCE 2 APPLICATIONYou must use spreadsheet software (e.g. Excel) for this problem. 1. For each state and Washington DC, the percentage of people without health insurance was determined. Given the data set (The file is located in the main Experience folder) create the following using spreadsheet software. Refer to the model/methodology for the desired format. Make sure to use 5-20 classes with a "nice" class width when creating the distribution tables. Make sure to label axes in both graphs. a. Grouped frequency distribution (table) b. Grouped relative frequency distribution (table) c. frequency histogram (graph) d. relative frequency histogram (graph) Submit the completed spreadsheet as a .xls or .xlsx file. 2. A survey of 50 college students was conducted to determine how much weekly income they earned from employment. Given the data set in Applications folder for this experience complete the following. Refer to the model/methodology for the desired format. a. Find the 5 number summary of the data set. Min= Q1= Median= Q3= Max= b. Create a box-plot for the data set using software (Choices include: The boxplot generator linked in the resources area, spreadsheet software, TI-84 (take a picture of your calculator), other software or websites.) Upload your finished file below. Question 2 Part 6 of 9Choose File No file chosen c. Identify any outliers. List the individual numbers that are outliers for this data set. If there are multiple outliers, separate them by commas. d. Give a possible explanation as to why the individual (or individuals) from part c might have a number (or numbers) that are so high (or so low). e. Interpret yourself as a percentile in the data set. First estimate your weekly income from employment (If you are not employed then use 0). Then find the percentile (see book for the formula) for your income using the sample data. Then interpret the percentile using the definition and writing a complete sentence.

Review the rubric to make sure you understand the criteria for earning your grade. In your textbook, Essential Statistics, review Chapter 11, “Chi-Square and Analysis of Variance,” focusing on Section 11-3, “One-Way Analysis of Variance.” Watch the video “Chi-Square” explaining the Excel skills you will need to complete the problems. Note that the version of Excel presented in the video may differ from the one you are using. Complete the five problems in the file WS5Homework (Excel). Each problem is on a separate tab (worksheet).