Determine the coefficient of determination

Reference no: EM13127992

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)
27 30
44 19
32 24
47 13
23 29
40 17
34 21
52 14

A) 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?

Reference no: EM13127992

Questions Cloud

Investments in current assets section : Fulton will report investments in its current assets section of :

Evaluate the proposal to purchase advanced machine : Calculate the payback period if advanced machine is purchased and calculate the net present value if advanced machine is purchased.

How many times faster will the reaction go : For the first-order reaction 2N2O5 ---> 2N2O4 + O2, the activation energy is 106kJ/mol. How many times faster will the reaction go at 100 degrees C than at 25 degrees C?

What are the income statement, balance sheet : Assume Grant uses straight-line depreciation. What are the income statement, balance sheet, and statement of cash flow effects for 2006?

Determine the coefficient of determination : Determine the coefficient of determination (Use Megastat or Excel, Tools, Data Analysis, Regression function). Interpret the result.

Illustrate what amount of cash disbursements for insurance : Illustrate what amount of cash disbursements for insurance would be reported in Walsh's 2008 net cash provided by operating activities presen ted on a direct basis?

What is the final temperature of the water : 2K(s)+2H2O(l)--> 2KOH(aq) + H2(g) A 5.00 g chunk of potassium is dropped into 1.00 kg water at 24 deg C. What is the final temperature of the water after the preceding reaction occur.

Use chain rule for first three derivatives : I need to know how to find first 3 derivatives for f(x) = cos(sq) 2X. I am able to find derivatives for similar problems, but the 2X portion is throwing me off.

Illustrate what should shorebuck do : Latte has a unit contribution margin of $45 and takes three machine hours to make and cappuccino has a unit contribution margin of $32 and takes two machine hours to make. There are 1,200 machine hours available to manufacture a product. Illustra..

User Account

All Pages