i have math and excel assignment

MTH 134 – Recitation 2

Lesson 18 – Alternative Assessment for SU20: Linear Models

For this assignment, you will work in Excel and copy work into this document. It should be possible to type your responses into this Word file and then there is no need to print and then scan. The goal is to show that you can create and interpret linear models in Excel and report your results. You did a hand drawn linear model in the Lesson 16 assignment.

Once your work is completed, save this document and your work in Excel. Then submit both the completed Word document AND the Excel file to your instructor in Blackboard. To do so, click on the name of the assignment and follow directions. (4 points)

The Excel data file gives the per capita income of the United States from 1967 until 2018.

Access the link in Blackboard for the Excel File: Lesson 18 Recitation Data File SU20 .

FIRST: Reinitialize the independent variable for a zero year of 1960. With reinitialized values, create a professional looking scatterplot with the title: US Per Capita Income in Current Dollars Then do the following: (18 points)

1. Enter your name in the spreadsheet where it can be copied with the other work and pasted into this document. (2, 8, 8, 4, 4 points for all these steps)

2. Use Excel to compute the equation of the linear regression as shown in class.

3. Find the correlation coefficient (nearest .001) using the Excel Data Analysis Tool.

4. Clearly indicate equation and correlation coefficient on your scatterplot.

5. Copy and paste your Excel plot and name into the given box.

Then complete the following questions about your regression line.

a) Write the regression equation Excel gave for the data: (2 point)

b) Identify the average rate of change for your data and explain what it means in this context, including units. (6 points)

c) Identify the initial condition for your linear regression function. Discuss what that tells you about a reasonable domain for this model. (6 points)

d) When you select the equation to be shown in Excel, you can also select to see the R-squared value. This is the square of the correlation coefficient. So, find the R-squared value and take its square root, paying attention to whether it should be positive or negative. State your values below to the nearest .001. (6 points)

Correlation Coefficient: _____________