Use the data in the spreadsheet (columns J to N to run the following tests:

The spreadsheet has 10-K report and financial data for a sample of semiconductor firms for fiscal year 2016.

Data Definitions:

CSR= Corporate social responsibility reporting,CSR=1 if disclosing; 0 otherwise

LAG = number of days between 10-K filing date and fiscal year-end date

SIZE = natural log of total assets

ROA = earnings divided by total assets

Big4 = 1 for Big4 auditor; 0 otherwise

Requirement 1

State the nul and alternative hypotheses that the means of ROA and Size are different from zero.

Requirement 2

Use the data in the spreadsheet to test the hypotheses you stated in requirement 1.

Requirement 3

Run the correlation between the variables and comment on the relationships between the variables.

Requirement 4

Run a multivariate regression to examine if a management decision to disclose CSR is a function of

ROA, SIZE, BIG4

MODEL:CSR= A0 + A1(ROA) + A2(SIZE) + A3(BIG4) +e

Explain the results of the above model:

a. direction Positive or negative

b. whether the coefficient of every variable is statistically significant from zero.

c. the overall explanationatory power of the model (R-squared).

Requirement 5

State two other variables that you think could be added to the model

Company CIK Code Auditor Auditor Key Year Ended Da Source Date Earnings ($) Assets ($) CSR LAG SIZE ROA Big4 ADVANCED MICRO DEVICES INC 2488 Ernst & Yo 2 12/31/2016 2/21/2017 16:52 -497,000,000 3,321,000,000 0 52 21.9235 -0.1497 SKYWORKS SOLUTIONS, INC. 4127 KPMG LLP 4 9/30/2016 11/22/2016 16:24 995,200,000 3,855,400,000 53 22.0727 0.25813 ANALOG DEVICES INC 6281 Ernst & Yo N 10/29/2016 11/22/2016 8:18 861,664,000 7,970,278,000 24 22.799 0.10811 5 APPLIED MATERIALS INC /DE 6951 KPMG LLP 4 10/30/2016 12/15/2016 16:46 1,721,000,000 14,570,000,000 1 46 23.4022 0.11812 6 DIODES INC /DEL/ 29002 Moss Ada 13 12/31/2016 2/27/2017 17:27 15,935,000 1,528,552,000 0 58 21.1476 0.01042 INTEL CORP 50863 Ernst & Yo IN 12/31/2016 2/17/2017 8:37 10,316,000,000 113,327,000,000 0 48 25.4535 0.09103 8 SEMTECH CORP 88941 Ernst & Yo 2 1/31/2016 3/31/2016 16:31 11,497,000 911,517,000 0 60 20.6306 0.01261 9 TEXAS INSTRUMENTS INC 97476 Ernst & Yo 12/31/2016 2/23/2017 13:00 3,595,000,000 16,431,000,000 1 54 23.5224 0.21879 10 MICROSEMI CORP 310568 Pricewater 10/2/2016 11/16/2016 17:08 -32,600,000 4,423,000,000 0 45 22.2101 -0.0074 11 INTEGRATED DEVICE TECHNOLOGY INC 703361 Pricewater 4/3/2016 5/20/2016 16:09 194,737,000 1,099,189,000 1 47 20.8178 0.17716 12 APPLIED MICRO CIRCUITS CORP 711065 KPMG LLP 3/31/2016 5/20/2016 17:26 -32,571,000 146,292,000 0 50 18.8011 -0.2226 13 MICRON TECHNOLOGY INC 723125 Pricewater 9/1/2016 10/28/2016 13:49 -276,000,000 27,540,000,000 0 57 24.0389 -0.01 14 NVE CORP /NEW/ 724910 Grant Tho 3/31/2016 5/4/2016 16:32 12,292,315 100,854,056 0 34 18.4292 0.12188 15 MAXIM INTEGRATED PRODUCTS INC 743316 Deloitte & 6/25/2016 8/12/2016 16:49 227,475,000 4,234,616,000 1 48 22.1666 0.05372 743988 Ernst & Yo NI 16 XILINX INC 4/2/2016 5/17/2016 16:45 550,867,000 4,819,269,000 45 22.2959 0.11431 17 EXAR CORP 753568 BDO USA I 11761 3/27/2016 5/27/2016 16:37 -16,026,000 255,373,000 0 61 19.3582 -0.0628 18 KOPIN CORP 771266 Deloitte & 3 12/31/2016 3/22/2017 21:56 -23,434,116 87,832,272 0 81 18.2909 -0.2668 19 CIRRUS LOGIC INC 772406 Ernst & Yo 2 3/26/2016 5/25/2016 16:14 123,630,000 1,181,883,000 1 60 20.8904 0.1046 20 SIGMA DESIGNS INC 790715 Armanino 20474 1/30/2016 4/4/2016 15:39 158,000 216,669,000 1 65 19.1939 0.00073 21 LINEAR TECHNOLOGY CORP /CA/ 791907 Ernst & Yo 2 7/3/2016 8/25/2016 13:00 494,346,000 2,049,981,000 1 53 21.4411 0.24115 22 CYPRESS SEMICONDUCTOR CORP /DE/ 791915 Pricewater 1/1/2017 3/1/2017 16:29 -683,234,000 3,871,871,000 0 59 22.077 -0.1765 23 EMCORE CORP 808326 KPMG LLP 9/30/2016 12/7/2016 16:41 8,266,000 127,211,000 0 68 18.6614 0.06498 24 PHOTRONICS INC 810136 Deloitte & 10/30/2016 1/6/2017 12:38 46,200,000 987,988,000 0 68 20.7112 0.04676 25 SYNAPTICS Inc 817720 KPMG LLP 6/25/2016 8/26/2016 8:01 72,200,000 1,300,200,000 0 62 20.9858 0.05553 26 MICROCHIP TECHNOLOGY INC 827054 Ernst & Yo IN 3/31/2016 5/24/2016 17:13 324,132,000 5,537,883,000 54 22.4349 0.05853 27 POWER INTEGRATIONS INC 833640 Deloitte & W 12/31/2016 2/8/2017 17:05 48,898,000 554,410,000 39 20.1334 0.0882 28 LATTICE SEMICONDUCTOR CORP 855658 KPMG LLP 12/31/2016 3/1/2017 15:51 -54,099,000 766,883,000 60 20.4578 -0.0705 29 SUNPOWER CORP 867773 Ernst & Yo 2 1/1/2017 2/17/2017 6:08 -471,064,000 4,567,167,000 47 22.2422 -0.1031 OOHO 30 QUICKLOGIC CORPORATION 882508 Moss Ada 13 1/1/2017 3/9/2017 17:19 -19,148,000 21,844,000 67 16.8994 -0.8766 31 MRV COMMUNICATIONS INC 887969 Grant Tho 6 12/31/2016 3/9/2017 17:19 -11,637,000 56,260,000 68 17.8455 -0.2068 32 CREE INC 895419 Pricewate 6/26/2016 8/25/2016 16:26 -21,536,000 2,766,060,000 60 21.7407 -0.0078 H P 33 VIAVI SOLUTIONS INC. 912093 Pricewater 7/2/2016 8/30/2016 16:20 -99,200,000 1,678,100,000 59 21.2409 -0.059134 RAMBUS INC 917273 Pricewater 1 12/31/2016 2/17/2017 14:26 6,820,000 783,496,000 48 20.4793 0.0087 35 IXYS, LLC 945699 BDO USA I 11761 3/31/2016 6/8/2016 18:52 14,741,000 422,701,000 69 19.8622 0.03487 36 SILICON LABORATORIES INC 1038074 Ernst & Yc 2 12/31/2016 2/1/2017 14:24 61,494,000 1,081,844,000 32 20.8019 0.05684 37 OSI SYSTEMS INC 1039065 Moss Ada 13 6/30/2016 8/19/2016 17:02 26,157,000 991,723,000 50 20.715 0.02638 38 FORMFACTOR INC 1039399 KPMG LLP 4 12/31/2016 3/15/2017 17:27 -6,557,000 618,982,000 74 20.2436 -0.0106 39 PIXELWORKS, INC 1040161 KPMG LLP 4 12/31/2016 3/8/2017 16:01 -11,107,000 30,857,000 67 17.2449 -0.36 40 NVIDIA CORP 1045810 Pricewater 1 1/31/2016 3/16/2016 18:07 614,000,000 7,370,000,000 1 45 22.7207 0.08331 41 AMKOR TECHNOLOGY, INC. 1047127 Pricewater 1 12/31/2016 2/24/2017 15:25 164,190,000 4,092,086,000 55 22.1323 0.04012 42 AXT INC 1051627 BPM LLP 29311 12/31/2016 2/27/2017 16:32 5,636,000 154,246,000 0 58 18.8541 0.03654 43 FINISAR CORP 1094739 BDO USA I 11761 5/1/2016 6/17/2016 14:24 35,193,000 1,645,371,000 0 47 21.2212 0.02139 44 INTERSIL CORP/DE 1096325 KPMG LLP 4 12/30/2016 2/17/2017 16:32 48,137,000 1,165,341,000 49 20.8763 0.04131 45 ON SEMICONDUCTOR CORP 1097864 Pricewater 1 12/31/2016 2/28/2017 15:57 182,100,000 6,924,400,000 1 59 22.6583 0.0263 46 CABOT MICROELECTRONICS CORP 1102934 Pricewater 9/30/2016 11/16/2016 14:05 59,849,000 727,230,000 1 47 20.4048 0.0823 47 OCLARO, INC. 1110647 Grant Tho 6 7/2/2016 8/26/2016 16:09 8,580,000 359,049,000 0 55 19.699 0.0239 48 IPG PHOTONICS CORP 1111928 Deloitte & 3 12/31/2016 2/27/2017 16:51 260,752,000 1,789,999,000 58 21.3055 0.14567 49 INPHI Corp 1160958 Pricewater 12/31/2016 3/1/2017 15:17 99,456,000 990,595,000 60 20.7138 0.1004 50 CEVA INC 1173489 Ernst & Yo 2 12/31/2016 3/10/2017 16:05 13,100,000 242,495,000 0 69 19.3065 0.05402 51 CAVIUM, INC. 1175609 Pricewater 12/31/2016 2/28/2017 16:38 -147,209,000 1,650,531,000 59 21.2244 -0.0892 52 NEOPHOTONICS CORP 1227025 Deloitte & 3 12/31/2016 3/16/2017 16:24 -205,000 390,887,000 75 19.7839 -0.0005 53 FIRST SOLAR, INC. 1274494 Pricewater 1 12/31/2016 2/22/2017 10:15 -416,112,000 6,824,368,000 O 53 22.6438 -0.061 54 Ultra Clean Holdings, Inc. 1275014 Moss Ada 13 12/30/2016 3/15/2017 15:10 10,051,000 380,697,000 75 19.7575 0.0264 55 AMBARELLA INC 1280263 Pricewater 1/31/2016 3/25/2016 13:01 76,508,000 410,615,000 19.8332 0.18633 56 MONOLITHIC POWER SYSTEMS INC 1280452 Deloitte & 3 12/31/2016 3/1/2017 16:49 52,720,000 511,126,000 1 60 20.0521 0.10314 57 MAXLINEAR INC 1288469 Grant Tho 6 12/31/2016 2/8/2017 19:44 61,292,000 422,652,000 39 19.8621 0.14502 OHOP 58 InvenSense Inc 1294924 Deloitte & 3 4/3/2016 5/25/2016 17:06 -21,254,990 622,500,000 0 52 20.2493 -0.0341 59 INTERMOLECULAR INC 1311241 Armanino 20474 12/31/2016 3/3/2017 16:16 -15,437,000 53,168,000 0 62 17.789 -0.2903 60 Mellanox Technologies, Ltd. 1356104 Pricewater 1 12/31/2016 2/17/2017 16:11 18,518,000 1,473,505,000 0 48 21.1109 0.01257 61 ALPHA & OMEGA SEMICONDUCTOR Ltd 1387467 Grant Tho 6 6/30/2016 8/26/2016 17:17 -2,928,000 318,505,000 0 57 19.5791 -0.0092 62 GigPeak, Inc. 1432150 BPM LLP 29311 12/31/2016 3/15/2017 16:31 2,233,000 140,435,000 74 18.7603 0.0159 63 MACOM Technology Solutions Holdings, Inc 1493594 Deloitte & 3 9/30/2016 11/17/2016 16:44 1,434,000 1,188,551,000 48 20.896 0.00121 64 Qorvo, Inc. 1604778 KPMG LLP 4 4/2/2016 5/31/2016 17:01 -28,845,000 6,596,819,000 9 22.6099 -0.0044 65 Xperi Corp 1690666 Pricewater 1 12/31/2016 2/27/2017 16:39 56,089,000 1,186,436,000 58 20.8942 0.04728