Suppose that a car-rental agency offers insurance for a week that costs $ 10 per day. A minor fender bender will cost $ 1,500, whereas a major accident might cost $ 15,000 in repairs. Develop a payoff...

1 2 2 3.8461538461538464E-2 3.8461538461538464E-2 2 8 10 0.15384615384615385 0.19230769230769232 3 20 30 0.38461538461538464 0.57692307692307698 4 16 46 0.30769230769230771 0.88461538461538469 5 6 52 0.11538461538461539 1 52 1 1 1 1.9230769230769232E-2 1.9230769230769232E-2 2 6 7 0.11538461538461539 0.13461538461538464 3 23 30 0.44230769230769229 0.57692307692307687 4 14 44 0.26923076923076922 0.84615384615384603 5 8 52 0.15384615384615385 0.99999999999999989 52 1 3 3 5.7692307692307696E-2 5.7692307692307696E-2 2 6 9 0.11538461538461539 0.17307692307692307 3 23 32 0.44230769230769229 0.61538461538461542 4 16 48 0.30769230769230771 0.92307692307692313 5 4 52 7.6923076923076927E-2 1 52 3 3 3 5 4 5 5 4 4 5 4 2 3 3 2 2 1 3 4 4 4 2 3 3 2 4 3 3 3 3 5 5 3 5 5 2 4 3 3 4 2 4 2 4 1 3 3 3 2 4 3 4 3 5 3 4 4 3 3 4 3 2 3 4 3 4 3 2 3 3 3 1 4 3 3 4 2 3 3 3 5 4 3 3 1 3 4 4 4 2 1 2 4 2 3 3 3 3 3 2 3 3 4 3 4 3 5 4 3 5 3 2 5 4 3 5 4 3 4 4 3 4 4 3 4 3 3 3 4 3 4 3 4 3 1 4 3 3 4 3 2 5 5 5 4 2 4 3 3 3 4 4 2 4 5 3 Type Cell Phone Survey Gender Carrier Usage Signal strength Value for the Dollar Customer Service M AT&T Basic Average Camera Smart High Very high F Low Other Sprint T-mobile Verizon Hint: Create data tables and histogrmas for the columns Signal Strength, Value for the Dollar and Customer Service. The histogram should be a combined column chart showing the frequency distributions and a line chart showing the cumulative relative frequencies. To recieve full credit, the Excel charts should be "presentation quality" including a title, legend and labels on the apropriate axis. (10 points) 1. Create the frequency distributions and histograms for the numerical data in the Tab Cell Phone Survey . EBTM 306 – Fundamentals of Project Management and Business Decisions Fall Semester - 2013 Final Exam Total Points: 30 Name: 2. Follow these...