You want to run a simulation and you believe that 60% of your burger sales for a given week show up on the weekends (split evenly between Friday, Saturday and Sunday) while the remaining 40% are evenly divided across the four other weekdays (Monday, Tuesday, Wednesday and Thursday). As an example under this distribution, you would expect to sell 10 burgers on any given Monday.

Your recorded data over the past 11 weeks is below. Use the average demand for each day (Monday to Sunday) to test your assumption about the daily distribution of burger sales.

The data is uploaded as an XLS File.

Looking forward to this forums help in helping me understand how to go about this problem.