Perform a multiple regression analysis without the meter

Assignment Help Microeconomics
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

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd