Statistics for Business: Decision Making and Analysis, 3rd Edition

• ... due to a single outlier as in the plot below. It may be that most of the data fall roughly along a straight line with the exception of an outlier.

  

  

  19.5-9 Full Alternative Text

19.1 Analytics in Excel: Estimating Consumption

Read the data file 19_4m_gas_consumption.csv into Excel. The worksheet has 49 rows and four columns that give the month, the year, the gas consumption, and the average monthly temperature. The first task is to compute the number of degrees below 65 degrees. The value should be zero if the temperature is 65 degrees or higher, ...