StudentShare solutions

# Maths and Excel exercise - Essay Example

## 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. ...
TOTEXP2
10.82
109.38

Note: 95% Confidence Interval has been calculated for the left tail, since all 3 variables show skewed distributions.
e)
Correlation coefficient r = 0.9927

Correlation coefficient r = 0.9979
f) The regression equation for TOTEXP1 Vs FINC is y = .59x + 1.5, while the regression equation for TOTEXP2 Vs FINC is y = .16x + .088
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. One possible interpretation is that spending on less basic needs is more constrained by income than spending on more basic needs ...Show more

## Summary

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
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Maths and Excel exercise"
with a personal 20% discount.
Grab the best paper

### Check these samples - they also fit your topic

Excel Project
Software prepared by Oracle listed below: Oracle E-Business Suite Financials Oracle’s PeopleSoft Accounting and financial software prepared by Sage Company are: ACT!, Sage Abra, FAS, CPA Software, MAS 90, Sage Fundraising, Sage MIP Fund Accounting, SalesLogix and Peachtree.
6 pages (1500 words) Essay
Misconception in maths
Problem A: Two examples of student’s misconception that could cause this error can be firstly the concept of multiplication of signed numbers is not clear among the students. They might have a misconception that when numbers of opposite signs are multiplied with each other the sign of the greater number which is multiplied will be there on the product or will affect the sign of the product.
1 pages (250 words) Essay
Maths investigation
12*1/3=4. here the total area is the area of the triangle in the stage 0 plus the areas of the smaller triangles with side 1/3, which are 3 in number. At stage 2 each side of the figure in the stage 1 is replaced by the zigzag line(keeping the orientation same) with each segment of the zigzag line being 1/3 of the each side in the stage 1 i.e.
3 pages (750 words) Essay
MS Excel
Managers can utilize Excel in several ways and for several scenarios as well. Primarily though, the spreadsheet is most valuable when managers ponder on and engage in the decision making process. Its value lies in the fact that it is a highly efficient tool for analyzing data.
2 pages (500 words) Essay
Maths Coursework Investigating Borders
Now we list the total number of squares for patterns beginning from pattern 1 and onwards. Then we list the difference between two adjoining values and the third row gives the difference
4 pages (1000 words) Essay
Maths
A logistic model takes a similar form to the geometric, but the growth factor depends on the size of the population and is variable. The growth factor is often estimated as a linear function by taking estimates of the projected initial growth rate and the eventual
10 pages (2500 words) Essay
Excel Project
Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided. The Sales Trend Analysis involves the
3 pages (750 words) Essay
Exercise for windows excel
The most important part of this process is the planning, which includes the steps necessary to fulfill the task. This process has as primary step the initiation phase, in which the scope of the project and the resources
3 pages (750 words) Essay
Maths Construction
c) Company Building Control design produces resistors by specification. The resistance R is given by R= R0 (1+αt). R0 is the
2 pages (500 words) Essay
Excel
Abbott Laboratories has a relatively higher average return and lower risk when compared to Unilever and S & P 500 which has a higher average return than it but a higher risk rate.
11 pages (2750 words) Essay
Click to create a comment
Let us find you another Essay on topic Maths and Excel exercise for FREE!