### Free Educational Resources

• > ECO 301: MILESTONE ONE
+

# ECO 301: MILESTONE ONE

##### Rating:
(0)
Author: Christine Farr
##### Description:

http://theperfecthomework.com/eco-301-milestone-one/

ECO 301: Milestone One Directions

Step 1
Download the Regression Analysis Practice document (Excel file).

Step 2
Make sure you have the Data Analysis ToolPak add-in for your Excel. You can do that by going to the Data tab and searching forData Analysis. If it does not appear, you will need to download it. The steps to download add-ins varies with each version of Excel. Here are the steps for the 2007 version:

Click on the Excel icon in the upper-left corner of your spreadsheet.
Click on Excel Options.
Along the left-side menu, click on Add-Ins.
Select Analysis ToolPak and follow the instructions.

Step 3
At the bottom, click on the “Demand for Jet Fuel” tab. The sample demand equation is estimated using this data set, and the results are shown.

Step 4
Use the procedure described to estimate the demand for gasoline using the same steps identified in the example below. Sample answers are based on the “Demand for Jet Fuel” data.

Evaluate adjusted R2.
The adjusted R2 is 0.778421. It indicates that approximately 78% of the variation in the demand for jet fuel across states is explained by the three independent variables—price, state GDP, and state population.

Evaluate each of the independent variables using a t-test.
Table 1 provides the results of the t-tests for each of the independent variables.

Coefficients

Standard Error

T-Stat

P-Value

Intercept

-18.4498

45.28617

-0.40741

0.68556

Price

0.138429

2.788582

0.049641

0.960619

GDP

0.170079

0.039165

4.342646

7.45E-05

Population

0.005281

0.001791

2.948036

0.004967

Table 1: T-Test Analysis

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial