Question 1: Use excel to construct your scatter plot. Write your answers to the questions in a word document. Include the scatter plot you created in your word document. Please use data file 1 for problem 1. Question 2: Use excel to construct a scatt
Question 1: Use excel to construct your scatter plot. Write your answers to the questions in a word document. Include the scatter plot you created in your word document. Please use data file 1 for problem 1. Question 2: Use excel to construct a scatter plot. Compute the correlation coefficient by hand. You may use excel to do the hand computations. In other words you may use excel to sum up the column compute the squares of each column etc. You may hand write this and upload an image of your handwritten work. Answer any question in a word document. Please use data file 2 for problem 2. Question 3: Use excel to perform all of the computations. For some bonus points compute the regression line by hand an upload your work. Upload ONE excel document containing a worksheet for each question. Upload ONE word document with any written responses. Please use data file 3 for problem 3.