Using Microsoft Excel. Calculate the trend (mm/year) over the 75 years, report it and plot the trend-line.

Does your data show a statistically significant trend? What is the error in the trend estimate? Report the error and other diagnostic information which you coulduse to assess your confidence in the trend estimate in the (assumed) linear model.

Below is the data:

Year Sea Level

1940 6966

1941 6918

1942 6946

1943 6912

1944 6943

1945 6988

1946 6988

1947 6945

1948 7002

1949 6971

1950 6935

1951 6995

1952 6991

1953 6992

1954 6959

1955 6998

1956 7016

1957 6998

1958 7033

1959 6959

1960 7034

1961 7031

1962 7044

1963 6967

1964 6991

1965 6986

1966 7009

1967 7043

1968 7027

1969 7056

1970 7056

1971 7073

1972 7131

1973 7101

1974 7073

1975 7096

1976 7012

1977 7009

1978 7111

1979 7088

1980 7054

1981 7050

1982 7087

1983 7169

1984 7146

1985 7105

1986 7111

1987 7142

1988 7068

1989 7092

1990 7080

1991 7142

1992 7165

1993 7158

1994 7104

1995 7139

1996 7216

1997 7212

1998 7264

1999 7206

2000 7172

2001 7167

2002 7141

2003 7213

2006 7230

2007 7194

2008 7211

2009 7279

2010 7291

2011 7275

2012 7281

2013 7258

2014 7285

2015 7255

sea_level_data_assignment1_2021.xlsx This is the link to the spreadsheet