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.

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
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.
Transcribed Image Text: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.
Transcribed Image Text: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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,