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.

Using the “Independent Project Data” set file supplied above, perform an analysis in StatCrunch for the following using the variable(s) of your choice: Frequency distribution of a variable and bar graph of the same variableDescriptives of a continuous variable: mean, median, mode, skewness, kurtosis, standard deviation and graph of that variableCross tabulation of two variables with the appropriate statistical Comparison of two groups (single variable) on a single continuous variable with the appropriate statistical testComparison of the effect of three or more groups (single variable) on a single continuous variable with the appropriate statistical testScatterplot and correlation between the two continuous variables with the appropriate statistical test Think carefully about what kind of variables to choose for the given tasks. A short descriptive statement should accompany each of the above including a description of the variables used and any meaning that may be attached to the results. Write up the project in a WORD document for submission.