For context, I take this course about using MatLab, which is basically using code to solve basic mathematics, And I've been assigned a project to solve any problem I could think of. Because I play games and like seeing numbers of what I do, I wanted to know how much in-game currency I could get from missions in a month.
So I've been collecting data for the past month to build my estimation on, considering that:
I get 80-130 from daily quests and I get one daily quest a day, 80 is way more common than 130, and rarity increases with the amount I'll get
I get 0-80 from mission alerts a day, yet its quite rare to get more than 50 a day, and its very common to just get 0
my question is how can I use this excel sheet of the past months data to get an estimate of how much I'll get monthly, and I want to take into account an error chance too?