Table 1 - Total sales generated by the seafood industry and the corresponding jobs supported by the seafood industry in the top 10 states by seafood sales.
State	Total Sales Generated by the Seafood Industry (in $ millions)	Jobs Supported by the Seafood Industry (1000s)
California	22,776	125
Florida	16,874	77
Massachusetts	7,663	87
Washington	7,464	55
New Jersey	6,226	37
New York	4,412	33
Alaska	3,895	47
Maine	2,582	42
Texas	2,091	22
Louisiana	2,022	36

Table 1 shows data on the total sales generated by the seafood industry and the corresponding jobs supported by the seafood industry in the top 10 states by seafood sales. The data are published by the National Marine Fisheries Service of the National Oceanic and Atmospheric Administration of the U.S. Department of Commerce.

Instructions:

Note that you may need to add the linear regression capability to the Excel program on your PC. The Linear Regression Analysis in Excel blog post may help if you need it: https://www.ablebits.com/office-addins-blog/2018/08/01/linear-regression-analysis-excel/

Use the Question 1 Workspace tab to help complete the following tasks as needed:

1. Develop a simple regression model using the appropriate Excel function to predict the number of jobs supported by the seafood industry from the total sales generated by the seafood industry of a given state . You will develop an equation with the following structure:

y = a + b1 * X1

where: y = the number of jobs supported by the seafood industry or the dependent variable

a = intercept

b1 = coefficient of the independent variable - X1

X1 = the total sales generated by the seafood industry or the independent variable

[Enter regression equation and predicted number of jobs here]