I'm trying to calculate an average and STD of a very long list of number. In column A I have a list of numbers from 1 to 17. In column B I have a number that tells me how many times the number in column A appears in my raw data.
For example- cell A2 has the number 1 and cell B2 has the number 340, which measn that in my raw data, the number 1 appears 340 times. Unfortunately, I cannot use the raw data to calculate the average. Here is the data I have: