its an excel statistics projectgain a better understanding of the use of excel to make HW problems easierTask: Follow the directions below in the order given. There are 21 questions consisting of graphs and figures as well as answers to simple questions about the data or graphs. There are two parts to the project. Part 1 is this set of instructions. Part 2 is an Excel file with 6 worksheets provided for all your answers. At the end, you will print off the Excel worksheets used in the exercise and turn them in for a grade. When a question appears, answer it with its related computer output at that point; do not wait until the end of the paper to enter answers to all the questions. Please label your answers.

To prepare for this Discussion: Review this week’s Learning Resources and the Descriptive Statistics media program. For additional support, review the Skill Builder: Visual Displays for Categorical Variables and the Skill Builder: Visual Displays for Continuous Variables, 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. Review the Chapter 4 of the Wagner text and the examples in the SPSS software related to central tendency and variability. From the General Social Survey dataset found in this week’s Learning Resources, use the SPSS software and choose one continuous and one categorical variable Note: this dataset will be different from your Assignment dataset). As you review, consider the implications for positive social change based on the results of your data. BY DAY 3 Post, present, and report a descriptive analysis for your variables, specifically noting the following: For your continuous variable: Report the mean, median, and mode. What might be the better measure for central tendency? (i.e., mean, median, or mode) and why? Report the standard deviation. How variable are the data? How would you describe this data? What sort of research question would this variable help answer that might inform social change? Post the following information for your categorical variable: A frequency distribution. An appropriate measure of variation. How variable are the data? How would you describe this data? What sort of research question would this variable help answer that might inform social change? 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. 

Assignment: Testing for Correlation and Bivariate Regression You had the chance earlier in the week to perform an article critique on correlation and simple linear regression and obtain peer feedback. Hopefully you are excited about the potential these tests hold; equally important is that you recognize some of their weaknesses. Now, it is once again time to put all of that good brainstorming to use and answer a social research question with the correlation and simple linear regression. As you begin the Assignment, be sure and pay close attention to the assumptions of the test. Specifically, make sure that your variables are metric level variables that can easily be interpreted in these tests. For this Assignment, you will examine correlation and bivariate regression testing. To prepare for this Assignment: Review this week’s Learning Resources and media program related to regression and correlation.Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in the Learning Resources for this week.Based on the dataset you chose, construct a research question that can be answered with a Pearson correlation and bivariate regression.Once you perform your correlation and bivariate regression analysis, 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 correlation and bivariate regression results for each research question. Do not forget to evaluate if the correlation and bivariate regression assumptions are met and report the effect size. In your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be.Refernces Laureate Education (Producer). (2016b). Correlation and bivariate regression [Video file]. Baltimore, MD: Author. Frankfort-Nachmias, C., & Leon-Guerrero, A. (2018). Social statistics for a diverse society (8th ed.). Thousand Oaks, CA: Sage Publications. Chapter 12, “Regression and Correlation” (pp. 325-371) Wagner, W. E. (2016). Using IBM® SPSS® statistics for research methods and social science statistics (6th ed.). Thousand Oaks, CA: Sage Publications. Chapter 8, “Correlation and Regression Analysis” https://academicguides.waldenu.edu/rsch8210 https://rpsychologist.com/index.html