Explore BrainMass
Share

Explore BrainMass

    Excel Formula for Market Capitalization

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

    The market capitalization and the salary of the chief executive officer for 20 companies are shown in the following table:

    See attached file.

    A. Develop the estimated regression equation that can bee used to predict the CEO salary give the market capitalization.

    B. The residual analysis to determine whether any outliers and or influential observation are present. Briefly summarize your findings and conclusions.

    © BrainMass Inc. brainmass.com October 10, 2019, 4:36 am ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/excel-formula-market-capitalization-468887

    Attachments

    Solution Summary

    The expert examines excel formula for market capitalization.

    $2.19