Question
You will apply regression analysis, a popular statistical method, to study the potential relationship between three variables. For example, how much does the increase in
You will apply regression analysis, a popular statistical method, to study the potential relationship between three variables. For example, how much does the increase in major greenhouse gases such as carbon dioxide and methane in the atmosphere affect Earth's temperature? How important are the inflation and unemployment rates in driving interest rate changes? How significant are the gender and age factors in determining the ratings of a TV show? How much do the state of the economy and advertising expenses affect retail sales? In general, you should select a topic that is neither too technical nor too broad. It would be best to narrow your investigation to a specific (testable) relationship between a few variables. You will need to locate and document your data sources yourself. Data availability should be considered in selecting which research question to pursue. You can use any three data variables you want for your estimated relationship so long as you can justify their relevance for inclusion. There is no restriction on your choice of variables. After all, all you need is to identify three possibly related variables and gather their data for your project. You will have one dependent variable (Y) and two explanatory variables (X1 and X2) in your regression model: Y = 0 + 1X1 + 2X2 + . You will then estimate the model using Excel's regression tool and present the results in your paper.
total electricity consumption in residential Los Angles Area. how much does the total electricity consumption increase when population increases? What is another variable that I can add to my regression model and how can I format my data?
expressed in millions kWH | |
year | electricity consumption |
2020 | 22913.1 |
2019 | 20699.46 |
2018 | 20525.58 |
2017 | 20617.69 |
2016 | 20295.25 |
2015 | 20436.65 |
2014 | 20745.73 |
2013 | 20614.32 |
2012 | 21079.32 |
2011 | 20065.71 |
2010 | 19721.79 |
2009 | 20590.54 |
2008 | 21115.80 |
2007 | 20536.22 |
2006 | 20377.05 |
2005 | 19711.03 |
2004 | 19507.04 |
2003 | 19056.04 |
2002 | 17917.33 |
2001 | 18212.58 |
2000 | 18891.63 |
1999 | 17665.12 |
1998 | 17234.63 |
1997 | 17578.66 |
1996 | 16322.04 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started