Excel Project Answer Sheet

pdf

School

John Tyler Community College *

*We aren’t endorsed by this school

Course

154

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by bobpalmer04

[Part 1: Weighted Average| OfL+ 10-§6+ 10 B+ ————— Excel Project Answer Sheet a. SHOW ALL WORK. Remember that this is weighted average. b. Round your answer to nearest hundredth. - . 1. Compute BY HAND the final course grade for a student with the given scores below. o TN BB LL TS WLe-92=8310.09/ | 9o =83 4004 / [/ o/ /} Quiz Ave fa ge { \ / Excel Project {\ . (/8 Homework Average 82 86 85 Finance Project 77 Tests 88, 75,92 . 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? **Reminder that the lowest homework and lowest quiz grade are dropped in this course. 205\ 20680 U XBH*@% 79+%-5 'lj\°2§ “X=T70006 a, GOIR. L6 Category Grades s U0 | Homework 373{2&33,{0:«39,*190,*4_5;\5;,41;"8,*5;:5525 / Q= 5@ I\ 20| Quiz \ 0| Excel Project 82)86472,'53, 0, 68, 43, 100, 66, 42 74 ! i ) \S| Finance Project 78 5/ Wi Tests ne 79,57 él2/Cl 2 é% a. Algebraically calculate the grade needed for test 3 in order to earn a C (70), showing ALL wark below. Round your final answer to the nearest tenth. 60\\2.%% (P .,,@_35_)( =T1000 e

/ 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. /a. (NOTE: Do NOT replace your weighted average work from step 2 and 3, create a new table with the new data). b. Copy and paste the original table to a new area on the sheet, and put in the new data. 4. Is i7possible 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 tl'zis igpozs\i/ble.) U%\(\b 3(\,\& A«ﬂ)ﬂ)\ Eyf,\' g(w’\ [E=2 a’w‘\f}\ e ’\{c‘::)r ?’) Scove O‘P @ BNl eVeR (T, W00%, O all of Wi Yome il Nitholas wWeuld net Be alle Yo (ase nis (adl Yo o @%\ b. Using the scores from your Excel ta%e, hand calculatev&ic olas’ final grade and see if it is possible | for him to earn a B. Explain why it is or is not possible. | %gifigo \XY ifi\’\DX' @bfifi\k\fi o N{C\'\0\°~5 to (e 1074 s «C‘iv&m\f (&5\@ To Of C’\\OG\/& o %(fo) {%;71:3( N NP Ypepue of bhe vest of {\.“55-51 hio low Scores Such as Wi quirses Hm’%L\ 1 PXnY Ny 3555%&;‘} ;

PPart 2: Weekly Earnings| —TN /1. The relationship between time and median weekly earnings is: (Circle one): Ginearj Exponential / 2. State your observations about the actual data compared to the trendline (give some clarity as to the , AR | relationship between the data points and .‘t;he trendline).T e D\C‘st el shodrea, A\OU.;V\ I B 2 4 | ‘@Of%f—jr\\j Ling v \jSmr\ Yol bvend \ine Setieey Fhgh Mnere were Vears ook Yo medion wed Ay e.,mii_ S o) i\oww (or Y Previoud Veal of pearl, Shed Fhe Some despile Nok FWe Yyendiing doet. tens Yo YaeXn bae e | SeX (odtwer \well. ] ) 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 vear as the x-values, m.:t ”yezir:ssince“’}. \' = \Q%O}X_SQHD | 2030 JOAT Del Weg) ™= (eet) . Soo ool CTAME Y 14907 (20730) - 38330 e UDOR. A\ ~2g390 = 1173, 7\ 4. Using your Excel-generated trendline equation, during what year would a person expect to earn $1628? Show all work to support your answer. e b /Yéar: !— 11314 80% % K30 Qe dOHO 30%: »%sfigz 14.807-X 49300 40 S 04X i AOND.04= X 0.5 . /5. Explain what real-world phenomena ¢ould affect median weekly earnings ovet time using a complete £ p ‘ sentence. ‘v\‘)\sc\f\GN\ﬂV\m Sudla a4 wndladion | CLOnaiL '?Y‘)g'f)mh, o ad+amg\k,ow \ JEQ,K\\?\{‘% ﬂ{;fim:a\i?e?\\;vv\'\ g\,\t \aoof Marked have the b Y Lo od Yok medion Phe demand $or Joho of specific S s Whieh can then ok Wi S pondd émfi ¥ of ko o < idd @ loum hunitics, Part 3: World Population] Plowment ofPartonitics | Jf The relationship between time and world population is: (Circle one): Linear xponential /. 2. State your observations about the actual data compared to the trendli&e (give some clarity as to the é&&@fon ship between the data points and the trendline).T\/\g, Yren \\hc Heems gy b e f cfi‘v\U‘/ o€ YWe SLterPlot Lo eXamPle 1y 2017 he \oor Aok Pots o ke D V\&J (0@ e Teend\ine Seems g e L BWon o6 Yne olal Volde. AN WS A fefaniey Thiodaive, Vo ‘ | /,, XR’EZ\ (;;Yv\v\i Vedol 5\10\20 w\\b{\ Ao *«w‘-\v?go&f gu'.\‘i uz\r\&\v.\l;fi (_i\gu,'«\&fix b " When generating an 3. Use the equation generated by Excel to predict the world population in the year 2030. exponential r’nodel,‘ Show your work and state the results of using Excel-generated trendline equation to Excel uses the number predict the world population in 2030 (keep in mind that the data for this example used | “€”inthe base of the the entire year as the x-values, not “years since__*). formula. The value of 8.0V eis approximately \/ =\ S18% ¢ (yend 271898 Forvour 2030 6JORLT205 feofle) (ppicien Sleulations, you can i Y either use this 0.011"%030 5 : T LAy \ . 51%{?) e =FH108 604 6319} approximate value, or 5o okl Lram cealty A use the e* button on ~ 4. Explain what real-world phenomena could affect world population growth over time your calculator. [ % using a complete sentence. "‘ﬂ\oﬂe\'\u Sutin ol oaless Yo ;,\ah%mev ; . . imProvemenke n Sowihelion, Fecility (2%es | economic AT AT TN, mgdion, Wl and, ‘(V\Oflvc»\\!(\‘ eSS o o\ odlect QoPuledion oWty aver Fin \ e WNLleobiney e wgmeel ok oitng and, Oeerensing Ne Nowper of Aece(»:/, ~——mma s

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

/ 1. ADJbuys 7 new albums every week to keep her collection current. She eurrently owns 220 albums. . The relationship between # of weeks and # of albums is (Circle one): @ Exponential / 2. Write a recursive and explicit formula for the number of albums the DJ has after n weeks. P=200 i Explicit formula for the number of albums after n weeks{'ﬂ s P B 4 3. Based on your work in Excel, how many albums will she have after 1 year {52 weeks)g/, uy l 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. s D\’)\D*‘l\’\ 145 Week:v]B \} -0 2.0 — = 5 = In= 582 5 =15 IPjrt 5: Fox Trot Problem o s / 1. The relationship between # of weeks and seconds of HW is: (Circle one): Linear ( Exponential j 2. Write both a recursive and an explicit formula for the situation descnbed J Recursive formula for seconds of homework after n weeks:?\P,l = h-1 | 3. How many hours would you be spending on homework at the end of 30 weeks (n=29)? *Round your answer to nearest hundredth. e Come 10 %\wm o A Would you agree to thls7 Yes/No N 'f 4. How many minutes would you spend at the end of 12 weeks (n = 11)? *Round your answer tc nearest hundredth. et 35 e, Tlme E\—\ \Ib Mome m)\’té w«"’ p——— Keepmg nd the amount of homework done in Week 1, Week 2, etc., would you agree to this? -,:/ Yes/No ““ Zw

Excel Project Answer Sheet

Related Documents