Can the cost of flying a commercial airliner be predicted using regression analysis?
Suppose a study is conducted to predict cost of a flight by number of passengers using only Boeing 737s traveling 500 miles in comparable routes during the same season of the year. Given here is Excel output for a simple regression model that was developed for this case. Analyze the computer output.

1) Write down the estimated regression equation. What stands here for Y and what for X1?
2) How many airliners were in the sample?
3) Does there appear to be any relationship between 2 variables? Which indicator do you use to estimate that?
4) Discuss the strength of the regression model. Did the estimated regression equation provide a good fit?
5) Discuss the significance of slope coefficient on the basis of the output.

SUMMARY OUTPUT
____________________
Regression Statistics
____________________
Multiple R 0.942
R Square 0.886
Adjusted R Square 0.875
Standard Error 15.6491
Observations 12
ANOVA
__________________________________________________
df SS MS F Significance F
__________________________________________________
Regression 1 19115.063 19115.0632 78.05 0.00005
Residual 10 2448.937 244.8937
Total 11 21564
_____________________________________________________________________
Coefficients Standard Error T-Stat P-value
_____________________________________________________________________
Intercept 30.9125 13.2542 2.33 0.041888
X1 2.2315 0.2526 8.83 0.000005

1) Write down the estimated regression equation. What stands here for Y and what for X1?

Y=30.9125 + 2.2315 X1

Y= cost of a flight

X1 = No of passengers

2) How many airliners were in the sample?

There were 12 airlines in the sample.

3) Does there appear to be any relationship between 2 variables? Which indicator do you use to estimate that? ...

Solution Summary

The solution interprets and analyzes the computer output for a regression analysis that is used to predict cost of a flight by number of passengers using only Boeing 737s traveling 500 miles in comparable routes during the same season of the year.

Regressionanalysis was used to estimate the following linear trend equation:
St = 10.5 + 0.25t
Use this equation to forecast the value of the dependent variable (St) in time period of 10.
10.75
13
35.5
2.5

The following data relate the sales figures of the bar in Marty and Polly Starr's small bed-and-breakfast inn in Marathon, Florida, to the number of guests registered that week:
Week Guests Bar Sales
1 16 330
2 12 270
3 18 380
4 14 300
a) Perform a linearregression that relates bar sales to guests (not to time).
b

Simple LinearRegression and Multiple Regression.
I'd like to ask whether you think multiple regression (the use of more IV's) is always better than simple regression? Why or why not?
What problems may exist with multiple regression that are not an issue for simple linearregression?

Application of simple linearregressionanalysis to the estimation of a demand equation has yielded the following
Q = 24 - 2P
If the current product price is P=$6 and the quantity sold per time period is Q = 10, then the erro (e) for the current time period is equal to (actual quantity sold - estimated quantity sold)?
1

Develop simple linearregression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually. Do the assumptions of linearregression hold for your models? How do these models compare to the multiple regression models?

1. Describe what a line is that satisfies the least-squares property-what is it and what is the function? (Please share your own way of understanding it).
2. This week we looked at regressionanalysis. What is the difference between a simple regressionanalysis and multiple regression? Please give examples.

The attached file contains observations of the American minimum wage during each of the years from 1950 through 2004. Has the minimum wage been growing at roughly a constant rate over this period? Use simple linearregressionanalysis to address this question. Explain your results.