- #1
MrNeWBiE
- 75
- 0
Well am not looking for someone to solve the problems ,,,
am looking for someone telling me how to use excel to solve some problems.
with excel functions.
the problems
"
1.From this population of 500 households, select a simple random sample of 50 households (Use the program embedded in the data file to help you select the sample).
2.Develop bar charts of HLE and frequency, G and frequency,
3.Plot the 50 sample points of MI and MFE values that you obtained in 1 on a scatter diagram. (Plot MI values along the X-axis and MFE values along the Y-axis - does this seem a reasonable suggestion? Why?)
4.Draw a scatter diagram of the sample points relating the FS and MFE values. What conclusion you make of the result?
5.Determine the range, median, mode, mean, standard deviation, variance, Q1, Q3, IQR.
6.Determine the values of rxy from the 50 pairs of MI and MFE values.
7.Calculate all the measures of location and dispersion of the sample of MFE, FS and MI values.
8.Using the estimates of the sample mean and standard deviation obtained in 7 above develop a 90% confidence interval estimate for the mean of the population of MFE, FS and MI values. State any assumptions used.
9.What is the probability of finding more than 3 females as head of house holds in a sample of 20?
"
well first 2 parts I am able to solve them ,,, but the other i don't know the right function ,,,
well i don't want to slove it with the simple method because it will take long time from me ,,, and the doctor asked to solve with excel function .
the sample am working on is in the attachment .
am looking for someone telling me how to use excel to solve some problems.
with excel functions.
the problems
"
1.From this population of 500 households, select a simple random sample of 50 households (Use the program embedded in the data file to help you select the sample).
2.Develop bar charts of HLE and frequency, G and frequency,
3.Plot the 50 sample points of MI and MFE values that you obtained in 1 on a scatter diagram. (Plot MI values along the X-axis and MFE values along the Y-axis - does this seem a reasonable suggestion? Why?)
4.Draw a scatter diagram of the sample points relating the FS and MFE values. What conclusion you make of the result?
5.Determine the range, median, mode, mean, standard deviation, variance, Q1, Q3, IQR.
6.Determine the values of rxy from the 50 pairs of MI and MFE values.
7.Calculate all the measures of location and dispersion of the sample of MFE, FS and MI values.
8.Using the estimates of the sample mean and standard deviation obtained in 7 above develop a 90% confidence interval estimate for the mean of the population of MFE, FS and MI values. State any assumptions used.
9.What is the probability of finding more than 3 females as head of house holds in a sample of 20?
"
well first 2 parts I am able to solve them ,,, but the other i don't know the right function ,,,
well i don't want to slove it with the simple method because it will take long time from me ,,, and the doctor asked to solve with excel function .
the sample am working on is in the attachment .