Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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? Reread the problem and discuss with your group whether the situation describes linear or exponential growth. Circle one below: 1. Exponential 2. Write a recursive formula for the number of albums the DJ has after n weeks. 3. 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. 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 5. 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 6. Use the data computed in Excel to answer the question. (I should be able to click on the cell for Week 52 and see a formula that is computing the value shown). How many albums will the DJ own 1 year from now? 7. 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 8. Enter the value of P in cell F3. Enter your explicit formula in cell F4, remembering to begin with an - and to either type or click the cell locations containing your P and your n in order to write the formula Check to make sure you get the same value as when you used the recursive formula

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance

Authors: John P. Wiedemer

8th Edition

0324142900, 9780324142907

More Books

Students also viewed these Finance questions