Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a plot with Rate as the y variable and date as the x variable. Include the equation and R2 in the plot. Create a
Create a plot with "Rate" as the y variable and "date" as the x variable. Include the equation and R2 in the plot. Create a new variable for X which is the sequence of 1 through the last "Date" value. This can be created in the column next to the "Rate" variable. Then, do a linear regression with "rate" as the Y variable and the new column of values you created for X. You do not have to plot this new data. Record the confidence interval for the slope. Is the slope significantly negative?
Date | Rate |
2014 Jan | 6.6 |
2014 Feb | 6.7 |
2014 Mar | 6.7 |
2014 Apr | 6.2 |
2014 May | 6.2 |
2014 Jun | 6.1 |
2014 Jul | 6.2 |
2014 Aug | 6.2 |
2014 Sep | 6.0 |
2014 Oct | 5.7 |
2014 Nov | 5.8 |
2014 Dec | 5.6 |
2015 Jan | 5.7 |
2015 Feb | 5.5 |
2015 Mar | 5.5 |
2015 Apr | 5.4 |
2015 May | 5.5 |
2015 Jun | 5.3 |
2015 Jul | 5.3 |
2015 Aug | 5.1 |
2015 Sep | 5.1 |
2015 Oct | 5.0 |
2015 Nov | 5.0 |
2015 Dec | 5.0 |
2016 Jan | 4.9 |
2016 Feb | 4.9 |
2016 Mar | 5.0 |
2016 Apr | 5.0 |
2016 May | 4.7 |
2016 Jun | 4.9 |
2016 Jul | 4.9 |
2016 Aug | 4.9 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started