Maths and Excel exercise - Essay Example

Only on StudentShare

Extract of sample
Maths and Excel exercise

The horizontal dotted line indicates that the blue curve and the green curve have the same maximum. The vertical dotted lines indicate the maxima for the three curves, respectively.
g) The weight of the heads of household appears to be normally distributed. Wages however are extremely skewed, resulting in many households with low wages and a few with high wages. The education level is a symmetric, discrete distribution, with both highly educated and less educated heads of households being rare. Since weight is the only symmetric distributed variable in the table, only in its case are the sample mean and median close to each other. Another indication that weight is indeed normally distributed is the proximity of the actual percentages of weights falling within the three given intervals to the empirical percentages. This is because the empirical percentages are calculated assuming normality of the data. An interesting observation is that the size of the 95% confidence interval for clothing and recreational expenses is actually much higher than that of more basic expenses such as food and housing. It is also interesting to note that clothing and recreational expenses are more tightly correlated with net income than food and household expense are, as indicated by the marginally higher correlation coefficient of TOTEXP2 with FINC than TOTEXP1 with FINC. ...
Download paper


Thus we have two equations for the two unknowns, x and z. Solving these equations gives us x* = 0.2887 and z* = 4.3923, which is the amount that the Government needs to contribute to bring back profit to the original level.
Figure 1. The profit functions for the three optimization scenarios represented in the figure…
Author : starkloraine

Related Essays

MS Excel
Since the decisions that managers make are based on data presented to them, the value of Excel is undoubted. However, in order for managers to understand what the data they have implies, they must make use of analysis tools. Microsoft Excel provides them with such tools. In Excel, managers find different analysis tools particularly those used for statistics.…
2 pages (502 words) Essay
2 pages (502 words) Essay
Memory Game maths GCSE
Most theoretical models of memory distinguish three main systems or types: sensory memory, short-term or working memory, and long-term memory. Within each of these categories are further divisions. Sensory memory refers to the initial, momentary recording of information in our sensory systems. When sensations strike our eyes, they linger briefly in the visual system. This kind of sensory memory is called iconic memory and refers to the usually brief visual persistence of information as it is being interpreted by the visual system. Echoic memory is the name applied to the same phenomenon in the…
4 pages (1004 words) Essay
Maths Coursework Investigating Borders
Here we observe that the second row gives the number of white squares added at each level, and the third row is a constant, that is, 4.…
4 pages (1004 words) Essay
1. A hydroelectric project is expected to create a large lake into which some fish are to be placed. A biologist estimates that if 10,000 fish were introduced into the lake, the population of fish would increase by 50% in the first year, but the long-term sustainable limit would be about 60,000. Form the information above, write two ordered pairs in the form where . Hence, determine the slope and equation of the linear growth factor in terms of .…
10 pages (2510 words) Essay
Excel Project
In the graph provided below, it illustrates that the sales trend of the company is increasing. The trend in the sales growth of the company is rising from the August 2004 and dips down on March, April and July 2005. The sales peaked at $115,000 in the May 2006. Please note that the data for June 2006 is incomplete where it comprises only of three days data and it shall be disregarded. This is the reason for the sales decrease in June 2006.…
3 pages (753 words) Essay
Got a tricky question? Receive an answer from students like you! Try us!