A data set is down below & contains development data for many… A data set is down below & contains development data for many countries around the world. The columns in the files are as follows Y Annual percentage growth rate of GDP X1 Improved water source (% of population with access) Access to an improved water source refers to the percentage of the population using an improved drinking water source. X2 Improved sanitation facilities (% of population with access) Access to improved sanitation facilities refers to the percentage of the population using improved sanitation facilities.X3 Access to electricity (% of population) Access to electricity is the percentage of population with access to electricity.X4 Renewable energy consumption (% of total final energy consumption) Renewable energy consumption is the share of renewables energy in total final energy consumption. X5 CO2 emissions (metric tons per capita) Carbon dioxide emissions are those stemming from the burning of fossil fuels and themanufacture of cement.X6 Internet users (per 100 people) Internet users are individuals who have used the Internet (from any location) in the last 12 months(a) Using the data set Homework1.Regression.xlsx, please run a regression with Annual Percentage Growth rate of GDP as the dependent (Y) variable and all other variables are the independent (X) variables – X1, X2, X3, X4, X5, X6. The definitions of all the X variables are given above. Please copy and paste your Excel output into your word document and do not submit your Excel file. (b) What can you say about the goodness of fit of the equation? Please explain. (c) Based on the definitions of the variables as given above (i) Would you expect the coefficient of X1 to be positive or negative? Explain. (ii) Would you expect the coefficient of X3 to be positive or negative? Explain, (d) Which independent variables have a significant coefficient in the regression? Explain. (e) Based on the results of your regression only, do you think that the producing in a sustainable manner (as measured by the independent (X) variables) have an impact on annual percent growth rate of GDP? Explain. Business Economics BC 807
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more