Question
Normal distributions can be used for many purposes.One purpose might be to determine warranty times on a new game system.Consider if game systems normally last
Normal distributions can be used for many purposes.One purpose might be to determine warranty times on a new game system.Consider if game systems normally last for 36 months before a failure of some sort with a standard deviation of 5 months.If we wanted to have a warranty that paid off on only 5% of the machines (in other words where 95% of them will work) then we could use:
=NORMINV(0.95,36,5)
which would give 44.22 months.This means that we should set our warranty period at 44 months to make sure that we only have to pay off on 5% of the machines.We obviously want to keep our customers happy and fix their system if it fails after a few months.
Come up with at least two examples for normal distributions (similar to the above) with numbers and the formula (Google Sheets or Excel) that you used.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started