Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the data in the spreadsheet (columns J to N to run the following tests: You must include your name on your submission and enter

Use the data in the spreadsheet (columns J to N to run the following tests: You must include your name on your submission and enter your answers to the Individual Research Project Assignment on the appropriate page on classes 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 reqyirement 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 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

image text in transcribedimage text in transcribed
Company CIK Code Auditor Auditor Key Year Ended Date Source Date Earnings ($) Assets ($) CSR LAG SIZE ROA Big ADVANCED MICRO DEVICES INC 2488 Ernst & You 12/31/16 2/21/17 16:52 497,000,000 3,321,000,000 0 52 21.92353 -0.149654 W N AN SKYWORKS SOLUTIONS, INC. 4127 KPMG LLP 9/30/16 11/22/16 16:24 995,200,000 3,855,400,000 1 22.07274 0.258131 ANALOG DEVICES INC 6281 Ernst & You IN 11/22/16 8:18 7,970,278,000 24 22.79899 0.10811 P 10/29/16 861,664,000 5 APPLIED MATERIALS INC /DE 6951 KPMG LLP 10/30/16 12/15/16 16:46 1,721,000,000 14,570,000,000 1 46 23.40223 0.118119 6 DIODES INC /DEL/ 29002 Moss Adan 13 12/31/16 2/27/17 17:27 15,935,000 1,528,552,000 58 21.14759 0.010425 INTEL CORP 50863 Ernst & You 12/31/16 2/17/17 8:37 10,316,000,000 113,327,000,000 0 18 25.45354 0.091029 ISEMTECH CORP 88941 Ernst & You 1/31/16 3/31/16 16:31 11,497,000 911,517,000 o 60 20.63062 0.012613 9 TEXAS INSTRUMENTS INC 97476 Ernst & You HNN 12/31/16 2/23/17 13:00 3,595,000,000 16,431,000,000 54 23.52244 0.218794 10 MICROSEMI CORP 310568 Pricewatert 10/2/16 11/16/16 17:08 -32,600,000 4,423,000,000 0 45 22.21008 -0.007371 11 INTEGRATED DEVICE TECHNOLOGY INC 703361 Pricewatert 4/3/16 5/20/16 16:09 194,737,000 1,099,189,000 47 20.81784 0.177164 12 APPLIED MICRO CIRCUITS CORP 711065 KPMG LLP 3/31/16 5/20/16 17:26 -32,571,000 146,292,000 50 18.80112 -0.222644 13 MICRON TECHNOLOGY INC 723125 Pricewatert 9/1/16 10/28/16 13:49 -276,000,000 27,540,000,000 57 24.03891 -0.010022 W O H A 1 NVE CORP /NEW/ 724910 Grant Thorr 3/31/16 5/4/16 16:32 12,292,315 100,854,056 34 18.42919 0.121882 15 MAXIM INTEGRATED PRODUCTS INC 743316 Deloitte & 7 6/25/16 8/12/16 16:49 227,475,000 4,234,616,000 48 22.16656 0.053718 743988 Ernst & You N 16 XILINX INC 4/2/16 5/17/16 16:45 550,867,000 4,819,269,000 45 22.29589 0.114305 17 EXAR CORP 753568 BDO USA LI 11761 3/27/16 5/27/16 16:37 -16,026,000 255,373,000 61 19.35824 -0.062755 18 KOPIN CORP 771266 Deloitte & 7 12/31/16 3/22/17 21:56 -23,434,116 87,832,272 81 18.29094 -0.266805 19 CIRRUS LOGICINC 772406 Ernst & You 2 3/26/16 5/25/16 16:14 123,630,000 1,181,883,000 60 20.89037 0.104604 20 SIGMA DESIGNS INC 790715 Armanino L 20474 1/30/16 4/4/16 15:39 158,000 216,669,000 65 19. 19388 0.000729 21 LINEAR TECHNOLOGY CORP /CA/ 791907 Ernst & You N 7/3/16 8/25/16 13:00 494,346,000 2,049,981,000 53 21.4411 0.241147 22 | CYPRESS SEMICONDUCTOR CORP /DE/ 791915 Pricewatert 1/1/17 3/1/17 16:29 -683,234,000 3,871,871,000 0 59 22.077 -0.176461 23 EMCORE CORP 808326 KPMG LLP 9/30/16 12/7/16 16:41 8,266,000 127,211,000 0 68 18.66136 0.064979 24 PHOTRONICS INC 810136 Deloitte & 7 10/30/16 1/6/17 12:38 46,200,000 987,988,000 38 20.71118 0.046762 25 SYNAPTICS Inc 817720 KPMG LLP 6/25/16 8/26/16 8:01 72,200,000 1,300,200,000 62 20.98578 0.05553 26 MICROCHIP TECHNOLOGY INC 827054 Ernst & You 3/31/16 5/24/16 17:13 324,132,000 5,537,883,000 54 22.43488 0.05853 NAWNAW 27 POWER INTEGRATIONS INC 833640 Deloitte & 1 12/31/16 2/8/17 17:05 48,898,000 554,410,000 20.13342 0.088198 28 LATTICE SEMICONDUCTOR CORP 855658 KPMG LLP 12/31/16 3/1/17 15:51 -54,099,000 766,883,000 60 20.45784 -0.070544 29 SUNPOWER CORP 867773 Ernst & You 1/1/17 2/17/17 6:08 -471,064,000 4,567,167,000 47 22.24216 -0.103141 30 QUICKLOGIC CORPORATION 882508 Moss Adan 13 1/1/17 3/9/17 17:19 19,148,000 21,844,000 67 16.89944 -0.876579 31 |MRV COMMUNICATIONS INC 887969 Grant Thorr O 12/31/16 3/9/17 17:19 -11,637,000 56,260,000 17.84549 -0.206843 32 CREE INC 895419 Pricewatert 6/26/16 8/25/16 16:26 -21,536,000 2,766,060,000 60 21.74069 -0.007786 33 IVIAVI SOLUTIONS INC. 912093 Pricewatert 7/2/16 8/30/16 16:20 -99,200,000 1,678,100,000 59 21.24093 -0.059114 34 RAMBUS INC 917273 Pricewatert 12/31/16 2/17/17 14:26 6,820,000 783,496,000 48 20.47928 0.008705 35 IXYS, LLC 945699 BDO USA LI 11761 3/31/16 6/8/16 18:52 14,741,000 422,701,000 59 19.86218 0.034873 36 SILICON LABORATORIES INC 1038074 Ernst & You 2 12/31/16 2/1/17 14:24 61,494,000 1,081,844,000 32 20.80193 0.056842 37 OSI SYSTEMS INC 1039065 Moss Adan 13 6/30/16 8/19/16 17:02 26,157,000 991,723,000 50 20.71495 0.026375 38 FORMFACTORINC 1039399 KPMG LLP 12/31/16 3/15/17 17:27 -6,557,000 618,982,000 74 20.24359 -0.010593 39 PIXELWORKS, INC 1040161 KPMG LLP 12/31/16 3/8/17 16:01 -11,107,000 30,857,000 67 17.24487 -0.359951 40 INVIDIA CORP 1045810 Pricewatert 1/31/16 3/16/16 18:07 614,000,000 7,370,000,000 45 22.72068 0.083311B C D E F G H K M N 35 IXYS, LLC 945699 BDO USA LI 11761 3/31/16 6/8/16 18:52 14,741,000 422,701,000 69 19.86218 0.034873 36 SILICON LABORATORIES INC 1038074 Ernst & You 12/31/16 2/1/17 14:24 61,494,000 1,081,844,000 20.80193 0.056842 37 OSI SYSTEMS INC 1039065 Moss Adan 13 6/30/16 8/19/16 17:02 26,157,000 991,723,000 50 20.71495 0.026375 38 FORMFACTORINC 1039399 KPMG LLP 4 12/31/16 3/15/17 17:27 -6,557,000 618,982,000 74 20.24359 -0.010593 89 PIXELWORKS, INC 1040161 KPMG LLP 12/31/16 3/8/17 16:01 -11,107,000 30,857,000 17.24487 -0.359951 40 NVIDIA CORP 1045810 Pricewatert 1/31/16 3/16/16 18:07 614,000,000 7,370,000,000 45 22.72068 0.083311 41 AMKOR TECHNOLOGY, INC. 1047127 Pricewatert 12/31/16 2/24/17 15:25 164,190,000 4,092,086,000 OOHIO 55 22.13232 0.040124 42 AXT INC 1051627 BPM LLP 29311 12/31/16 2/27/17 16:32 5,636,000 154,246,000 58 18.85406 0.036539 43 FINISAR CORP 1094739 BDO USA LI 11761 5/1/16 6/17/16 14:24 35,193,000 1,645,371,000 47 21.22123 0.021389 14 INTERSIL CORP/DE 1096325 KPMG LLP 12/30/16 2/17/17 16:32 48,137,000 1,165,341,000 49 20.87628 0.041307 15 ON SEMICONDUCTOR CORP 1097864 Pricewatert 12/31/16 2/28/17 15:57 182,100,000 6,924,400,000 59 22.65832 0.026298 16 CABOT MICROELECTRONICS CORP 1102934 Pricewatert 9/30/16 11/16/16 14:05 59,849,000 727,230,000 47 20.40475 0.082297 47 OCLARO, INC. 1110647 Grant Thorr 7/2/16 8/26/16 16:09 8,580,000 359,049,000 55 19.69897 0.023896 HWO H H 18 IPG PHOTONICS CORP 1111928 Deloitte & 7 12/31/16 2/27/17 16:51 260,752,000 1,789,999,000 58 21.30548 0.145672 19 INPHI Corp 1160958 Pricewatert 12/31/16 3/1/17 15:17 99,456,000 990,595,000 60 20.71382 0. 1004 50 CEVA INC 1173489 Ernst & You 12/31/16 3/10/17 16:05 13,100,000 242,495,000 69 19.30649 0.054022 51 CAVIUM, INC. 1175609 Pricewatert 12/31/16 2/28/17 16:38 -147,209,000 1,650,531,000 59 21.22436 -0.089189 HWHN INEOPHOTONICS CORP 1227025 Deloitte & 1 12/31/16 3/16/17 16:24 -205,000 390,887,000 75 19.78393 -0.000524 53 FIRST SOLAR, INC. 1274494 Pricewatert 12/31/16 2/22/17 10:15 -416,112,000 6,824,368,000 53 22.64377 -0.060974 54 Ultra Clean Holdings, Inc. 1275014 Moss Adan 13 12/30/16 3/15/17 15:10 10,051,000 380,697,000 75 19.75751 0.026402 $5 AMBARELLA INC 1280263 Pricewatert 1/31/16 3/25/16 13:01 76,508,000 410,615,000 54 19.83317 0.186325 56 MONOLITHIC POWER SYSTEMS INC 1280452 Deloitte & 1 12/31/16 3/1/17 16:49 52,720,000 511,126,000 60 20.05213 0.103145 W O W H 57 MAXLINEAR INC 1288469 Grant Thorr 12/31/16 2/8/17 19:44 61,292,000 422,652,000 39 19.86206 0.145018 58 InvenSense Inc 1294924 Deloitte & 1 4/3/16 5/25/16 17:06 -21,254,990 622,500,000 20.24925 -0.034145 59 INTERMOLECULAR INC 1311241 Armanino L 20474 12/31/16 3/3/17 16:16 -15,437,000 53,168,000 62 17.78897 -0.290344 50 Mellanox Technologies, Ltd. 1356104 Pricewatert 1 12/31/16 2/17/17 16:11 18,518,000 1,473,505,000 ooo 48 21.11091 0.012567 61 ALPHA & OMEGA SEMICONDUCTOR Ltd 1387467 Grant Thorr 6 6/30/16 8/26/16 17:17 -2,928,000 318,505,000 57 19.57915 -0.009193 62 Gig Peak, Inc. 1432150 BPM LLP 29311 12/31/16 3/15/17 16:31 2,233,000 140,435,000 74 18.76026 0.015901 63 MACOM Technology Solutions Holdings, Inc. 1493594 Deloitte & 1 W 9/30/16 11/17/16 16:44 1,434,000 1,188,551,000 18 20.896 0.001207 64 Qorvo, Inc. 1604778 KPMG LLP 4/2/16 5/31/16 17:01 -28,845,000 6,596,819,000 59 22.60985 -0.004373 65 Xperi Corp 1690666 Pricewatert 12/31/16 2/27/17 16:39 56,089,000 1,186,436,000 58 20.89422 0.047275 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Linear Algebra

Authors: Peter J. Olver, Cheri Shakiban

1st edition

131473824, 978-0131473829

More Books

Students also viewed these Mathematics questions