Regression using the data

by | Feb 16, 2022 | Data Analysis

read the and download the file posted here, then watch the video posted in the folder about how to conduct regression in Microsoft excel, and then emulate the regression results using the excel file titled “production excel data” for production case to be posetd (2 tables)”. Then discuss about the two regression results about the production function using two inputs : Labor and Capital. Upload the excel file containing results of the two regressions. Comment on inclusion of which other variables would have made this production function model more realistic. These two regression results need to be included in the same excel file as separate worksheet ply (please watch the posted video about how to insert regression results as separate worksheet ply).

  1. Please conduct regression using the data on the excel file titled “car_sales_data_for_regression_assignment” and then save the regression results on separate worksheet ply as shown on the how to video in this regard. Please comment on the sign and statistical significance of the estimated coefficients of seven independent variables (dependent variable is “cars_sold_annually”). Please comment on inclusion of which other variables would have further improve the predictability of the model. Please upload your excel file containing the regression results.
  2. Create a power point file and in 6-8 (minimum six and maximum eight) slides please interpret the regression results as found in the Production function estimates and the annual car sales regression exercises. Please add your voice narration to your power point analysis (watch the video posted in this folder about how to add voice narration to your power point presentation slides).

let me know if you have any questions in this regard. In your power point slides, please answer to the following questions:

A. List the dependent variable (Y-variable) and independent variables (X-variables) in the “production function model” and in the “annual car sales” model? Interpret the sign and magnitude of the estimated coefficients of these two models and comment on their statistical significance (if P-values of an estimated coefficient is 0.05 or less then it is statistically significant). Please comment on the coefficient of determinations (R-squared) of the models (production model and car sales model).

B. Please refer to the PDF file provided and explain why sometimes it is better to use a Cobb Douglas production function on When it is recommended that we use “Double log or Log Linear production function” instead of a “Linear production function”? If you are the manager, to make the production function model more “realistic”, which other variables you may include to increase the explainability of the model? (Think about other factions of production, besides labor and capital and think about the practicality of data collection about the variables that are currently non included in the model, but you would like to include them in the regression model as a manager)

C. Comment on suitability of the independent variables (the X-variables) the annual car sales data and the regression results. Which other independent variables you would like to include in the model to improve the explainability power of the model? If you are the manager of this multilocation car dealership, how would you go about managing the data collection process for the variables that are currently missing in the model and you would like to include them in the model.

Sample Solution

Sample solution

Dante Alighieri played a critical role in the literature world through his poem Divine Comedy that was written in the 14th century. The poem contains Inferno, Purgatorio, and Paradiso. The Inferno is a description of the nine circles of torment that are found on the earth. It depicts the realms of the people that have gone against the spiritual values and who, instead, have chosen bestial appetite, violence, or fraud and malice. The nine circles of hell are limbo, lust, gluttony, greed and wrath. Others are heresy, violence, fraud, and treachery. The purpose of this paper is to examine the Dante’s Inferno in the perspective of its portrayal of God’s image and the justification of hell. 

In this epic poem, God is portrayed as a super being guilty of multiple weaknesses including being egotistic, unjust, and hypocritical. Dante, in this poem, depicts God as being more human than divine by challenging God’s omnipotence. Additionally, the manner in which Dante describes Hell is in full contradiction to the morals of God as written in the Bible. When god arranges Hell to flatter Himself, He commits egotism, a sin that is common among human beings (Cheney, 2016). The weakness is depicted in Limbo and on the Gate of Hell where, for instance, God sends those who do not worship Him to Hell. This implies that failure to worship Him is a sin.


This question has been answered

God is also depicted as lacking justice in His actions thus removing the godly image. The injustice is portrayed by the manner in which the sodomites and opportunists are treated. The opportunists are subjected to banner chasing in their lives after death followed by being stung by insects and maggots. They are known to having done neither good nor bad during their lifetimes and, therefore, justice could have demanded that they be granted a neutral punishment having lived a neutral life. The sodomites are also punished unfairly by God when Brunetto Lattini is condemned to hell despite being a good leader (Babor, T. F., McGovern, T., & Robaina, K. (2017). While he commited sodomy, God chooses to ignore all the other good deeds that Brunetto did.

Finally, God is also portrayed as being hypocritical in His actions, a sin that further diminishes His godliness and makes Him more human. A case in point is when God condemns the sin of egotism and goes ahead to commit it repeatedly. Proverbs 29:23 states that “arrogance will bring your downfall, but if you are humble, you will be respected.” When Slattery condemns Dante’s human state as being weak, doubtful, and limited, he is proving God’s hypocrisy because He is also human (Verdicchio, 2015). The actions of God in Hell as portrayed by Dante are inconsistent with the Biblical literature. Both Dante and God are prone to making mistakes, something common among human beings thus making God more human.

To wrap it up, Dante portrays God is more human since He commits the same sins that humans commit: egotism, hypocrisy, and injustice. Hell is justified as being a destination for victims of the mistakes committed by God. The Hell is presented as being a totally different place as compared to what is written about it in the Bible. As a result, reading through the text gives an image of God who is prone to the very mistakes common to humans thus ripping Him off His lofty status of divine and, instead, making Him a mere human. Whether or not Dante did it intentionally is subject to debate but one thing is clear in the poem: the misconstrued notion of God is revealed to future generations.

 

References

Babor, T. F., McGovern, T., & Robaina, K. (2017). Dante’s inferno: Seven deadly sins in scientific publishing and how to avoid them. Addiction Science: A Guide for the Perplexed, 267.

Cheney, L. D. G. (2016). Illustrations for Dante’s Inferno: A Comparative Study of Sandro Botticelli, Giovanni Stradano, and Federico Zuccaro. Cultural and Religious Studies, 4(8), 487.

Verdicchio, M. (2015). Irony and Desire in Dante’s” Inferno” 27. Italica, 285-297.

This question has been answered.

Get Answer