#### Currency Excel Project

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 Excel Project

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...

#### Exponential Growth Model Algebra Examples

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...

#### Excel of the Planets

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...

#### Solving a system of linear equations: median income

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 ...

#### Lines Excel

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...

#### Urban and Rural Excel

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...

#### Earth Excel

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 length of one side in a similar triangle

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...

#### Excel--Heart Rate

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...

#### Marriage and Divorce Rates: Excel

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...

#### Excel GPA

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...

#### Conversions: Length, Mass, Volume, and Speed

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...

#### Scientific Notation Problems

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...

#### Finding the probabilities of events

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...

#### Emile's Inheritance

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...

#### Simple volume of a cylinder with unit conversion.

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...

#### Problems of Polynomials

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 ...

#### Vector Calculus and Linear Algebra

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 ...

#### Applied Algebra: Minting Pennies

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 ...

#### Variance on Shelter Sample Data

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...