1. Make a formula that calculates the mean/average of monthly sales across all stores, all days, in thousands of dollars. Hint: input data is already in 1000s

2. Make a formula that calculates the number of observations you have in the data

For the remaining questions in this section, use the following values, which show the sales from three stores over three months. When answering each question, enter the calculation that uses the appropriate Excel formula. 50 100 20 110 200 20 120 200 150 200 30 Sales ($k) Store Month B C C A January C C January A February | February A March 30 A April B March | April January February March April