Data Analysis And Business AnalyticsCompetency

by | Jun 5, 2023 | Statistics

 

Competency 3 Statement
Utilizing statistical regression and time series analysis models, you will be able to evaluate and analyze how multiple variables impact an organization. You
will also be able to create forecasts and interpret data to analyze performance as it impacts strategic planning and comparative advantage for an
organization.
Manipulating data to create models helps us describe and summarize relationships between variables. Understanding how variables relate to each other
helps businesses predict performance and make informed strategic plans. For example, to make an informed recommendation to management regarding
which types of office buildings to acquire or sell, you would model the relationship between assessed value and given variables.
This reflection gives you an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models, and then reflect on office
buildings you recommend acquiring and selling, and why.
Pre-Reflection Exercise
Download the Competency 3 Reflection Data Set. The data set is information about the tax assessment value assigned to medical office buildings in a city.
The following is a list of the variables in the database:
Floor Area: square feet of floor space
Offices: number of offices in the building
Entrances: number of customer entrances
Age: age of the building (years)
Assessed Value: tax assessment value (thousands of dollars)
As you work through the following exercises, note your answers to the given questions so you can easily summarize them in your reflection.
Use the data set to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.
1. Construct a scatter plot in Excel with Floor Area as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear
regression equation and R2 in your graph.
Do you observe a linear relationship between the 2 variables?
2. Use Excels Analysis ToolPak to conduct a regression analysis of Floor Area and Assessment Value.
Is Floor Area a significant predictor of Assessment Value?
3. Construct a scatter plot in Excel with Age as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear
regression equation and R2 in your graph.
Do you observe a linear relationship between the 2 variables?
4. Use Excels Analysis ToolPak to conduct a regression analysis of Age and Assessment Value.
Is Age a significant predictor of Assessment Value?
Construct a multiple regression model.
Use Excels Analysis ToolPak to conduct a regression analysis with Assessment Value as the dependent variable and Floor Area, Offices, Entrances, and Age
as independent variables.
What is the overall fit R2? What is the adjusted R2?
Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?
What is the final model if we only use Floor Area and Offices as predictors?
Suppose our final model is: Assessed Value = 115.9 + 0.26 x Floor Area + 78.34 x Offices.
What would be the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago?

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