Explore BrainMass

Excel Formula for Market Capitalization

This content was STOLEN 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 December 20, 2018, 8:59 am ad1c9bdddf


Solution Summary

The expert examines excel formula for market capitalization.