show work in Microsoft word and upload

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 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 6

Contribution y 500 100 300 50 75 80

2. 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 .2

3. 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 45

Number of acres burned y 62 42 19 26 51 15 30 15

4. 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.