Explore BrainMass

Explore BrainMass

    Correlation matrix: Interpret data for JAX, DFW, LAX models

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See attached files.

    Provide a correlation matrix.

    Use the data to obtain the 'best' multiple regression model.

    Can you please provide a short write-up in Word that interprets your output discussing

    - which independent variables are most strongly related to price,
    - which are least strongly related to price,
    - if the directions of the correlations make sense,
    - if there appears to be any multicollinearity,
    - your logic in excluding/including independent variables in your 'best' model.

    Please include:

    An Excel file that shows the data set used, and provides the statistical output or calculations and short interpretations of your output.

    © BrainMass Inc. brainmass.com March 4, 2021, 10:44 pm ad1c9bdddf


    Solution Summary

    The correlation matrix and two regressions are computed and explained in everyday language suitable for novices. Data has been reformatted in excel to better run models.