show work in Microsoft word and uploadFor the following data:(a) Use Excel or another software to draw the scatter plot for the variables. You can either upload the file or copy the scatterplot into the text box for your answer.(b) Visually, determine whether there is a linear correlation between the two variables and, if so, determine whether it is positive or negative.(c) Using statistical methods, test the significance of the correlation coefficient at an alpha value of 0.05. Compare these results with your results from (b).The director of an alumni association for a small college wants to determine whether there is any type of relationship between the amount of an alumnus's contribution (in dollars) and the years the alumnus has been out of school. The data follow. Years x 1 5 3 10 7 6Contribution y 500 100 300 50 75 802. For the following data: (a) Use Excel or another software to draw the scatter plot for the variables. You can either upload the file or copy the scatterplot into the text box for your answer.(b) Visually, determine whether there is a linear correlation between the two variables and, if so, determine whether it is positive or negative.(c) Using statistical methods, test the significance of the correlation coefficient at an alpha value of 0.05. Compare these results with your results from (b). The average normal daily temperature (in degrees Fahrenheit) and the corresponding average monthly precipitation (in inches) for the month of June are shown here for seven randomly selected cities in the United States. Avg. daily temp. x 86 81 83 89 80 74 64 Avg. mo. precip. y 3.4 1.8 3.5 3.6 3.7 1.5 .23. For the following data: (a) Use Excel or another software to draw the scatter plot for the variables. You can either upload the file or copy the scatterplot into the text box for your answer.(b) Visually, determine whether there is a linear correlation between the two variables and, if so, determine whether it is positive or negative.(c) Using statistical methods, test the significance of the correlation coefficient at an alpha value of 0.05. Compare these results with your results from (b).An environmentalist wants to determine the relationships between the numbers (in thousands) of forest fires over the year and the number (in hundred thousands) of acres burned. The data for 8 recent years are shown.Number of fires x 72 69 58 47 84 62 57 45Number of acres burned y 62 42 19 26 51 15 30 154. Which of the following statements is true about the following conclusion drawn after finding that there is a significant correlation between annual personal income and years of education.Conclusion: More education causes a person's income to rise.A. The conclusion cannot be drawn because correlation does not necessary implies causality.B.The conclusion is correct since the correlation is significant.C. The conclusion is incorrect; Instead we should conclude that annual personal income increases more years of education.D. No answer text provided.

Assignment: Variables, Measurement, and SPSSQuantitative research consists of testing and understanding relationships between variables. Researchers construct these variables as measureable expressions of social phenomena. Modern statistics provides you with a host of resources to answer questions, but each statistical test has a set of assumptions regarding the measurement of the variables. It is therefore important to understand how variables are measured because their measurement will influence the type of analytic tools available to you.SPSS is a statistical software program that allows you to enter these variables into a spreadsheet format and record the measurements from a sample. Additionally, SPSS allows you to perform statistical analysis. Before launching into your analyses, though, it is important to understand how the variables are measured. That understanding will help you interpret the SPSS output.In this week’s Discussion, you considered topics with social change implications. For this Assignment, you will examine data to analyze independent and dependent variables, determine how they are measured, and decipher whether a social change question can be answered and the implications for such change.To prepare for this Assignment:Review the Learning Resources as well as the SPSS resources found in this week’s Learning Resources.Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in this week’s Learning Resources and then choose two variables that interest you.For this Assignment:Write a 1- to 2-page summary and include the following:A description of what the each of the variables measure.A description of the unit of analysis.A description and explanation of the levels of measurement for each variable (i.e., nominal, ordinal, interval, ratio).Explain how you might conceive these variables to be used to answer a social change question. What might be the implications for social change?Support your summary using appropriate scholarly citations and references. Use proper APA format.