Question: 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?

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Demand Estimation Assignment - iScream Ice Cream Co. iScream is a Chicago start-up that sells ice cream in several mobile ice cream trucks. The main innovative feature of their business is the...

can you do this experiment and calculate the final result \begin{tabular}{|c|} \hline \\ \hline 1 \\ \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ \hline 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\...

can you do this experiment and calculate the result Objective- To determine the enthalpy of vaporization of water using the Clausius-Clapeyron equation. BackGroundInformation- In the experiment you...

REVIEW THE ARTICLE BELOW then Discuss the following below: Discuss the article. Discuss whether you do or do not agree with the idea that "Wealth is Health" related to this article. Discuss 2-3...

Objective: This equation can be re-written as 1. To investigate the relationship between the mass, velocity and momentum of an object. (me = - (m) MA (4) 2. To investigate the law of conservation of...

INTRODUCTION This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and...

This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and Querying in Excel...

W Employee Degree Attained Years since graduation Salary (annual) 1 BSc 3 39,000 2 MS 6 58,800 3 MS 3 50,400 4 PhD 7 95,900 5 BSc 6 48,000 6 PhD 9 105,300 7 MS 4 53,500 8 PhD 3 77,100 9 BSc 7 51,000...

The purpose of this project is to familiarize you with basic concepts of statistics and data analysis. The exercise will help you develop an understanding of data analysis through data visualization...

Employee Degree Attained Years since graduation Salary (annual) 1 BSc 3 39,000 2 MS 6 58,800 3 MS 3 50,400 4 PhD 7 95,900 5 BSc 6 48,000 6 PhD 9 105,300 7 MS 4 53,500 8 PhD 3 77,100 9 BSc 7 51,000 10...

What is sustainability and what does it mean for a business?

What principal will earn $24.87 at 4.75% in 156 days?

Free cash flow is calculated as _ _ _ _ _ . cash flow from operating activities plus investments in PP&E needed to maintain current production

Probability Concepts. Narcissism Records, Inc., has just completed an agreement to re-release a recording of "The Boss's Greatest Hits." The Boss had a number of hits on the rock-and-roll charts...

The Carla Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in the Sunbelt. In order to do so, Carla has decided to locate a new...

Evaluate the advertisement drafted by Nandi for the position of Warehouse Supervisor and make recommendations for its improvement

1. What does this mean for me?

2. Think of a person you really appreciate and who is a role model for you, such as something you admire for what the person does or has done (historical people, friends, family, from fairy tales,...

5. List at least three personal roles that you want to perform better. What can you imagine doing to perform better in these three personal roles. Use tomorrow to improve what you think can be...