Please show excel functions used or work The credit scores of 35-year-olds apply

Question

Please show excel functions used or work

The credit scores of 35-year-olds applying for a mortgage at Ulysses Mortgage Associates are normally distributed with a mean of 600 and a standard deviation of 90. Find the credit score that defines the upper 5 percent. (Use Excel or Appendix C to calculate the z-value. Round your final answer to 2 decimal places.) Credit score Seventy-five percent of the customers will have a credit score higher than what value? (Use Excel or Appendix C for calculation of z-value. Round your final answer to 2 decimal places.) Credit score Within what range would the middle 80 percent of credit scores lie? (Use Excel or Appendix C for calculation of z-value. Round your final answer to 2 decimal places.)

Explanation / Answer

a) for top 5% scores ,.at 95 percentile; z=1.6449

hence corresponding score =mean+z*std deviation =748.04

b)for this , at 25 percentile z=-0.6745

hence score =539.30

c)for middle 80%; it will lie b/w 10 and 90 percntile for which z=+/-1.2816

hence corresponding scores =484.66 to 715.34

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.