Wk8

Complete the problems below from the textbook. You will need to use the “Lincolnville School District Bus Data” file for this assignment.  The file is located in the topic materials.

1. Chapter 12 – Problem 51
2. Chapter 15 – Problem 57
3. Chapter 15 – Problem 64

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.

Submit output in one Excel file.

2

>ChartDataSheet_

/2

/2

1

:0

.3

2

1

2

3 806
3

1 827

3 827

3

1

.5

2

2

2 851.5

1 851.5
1 806

2 806

1

3 669.5
1

3 737.75
1

3 919.75
1

3 988

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

741 1

1

1

757 2

1

1

1

1

1

1

1

1

1

1

799 2

1

1

1

1

806 1
806 2

1

1

1

815 2
815 3

1

816 2

1

817 2
817 3

1

1

819 2

1

1

1

1

827 1
827 2
827 3

1

1

1

1

1

1

1

1

1

1

842 2
842 3

1

1

1

1

1

1

851 1

1

1

1

857 2

1

1

859 2

1

1

1

866 2

1

1

1

1

1

1

1

1

908 1

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

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

																											This worksheet contains values required for MegaStat charts.
Boxplot																																																																																																																																																																																	1										8																																																					0												10														6																																				3														9
													7								4
															806
														827
									8				5
			851.5
		908
					669.5
					737.	75
					919.75
					988
Boxplot 1/28/2010 16:06.08
Dotplot 1/28/2010 16:06.08
		751
			7	57
	760
	774
	775
	780
	784
	785
	790
	792
	798
			799
	800
	802
	803
	804
	809
	8	12
					815
			816
					817
	818
			819
	821
	822
	823
	826
	828
	830
	831
	832
	835
	836
	837
	8	38
	8	39
					8											42
	844
	8	45
	846
	847
	848
	849
	853
	856
			857
	858
			859
	864
	865
			866
	869
	870
873
	874
	882
		883
	885
		895
Boxplot 1/28/2010 16:08.20
	1.8		980
		1008
Dotplot 1/28/2010 16:08.20

Bus

Miles

10

1

6

5

75

973

0 14

2

1

10

751 Keiser 0 14

2

Bluebird 0 55 1008 2

Bluebird 1 55

5

65

Bluebird 0 55

10

Keiser 0 55

8

Bluebird 0 42

7

3

Bluebird 0 55

9

Bluebird 0 55

10

Bluebird 0 55

10

Bluebird 0 55

4

Bluebird 0 55

6

29 Bluebird 1 55

6

Keiser 0 55

6

Keiser 1 55

3

3

Bluebird 0 55

9

3

370 Keiser 1 55

8

Bluebird 0 55

8

464 Bluebird 1 55

3

11698

948 Keiser 0 42

9

Keiser 0 55

7

Keiser 1 6

3

43 Bluebird 1 55

9

704 Bluebird 0 55

8

814 Bluebird 0 55

4

39 Bluebird 1 55

6

Bluebird 1 55

9

75 Bluebird 0 55

6

Keiser 1 55

9

Keiser 0 55

9

5

Bluebird 0 55

1

9

Bluebird 0 42

6

Keiser 0 42

8

732 Keiser 0 42

9

Keiser 1 55

9

193 Thompson 0 14

11

Bluebird 0 55

9

57 Bluebird 0 55

7

Bluebird 0 42

6

61 Keiser 0 55

9

6

135 Bluebird 0 55

7

Thompson 0 14

8

Thompson 1 14

8

Bluebird 0 55

8

Bluebird 0 55

10

754 Keiser 0 14

14

540 Bluebird 1 55

4

660 Bluebird 1 55

6

353 Keiser 1 55

9

4

Bluebird 1 55

10

Thompson 0 6

9

10802

Bluebird 0 55

8

Bluebird 0 55

7

Keiser 0 42

4

Keiser 0 55

6

Bluebird 0 55

9

Keiser 0 42

10

Bluebird 0 42

4

Bluebird 0 55

2

9 Keiser 1 55

4

Bluebird 1 55

10

Keiser 0 14

4

156 Thompson 0 14

12

427 Keiser 1 55

7

883 Bluebird 1 55

2

168 Thompson 1 14

7

Bluebird 0 42 5284 10

Bluebird 0 42

7

Bluebird 1 55

10

Bluebird 0 55

5

45 Keiser 0 55

6

38 Keiser 1 14

6

314 Thompson 0 6

11

507 Bluebird 0 55

7

40 Bluebird 1 55

10

Bluebird 0 55

5

Bluebird 1 55

8

418 Bluebird 0 55

9

Data Set 3 –Lincolnville School District Bus Data
ID	Manufacturer	Engine Type (0=diesel)	Capacity	Maintenance Cost	Age	Odometer	Miles
																								Keiser												14		464	5	43			11
396								Thompson	1072	21858	11969
122																																															Bluebird																																																							55	9394	116580	11967
1078	22444	11	948
279	22672	11925
500	53	29		507	11922	Variables
520	4794	119130	11896
759	3952	87872	11889	ID = Bus identification number
714	3742	7	370	11837
875	4376	97947	11	814	Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson)
600	4832	119860	11800
953	5160	117700	11798	Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1)
101	1955	41096	11789
358	2775	70086	11782	Capacity = number of seats on the bus
5352	69438	11781
365	3065	63384	11778	Maintenance cost = dollars spent to maintain a bus last year
162		314	31266	11757
686		156	34674	11707	Age = number of years since the bus left the manufacturer
7766	86528	11	704
887	3743	93672		11698	Odometer Miles = total number of miles traveled by a bus
2	5	40	34530
4342	97956	11691	Miles = number of miles traveled since last maintenance
678	33	61	75229	11668
481	3097	34362	11662
8263	102969	11615
4218	83424	11610
2028	40824	11576
5821	69444	11533
699	9069	98307	11518
3011	71970	11462
693	9	193	101889	11461
989	4795	10	660	11	418
982	505	10276	1	135
321	2	732	70122	11358
724	3	754	91968	11344
4640	101196	11342
880	8410	97065	11336
5922	128711	11248
884	4364	92457	11231
3190	79240	11222
731	3213	68526	11	168
4139	10	353	11148
3560	76426	11127
833	3920	90968	11112
671	6733	89792	11100
692	3770	93248	11048
200	5168	103700	11018
7380	146860	11003
3656	4	5284	10945
6213	64434	10911
	427	45744	10902
482	10575	116534		10802
398	4752	95922
984	3809	87664	10760
977	3769	79422	10759
705	2152	47596	10755
767	2985	71538	10726
326	4563	107343	10724
120	4723	110320	10674
554	1826	44604	10662
695	1061	23152	10633
3527	46848	10591
861	9669	106040	10551
603	2116	44384	10518
6212	140460	10473
6927	73423	10355
1881	20742	10344
7004	83006	10315
954	101000	10235
768	3173	71778	10227
490	10133	106240	10210
725	2356	57065	10209
3124	60102	10167
5976	61662	10140
5408	128117	10128
3690	72849	10095
9573	118470	10081
918	2470	53620	10075
387	6863	89960	10055
4513	104715	10000

Problem 51

Refer to the Lincolnville School District bus data.

a. Conduct a test of hypothesis to reveal whether the mean maintenance cost is equal for each of the bus manufactures. Use the .01

significance level.

b. Conduct a test of hypothesis to determine whether the mean miles traveled since the last maintenance is equal for each bus manufacturer. Use the .05 significance level.

Problem 57

A survey investigated the public’s attitude toward the federal deficit. Each sampled citizen was classified as to whether he or she felt the government should reduce the deficit or increase the deficit, or if the individual had no opinion. The sample results of the study by gender are reported below.

Gender        Reduce the Deficit           Increase the deficit         No Opinion

Female           244                             194                                         68

Male               305                             114                                         25

At the .05 significance level, is it reasonable to conclude that gender is independent of a person’s position on the deficit?

Problem 64

Refer to the Lincolnwood School District bus data.

a. Suppose we consider a bus “old” if it has been in service more than 8 years. At the

.01 significance level, can we conclude that less than 40% of the district’s buses are

old? Report the p-value.

b. Find the median maintenance cost and the median age of the buses. Organize the

data into a two-by-two contingency table, with buses above and below the median of

each variable. Determine whether the age of the bus is related to the amount of the

maintenance cost. Use the .05 significance level.

c. Is there a relationship between the maintenance cost and the manufacturer of the

bus? Use the breakdown in part (b) for the buses above and below the median maintenance cost and the bus manufacturers to create a contingency table. Use the .05

significance level.

Problem 51

Problem 57

Problem 64