The Data
The dataset "energy" is a random sample of 56 cases from “Existing Buildings Energy Performance Ordinance Report” from the City of San Francisco Open Data Portal. There are 2,629 cases in the dataset.
Citation: SFEBO Help Desk.(Last updated 11/13/2020).Existing Buildings Energy Performance Ordinance Report [data file]. Provided by SF Environment. (Retrieved 11/29/2020). https://data.sfgov.org/Energy-and-Environment/Existing-Buildings-Energy-Performance-Ordinance-Re/j2j3-acqj
There are 57 cases. Each case is a building in San Francisco that must be benchmarked using Energy Star Portfolio Manager annually.
There are 6 variables:
- parcel - the parcel number
- building - the building name
- postal_code - the postal code
- year_built - the year the building was built
- energy_score19 - the ENERGY STAR score for 2019; 1 - 100, where 50 is the national median score, and 100 is best energy performance.
- energy_score18 - the ENERGY STAR score for 2018
energy.csv download https://data.sfgov.org/Energy-and-Environment/Existing-Buildings-Energy-Performance-Ordinance-Re/j2j3-acqj
The Statistics
For the 57 building in the sample, the average change from scores in 2018 to 2019 was 1.614035, with a standard deviation of 9.315414.
Question
Use the statistics from the energy dataset to answer the following question:
"With 99% confidence, what is the average change in ENERGY STAR scores from 2018 to 2019 for all buildings in San Francisco that require annual benchmarks?"
*If any conditions are not met, please state which one(s) and proceed with the inference.