Hello: I have a small data set and I want to confirm that the average formulas I am using are correct: What I want to make sure is that I am using the correct average formulas to accomplish the following:
1)monthly average
2)Monthly weighted average
3)3 month rolling average
The data set has only 2 columns. Can somebody help me on confirming that I am getting the correct results. I have attached the file per the link below. Thanks in advance. Regards
https://www.dropbox.com/s/hqfye35pvgp3ax2/averagequestion.xlsx?dl=0
1)monthly average
2)Monthly weighted average
3)3 month rolling average
The data set has only 2 columns. Can somebody help me on confirming that I am getting the correct results. I have attached the file per the link below. Thanks in advance. Regards
https://www.dropbox.com/s/hqfye35pvgp3ax2/averagequestion.xlsx?dl=0