1 of 11

Analysis on Electricity Consumption Main Campus

Done by

Shikhar Sinha�Naitik Gandhi

2 of 11

Business and Analytical Problem

Minimizing the electricity consumption of main campus.

Identify variables affecting our objective.

Reduce the cash expense on electricity.

Analyze the energy Usage.

Determine effective energy reduction method.

Develop a regression model.

  • Business Problem
  • Analytical Problem

3 of 11

Data and Assumptions

Data of year 2018 and 2022 utilized.

Data considered for analysis is average KWH usage, average temperature, class enrolment and number of classes.

Data considered only for classes happening in-person and hybrid classes.

Temperature and KWH reading taken between 7am to 10pm only considered.

Classes with 0 enrollment are completely ignored.

FCN, FCS, blank cells and web under building columns were ignored.

4 of 11

Methodology Selection

CORRELATION

REGRESSION ANALYSIS

5 of 11

Model Building and Development.

 

Avg KWH 2022

2022 Avg Temp

Class Enrollment 2022

Number of classes 2022

Avg KWH 2022

1

 

 

 

2022 Avg Temp

0.994805339

1

 

 

Class Enrollment 2022

-0.732746523

-0.681055447

1

 

Number of classes 2022

-0.803618816

-0.757336279

0.977213491

1

6 of 11

Model Building and Development continued.

  • Quadratic (2nd Degree) 2018
  • Cubic (3rd Degree) 2018

7 of 11

Model Building and Development continued.

  • Quadratic (2nd Degree) 2022
  • Cubic (3rd Degree) 2022

8 of 11

Regression Equations

The regression equation is

  • Avg KWH usage 2018 = 1212 - 44.72 Avg Temp 2018 + 0.8799 Avg Temp 2018^2 - 0.004829 Avg Temp 2018^3
  • Avg KWH usage 2022 = 435.7 + 5.135 Avg Temp 2022 - 0.1511 Avg Temp 2022^2 + 0.001891 Avg Temp 2022^3

​

9 of 11

Deployment and Solutions

More Hybrid classes.

Minimum classes in peak hours.

Increasing classes on Friday.

Room wise temperature control.

Minimum buildings usage in summer.

Renewable energy resource.

10 of 11

Conclusion

NO RELATION FOUND BETWEEN NUMBER OF CLASS AND ENERGY CONSUMPTION.

OCCUPANCY IS ALSO NOT THE FACTOR VARYING CONSUMPTION.

ELECTRICITY CONSUMPTION TOTALLY RELY ON OUTSIDE TEMPERATURE.

11 of 11

Question and Answers

​

​

Thank You.