Badgers are being monitored to ensure that their population is healthy and growing. Use Microsoft Excel's =TREND and =SLOPE functions and the following data to calculate your answer to the questions: Year 2010 = Population 12900 ; 2011 = 13300 ; 2012 = 19600 ; 2013 = 19200 ; 2014 = 21300 ; 2015 = 23200. a) Given the data above, and assuming a stable environment, what will the population be in the year 2018? (rounded to the nearest whole number, no commas). b) How fast is their population growing per year? (rounded to the nearest whole number, no commas)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter14: Data Mining
Section14.2: Classification Methods
Problem 3P
icon
Related questions
Question
Badgers are being monitored to ensure that their population is healthy and growing.
Use Microsoft Excel's =TREND and =SLOPE functions and the following data to calculate your answer to the questions:
Year 2010 = Population 12900 ; 2011 = 13300 ; 2012 = 19600 ; 2013 = 19200 ; 2014 = 21300 ; 2015 = 23200.
a) Given the data above, and assuming a stable environment, what will the population be in the year 2018? (rounded to the nearest whole number, no commas).
b) How fast is their population growing per year? (rounded to the nearest whole number, no commas)
Transcribed Image Text:Badgers are being monitored to ensure that their population is healthy and growing. Use Microsoft Excel's =TREND and =SLOPE functions and the following data to calculate your answer to the questions: Year 2010 = Population 12900 ; 2011 = 13300 ; 2012 = 19600 ; 2013 = 19200 ; 2014 = 21300 ; 2015 = 23200. a) Given the data above, and assuming a stable environment, what will the population be in the year 2018? (rounded to the nearest whole number, no commas). b) How fast is their population growing per year? (rounded to the nearest whole number, no commas)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L