Do heavier cars use more gasoline? If so, can we predict the mileage rating of a car given its weight? Suppose 8 cars were randomly chosen and their weights (in hundreds of pounds) and mileage rating (mpg) are recorded.Weight (x)MPG (y)273044193224471323294017 34215214A)If we want to estimate gas consumption based on the weight of car, which variable is the dependent variable and which is the independent variable?B)Draw a scatter diagram ([first input you data in excel column A & B. Use MegaStat, correlation/regression, scatterplot or use Excel, Tools, data analysis, regression function to answer questions c-e].C)What is the value of coefficient of correlation (Use Megastat or Excel, Tools, Data Analysis, Regression function). Is there a linear relationship between the two variables? If so, how strong is the relationship?D)Determine the coefficient of determination (Use Megastat or Excel, Tools, Data Analysis, Regression function). Interpret the result.E)Write the simple linear regression equation for the least square regression line that shows the relationship between weight of cars and gas consumption (use Megastat or Excel regression coefficients table).F) Interpret the meanings of regression coefficients (slope and intercept) in the above equation.G)Predict the mileage rating for a car that weighs 6000 pounds?