Part 4: DJ's Albums The relationship between # of weeks and # of albums is:(Circle one) Linear Exponential 1. Po-itid Recursive formula for number of albums after n weeks: 2. P = Explicit formula for the number of albums after n weeks: P = 6. %3D Based on your work in Excel, how many albums will she have after 1 year (52 weeks)? 8. Click on the Activity 3 tab at the bottom of the screen in Excel to proceed. Part 4: DJ's Albums Determine whether a real world situation describes linear or exponential growth Write a recursive formula to model the growth of a real world problem. Write an explicit formula to model the growth of a real world problem. Use the recursive and explicit formulas to predict future values. Math Objectives: Excel Objectives: Use Excel to create a table, Enter a formula that uses data from the table to compute a value. Use excel to continue a pattern in a table without typing each cell individually. Copy and paste the formula to continue a pattern in a table. A DJ buys 3 new albums every week to keep her collection current. She currently owns 300 albums. How many albums will she own one year from now? 1. Reread the problem and determine whether the situation describes linear or exponential growth. Circle your answer on the provided answer sheet. 2. On the provided answer sheet, write a recursive formula for the number of albums the DJ has after n weeks. 3. EXCEL: You will use Excel to create a table that shows the total number of albums the DJ has each week. Enter her current (initial) number of albums in cell B3. 4. EXCEL: Column A will show the number of weeks from now. Rather than typing the numbers 1 through 52, highlight cells A3 through A6, then move the mouse onto the box on the bottom right hand corner of your highlighted block until it turns to a solid cross, +. Click the cross and pull down to the rows below in order to continue the pattern. This is a very useful feature of Excel. EXCEL: Column B will show the current number of albums. Click on cell B4, and type a formula that gives the number of albums the DJ owns 1 week later. (Remember to begin with an = sign to tell Excel that you are writing a formula.) In your formula, use the location of the cell containing the value that you want in order to refer to that value (don't just type the number). Once you have checked that your formula makes sense, highlight B4, click the bottom right hand corner (make sure it shows the solid cross, +), and drag down to continue the pattern to the rest of the cells. You can click on a different cell in Column B and see how the formula has changed. 5. %3D 6. While Excel makes things easier by allowing us to drag to continue a pattern, we still really didn't need to compute all of the data for weeks 1 through 51 if we actually only need to know about week 52. If we had instead come up with an explicit formula, we could have just filled in one row to get our answer. Reread the problem to determine P, and write an explicit formula for the number of albums the DJ has after n weeks on the provided answer sheet.