Wk 4
****MUST BE IN EXCEL/SHOW WORK/NO PLAGIARISM*****Complete the problems below from the textbook. You will need to use the “Lincolnville School District Bus Data” and the “Century National Bank Data” files for this assignment.The files are located in the topic materials. For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.
ChartDataSheet_
This worksheet contains values required for MegaStat charts.
Boxplot 1/28/2010 16:03.39
2 741
2 806
3 806
3 827
1 827
3 827
3 851.5
2 851.5
2 908
2 851.5
1 851.5
1 806
2 806
1 669.5
3 669.5
1 737.75
3 737.75
1 919.75
3 919.75
1 988
3 988
Boxplot 1/28/2010 16:06.08
2 741
2 806
3 806
3 827
1 827
3 827
3 851.5
2 851.5
2 908
2 851.5
1 851.5
1 806
2 806
1 669.5
3 669.5
1 737.75
3 737.75
1 919.75
3 919.75
1 988
3 988
Dotplot 1/28/2010 16:06.08
741 1
751 1
757 1
757 2
760 1
774 1
775 1
780 1
784 1
785 1
790 1
792 1
798 1
799 1
799 2
800 1
802 1
803 1
804 1
806 1
806 2
809 1
812 1
815 1
815 2
815 3
816 1
816 2
817 1
817 2
817 3
818 1
819 1
819 2
821 1
822 1
823 1
826 1
827 1
827 2
827 3
828 1
830 1
831 1
832 1
835 1
836 1
837 1
838 1
839 1
842 1
842 2
842 3
844 1
845 1
846 1
847 1
848 1
849 1
851 1
853 1
856 1
857 1
857 2
858 1
859 1
859 2
864 1
865 1
866 1
866 2
869 1
870 1
873 1
874 1
882 1
883 1
885 1
895 1
908 1
Boxplot 1/28/2010 16:08.20
2 741
2 806
3 806
3 827
1 827
3 827
3 851.5
2 851.5
2 895
2 851.5
1 851.5
1 806
2 806
1 669.5
3 669.5
1 737.75
3 737.75
1 919.75
3 919.75
1 988
3 988
1.8 980
1.8 1008
Dotplot 1/28/2010 16:08.20
741 1
751 1
757 1
757 2
760 1
774 1
775 1
780 1
784 1
785 1
790 1
792 1
798 1
799 1
799 2
800 1
802 1
803 1
804 1
806 1
806 2
809 1
812 1
815 1
815 2
815 3
816 1
816 2
817 1
817 2
817 3
818 1
819 1
819 2
821 1
822 1
823 1
826 1
827 1
827 2
827 3
828 1
830 1
831 1
832 1
835 1
836 1
837 1
838 1
839 1
842 1
842 2
842 3
844 1
845 1
846 1
847 1
848 1
849 1
851 1
853 1
856 1
857 1
857 2
858 1
859 1
859 2
864 1
865 1
866 1
866 2
869 1
870 1
874 1
882 1
883 1
885 1
895 1
980 1
1008 1
Bus
Data Set 3 –Lincolnville School District Bus Data
ID Manufacturer Engine Type (0=diesel) Capacity Maintenance Cost Age Odometer Miles Miles
10 Keiser 1 14 4646 5 54375 11973
396 Thompson 0 14 1072 2 21858 11969
122 Bluebird 1 55 9394 10 116580 11967
751 Keiser 0 14 1078 2 22444 11948
279 Bluebird 0 55 1008 2 22672 11925
500 Bluebird 1 55 5329 5 50765 11922 Variables
520 Bluebird 0 55 4794 10 119130 11896
759 Keiser 0 55 3952 8 87872 11889 ID = Bus identification number
714 Bluebird 0 42 3742 7 73703 11837
875 Bluebird 0 55 4376 9 97947 11814 Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson)
600 Bluebird 0 55 4832 10 119860 11800
953 Bluebird 0 55 5160 10 117700 11798 Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1)
101 Bluebird 0 55 1955 4 41096 11789
358 Bluebird 0 55 2775 6 70086 11782 Capacity = number of seats on the bus
29 Bluebird 1 55 5352 6 69438 11781
365 Keiser 0 55 3065 6 63384 11778 Maintenance cost = dollars spent to maintain a bus last year
162 Keiser 1 55 3143 3 31266 11757
686 Bluebird 0 55 1569 3 34674 11707 Age = number of years since the bus left the manufacturer
370 Keiser 1 55 7766 8 86528 11704
887 Bluebird 0 55 3743 8 93672 11698 Odometer Miles = total number of miles traveled by a bus
464 Bluebird 1 55 2540 3 34530 11698
948 Keiser 0 42 4342 9 97956 11691 Miles = number of miles traveled since last maintenance
678 Keiser 0 55 3361 7 75229 11668
481 Keiser 1 6 3097 3 34362 11662
43 Bluebird 1 55 8263 9 102969 11615
704 Bluebird 0 55 4218 8 83424 11610
814 Bluebird 0 55 2028 4 40824 11576
39 Bluebird 1 55 5821 6 69444 11533
699 Bluebird 1 55 9069 9 98307 11518
75 Bluebird 0 55 3011 6 71970 11462
693 Keiser 1 55 9193 9 101889 11461
989 Keiser 0 55 4795 9 106605 11418
982 Bluebird 0 55 505 1 10276 11359
321 Bluebird 0 42 2732 6 70122 11358
724 Keiser 0 42 3754 8 91968 11344
732 Keiser 0 42 4640 9 101196 11342
880 Keiser 1 55 8410 9 97065 11336
193 Thompson 0 14 5922 11 128711 11248
884 Bluebird 0 55 4364 9 92457 11231
57 Bluebird 0 55 3190 7 79240 11222
731 Bluebird 0 42 3213 6 68526 11168
61 Keiser 0 55 4139 9 103536 11148
135 Bluebird 0 55 3560 7 76426 11127
833 Thompson 0 14 3920 8 90968 11112
671 Thompson 1 14 6733 8 89792 11100
692 Bluebird 0 55 3770 8 93248 11048
200 Bluebird 0 55 5168 10 103700 11018
754 Keiser 0 14 7380 14 146860 11003
540 Bluebird 1 55 3656 4 45284 10945
660 Bluebird 1 55 6213 6 64434 10911
353 Keiser 1 55 4279 4 45744 10902
482 Bluebird 1 55 10575 10 116534 10802
398 Thompson 0 6 4752 9 95922 10802
984 Bluebird 0 55 3809 8 87664 10760
977 Bluebird 0 55 3769 7 79422 10759
705 Keiser 0 42 2152 4 47596 10755
767 Keiser 0 55 2985 6 71538 10726
326 Bluebird 0 55 4563 9 107343 10724
120 Keiser 0 42 4723 10 110320 10674
554 Bluebird 0 42 1826 4 44604 10662
695 Bluebird 0 55 1061 2 23152 10633
9 Keiser 1 55 3527 4 46848 10591
861 Bluebird 1 55 9669 10 106040 10551
603 Keiser 0 14 2116 4 44384 10518
156 Thompson 0 14 6212 12 140460 10473
427 Keiser 1 55 6927 7 73423 10355
883 Bluebird 1 55 1881 2 20742 10344
168 Thompson 1 14 7004 7 83006 10315
954 Bluebird 0 42 5284 10 101000 10235
768 Bluebird 0 42 3173 7 71778 10227
490 Bluebird 1 55 10133 10 106240 10210
725 Bluebird 0 55 2356 5 57065 10209
45 Keiser 0 55 3124 6 60102 10167
38 Keiser 1 14 5976 6 61662 10140
314 Thompson 0 6 5408 11 128117 10128
507 Bluebird 0 55 3690 7 72849 10095
40 Bluebird 1 55 9573 10 118470 10081
918 Bluebird 0 55 2470 5 53620 10075
387 Bluebird 1 55 6863 8 89960 10055
418 Bluebird 0 55 4513 9 104715 10000 Sheet1
Balance ATM Services Debit Interest City
1756 13 4 0 1 2
748 9 2 1 0 1
1501 10 1 0 0 1
1831 10 4 0 1 3
1622 14 6 0 1 4
1886 17 3 0 1 1
740 6 3 0 0 3
1593 10 8 1 0 1
1169 6 4 0 0 4
2125 18 6 0 0 2
1554 12 6 1 0 3
1474 12 7 1 0 1
1913 6 5 0 0 1
1218 10 3 1 0 1
1006 12 4 0 0 1
2215 20 3 1 0 4
137 7 2 0 0 3
167 5 4 0 0 4
343 7 2 0 0 1
2557 20 7 1 0 4
2276 15 4 1 0 3
1494 11 2 0 1 1
2144 17 3 0 0 3
1995 10 7 0 0 2
1053 8 4 1 0 3
1526 8 4 0 1 2
1120 8 6 1 0 3
1838 7 5 1 1 3
1746 11 2 0 0 2
1616 10 4 1 1 2
1958 6 2 1 0 2
634 2 7 1 0 4
580 4 1 0 0 1
1320 4 5 1 0 1
1675 6 7 1 0 2
789 8 4 0 0 4
1735 12 7 0 1 3
1784 11 5 0 0 1
1326 16 8 0 0 3
2051 14 4 1 0 4
1044 7 5 1 0 1
1885 10 6 1 1 2
1790 11 4 0 1 3
765 4 3 0 0 4
1645 6 9 0 1 4
32 2 0 0 0 3
1266 11 7 0 0 4
890 7 1 0 1 1
2204 14 5 0 0 2
2409 16 8 0 0 2
1338 14 4 1 0 2
2076 12 5 1 0 2
1708 13 3 1 0 1
2138 18 5 0 1 4
2375 12 4 0 0 2
1455 9 5 1 1 3
1487 8 4 1 0 4
1125 6 4 1 0 2
1989 12 3 0 1 2
2156 14 5 1 0 2 Problem 44
Problem 48
Problem 56
Problem 66
Problem 71
Case A Ch 8
Problem 44
An economist uses the price of a gallon of milk as a measure of inflation. She finds that the average price is $3.82 per gallon and the population standard deviation is $0.33. You decide to sample 40 convenience stores, collect their prices for a gallon of milk, and compute the mean price for the sample.
a. What is the standard error of the mean in this experiment?
b. What is the probability that the sample mean is between $3.78 and $3.86?
c. What is the probability that the difference between the sample mean and the population mean is less than $0.01?
Problem 48
Refer to the Lincolnville School District bus data. Information provided by manufacturers of school buses suggests the mean maintenance cost per year is $4,400 per bus with a standard deviation of $1,000. Compute the mean maintenance cost for the Lincolnville buses. Does the Lincolnville data seem to be in line with that reported by the manufacturer? Specifically, what is the probability of Lincolnville’s mean annual maintenance cost, or greater, given the manufacturer’s data?
Ch 9
Problem 56
Families USA, a monthly magazine that discusses issues related to health and health
costs, surveyed 20 of its subscribers. It found that the annual health insurance premiums
for a family with coverage through an employer averaged $10,979. The standard
deviation of the sample was $1,000.
a. Based on this sample information, develop a 90% confidence interval for the population
mean yearly premium.
b. How large a sample is needed to find the population mean within $250 at 99%
confidence?
Problem 66
Near the time of an election, a cable news service performs an opinion poll of 1,000 prob-able voters. It shows that the Republican contender has an advantage of 52% to 48%.
a. Develop a 95% confidence interval for the proportion favoring the Republican candidate.
b. Estimate the probability that the Democratic candidate is actually leading.
c. Repeat the above analysis based on a sample of 3,000 probable voters.
Problem 71
Refer to the Lincolnville School District bus data.
a. Develop a 95% confidence interval for the mean bus maintenance cost.
b. Develop a 95% confidence interval for the mean bus odometer miles.
c. Make a business memo to the state transportation official to report your results.
Case Study
Century National Bank Refer to the description of Century National Bank at the end of the Review of Chapters 1-4 on page 129. When Mr. Selig took over as president of Century several years ago, the use of debit cards was just beginning. He would like an update on the use of these cards. Develop a 95% confidence interval for the proportion of customers using these cards. On the basis of the confidence interval, is it reasonable to conclude that more than half of the customers use a debit card? Make a brief report interpreting the results.
Info needed for case
Century National Bank has offices in several cities in the Midwest and the southeastern part of the United States. Mr. Dan Selig, president and CEO, would like to know the characteristics of his checking account customers. What is the balance of a typical customer? How many other bank services do the checking account customers use? Do the customers use the ATM service and, if so, how often? What about debit cards? Who uses them, and how often are they used? To better understand the customers, Mr. Selig asked Ms. Wendy Lamberg, director of planning, to select a sample of customers and report. To begin, she has appointed a team from her staff. You are the head of the team and responsible for preparing the report. You select a random sample of 60 customers. In addition to the balance in each account at the end of last month, you determine (1) the number of ATM (automatic teller machine) transactions in the last month; (2) the number of other bank services (a savings account, a certificate of deposit, etc.) the customer uses; (3) whether the customer has a debit card (this is a bank service in which charges are made directly to the customer’s account); and (4) whether or not interest is paid on the checking account. The sample includes customers from the branches in Cincinnati, Ohio; Atlanta, Georgia; Louisville, Kentucky; and Erie, Pennsylvania.
