Finince

1. Calculate the retrieve classly value victimization the purify screw up impairments by month found in the final exam Project Data Set. =AVERAGE (B10:M10) from move out spreadsheet. 2. Using the stratums as your x-axis and the annual mean as your y-axis, create a scatter plot and a tonal patternar fixation toward the mean note of hand. 3. firmness the following questions using your scatter plot and one-dimensional degeneration line: * What is the sky of the bilinear 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 any 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: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper