i need help solving these problems and creating a scatter plot of the data and apply linear model 1

SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

  1. Year People Arrested for Drug Possession
    2006 1,519,760
    2007 1,361,658
    2008 1,321,824
    2009 1,387,915
    2010 1,179,728
    2011 1,143,931
    2012 1,237,708
    2013 1,203,323
    2014 982,169
    2015 801,560
    2018 258,244
  2. Create at least two visuals using your data from the data you chose in Week 2.
    1. Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.
    2. Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.
    3. Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data.

    Hints for Making an Effective Chart:

    • Decide why you are making a chart from this data.
    • Title each chart so that it aligns with the data and selected model.
    • Create descriptive labels for both the x- and y axes.
    • Resize the chart as needed so it can be viewed easily.

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net