This activity consists of two problems.
Problem One
Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019. He was somewhat surprised to see the high number of what is classified as “late surgeries.” He has asked you, a quality analyst, to examine this data.
He requests the following items from you:
1. Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.
2. Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.
3. Create separate control charts in Excel for the number of late surgeries and the overall number of surgeries with a 95% confidence level. Show all calculations that you use to arrive at these control charts.
4. In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.
Late Surgeries versus Overall Surgeries
Month Number of Surgeries Number of Late Surgeries
January 435 112
February 401 129
March 572 186
April 409 103
May 577 89
June 329 156
July 467 156
August 301 94
September 235 89
October 325 127
November 378 156
December 444 124
Total 4873 1432
Problem Two
Dr. Amanda Guzik, head of infectious diseases for Forest Medical Center in Lake Park Illinois, asks you to analyze the following influenza data that she has collected over five years from cases that were treated at this medical center.
1. Use Excel to create a run chart for the data.
2. Use Excel to create a control chart with a 95% confidence level for this data. Include the mean, the LCL, and the UCL. Show all calculations that you use to arrive at these control charts.
3. In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.
Submit Word document(s) and Excel file(s) showing your responses and calculations.
Influenza Data by Quarter
Year Quarter # of Cases of Influenza Observed
1 1 3452
1 2 346
1 3 483
1 4 3984
2 1 4120
2 2 376
2 3 429
2 4 3583
3 1 4219
3 2 385
3 3 392
3 4 3614
4 1 3568
4 2 439
4 3 326
4 4 4103
5 1 4209
5 2 396
5 3 411
5 4 4008





Activity 1
You could look at the total surgeries completed, and about what fraction were late…and you could determine which month had the highest number of surgeries completed.

Activity 2
You could determine which year/quarter had the highest number of influenza cases…and when was the least.

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.

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.



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 Studies4(8), 487.

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