QBA 1720 Exam 2: Key Concepts & Excel Functions
QBA 1720 Exam 2 Note Sheet
Key Concepts and Formulas
Measures of Central Tendency:
Mean (Average):
=AVERAGE(range)Median:
=MEDIAN(range)Mode:
=MODE.SNGL(range)
Measures of Variability:
Standard Deviation:
=STDEV.S(range)Variance:
=VAR.S(range)68-95 Rule:
68% of data is within 1 standard deviation.
95% of data is within 2 standard deviations.
COUNTIFS Function:
Counts based on multiple conditions:
=COUNTIFS(criteria_range1,criteria1,[criteria_range2,criteria2],…)Example: Count the number of students who
Locke and Rousseau: Contrasting Political Philosophies
Locke and the Liberal State
In his book, *The Second Treatise on Civil Government*, John Locke reflects the views of the rising bourgeois class. According to Locke, man is rational and free, and his highest aspiration is happiness. The end of politics is the pursuit of happiness, which would be impossible without peace, harmony, and security.
Locke develops a theory of state and determines the source of the government’s legitimacy. He believes that the main priorities of his political philosophy are:
Read MoreInflation Impact, Financial Tools, Eurozone Policy, Economic Growth
Effects of Inflation
Loss of Buying Power: When inflation occurs, the prices paid by economic agents increase. Consequently, the purchasing power of money decreases.
Uncertainty: Prices contain valuable information for economic agents to make decisions. Inflation alters prices, destroying their informative capacity and provoking uncertainty.
Loss of Competitiveness of Domestic Production Overseas: Inflation will decrease the volume of exports of goods and services.
Unemployment: Two effects of inflation
Read MoreUnderstanding the Evolution of Life Forms and Humans
Evolution of Life Forms: A Theory
Conventional religious literature presents the theory of special creation, which suggests that:
- All living organisms we see today were created as such.
- The diversity of life has remained constant since creation and will continue to be the same in the future.
- The Earth is approximately 4,000 years old.
These ideas faced strong challenges during the nineteenth century. Based on observations made during a sea voyage around the world in a sail ship called H.M.S. Beagle,
Read MoreEffective Study Strategies and Note-Taking for Students
Motivation Strategies for University Students
People have different sources of motivation. Here are three strategies that university students can use to develop motivation:
- Studying together is beneficial. When students meet and discuss a certain subject, new ideas are born. This enriches their thinking and engraves information in their brains.
- Rewarding oneself is also motivating. After a long day of studying in a library with classmates, there’s nothing more rewarding than hanging out with favorite
Earth: Composition, Structure, and Atmosphere
Earth, the third planet from the Sun (150 million km), is not a perfect sphere due to its rotation. Its equatorial radius is 21 km longer than its polar radius, with an average radius of 6368 km. The Earth’s mass is approximately 6 x 1024 kg, and its density is 5.5 g/cm3.
Origin of Earth
The Earth’s origin is linked to the formation of the solar system. It began with a cloud of gas and dust, the remnants of material expelled by supernovae. A perturbation in this cloud, possibly from a supernova, caused
Read MoreRoman Property Law: Rights, Limits, and Defense
Item No. 3: The Property
Property is the power that belongs to a person, named the owner, to directly obtain from a certain thing all the legal use this thing is likely to provide.
Characters
-
It was an absolute right, not because it may have limitations, but because the powers of the owner are not prohibited or limited exhaustively and are therefore indeterminate. The advantages of ownership are reduced to three:
- Jus utendi: the right to use the thing.
- Jus fruendi: the right to obtain fruits and revenues.
The Evolution of Society: From Divine Rule to Modern State
Creations: The Legitimacy of Power
The legitimacy of power is given by a superior being (the existence of God). According to the Jews, the year 5770 was the creation of Genesis. God gave power to an elected individual and bestowed upon him the attributes for this.
Create = Power Law
Contract: Thomas Hobbes
In the seventeenth century, Leviathan. The foundation is not God, and they had to attack the church; the church was the bourgeoisie. Questioning the monarchy was to challenge power. The monarch torpedoed
Read MoreUnderstanding Concepts and Operational Definitions in Research
The Concept
The concept itself is a key element in the investigation. The conceptualization of a phenomenon is achieved through the determination of inherent properties that can be described through their similarities, differences, associations, and/or reinforcements. We can refer to any scientific theoretical system called a system of concepts or conceptual system.
“Now, we use these terms to represent phenomena or aspects thereof that we are investigating. Therefore, when we formulate a proposition,
Read MoreJunior Financial Controller Application & Legal Terms
Dear Hiring Manager,
I am writing to express my interest in the Junior Financial Controller position you have available. I possess the necessary skills and experience you are seeking and would make a valuable addition to your company.
My Double Degree in Business and Law and my current job as a Financial Controller have provided me with a well-rounded background and enabled me to develop an analytical/logical approach to tasks, software skills, and the ability to work under pressure. My current