Question.903 - Math 102 Correlation and Regression Project 30 points Due date is posted in weekly module In this project, you will perform regression analysis on data to develop a mathematical model that relates two variables. Then you will use this model to make predictions/conclusions. Objectives Find and use data directly from the internet Produce a scatterplot of the data Perform a regression analysis to find the equation of the line that best fits the data Display the results, plotted data, and the regression equation together for visual comparison Use the model to make predictions and conclusions about the data Guidelines You should consider your project as a technical report that you would turn into a boss on the job. Your grade will be based on the quality of your written presentation, tables and graphs, and the validity of any mathematics. The paper you turn in should have a mix of graphs and prose. Use complete sentences, good grammar and correct punctuation. Spelling is also important. You should aim to write your report in such a way that it can be read and understood by anyone who knows the material for this course. Finally, as a general rule for this and any other project, whenever you hypothesize an answer to a question, be sure to provide ample justification as to why you believe your answer to be correct. Find and select your data You must find data that relates two quantitative variables. (Present your data in a table, with columns appropriately labeled.) For example, in hockey by team, we could compare the number of shots made at the goal with the number of goals actually made. Check with your Instructor to be sure the data you have selected is a good fit for the project. Be sure to adequately provide a source for the data. Create your scatterplot using Microsoft Excel/ StatCrunch Input the data into two columns of Excel/StatCrunch. Make a scatter plot with these two variables (you can find this in the same place as the graphs from the first project). Label the axes and the graph accordingly. Regression analysis Use Excel to calculate the regression equation and the correlation coefficient. Add the regression line to your scatter plot. Be sure the equation is shown clearly on the graph. Answer the following questions What is the slope of your model Describe it in words (what does it really mean). What is the y-intercept of your model Describe it in words (What does it really mean Does it make sense) Use your equation to predict a y value that is not in your data. How confident are you in your prediction Make conclusions and apply it to the real world Write a two to three paragraph paper explaining the significance of your results and how you can interpret them. Examine the results of your regression and determine if there is a strong, weak, or no correlation between your two variables. Describe how your results might impact the real world. What sorts of useful applications might you be able to make from your model Write about ways that you might take advantage of the data. If you feel your data was not particularly useful due to a low correlation coefficient, write about what other patterns you see in the scatterplot or how it is useful to know that there is little correlation between the variables.

Answer Below: