Question: Answer the questions below using the following Forbes data set. Forbes 500 Random Subsample ($, millions) Conduct a correlation matrix using the Forbes 500 dataset.

Answer the questions below using the following Forbes data set.
Forbes 500 Random Subsample ($, millions)
Number of (thousands) Assets Sales Market Net Cash Value Profit Flow 82.60 1,034.00 1,510.00 697.00 126.50 16.60 785.00

Conduct a correlation matrix using the Forbes 500 dataset. Determine which variables have a significant relationship.
Select an independent and dependent variables and run a regression analysis. What can you conclude from the findings?

Number of (thousands) Assets Sales Market Net Cash Value Profit Flow 82.60 1,034.00 1,510.00 697.00 126.50 16.60 785.00 89.00 956.00 1,271.00 191.20 5.00 1,890.00 2,533.00 1,783.00 176.00 267.00 44.00 1,133.00 532.00 2.10 752.00 82.30 137.10 413.50 11,682.00 3,790.00 4,149.00 806.80 11.90 6,080.00 635.00 291.00 18.10 35.20 3.70 337.30 31,044.00 3,296.00 2,705.00 425.50 20.10 145.80 5,878.00 3,204.00 2,100.00 380.00 10.80 1,573.00 1,721.00 981.00 172.60 326.60 1.90 2,135.00 2,268.00 2,634.00 247.20 55.50 21.20

Step by Step Solution

3.50 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To construct a correlation matrix open a spreadsheet past this data in it Go to data data analysis c... View full answer

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

Document Format (1 attachment)

Word file Icon

1019-B-M-A-P-C(3950).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!