Question

# Using Module 7 Excel Assignment regression data set: the relationship between Income Per Household and Quantity...

Using Module 7 Excel Assignment regression data set: the relationship between Income Per Household and Quantity Demanded of Heating Oil is:

Select one:

a. Depends on Income

b. Can not be determined

c. positive

d. negative

 Quantity Demanded of Heating Oil Income Per Household Price of Heating Oil 7.1 9 50 5.7 9 50 10.3 10 50 11.8 10 50 11.9 11 50 13.9 11 50 5.7 11 60 6.6 11 60 11.5 12 60 12.6 12 60 16.8 13 60 14.4 13 60 13.2 13 70 9.7 13 70 16 14 70 9.3 14 70 19 15 70 21.5 15 70 11.3 15 80 15.6 15 80 15.6 16 80 15.8 16 80 21.7 17 80 20.9 17 80 Quantity Demanded of Heating Oil is the dependent variable

The correct answer is option C

-------------------------------------------------------------------------------------------------------------------------------

To understand the relationship between quantity demanded of heating oil and income per household, we have to perform a regression analysis between the two variables.

The regression equation is given as

y = b0 + b1 X

where b0 = intercept

b1 = slope

y = dependent variable = Quantity Demanded of Heating Oil

x = independent variable = Income Per Household

The regression analysis is done using excel and the values of b0 and b1 are determined.

b0 = - 6.53

b1 = 1.52

The regression equation becomes

y = - 6.53 + 1.52 X

From the above equation , we observe that the coefficient of the independent variable is positive which means that as income increases, the quantity demanded of heating oil also increases. Thus the dependent variable and the independent variable have a positive relationship.  #### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### can u clearly show me how to find a sample size (N) , A2, and can... can u clearly show me how to find a sample size (N) , A2, and can you also tell me why we are using an X Chart? Problem 1 A restaurant wants to control kitchen preparation time of dinner meals using an X chart. The process standard deviation is unknown. Each evening a manager takes a random sample of 14 dinner orders and measures and records their kitchen preparation time. Create an X Chart using data in the table below...

• ### 30 Price or eating Oil (Dollars per barrel) Quantity Demanded (Thousands of barrels per day) 100... 30 Price or eating Oil (Dollars per barrel) Quantity Demanded (Thousands of barrels per day) 100 60 Quantity Supplied (Thousands of barrels per day) PRICE (Dollars per barrel) Demand Shifters Supply Shifters Gas Cost of Crude Oil (Per barrel of heating on Price of Natural (Dollars per 1,000 cubicit) Price of an Oil Furnace (Dollars per furnace) Average Annual Income (Thousands of dollars) 2000 Cost of Refining of (Per barrel of heating oil) 20 40 60 80 100 120 140...

• ### 4. Understanding changes In equillbrium price and quantity Aa Aa Suppose you are an analyst in... 4. Understanding changes In equillbrium price and quantity Aa Aa Suppose you are an analyst in the oil refinery industry and are responsible for estimating the equilibrium price and quantity of home heating oil. To do so, you must consider factors that can affect the supply of and demand for heating oil. Determinants of the demand for heating oll include household income, the price of an oil furnace (a complement to heating oil), and the price of natural gas (a...

• ### EQUILIBRIUM CALCULATOR: MARKET FOR HEATING OIL PRICE (Dollars per barrel] 80 Price of Heating Oil 30... EQUILIBRIUM CALCULATOR: MARKET FOR HEATING OIL PRICE (Dollars per barrel] 80 Price of Heating Oil 30 Dollars per barrel) Quantity Demanded Thousands of barrels/day] Shortage 70 100 Quantity Supplied 60 60 Thousands of barrels/day) 50 40 Surplus Thousands of barrels/day) Thousands of barrels/day) 40 DEMAND SHIFTERS SUPPLY SHIFTERS 30 Price of Natural Gas [Dollars per 1,000 cubic ft.] Cost of Crude Oil Per barrel of heating oil] 10 25 20 Price of an Oil Furnace [Dollars per furnace] Cost of...

• ### correlations and linear regression education and income 3. Use the following data set and complete the table. (Inc... correlations and linear regression education and income 3. Use the following data set and complete the table. (Income is the dependent variable and education is the independent variable) Education (Years) I x -* Yi- } (x; - x)(y;-)) (x; -x² Income (\$1000) 15 46 13 17 58 46 13 10 40 63 15 18 11 9 11 15 45 12 50 16 9 14 48 58 14 16 50 11 a. Calculate x, y, and the standard deviations for both...

• ### Final Project For this assignment, use data from W1 Assignment. Using Minitab. Give instructions on how...

Final Project For this assignment, use data from W1 Assignment. Using Minitab. Give instructions on how to insert data into Minitab. This week, you will explore the hypothesis that higher levels of stress are associated with lower levels of confidence. Compute the correlation between the stress score and confidence scores. StressScore   Confidence 3   100 5   112 2   125 9   150 7   136 4   107 3   143 1   141 4   134 2   148 5   139 3   117 7   76 8   99...

• ### Create a scatterplot of Avg. Total Score vs. PPS with regression line. With Minitab, compute the...

Create a scatterplot of Avg. Total Score vs. PPS with regression line. With Minitab, compute the basic statistics needed to compute the equation of the regression line, then compute the equation by hand. (Include the Minitab print out of the basic statistics used in your computation and type the equation itself, but, remember, you do not have to include your by-hand computations in your paper.) More specifically how to do this operation on minitab express here is the data:   ...

• ### The excel file National Football League provides various data on professional football for one season.     Construct a scatter diagram for Points/Game and Yards/Game in the Excel file. Does there a...

The excel file National Football League provides various data on professional football for one season.     Construct a scatter diagram for Points/Game and Yards/Game in the Excel file. Does there appear to be a linear relationship? Develop a regression model for predicting Points/Game as a function of Yards/Game. Explain the statistical significance of the model. Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. National Football League Data 2007 Season Team Points/Game Yards/Game...

• ### The excel file National Football League provides various data on professional football for one season.     Construct...

The excel file National Football League provides various data on professional football for one season.     Construct a scatter diagram for Points/Game and Yards/Game in the Excel file. Does there appear to be a linear relationship? Develop a regression model for predicting Points/Game as a function of Yards/Game. Explain the statistical significance of the model. Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. National Football League Data 2007 Season Team Points/Game Yards/Game...

• ### Question 9 Figure 15-10 Price and cost per unit Po MC P, P2 P3 Demand MR... Question 9 Figure 15-10 Price and cost per unit Po MC P, P2 P3 Demand MR Quantity Refer to Figure 15-10. The deadweight loss due to a monopoly is represented by the area GEH. FGE. O FQ1 Q2E. FHE. Question 10 Table 15-1 Quantity Demanded (units) Total Cost of Production (dollars) \$530 Price per Unit 10 \$85 540 80 75 11 550 12 560 13 70 65 575 14 595 15 60 625 16 55 A monopoly producer of foreign...