Statistics Homework Solutions
#2515
Simple statistical excell functions/formulas
Please DO NOT respond if you're UNABLE to give detailed and specific answer to both question.
Let's say I have two columns of numbers (5 in each column).
1/ Pls. advise of the following functions' FORMULA in excell:
percentile
range
rank
weighted average
confidence
correlation
forecast
2/ and elaborate as to WHAT that function is telling me (how is it useful)?
What is this?
By OTA - Overall OTA Rating
Sheng Huang, MSc - 4.6/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- formula.xls
- explanation.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Percentile Rank - Refer to the math scores of the 12 students below: 75 80 68 53 99 58 76 73 85 88 91 79 Find the percentile rank for the score 85. Give a brief interpretation of this percentile rank.
- Corresponding percentile of a z value - True or false. The z-value which corresponds to the 18th percentile is z = -0.92.
- Find the Percentile - 22. The following frequency distribution presents a set of exam scores for a class of N=20 students. x f cf c% 90-99 4 20 100 80-89 7 16 80 70-79 4 9 45 60-69 3 5 25 50-59 2 2 10 a. find th ...
- Estimated percentile rank - Tthe mean for a special distribution is 100 and the standard deviation is 15. What is the estimated percentile for an individual who had a score of 90 on this scale?
- Mean and Standard Deviation and 95% confidence interval for mean - 1. A sample of 10 high school students completed a course designed to increase SAT verbal scores. The following is the summary for this group’s SAT verbal scores after completion of the course: ] ...
