Construct a full multiple regression model of market cap

Assignment Help Other Subject

Reference no: EM133719787

Managerial Decision Making for Security Executives

E-Commerce/Internet Companies

Consider the data provided on the Excel file on top 100 E-commerce/Internet companies (year 2020) provide on the Excel file. The variables listed are: Company Name, Headquarter, Industry, Revenue (in Billions), Marketing Budget (millions), Number of employees, administrative Expenses, and Market Capitalization (Market Cap, Billions).

Using Excel Data Analysis, construct the descriptive Statistics of 5 listed numerical values and comment on shape of each data set.
Construct 4 scatter diagrams of each variable against Market Cap (Y variable). Identify outlier companies in each graph. Make sure to label the X and Y variable in graphs.

Based on graphs, identify possible outlier companies.

Construct a correlation matrix of all 5 variables and discuss correlations between variables against Market Cap. Rank the variables based on correlation with Market Cap.

Construct a full multiple regression model of Market Cap (Y) against the other variables.

Outline the regression equation, and interpret the R-squared, Significant F, and list the variables based on P-values in the order of significance in the model.

Construct a multiple regression model of the top 3 variables in part (d) and outline the regression equation, and interpret the R-squared, Significant F, and list the variables based on P-values in the order of significance in the model. Make sure to find the residual values for this model.

Based on the residual values in part e, list the top 5 (undervalued) and bottom 5 overvalued companies based on the residuals. Positive residual indicates overvalued and negative residuals indicate undervalue companies in terms of market cap.

Use the Excel PivotTable to construct a table of data with Industry, company name, market cap, revenue, marketing budget, administrative expenses, and number of employees. Identify top three companies in E-commerce, Internet, social media and Software of listed categories.
Provide a brief conclusion of findings of your analysis.

Reference no: EM133719787

Questions Cloud

Which do you think is more beneficial to society : Which do you think is more beneficial to society? Use the theoretical perspectives explained in your textbook to demonstrate your opinion.

What will you do to assure your team members : What will you do to assure your team members that they have a voice and are free to challenge each other's input?

Is there a danger in understanding child development : Is there a danger in understanding child development and healthy family dynamics (micro) without understanding broader impact of policy, law, and culture?

How were international musical culture addressing experience : MUSC 100 San Jose State University- How were international musical cultures addressing these experiences compared with the United States?

Construct a full multiple regression model of market cap : MGT 6332 Managerial Decision Making for Security Executives and Outline the regression equation, and interpret the R-squared, Significant F

Different in parenting and deviant behaviour : Parenting and deviant behaviour: disscuss how different parenting styles can contribute to or deter deviant behaviour.

Describe how the company is protecting and respecting people : MKTG 716- Describe how the company is protecting and respecting people. Where does it produce its products? How does it treat its employees?

Define racial profiling : Define racial profiling. Describe the connection between stereotypes and racial profiling. Explain the consequences of racial profiling.

Design deficiencies with respect to ergonomics : Description of the product or system with photos or sketches and Design deficiencies with respect to ergonomics principals and criterion measure

User Account

All Pages