Finince

1. Calculate the mean yearly value using the clean screw up prices by month found in the final exam Project Data Set.

=AVERAGE (B10:M10) from jump out spreadsheet.
2. Using the years as your x-axis and the annual mean as your y-axis, create a scatter plot and a linear fixation toward the mean line.

3. firmness the following questions using your scatter plot and linear regression line:
* What is the slope of the linear regression line?
* 0.0674 =SLOPE(N10:N39,A10:A39) from EXCEL spreadsheet
* What is the Y-intercept of the linear regression line?
* -127.6435 =INTERCEPT(N10:N39,A10:A39) from Excel spreadsheet
* What is the equation of the linear regression line in slope-intercept form?
* y = 0.0647x 127.6435
* ground on the linear regression line, what would be an estimated cost of gas in the year 2020?
* Estimated Cost of Gas for 2020 = 3.098
* What are the residuals of from each one year?
Annual| Residual|
1.296| -0.657|
1.241| -0.538|
1.212| -0.445|
1.202| -0.369|
0.927| -0.030|
0.948| 0.013|
0.946| 0.080|
1.022| 0.069|
1.164| -0.008|
1.140| 0.081|
1.127| 0.159|
1.108| 0.242|
1.112| 0.303|
1.147| 0.332|
1.231| 0.313|
1.234| 0.375|
1.059| 0.614|
1.165| 0.573|
1.



510| 0.293|
1.461| 0.407|
1.358| 0.575|
1.591| 0.407|
1.880| 0.182|
2.295| -0.169|
2.589| -0.397|
2.801| -0.544|
3.266| -0.945|
2.350| 0.036|
2.788| -0.337|
3.129| -0.614|

* Select a received price that you have seen or paid recently for gas.
* $3.99 a gallon in Salem Virginia
* Is that price within the align of the linear regression line or is it an outlier?
* It is an outlier, the max regression line was 2.515
* Is it within the confidence interval of 5% or either end?
* No, the $3.99 is 31.03% greater than the regression line.If you want to come up a full essay, order it on our website: Orderessay



If you want to get a full essay, wisit our page: write my essay .