Week9 Assignment-August Polar Sea Ice Area Loss

Week 9 Assignment – August Polar Sea Ice Area Loss

In this assignment, you will examine actual data on the reduction in polar sea ice area in August between 1979 and 2015.

Background: You will use the August Polar Sea Ice Area Loss Spreadsheet to:

· Calculate a linear regression of the polar sea ice area in August.

· Use this regression to forecast wen polar sea ice will completely disappear in August.

Notice: Access the August Polar Sea Ice Area Loss Instructions to see the steps for performing the linear regression calculation. The August Polar Sea Ice Loss instructions also provide a series of related questions for to answer.

Begin Work on Your Lab

To begin work your lab, access:

· August Polar See Ice Area Instructions [DOCX] below.

· August Polar Sea Ice Area Loss Spreadsheet [XLSX] below.

 

August Polar Sea Ice Area Loss Instructions

Objective: Determine a linear regression between the year and August polar sea ice area using Excel. After accessing the August Polar Sea Ice Area Loss Spreadsheet course file, you will perform your calculations and specify what year there will be no sea ice area in August.

 

Step Number

Instructions

1

Access the August Polar Sea Ice Area Loss Spreadsheet. This spreadsheet specifies the year and total polar sea ice area in August.

 

2

· On your spreadsheet, highlight all the data in the Year and the Total Sea Ice Area columns.

· Click INSERT > CHARTS > Scatter.

 

3

· Click on the data in your chart to select data.

· Right-click and select “Add Trendline.”

 

4

Click on the trendline. You will see a box called “Format Trendline.”

 

5

Scroll down the Format Trendline box until you see “Forecast.”

 

6

Under “Forward,” add enough years to the trendline until the line reaches zero ice area. This is the year there will be no polar sea ice in August.

 

7

· Answer the questions below.

· Submit your August Polar Sea Ice Area Loss Spreadsheet and the August Polar Sea Ice Area Loss Instructions to the assignment area.

 

 

 

Questions

1. According to your forecast, in which year will there be no polar sea ice in August?

2. Does the reduction in polar sea ice area constitute evidence that global warming is real? Why or why not?

 

3. How will the reduction in polar sea ice area affect the sea level and the safety of coastal communities?

 

· In your response, specify at least one coastal area that would potentially be affected by the loss of polar sea ice area.

· Be sure to cite the source of your information. Good places to start your research include Google Scholar; or governmental websites, such as the National Oceanic and Atmospheric Administration (NOAA).

Reference

National Oceanic and Atmospheric Administration. 2015. August Monthly Sea Ice Area for the Arctic. ftp://sidads.colorado.edu/pub/DATASETS/NOAA/G02135/north/monthly/data/

Place Order

Don't hesitate - Save time and Excel

Assignmentsden brings you the best in custom paper writing! To get started, simply place an order and provide the details!

Place Order
Top