please help me solve this practice question using excel functions # of vacation days 0 0 0 0 0 1 1 2 2 2 3 3 3 4 5 5 6 6 7 8 9 15 15 20 22 50
Minimization
In mathematics, traditional optimization problems are typically expressed in terms of minimization. When we talk about minimizing or maximizing a function, we refer to the maximum and minimum possible values of that function. This can be expressed in terms of global or local range. The definition of minimization in the thesaurus is the process of reducing something to a small amount, value, or position. Minimization (noun) is an instance of belittling or disparagement.
Maxima and Minima
The extreme points of a function are the maximum and the minimum points of the function. A maximum is attained when the function takes the maximum value and a minimum is attained when the function takes the minimum value.
Derivatives
A derivative means a change. Geometrically it can be represented as a line with some steepness. Imagine climbing a mountain which is very steep and 500 meters high. Is it easier to climb? Definitely not! Suppose walking on the road for 500 meters. Which one would be easier? Walking on the road would be much easier than climbing a mountain.
Concavity
In calculus, concavity is a descriptor of mathematics that tells about the shape of the graph. It is the parameter that helps to estimate the maximum and minimum value of any of the functions and the concave nature using the graphical method. We use the first derivative test and second derivative test to understand the concave behavior of the function.
please help me solve this practice question using excel
# of vacation days | ||
0 | ||
0 | ||
0 | ||
0 | ||
0 | ||
1 | ||
1 | ||
2 | ||
2 | ||
2 | ||
3 | ||
3 | ||
3 | ||
4 | ||
5 | ||
5 | ||
6 | ||
6 | ||
7 | ||
8 | ||
9 | ||
15 | ||
15 | ||
20 | ||
22 | ||
50 | ||
![93
94 2)
Use the vlookup function to find :
Note: Remember that you have to sort your data first and follow the steps in your class note to find the answer
95
96
97
a) The first quartile
98
99
100
b) The second quartile
101
102
103
104
c) Compare your result with the one obtained by using the Excel's built-in functions
105
106
107 3)
108
109
Find the sum of the deviations (x-mean)
110](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff4ddd6b9-9555-4bd2-8187-6cd68a751f90%2F376cb1df-6df9-4482-b8ae-db60911f3a74%2Frqnj81l_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)