One problem facing the manager of maintenance departments is when to change the bulbs in streetlamps. If bulbs are changed only when they burn out, it is quite costly to send crews out to change only one bulb at a time. This method also requires someone to report the problem and, in the meantime, the light is off. If each bulb lasts approximately the same amount of time, they can all be replaced periodically, producing significant cost savings in maintenance. Suppose that a financial analysis of the lights at Yankee Stadium has concluded that it will pay to replace all of the light bulbs at the same time if the variance of the lives of the bulbs is less than 200 ℎ????2. The lengths of life of the last 100 bulbs were recorded. What conclusion can be drawn from these data? Use a 5% significance level. ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS. Lifetimes 2000 1996 1994 1991 1999 1978 1979 2013 1992 2007 1990 2014 1994 1997 1997 1981 1988 2001 1993 2002 2009 1985 1985 2006 2006 2020 1992 1995 1992 1982 1999 2007 1992 1988 2001 1970 2009 2001 2007 2004 1992 1993 2002 2019 2024 2023 2023 2017 2008 2029 2017 2000 2029 1996 2007 1995 1995 2031 2010 2013 1994 1991 2001 1981 1994 1983 1978 2003 2002 2001 2009 2004 2006 1989 2016 1988 2035 1978 2005 2009 1978 2000 1998 2002 2008 1993 1989 1996 1977 1982 2008 2007 1983 2001 1995 1997 1992 2005 1984 2018
One problem facing the manager of maintenance departments is when to change the bulbs in streetlamps. If bulbs are changed only when they burn out, it is quite costly to send crews out to change only one bulb at a time. This method also requires someone to report the problem and, in the meantime, the light is off. If each bulb lasts approximately the same amount of time, they can all be replaced periodically, producing significant cost savings in maintenance. Suppose that a financial analysis of the lights at Yankee Stadium has concluded that it will pay to replace all of the light bulbs at the same time if the variance of the lives of the bulbs is less than 200 ℎ????2. The lengths of life of the last 100 bulbs were recorded. What conclusion can be drawn from these data? Use a 5% significance level. ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS.
Lifetimes |
2000 |
1996 |
1994 |
1991 |
1999 |
1978 |
1979 |
2013 |
1992 |
2007 |
1990 |
2014 |
1994 |
1997 |
1997 |
1981 |
1988 |
2001 |
1993 |
2002 |
2009 |
1985 |
1985 |
2006 |
2006 |
2020 |
1992 |
1995 |
1992 |
1982 |
1999 |
2007 |
1992 |
1988 |
2001 |
1970 |
2009 |
2001 |
2007 |
2004 |
1992 |
1993 |
2002 |
2019 |
2024 |
2023 |
2023 |
2017 |
2008 |
2029 |
2017 |
2000 |
2029 |
1996 |
2007 |
1995 |
1995 |
2031 |
2010 |
2013 |
1994 |
1991 |
2001 |
1981 |
1994 |
1983 |
1978 |
2003 |
2002 |
2001 |
2009 |
2004 |
2006 |
1989 |
2016 |
1988 |
2035 |
1978 |
2005 |
2009 |
1978 |
2000 |
1998 |
2002 |
2008 |
1993 |
1989 |
1996 |
1977 |
1982 |
2008 |
2007 |
1983 |
2001 |
1995 |
1997 |
1992 |
2005 |
1984 |
2018 |
Step by step
Solved in 3 steps with 1 images