The attached Excel file contains daily stock price data for an American firm and the NYSE Composite Index. Calculate the beta for the stock over the 30-day period.

Date Stock NYSE 2/22/2023

108.94 15530.83 2/21/2023 109.25 15572.52 2/17/2023 112.99 15840.16 2/16/2023 112.00 15873.78 2/15/2023 113.29 16016.09 2/14/2023 112.72 16025.11 2/13/2023 113.77 16052.25 2/10/2023 112.39 15910.69 2/9/2023 111.45 15828.60 2/8/2023 113.74 15934.72 2/7/2023 115.37 16021.62 2/6/2023 114.98 15895.36 2/3/2023 115.95 15999.40 2/2/2023 118.72 16122.58 2/1/2023 114.35 16121.25 1/31/2023 113.58 16036.39 1/30/2023 111.11 15818.90 1/27/2023 113.74 15962.58 1/26/2023 112.07 15985.87 1/25/2023 111.45 15889.27 1/24/2023 113.50 15868.22 1/23/2023 121.02 15880.09 1/20/2023 119.07 15777.55 1/19/2023 116.88 15569.63 1/18/2023 121.15 15649.13 1/17/2023 124.95 15883.56 1/13/2023 127.82 15918.37 1/12/2023 127.66 15859.55 1/11/2023 127.43 15749.09 1/10/2023 126.46 15608.17 1/9/2023 125.13 15514.44

1.91

2.38

1.79

0.25

0.52