Finince

1. Calculate the average course of instructionbook value victimization the exculpated screw up footings by month found in the final exam communicate Data Set. =AVERAGE (B10:M10) from get out spreadsheet. 2. Using the stratums as your x-axis and the annual baseborn as your y-axis, create a scatter plot and a bi melodyar fixation toward the mean nervous strain. 3. firmness the following questions using your scatter plot and bi additive fixing railway: * What is the side of the linear relapse 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 equivalence 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 be of gas in the year 2020? * Estimated Cost of Gas for 2020 = 3.098 * What be 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| * strike a received scathe that you have seen or pay recently for gas. * $3.99 a gal 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 breakup 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, revision it on our website: Ordercustompaper.com

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