# Final Exam Math 110 Latest 2015

August 30, 2017

Question
Open the Final Exam Excel file. Use the first page for calculations for questions # 2, 3, 4, 5, 7,
and 10 and open the necessary tabs (at the bottom of the file) for questions #1, 6, 8, and 9. Do
your work in excel and write your answers in bold underneath the questions. Note: kWh is the
abbreviation for kilowatt-hour, a unit of measurement for electricity usage.
“What is a soul? It’s like electricity – we don’t really know what it is, but it’s a force that
can light a room.” Ray Charles
1. Open the Energy by State tab.
a. Which state used the most energy in 2013? Are you surprised? Why or why not? [2
pts]
b. In column D, calculate the amount of energy consumed per person for each state.
Which state consumed the most energy per person? Which state consumed the least
amount per person? Name the state and the amount of energy per person with correct
units. [4 pts]
c. Open the Map Making Tool. Make a map of states and energy consumption per
person. Give map an appropriate title. Copy and paste the map here. [2 pts]
d. Thoroughly describe any geographical trends of energy consumption. Mention any
outliers to the trends. [2 pts]
(just FYI—the states with higher energy consumption per person are also the states responsible
for generating a lot of the energy used in the US. It takes a lot of energy to generate energy)
2. There are 49,000 wind turbines in the US and the population of the country was 318.9 million
people. Calculate the number of wind turbines per 100,000 people in the US. [2 pts]
3. China produced 4.938 trillion kWhs of electricity in 2012. That same year, the US produced
4.256 trillion kWhs.
a. Compare the amount of electricity produced in China to the amount produced in the
US in 3 ways. Write a sentence for each. [6 pts]
b. If China’s production was 22% of all the electricity produced in the entire world, what
was the total global electricity production in 2012? [2 pts]

4. Your location in the US can affect how much you pay for electricity. For example, the average
monthly electric bill for Illinois residents is \$104.93. This amount is 20% higher than the
average monthly electric bill for our neighbors in Indiana. What is the average monthly electric
bill for Indiana residents? [2 pts]
5. In 2007, the total amount of electricity generated in the US was 4.160 trillion KWh and was
increasing by .66 trillion kWh per year. Write the appropriate equation to represent this growth.
6. Open the file Electricity Use, which contains data on the amount of electricity used in the US
from 1982 to 2009.
a. The data sets shows that the total amount of electricity used in the US increased almost
every year during this period. A friend of yours claims that this fact indicates that
Americans are using more electricity per person. You, having taken this Quantitative
Literacy course, are more cautious about drawing this conclusion. Why are you more
cautious? Explain why your friend is not necessarily correct. [2 pts]
b. Make a scatter graph of the data. Choose the layout with the trendline and equation
and R2 value. Title and label the graph appropriately. Copy and paste the graph here. [2
pts]
c. According to the trendline equation, how much electricity will be used in the US in
2017? How confident are you in this prediction? Why? [3 pts]
d. According to the trendline equation, in what year was there no electricity used in the
US? How confident are you in this prediction? Why? [3 pts]
7. In 2006, 26.59 billion kWh of electricity was generated in the US by wind power. In 2007, it
was 34.45 billion kWhs.
a. Assume the amount of electricity generated by wind power is growing exponentially.
Write the exponential equation for this situation. Define your variables. [4 pts]
b. According to your exponential equation, how many kWhs would have been generated
in 2013? [2 pts]
c. In 2013, the actual amount of electricity generated by wind power was 167.665 billion
KWh. Between 2006 and 2013, did wind power grew faster or slower than you predicted
with your equation above? [1 pt]
8. Open the tab Renewable, which contains data on electricity generated in the US from
renewable sources.
a. Make an appropriate graph of this data. Label and format correctly. [3 pts]
b. Thoroughly describe and interpret the data and graph. Include at least one relevant,
informative calculation in your description. [3 pts]
9. Open the tab Electricity Prices, which contains data on the average retail price of electricity
for residential use from 1993 to 2013.

a. Using this data and the CPIs from the CPI tab, in column D, convert the average prices
for residential electricity into 2013 constant dollars. Then make a graph of the years and
the prices in constant dollars. Paste this graph here. [4 pts]
b. Look at the actual prices for the years 2000 to 2004. During those years did the actual
price of electricity increase, decrease, or remain the same? [1 pt]
c. Now look at the constant dollar values of the price of electricity for the years 2000 to
2004 (either on the table or the graph). What do these values tell you about how the
actual prices changed in those years? [2 pts]
10. In an effort to save money on your electric bill, you decide to upgrade your appliances to
more energy-efficient models. After researching Consumer Reports "Green Buying Guide," you
buy a new washer/dryer, refrigerator, dishwasher, air conditioner, and vacuum. These new
appliances cost a total of \$9,000. You do not have quite enough money now, so you make a
down payment of 15% of the cost and take out a loan for the rest with a 3 year loan that has a
6.5% APR.
a. What is the loan amount? [2 pts]
b. What is your monthly payment for the loan? [3 pts]
c. What is the total paid back over the course of this loan? [2 pts]
d. What is the total interest you paid on this loan? [2 pts]
e. The total paid back for the loan is what percent greater than the loan amount? [2 pts]

When finished, submit both this document with answers and your excel file to Blackboard.
Thank you for your hard work this semester!
All data in this exam is from the following sources:
Statistical Abstract of the US
US Census Bureau (census.gov)
Energy Information Administration of the US (eia.gov)
American Wind Energy Association (awea.org).

Get a 30 % discount on an order above \$ 100
Use the following coupon code:
RESEARCH
Positive SSL