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, ...

Get Statistics for Business: Decision Making and Analysis, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.