MATH 101 LAB 4 (1)
.docx
keyboard_arrow_up
School
Oakland University *
*We aren’t endorsed by this school
Course
101
Subject
Mathematics
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by GeneralRamPerson1110
MATH 101 LAB 4 - Exploring Annual Wind Power Production Data
NAME:
DATE:
03/23/24
INTRODUCTION
Over many decades, wind power has been heralded as a source of clean alternative energy to feed our
insatiable appetite for electricity. In this lab assignment, you will explore data that has been collected
over many years recording increased energy production globally from wind power generation. Wind power production is measured in megawatts (MW), which is a unit of power that represents one
million watts. The data you will see was sourced from the International Energy Agency
(https://www.iea.org/), which compiles and analyzes data on renewable energy sources such as wind
power. In the spreadsheet lab4data.xls
, you will find annual wind power production from 2002 to 2021. For this analysis, you will create a scatter plot of the provided data and fit a polynomial trendline to the
data. The resulting model equation will be quadratic and can be used to predict future annual wind power
production if current trends persist. PROCEDURES
●
Open the data set spreadsheet
lab4data.xls
in Excel or similar software (i.e. Google Sheets). ●
Select both columns: Year and Annual Wind Power Production (MW)
○
The variable Year will be the independent variable (horizontal axis). ○
Annual Wind Power Production (MW) will be the dependent variables (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 that auto populated. ○
Label the horizontal axis by finding the option for Axis Title
under the Horizontal Axis
menu. Label the horizontal axis as
Year
.
○
Label the vertical axis by finding the option for Axis Title
under the Vertical Axis
menu.
The vertical axis should be labeled as Annual Wind Power Production (MW)
.
●
Create a trendline through the data points on your scatter plot and display the model equation. ○
From the chart format menu, under the Series “Annual Wind Power Production (MW)”
menu, activate the Trendline
option. ○
Set the Trend Type
to Polynomial and the Order to 2. This will model the trend in the
data with a quadratic function
.
○
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 trendlines and model equations displayed in the space below. QUESTIONS
1.
The purpose of this analysis is to model wind power production data with a quadratic function of
the form
f(x) = ax
2
+ bx + x
. In the space below, type the model quadratic function for the
relationship between year and annual wind power production in standard mathematical form
using the coefficients calculated on the spreadsheet. Note: Use the coefficient values for a, b, and c calculated in the spreadsheet and not displayed in
the trendline equation. f(x) =168.5x
2
+6x+9 2.
Using the model equation, determine the annual wind power production in the year 2030.
y= 6949910039
3.
Using the model equation, determine the annual wind power production in the year 2050.
y= 7087528559
4.
What other factors might need to be taken into account to provide a more robust model to make
predictions regarding future annual wind power production? (25 - 50 words)
I think other factors like where the wind turbines are located would be good information to have.
Onshore vs. offshore wind turbines. Offshore turbines tend to get more consistent wind exposure
and higher speed winds. This will affect the amount of wind power production based on where
the windmills are located.
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