Perform a multiple regression analysis without the meter

Reference no: EM131904425

Project -

You have been given data on Electricity usage. You have data on the bill and a number of pieces of data thought to explain/predict the bill. I want you to use the tools learned in this class to tell me what I need to know in order to make a good explanation/prediction of electricity bills. Using the data set "Electric Bill Data" and accompanying documentation in the 'Class Project' folder on the Jupiter site for the course, do the following:

1. Perform a multiple regression analysis without the Meter, Heating, Cooling dummy variables. Use the 5% level of significance.

2. Fully explain the results. This means discuss/interpret each term and its significance, explain what the coefficients mean, the R-square, and F-value.

3. Check for autocorrelation.

4. Check for multicollinearity. (Rule of thumb that a correlation of .7 or more is suspect). (If not using Excel, construct a correlation matrix with coefficients and p values, if able to)

5. Add the three dummy variables. You must be careful, because it is possible to have any combination of new electric meter and new heating or cooling appliances. One can have none of these, one, two or all three, in various combinations. You should try to develop meaningful dummy variables such as:

1=None, 0=else;

1=all new, 0=else;

1=Emeter, 0=else;

1=Emeter and New Heat, 0=else;

1=New Heat, 0=else;

1=New Heat and New Cool, 0=else;

1=New Cool, 0=else.

6. Using the complete model, drop those variables that are not 5% significant.

7. Write out an 'executive summary' of your best results, as per the example below.

8. Using Bill and Time (why can't you use year or month?), perform a simple regression, performing the analyses above. Forecast two months of bills ahead.

9. Using Bill and Time and Time2 , perform a simple regression, performing the analyses above. Forecast two months of bills ahead.

10. Of these last two models, which do you conclude is the best model? Why? Are either of these better than the multiple regressions performed above?

You may use Excel for the regression, or you may use another statistical package if you prefer.

Attachment:- Assignment Files.rar

Reference no: EM131904425

Questions Cloud

Contrasting the collection of secondary data : Comparing and contrasting the collection of secondary data and their uses versus the analysis of current health care records and internal data

Project management a universal process : Are the rules and practices of project management a universal process, or do they change by project? Give some examples.

What influences have humans had on your local environment : What influences have humans had on your local environment, positive or negative? Explain what you found interesting and/or most applicable about body chemistry?

Employee turnover and absenteeism : How do you address a problem at work when there is increased employee turnover and absenteeism? How to motivate employee to focus on their job?

Perform a multiple regression analysis without the meter : Econ 510 Project - Perform a multiple regression analysis without the Meter, Heating, Cooling dummy variables. Use the 5% level of significance

Develop a campaign to help pharmaceutical company sell drug : Develop a campaign to help a pharmaceutical company sell a new drug that will affect the metastasis of cancer. (Use the information from this module).

Develop a low-cost marketing strategy to increase sales : You have been hired by Mr. Winder to develop a low-cost marketing strategy to increase sales and save his newly opened restaurant.

How does transformational leadership increase group effectiv : How does transformational leadership increase group effectiveness? How does transformational leadership impact empowerment and group cohesiveness?

Effectiveness of government organizations : Discuss the complexities involved in determining the effectiveness of government organizations

User Account

All Pages