MATH 101 LAB 1
.docx
keyboard_arrow_up
School
Salt Lake Community College *
*We aren’t endorsed by this school
Course
101
Subject
Mathematics
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by DrUniverseEchidna38
MATH 101 LAB 1 - Global Temperatures and Ocean Levels
NAME:
Insert your full name here.
DATE:
Insert today’s date.
INTRODUCTION
In this lab assignment, you will explore the possible linear relationship between mean global temperatures
(
o
C) and mean ocean levels (mm). In the spreadsheet lab1data.xls
, you will find a data set containing
mean global temperatures and mean ocean levels collected from 1920 to 2020. In this data set, mean global temperature is the average temperature of the Earth's surface, as measured by
land-based weather stations and ocean buoys. Mean ocean level is the average height of the ocean's
surface, as measured by tide gauges and satellite altimetry. This data set was obtained from the National
Oceanic and Atmospheric Administration (NOAA) and the Intergovernmental Panel on Climate Change
(IPCC). In order to analyze the possible linear relationship between mean global temperatures (
o
C) and mean
ocean levels (mm), you will create a scatter plot using the data set using Excel (or similar tool). You will
then use the software to draw a trendline through the scatter plot and develop a model equation for the
relationship between the variables. PROCEDURES
●
Open the data set spreadsheet
lab1data.xls
in Excel or similar software (i.e. Google Sheets). ●
Select both the mean global temperatures (
o
C) and mean ocean levels (mm) columns. The mean
global temperatures (
o
C) will be the independent variable (horizontal axis) and mean ocean levels
(mm) will be the dependent variable (vertical axis). ●
To create the scatterplot, click on the Insert menu then select the icon for a scatter plot. Choose
the option without lines. Your scatter plot should only consist of dots. ●
Label the scatter plot. ○
Right-click on the chart and then select format. ○
Remove the chart title and legend that auto populated. ○
Label the horizontal axis by finding the option for Axis Title
under the Horizontal Axis
menu. Label the horizontal axis Mean Global Temperatures (C).
○
Label the vertical axis by finding the option for Axis Title
under the Vertical Axis
menu.
The vertical axis should be labeled Mean Ocean Level (mm).
●
Create a trendline through the data points on your scatter plot and display the model equation. ○
From the chart format menu, under the Series “Mean Ocean Level (mm)”
menu, activate
the Trendline
option. ○
Make sure that the Trend Type
is Linear.
○
Select the Display Equation on Chart
option. Note: The instructions above are based upon the web-based version of Excel included with Office 365. If
you use another spreadsheet program, or different version of Excel, the above steps will differ.
Paste your scatter plot with the trendline and model equation displayed in the space below. <Paste your Scatter Plot here>
QUESTIONS
1.
In the space below, type the model equation for the relationship between mean global
temperatures (
o
C) and mean ocean level (mm) in standard mathematical form. 2.
What is the slope of this line? What does it represent? 3.
Using the model equation, predict the mean ocean level (mm) if mean global temperatures were
to reach 16
o
C. 4.
Using the model equation, predict the mean ocean level (mm) if mean global temperatures were
to reach 20
o
C. 5.
Describe how you might go about determining when (what years) we could expect to see the
mean ocean levels you predicted in question 2 and 3 (50 - 100 words). 6.
In the space below, explain the efficacy of modeling the relationship between mean global
temperatures (
o
C) and mean ocean levels (mm)s in this fashion. Explain whether or not this
approach provides a reliable method for making future predictions? What other factors might
need to be taken into account to provide a more robust model to make predictions? (50 - 100
words)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help