Currency
Project Description:
In this problem, you will convert one currency to another using the assumed exchange rates.
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values.
1) Start Excel. Download and open t...

Continents
Project Description:
In this problem, you will investigate the area and populations of the 7 continents. You will also provide the results as a pie chart.
1) Start Excel. Download and open the workbook named: Chapter_2-6_Continents_Start
2) In cell B14, calculate the total land area...

1. The population of a city was 124 thousand in 1992. The exponential growth rate was 1.6% per year. Use the exponential growth model p0e^kt.
a) Find the exponential growth function in terms of t, where t is the number of years since 1992.
p(t)=
2. The length of the instruction book for a count...

Calculate the orbital radii in different units for all the planets. You will also provide the results as a bar chart.
Use a cell reference or a single formula where appropriate. Do not copy and paste values or type values.
Steps to Perform:
1 Start Excel. Download and open the workbook named:...

Weighted Grade Book Project
Due Date:
Understanding how weighted averages work will be a very important topic for you in this course, since your grades are determined in this way. In this project, you will create an Excel spreadsheet that can calculate a student's final grade in a course. You wi...

On the basis of data from 1990 to 2006, the median income y in year x for men and women is approximated by the equations given below, where x=0 corresponds to 1990 and y is in constant 2006 dollars. If these equations remain valid in the future, in what year will the median income of men and women ...

This problem has you compare various linear functions.
a) Enter formulas for the 5 different linear functions which can be filled down that will output the appropriate y-value for the given x-values.
b) What is the y-intercept of each function? Answer should be a number.
c) Which slope from the 5...

The spreadsheet lists the population in the United States and also the percent urban/rural.
a.) Compute the total change and % change in U.S. population for each decade.
b.) Compute the actual urban population and rural population for each year.
c.) Make a stacked area chart of the urb...

The area covered by each of the Earth's oceans and by each of the continents is given (Continents: https://en.wikipedia.org/wiki/Continent Oceans: http://www.worldatlas.com/aatlas/infopage/oceans.htm ).
a.) Compute the total area covered by land. Convert the areas of continents and the tot...

Find the unknown lengths in the pair of similar triangles. (Triangles are not drawn to scale. Assume corresponding sides are in the same position within each triangle.)
a ------- cm (Simplify your answer.)
Find the unknown lengths in the pair of similar triangles.
a --------- mm
Find th...

Chapter 1-1 Heart Rate
Project Description:
In this problem, you will investigate the heart rate at different ages. You will also provide the results as a column chart. Use a cell reference or a single formula where appropriate.
Steps to Perform:
1 Start Excel. Download and open the workbook...

In this problem, you will investigate both marriage and divorce rates for the United States per 1,000 people in the population. You will also provide the results as a scatter chart.
1) Start Excel. Download and open the workbook named: Chapter_5-7_Marriage_Start
2) In cells D32:K46, insert a Sca...

Using the student grade data given to compute the Grade Point Average (GPA):
a.) Enter a formula in cell E2 which multiplies the Credits times the 4 Point Scale, this product gives Quality Points. Fill the formula down.
b.) Sum the Credits and the Quality Points.
c.) Compute the GPA by div...

Convert units for length, mass, volume, and speed using the given ratio tables. In particular, use mixed and absolute cell references so that your formulas are able to be filled across each row. Format all answers to 2 decimal places.
a.) Convert inches, feet, yards, centimeters, and meters t...

Section 3: Scientific Notation
1. How many one hundred dollar bills would you need to have ten thousand dollars? Explain.
2. How many 1,000 are there in 10 billion? Explain.
3. Explain in your own words:
a. How to convert a standard number to scientific notation.
b. How to convert a numb...

Per Capita
1) The National Oceanic and Atmospheric Administration (NOAA) reported that there are 17.8 million feet of Atlantic coastline in the state of North Carolina. If the population of North Caroline is approximately 9.5 million, find the number of feet of coastline per capita in North Carol...

Boys and Girls
A couple plans to have two children.
a) Determine the number of sample points in the sample space of the possible arrangements of bous and girls.
b) Construct a tree diagram and list the sample space.
Assuming that boys and girls are equally likely, determine the probability th...

Brenna's mom, Mrs. Herstone, is watching Brenna playing at the park. Some children are pushing Brenna around the merry-go-round. Mrs. Herstone decides to take some data, so she started her stopwatch. At 3.5 seconds Brenna is farthest from Mrs. Herstone 26 feet away. When the stopwatch reads 4.2...

Emile got a letter in the mail saying that a wealthy relative had left him an inheritance. At a meeting the next week, a lawyer read the following statement.
To Emile, because he likes math problems, I leave a choice. He can have one of two inheritances. He must make his choice before leavin...

Since this module focuses on measurement it will be very important that mathematical conversions be clearly demonstrated throughout your problem write-up. For example, if you are converting 28 yards to meters, you must track your calculations with cancellation of units as seen below:
28 yards t...

A downtown employee is looking for the best option for parking a car during a 5 day work week. One parking garage offers unlimited parking at a flat rate per month. Another garage offers an hourly rate for parking. Which option is best for the employee on a monthly basis?
Consider that the employ...

Suppose {e_t} and {E_t} are two independent white noise processes with variance sigma^2 and sigma^2_e respectively.
(a) Show that {v_t = e_tE_(t-1)} is also a white noise and calculate its variance.
(b) Show that y_t = v_t - 0.5_(vt-1) + 3e_(t-1) is stationary.

1. Write a function whose graph is the graph of y = (x+2)^2, but is refelcted about the x-axis.
2. Determine whether the given function is linear or nonlinear? If the function is linear, determine the slope.
x y = f(x)
1 -12
2 -7
3 -5
4 -4
5 -5
3. Form ...

Find an equation of the exponential function y=g(x) , whose graph passes through the 2 given points.
a) (0,5) (3,9)
b) (2,24) (4,8)
Please show how you got the answer.
And find a equation of the linear function y=f(x) for the same points.

Please help answer the following questions:
1. Find all intercepts of the function f(x)=4x^3-7x^2-16x+28 . For each intercept, show your algebra, then state the intercept using correct function notation and as an ordered pair. Clearly state whether the intercept is an x-intercept or a y-intercep...

Question 4
Find the work done by the force
F (x,y,z) = -x^2y^3 i + 4j + xk
on moving charged electric particle along the path given by the equation
r (t) = 2cos t i + 2sintj + 4k,
where the parameter t varies from pi/4 to 7pi/4.
Question 5
Displacement of the spring system with friction ...

6. Owing to the rising cost of copper, in 1982, the US Mint changed the composition of pennies from 95% Copper + 5% Zinc to 2.5% Copper + 97.5% Zinc to save money in minting pennies. Your favourite aunt has a collection of 5,000 pennies minted prior to 1982 and she intends on gifting the collection ...

You want to make a statement about the variability in the costs of personnel shelters. After collecting sample data (cost in $K) on 9 shelters you perform some preliminary calculations.
Given the information provided:
The coefficient of variation is about 17.64%
The variance is a...