Question
Overview: Calculate a regression and interpret it. a) Download the sheet containing Michigan GDP by quarter and the total Michigan income from Proprietors of business.
Overview: Calculate a regression and interpret it.
a) Download the sheet containing Michigan GDP by quarter and the total Michigan income from Proprietors of business. b) Properly format the data so you can do a regression (note that paste has a Transpose function) c) Do a regression and write some interpretation of the data. d) Take both the columns of data you have and take the natural log of each column. In Excel the command is ln ( column row ) e.g. (ln(c3)). Do another regression using the natural log-transformed variables. e) When you have a ln-ln regression model, the interpretation is approximated by a percentage (formally it is ex or Exp(x) where x is the parameter coefficient). In other words, if the coefficient is .03X, it would mean the Y variable increases by 3% for every unit change in X. Based on your analysis, what percentage of total Michigan GDP do Proprietors contribute? Is it statistically significant?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started