Test at a 5% level of significance whether beer sales exhibit quarterly fluctuation. State the method used and show your work.

umber of models should be developed -one for each major selling area. The available data consisted of 19 consecutive quarterly observations on the following variables: Sales = Quarterly beer sales (in tons) Temp = Average quarterly temperature (in degrees F) Sun = Quarterly total hours of sunlight Q2 = Dummy variable which is 1 for Quarter 2 and 0 otherwise Q3 = Dummy variable which is 1 for Quarter 3 and 0 otherwise Q4 = Dummy variable which is 1 for Quarter 4 and 0 otherwise. The data can be found on the book web site in the file CarlsenQ.txt. Develop a model which can be used to predict quarterly beer sales. Describe any weaknesses in your model. Write up the results in the form of a report that is to be given to the manager at Carlsen's brewery