Consider the data below of inches of rainfall per month for a region in the Northwestern United States

Plains

April20.1

May 15.3

June 19.8

July 17.4

August 16.8

Suppose you know that the standard deviation of rainfall per month in this region is 1.2 inches. Using Excel (or other appropriate software), find a 98% confidence interval for the average rainfall per month in this region. How many months-worth of data would we need to look at to be sure that our margin of error is less than .5? Please attach your Excel file (or other appropriate software) and, in a written analysis, explain what your conclusion is and why