how to do analysis of functions
Find the real basic functions by repeatedly asking ‘Why?’ the item is required until answers can no longer be found. For example, the function of a teenager’s dress might be ‘to look good’. Asking ‘Why?’ results in the more basic function of ‘attract attention of opposite sex’.
The best way of finding basic functions is usually to ask the customer. Another possible approach is to observe them in action. Consulting specifications may be appropriate, but is based on the possibly false assumption that these are correct.
With your question clearly defined and your measurement priorities set, now it’s time to collect your data. As you collect and organize your data, remember to keep these important points in mind:
In your organizational or business data analysis, you must begin with the right question(s). Questions should be measurable, clear and concise. Design your questions to either qualify or disqualify potential solutions to your specific problem or opportunity.
By interchanging the roles of the independent and dependent variables in a given function, one can obtain an inverse function. Inverse functions do what their name implies: they undo the action of a function to return a variable to its original state. Thus, if for a given function f(x) there exists a function g(y) such that g(f(x)) = x and f(g(y)) = y, then g is called the inverse function of f and given the notation f −1 , where by convention the variables are interchanged. For example, the function f(x) = 2x has the inverse function f −1 (x) = x/2.
The formula for the area of a circle is an example of a polynomial function. The general form for such functions is P(x) = a0 + a1x + a2x 2 +⋯+ anx n , where the coefficients (a0, a1, a2,…, an) are given, x can be any real number, and all the powers of x are counting numbers (1, 2, 3,…). (When the powers of x can be any real number, the result is known as an algebraic function.) Polynomial functions have been studied since the earliest times because of their versatility—practically any relationship involving real numbers can be closely approximated by a polynomial function. Polynomial functions are characterized by the highest power of the independent variable. Special names are commonly used for such powers from one to five—linear, quadratic, cubic, quartic, and quintic.
The FORECAST.ETS function in Excel 2016 or later is a great function which can detect a seasonal pattern.
2. Enter the value 89 into cell C11, select the range A1:C14 and insert a scatter plot with straight lines and markers.
1. On the Data tab, in the Forecast group, click What-If Analysis.
5. Enter the corresponding value 0.6 and click on OK again.