Assignment 1

  Hi, This is my last assignment for the semester, unfortunately I got bad marks in pervious quizzes and assignments. This is my only option to cover up for pass grade. Please go through the note which is stated above the  introduction. Also attached the files includes assignment questions and data sheets.  Subject: Computer Applications for Energy ManagementNote: To get full credit from this assignment, the student MUST implement, analyze, answer, and discuss each section of the assignment properly.1. IntroductionHVAC systems typically consume around 70% of a base building’s energy usage, with 25-35% of energy consumed by chillers producing chilled water for air-conditioning. Therefore, the efficiency of chillers and the optimization of their performance within the HVAC systems they operate are important in achieving high performance.2. Purpose of the AssignmentIn this assignment a one-year historical data (daily chilled water-1 excel file attached) for a chiller within a building has been measured. The main aims of this assignment are that students

• Taste the flavor of forecasting methods within buildings.
• Understand basic concepts of short-term/midterm forecasting.
• Learn how to
• capture the salient features using different regression models
• build regression models using Excel
• justify how well the models have fitted the data
• develop a model for one day ahead load forecasting

3. QuestionsStudents must answer the following questions in details.

1. Plot the data and apply the simple linear regression (SLR) model and second order regression (SOR) model for the chilled water and HDD. In both cases, find the mathematical models for producing daily chilled water as well.
2. Use the obtained models above to forecast the chilled water that you would expect for the next January (2014) if the HDD varies as shown in Table 1 (attached).
3. Apply multiple linear regression (MLR) model for the chilled water and all parameters impacting the amount of chilled water. Find the mathematical model for producing daily chilled water as well.
4. Use the obtained MLR model above to forecast the chilled water that you would expect for the next January (2014) if the RH, Tdew-C and HDD vary as shown in Table 1 (attached).
5. Calculate MAPE and RMSE for each model (SLR, SOR, and MLR) and discuss which model(s) is more fitted with the historical data?

4. DatasetBelow are the dataset and instruction available to perform the assignment. Please download them and follow the instruction.