MATH 101 LAB 1

.docx

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

Report
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