need either of the two parts completed

profileiamnickok
mgt611onlac-fa16-groupassignment-data_1.xlsx

Appendix 1

(Use this if you would like projects in rows)
Project Number Success Parameter Mean Revenue/Loss (Millions $'s)
Failure Challenged Success
1 6.07 -0.955 1.353 2.234
2 2.90 -0.581 1.342 1.972
3 3.97 -1.958 3.695 5.469
4 2.97 -0.469 1.533 2.960
5 3.95 -0.421 0.954 1.560
6 2.63 -0.606 2.251 4.254
7 1.42 -1.453 3.384 5.263
8 6.42 -0.359 0.538 1.182
9 3.24 -0.771 1.895 2.707
10 3.09 -0.361 1.203 2.468

Appendix 2

(Use this if you would like projects in rows)
Project Number Success Parameter Mean Revenue/Loss (Millions $'s)
Failure Challenged Success
L M H L M H L M H
1 6.07 -1.210 -0.946 -0.709 1.005 1.340 1.715 1.659 2.212 2.831
2 2.90 -0.685 -0.591 -0.467 1.078 1.365 1.583 1.584 2.005 2.326
3 3.97 -2.299 -1.932 -1.642 3.099 3.646 4.339 4.587 5.397 6.422
4 2.97 -0.579 -0.452 -0.376 1.227 1.479 1.893 2.370 2.855 3.655
5 3.95 -0.533 -0.410 -0.320 0.725 0.929 1.208 1.185 1.519 1.975
6 2.63 -0.728 -0.592 -0.497 1.848 2.200 2.706 3.492 4.157 5.113
7 1.42 -1.762 -1.493 -1.105 2.573 3.477 4.103 4.001 5.407 6.380
8 6.42 -0.406 -0.363 -0.308 0.462 0.543 0.609 1.015 1.194 1.337
9 3.24 -0.865 -0.766 -0.682 1.675 1.882 2.127 2.393 2.689 3.039
10 3.09 -0.447 -0.363 -0.273 0.908 1.211 1.490 1.863 2.485 3.056

Part 1

(Use this if you would like projects in columns)
Project 1 2 3 4 5 6 7 8 9 10
SP 6.07 2.9 3.97 2.97 3.95 2.63 1.42 6.42 3.24 3.09
Mean Revenue/Loss (Millions $'s) Failure -0.955 -0.581 -1.958 -0.469 -0.421 -0.606 -1.453 -0.359 -0.771 -0.361
Challenged 1.353 1.342 3.695 1.533 0.954 2.251 3.384 0.538 1.895 1.203
Success 2.234 1.972 5.469 2.96 1.56 4.254 5.263 1.182 2.707 2.468

Part 2

(Use this if you would like projects in columns)
Project 1 2 3 4 5 6 7 8 9 10
SP 6.07 2.9 3.97 2.97 3.95 2.63 1.42 6.42 3.24 3.09
Mean Revenue/Loss (Millions $'s) Failure L -1.210 -0.685 -2.299 -0.579 -0.533 -0.728 -1.762 -0.406 -0.865 -0.447
M -0.946 -0.591 -1.932 -0.452 -0.410 -0.592 -1.493 -0.363 -0.766 -0.363
H -0.709 -0.467 -1.642 -0.376 -0.320 -0.497 -1.105 -0.308 -0.682 -0.273
Challenged L 1.005 1.078 3.099 1.227 0.725 1.848 2.573 0.462 1.675 0.908
M 1.340 1.365 3.646 1.479 0.929 2.200 3.477 0.543 1.882 1.211
H 1.715 1.583 4.339 1.893 1.208 2.706 4.103 0.609 2.127 1.490
Success L 1.659 1.584 4.587 2.370 1.185 3.492 4.001 1.015 2.393 1.863
M 2.212 2.005 5.397 2.855 1.519 4.157 5.407 1.194 2.689 2.485
H 2.831 2.326 6.422 3.655 1.975 5.113 6.380 1.337 3.039 3.056