Nobody downloaded yet

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…

- Subject: Miscellaneous
- Type: Essay
- Level: College
- Pages: 3 (750 words)
- Downloads: 0
- 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 PAPERMaths and Excel exercise

- Tags:
- Aerobic Exercise
- Anaerobic Exercise
- Benefits of exercise
- Correlation
- Cubic Equations
- Excel
- Exercise
- Malcolm X
- Maths
- Optimization

Download file to see previous pages...
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 ...Download file to see next pagesRead More

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 ...Download file to see next pagesRead More

Comments (0)

Click to create a comment

Let us find you another Essay on topic Maths and Excel exercise for **FREE!**