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

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

#### Non-dimensionalising Differential Equations

Two species with populations N1(t) and N2(t) interact according to the model: (dN_1/d_t)=r_1N_1(1-(N_1/K_1) - b_12(N_2/K_1), (dN_2/d_t)=r_2N_2(1-b_21(N_1/K_2), Non-dimensionalise the system (7) so that: (d_u/d_t) = u (1- u - au), (d_u/d_t) = pv (1-Bu), finding explicit formulae for t...

#### Algebra: Elimination and Substitution Methods

1. Solve the following system of equations using the Substitution method: 5X-7Y= - 18 4X+3Y= 20 2. Solve the following system of equations using the elimination method: 2X-3Y=12 -2X+3Y=12 Solution: Computation of the Equations 2X-3Y =12 -2X+3Y =12 3. A total of \$80,000 is invested in ...

#### Graph rational equation

A. Graph the function  =  f(x) = x-2/x^2 - 3x + 2 B. Find the domain and range of , showing all work. C. Find the → , showing all work, or explain why the limit does not exist. D. Find the → , showing all work, or explain why the limit does not exist. E. Apply th...

#### Solving an example linear programming question

1. A component has a reliability of 0.75. How many identical components do we have to add n parallel to the frst to increase the overall reliability to 0.95? You may use the following general formulas R_sys = 1-(1-R1)(1-R2)...(1-Ri)...(1-Rn) Ri=e^-(lamda*t) 2. Find both the minimum and maximu...