Franklin University Math215 - Statistical Concepts Name: _______________________ Graphical Summaries - Application Assignment Download the Excel file with the Light Bulb data from your course page in Week2 Application Assignment. That file contains the life (in hours) of a sample of 40 100-watt light bulbs produced by Manufacturer A and a sample of 40 100-watt light bulbs produced by manufacturer B. Answer the following questions using Excel Analysis Tool Pack. Any graphs in Excel should be cut and paste on this Word document. You will turn in a single Word document, not an Excel file. 1. Construct a frequency distribution and a relative frequency distribution for Manufacturer A with a class width of 20.Copy and paste your distribution tables here. 2. Construct a histogram based on this frequency distribution table for Manufacturer A. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?) 3. Construct a frequency distribution and a relative frequency distribution for Manufacturer B with a class width of 20.Copy and paste your distribution tables here. 4. Construct a histogram based on this frequency distribution table for Manufacturer B. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?) 5. Compare the histograms in questions 2 and 4. Which manufacturer seems to produce longer lasting light bulbs? 6. Now, construct a frequency distribution table and a relative frequency distribution table for Manufacturer A with a class width of 100, starting at 650. Copy and paste your distribution tables here. 7. Construct a histogram based on this frequency distribution table for Manufacturer A. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?) 8. Now, construct a frequency distribution table and a relative frequency distribution table for Manufacturer B with a class width of 100, starting at 750. Copy and paste your distribution tables here. 9. Construct a histogram based on this frequency distribution table for Manufacturer B. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?) 270616 Franklin University Math215 - Statistical Concepts Name: _______________________ 10. Compare the histograms in questions 7 and 9. Which manufacturer seems to produce longer lasting light bulbs? 11. Compare the histograms in questions 2 and 7. Explain how changing the class width changes the shape of the distribution here. 12. Compare the histograms in questions 4 and 9. Explain how changing the class width changes the shape of the distribution here. 270616