How would you calculate this in excel format

show formulas

Generate a series with the same number of observations as the return series. Each observation of the new series corresponds to the outcome of a Bernoulli random variable, Y. The outcome is 1 if the net stock return in the same month is larger than or equal to 0.014 and zero otherwise.

Company name	(primary) exchange	net return
1 800 FLOWERS COM INC	Q	0.076466221
10X GENOMICS INC	Q	0.175065495
111 INC	Q	0.31702544
1347 PROPERTY INSURANCE HLDS INC	Q	0.189655172
180 DEGREE CAPITAL CORP	Q	-0.011494253
1ST CONSTITUTION BANCORP	Q	0.085868499
1ST SOURCE CORP	Q	0.00914219
2 U INC	Q	-0.038091419
21VIANET GROUP INC	Q	0.070901034
22ND CENTURY GROUP INC	A	0.067961165
3 D SYSTEMS CORP DEL	N	0.030624264
360 FINANCE INC	Q	0.028421053
36KR HOLDINGS INC	Q	-0.127508855
3M CO	N	0.039170643
500 COM LTD	N	-0.09947644
51JOB INC	Q	0.079877894
58 COM INC	N	0.052178153
89BIO INC	Q	-0.159258075
8I ENTERPRISES ACQUISITION CORP	Q	0
8X8 INC NEW	N	-0.108187135
9F INC	Q	-0.069767442
A A R CORP	N	0.009174312
A B B LTD	N	0.103527256
A B M INDUSTRIES INC	N	-0.007370361
A C C O BRANDS CORP	N	0.02295082
A C I WORLDWIDE INC	Q	0.010266667

Answer rating: 100% (QA)

ANSWER To generate a series of Bernoulli random variables based on the net return series we can use the IF function in Excel First create a new column ... View the full answer