for michael smith only

profilePROFESSOR CALLEN

Open the Microsoft® Excel® file you created in Week 3 with the best fit line.

Select "Save As" to create a new version of this workbook.

Delete your commentary from Week 3 and add new commentary per below:

Answer the following in 175 to 260 words in your commentary:

  1. How does the graph of a line compare to an arithmetic sequence? What does the slope represent? How would you find the first term? 
  2. Use your best fit equation to make a formula for the nth term of an arithmetic sequence. The year will represent the number of the term, and your data value will be the value at that term.
  3. Use your arithmetic equation to predict what the 2,050th term will be. Do you think this is a good estimate of what the real value will be? Why or why not?

Challenge Option

Open your Microsoft® Excel® file from Week 2 with your exponential graph.

Click "Save As" to create a new version of this file.

Delete the old commentary.

Answer the following by adding new commentary:

  1. How does the graph of an exponential equation compare to a geometric sequence? How would you find the common ratio? How would you find the first term (assuming the year is the number of the term)? 
  2. Use your best fit equation to make a formula for the nth term of a geometric sequence. The year will represent the number of the term, and your data value will be the value at that term.
  3. Use your geometric equation to predict what the 2,050th term will be. Do you think this is a good estimate of what the real value will be? Why or why not?

Create a Microsoft® PowerPoint® presentation and include the following:

  • One slide (Introduction) on your topic and question
    • Which topic/question did you choose?
    • Why does it interest you?
    • Where did you find the data?
  • One slide for each graphic (minimum of 3 graphics)
    • These should be clear, neat, organized, and labeled
    • Explain how you created these and show your answers to the previous weeks questions in the notes section of your slide
    • What did you conclude in each week?
  • One slide for a conclusion
    • Restate your topic and question, and give your answer to the question.
    • Show which model you chose that best fits your data and explain why.
    • Make a prediction about a future value based on your model and equation

 

 

    • 7 years ago
    • 25
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      challenge_option.xlsx
    • attachment
      week_3_discussion.xlsx
    • attachment
      data_representation.pptx