In this assignment use MS Excel to develop a "simple linear regression formula". Read How to Create A Simple Linear Regression Equation, https://owlcation.com/stem/How-to-Create-a-Simple-Linear-Regression-Equation it will help you with this assignment.

Next, enter the data in an excel sheet with the information, below. After you have installed the Analysis ToolPak, open "Data Analysis" and scroll down to "Regression" and click. The regression window will open. Run a regression analysis on the annual car sales, over the last three years, taken from William and Sam Automotive sales.

Year	Median Income	Car Sales
2019	$55,000	260
2020	$60,000	290
2021	$65,000	320

First identify the independent and dependent variables. Next explain the relationship between the independent and dependent variable include its strength and direction. Then, explain how the formula can be used to forecast future sales. Finally, if annual income in 2022 rises to $70,000 what is your prediction for car sales in 2022? Please attach or copy the data output in Excel include your scatterplot and graph with your response.