Excel Project Answer Sheet (week 5:part 1)

Excel Project Answer Sheet

Part 1: Weighted Average

1. Compute BY HAND the final course grade for a student with the given scores below.

a.       SHOW ALL WORK. Remember that this is weighted average.

20(82) +20(86) +10(85) +15(77) +11.67(88) +11.67(75) +11.66(92) =83.3993

b.      Round your answer to nearest hundredth.

Answer =83.40

2. Nicholas Hall is a student in MTH 154 who earned the following grades during the semester (listed below).

What is the lowest grade he could earn on Test 3 and still earn a C (70) for the course?

a.       Algebraically calculate the grade needed for test 3 in order to earn a C (70), showing ALL work below. Round your final answer to the nearest tenth.

20(64.1) + .20(56.43) +.15(80) +.45(65.33) +65.5045

3. Use your Excel file to verify the grades listed above, and show that Nicholas earns a C (70) overall grade with the test 3 score you calculated.

4. Is it possible for Nicholas to improve his score?

a. Using your test #3 score from #2, is it possible for Nicholas to pull his grade up from a C (70) to a B

(80) just by improving his homework score? (Use your excel table to adjust the scores and see if this is possible.)

b. Using the scores from your Excel table, hand calculate Nicholas’ final grade and see if it is possible for him to earn a B. Explain why it is or is not possible.

Yes, if he can average 1.3125 more of a percent he can

Part 2: Weekly Earnings

1.      The relationship between time and median weekly earnings is: (Circle one): Linear  Exponential

2.       State your observations about the actual data compared to the trendline (give some clarity as to the relationship between the data points and the trendline).

Answer: The equation is linear with a Trendline which appropriately reflects growth pattern of data graphed. It closely follows the trendline with minor fluctuations as the data is going over and under the trendline.

3.      Show your work and state the results of using Excel-generated trendline equation to predict median weekly earnings in 2030 (keep in mind that the data for this example used the entire year as the x-values, not “years since ___”). 2030

y = 20.306x - 39776

Y=median earnings

 x=year

y = 20.306x – 39776

20.306*2030 – 39776=1445.18

Y=1445.18

Therefore, the Predicted median weekly earnings in 2030 is $1445.18

 

4.      Using your Excel-generated trendline equation, during what year would a person expect to earn $1628? Show all work to support your answer. Year:

y = 20.306x – 39776

$1628=20.306x – 39776

1628+39776=20.306x

20.30x=41404

X=41404/20.30

X=2039

Therefore, a person is expected to earn $1628 by the year 2039

 

5.      Explain what real-world phenomena could affect median weekly earnings over time using a complete sentence

The median earning over time can be affected by natural disasters and competitors launching new products

 

Part 3: World Population

1. The relationship between time and world population is: (Circle one): Linear Exponential

2. State your observations about the actual data compared to the trendline (give some clarity as to the relationship between the data points and the trendline).

The actual data compared to the trendline shows an exponential relationship because it changes by a common ratio over equal intervals. The relationship is Exponential because the data follows the trendline but some of the data falls short of the trendline

3. Use the equation generated by Excel to predict the world population in the year 2030.

Show your work and state the results of using Excel-generated trendline equation to predict the world population in 2030 (keep in mind that the data for this example used the entire year as the x-values, not “years since ___”). 2030

y = 1.5283e^0.011x

X=2030

y = 1.5283e^0.011*2030

(0.011*2030)= 22.33

1.528e^22.33=7,619,371,254

Y=7,619,371,254

Therefore, the predicted world population in the year 2030 is 7,619,371,254

4. Explain what real-world phenomena could affect world population growth over time using a complete sentence.

Economic development, social and cultural factors, life expectancy and health care standards can affect population growth

Part 4: DJ’s Albums

1.      A DJ buys 7 new albums every week to keep her collection current. She currently owns 220 albums.

The relationship between # of weeks and # of albums is (Circle one): Linear         Exponential

2.      Write a recursive and explicit formula for the number of albums the DJ has after n weeks.

Recursive formula for number of albums after n weeks: P_n= 220+3*n

Explicit formula for the number of albums after n weeks: P_n=220+3(52)

3.      Based on your work in Excel, how many albums will she have after 1 year (52 weeks)? =376

4.      Using your explicit formula from question 2 above, during what week would the DJ acquire 745 albums. Show your algebraic calculation to support your answer.

220+3*n=754

223*n=745

=103 weeks

Therefore, the DJ would acquire 745 albums during week 103

Part 5: Fox Trot Problem

1.      The relationship between # of weeks and seconds of HW is :( Circle one): Linear    Exponential

2.      Write both a recursive and an explicit formula for the situation described.

Recursive formula for seconds of homework after n weeks: P _n = 2*(n-1)

 Explicit formula for the seconds of homework after n weeks: P n = 2^n*

3.      How many hours would you be spending on homework at the end of 30 weeks (n = 29)? *Round your answer to nearest hundredth.

Time: 298261.62 hours

Would you agree to this? Yes/No: NO

4.      How many minutes would you spend at the end of 12 weeks (n = 11)? *Round your answer to nearest hundredth.

Time: 68.26 minutes

 Keeping in mind the amount of homework done in Week 1, Week 2, etc., would you agree to this? Yes/No