Explain variance, standard deviation and beta. What do these terms describe about data? Show your calculations of variance and standard deviation using one variable (for example: test grades OR minutes of study time on this data set) of the approved data tables in the attachment below. Then use your own Excel software to calculate answers using one of the data sets below and attach the worksheet in your discussion text box. Try checking your work using descriptive statistics in the Data Analysis Pak. Make sure you provide a picture of the descriptive input box from Data Analytics in your worksheet. In your response postings, evaluate the worksheet of other students, discuss the calculations, and provide helpful tips on using Excel to calculate these descriptive statistics.

B C D E F G H Monarch Darden SP500 Walmart Moderna Casino Restaurants Amazon Apple 128.17 147.20 54.47 129.18 170.92 176.76 130.84 55.12 128.27 144.47 144.36 56.50 135.37 136.56 183.74 176.24 128.45 131.98 140.49 57.52 146.33 131.76 173.16 52.85 116.89 . 144.64 138.86 131.02 61.50 121.98 146.63 126.95 129.65 60.76 121.08 144.15 131.85 112.75 61.16 123.97 143.50 132.49 61.22 118.76 104.47 123.39 145.95 131.77 59.50 117.53 126.47 140.23 57.40 115.80 156.93 52.40 112.38 8,137.88 8,142.79 8,039.67 7,681.01 7,942.20 7,789.79 7,905.28 7,759.35 7,648.39 7,659.75 7,562.46 7,634.77 7,505.38 7,336.76 7,390.61 7,230.51 6,734.84 7,135.81 7,172.70 7,157.94 6,889.60 6,784.95 6,826.72 6,868.22 7,043.62 146.46 148.37 151.05 149.69 122.23 122.07 116.42 152.52 114.47 53.30 56.51 3,303.73 3,308.64 3,277.71 3,352.15 3,206.20 3,292.23 3,104.25 3,182.70 3,256.93 3,172.69 3,201.65 3,116.42 3,162.58 3,195.34 3,099.40 3,128.81 3,311.37 3,036.15 3,204.40 3,272.71 3,286.65 3,125.00 3,095.13 2,954.91 3,116.22 127.03 149.99 117.16 97.61 49.40 109.61 108.12 107.26 145.24 119.08 89.39 47.74 138.24 118.31 72.45 48.94 101.81 43.39 91.64 143.33 144.18 142.26 108.51 114.67 67.47 70.53 73.94 45.40 46.41 99.23 98.64 118.64 73.00 46.49 139.99 136.77 116.59 112.66 68.81 45.66 101.38 103.58 96.59 89.43 134.80 111.92 69.47 45.28 136.20 69.87 106.50 111.64 45.36 44.41 142.31 59.34 86.28 B C D E F G H Monarch Darden SP500 Walmart Moderna Casino Restaurants Amazon Apple 128.17 147.20 54.47 129.18 170.92 176.76 130.84 55.12 128.27 144.47 144.36 56.50 135.37 136.56 183.74 176.24 128.45 131.98 140.49 57.52 146.33 131.76 173.16 52.85 116.89 . 144.64 138.86 131.02 61.50 121.98 146.63 126.95 129.65 60.76 121.08 144.15 131.85 112.75 61.16 123.97 143.50 132.49 61.22 118.76 104.47 123.39 145.95 131.77 59.50 117.53 126.47 140.23 57.40 115.80 156.93 52.40 112.38 8,137.88 8,142.79 8,039.67 7,681.01 7,942.20 7,789.79 7,905.28 7,759.35 7,648.39 7,659.75 7,562.46 7,634.77 7,505.38 7,336.76 7,390.61 7,230.51 6,734.84 7,135.81 7,172.70 7,157.94 6,889.60 6,784.95 6,826.72 6,868.22 7,043.62 146.46 148.37 151.05 149.69 122.23 122.07 116.42 152.52 114.47 53.30 56.51 3,303.73 3,308.64 3,277.71 3,352.15 3,206.20 3,292.23 3,104.25 3,182.70 3,256.93 3,172.69 3,201.65 3,116.42 3,162.58 3,195.34 3,099.40 3,128.81 3,311.37 3,036.15 3,204.40 3,272.71 3,286.65 3,125.00 3,095.13 2,954.91 3,116.22 127.03 149.99 117.16 97.61 49.40 109.61 108.12 107.26 145.24 119.08 89.39 47.74 138.24 118.31 72.45 48.94 101.81 43.39 91.64 143.33 144.18 142.26 108.51 114.67 67.47 70.53 73.94 45.40 46.41 99.23 98.64 118.64 73.00 46.49 139.99 136.77 116.59 112.66 68.81 45.66 101.38 103.58 96.59 89.43 134.80 111.92 69.47 45.28 136.20 69.87 106.50 111.64 45.36 44.41 142.31 59.34 86.28