Question: Skyward Airlines would like to create a regression model to predict cash. The variables used in the regression model include values of cash, total revenue,

Skyward Airlines would like to create a regression model to predict cash. The variables used in the regression model include values of cash, total revenue, cash flow from operations, cash flow from investing and cash flow from financing for the last 8 years. Using the data analysis regression functionality in Excel, the following regression statistics were generated:
\table[[,,,,,],[,df,SS,MS,F,Significance F],[Regression,4,2601725,650431.1,9.830047,0.045178],[Residual,3,198503,66167.65,,],[Total,7,2800228,,,]]
Based on the AVONA output of the regression analysis, what can you conclude?
The regression model using the independent variables is significant since the value is less than 0.05.
Increasing more years in the data observation will improve the Significance F value.
Total revenue, cash flow from operations, cash flow from investing and cash flow from financing are reliable independent variables for the regression model.
Adding more independent variables in the model will help improve the Significance F value.
 Skyward Airlines would like to create a regression model to predict

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!