Testing Hypothesis

Refer to the Excel file Pallet (attached to the assignment) to address all the questions below:

The file contains the weight in pounds from a sample of 368 pallets of Boston shingles and 330 pallets of Vermont shingles.

For the Boston shingles, is there evidence at the 0.05 level of significance that the population mean weight is different from 3150 pounds?
Interpret the meaning of the p-value in (1)
For the Vermont shingles, is there evidence at the 0.05 level of significance that the population mean weight is different from 3700 pounds?
Interpret the meaning of the p-value in (3)
In (1) through (4) do you have to be concerned about the normality assumption? Explain.

Refer to the Excel file Phone for the assignment below:

The file contains samples of 20 problems reported to two different offices of a telecommunication company and the time to clear these problems in minutes from the customers’ lines.

Assuming that the population variances from both offices are equal, is there evidence of a difference in the mean waiting time between the two offices at the 0.05 significance level.
Find the p-value in question (1) and interpret the meaning.
What other assumptions are needed for question (1)?

BostonVermont
32023792
31343652
31343652
32263726
32363728
32503676
32663704
32243656
30883666
31323648
30983708
31183682
30943680
31083670
31003728
30843708
31343678
30903660
31543718
31383636
31563644
31383684
31303688
31183724
31123682
31683660
31663672
31223692
31603672
31463700
31243694
31703706
31323650
31623692
31563746
31363728
31623726
31363714
31363730
31483768
31523740
31663720
32023626
31523692
31543730
31263726
30983734
31063712
31223684
31183718
31643742
31583736
31223730
30643666
31763664
31443688
31563694
31623684
31303688
31563688
31843702
31703676
31763656
31523632
31623652
32003658
32023684
31423670
31703678
31423674
31543674
31583634
31063684
31363708
31703670
31243684
31743746
31603688
31623702
31603666
31183670
31383700
31323658
31403664
31343682
31663672
31223730
31543712
31303720
31063700
30923722
31363728
31503692
31383726
32143686
30923708
31623732
31263724
30863730
31123698
31383686
31183680
31563732
31563718
31443700
31603718
31663666
31723714
31343706
31863718
31463712
31443688
31243736
31223706
31163720
31263714
31403740
31103724
31283744
31143728
31383728
31063680
31423652
31283634
31423640
31443728
31223724
30463704
30623668
31143684
31003652
31263756
30883702
31403840
31403696
31203702
31323732
31303736
31403752
31143696
31083732
31463702
31723640
31023672
31203756
31023710
31323736
31203726
30883800
30843784
31203804
30983740
30963730
30883778
30923718
30623810
30843786
31363766
30803736
30563738
30643726
30883764
31103678
30963728
30943716
30803856
30743816
31143792
31363808
31043802
30803746
31043800
30823780
30803756
30743768
30953768
30983728
30843724
30863736
30743760
30923708
30623688
31083650
31323636
31223628
30783656
31803630
30763730
30723662
31143746
30803726
31023702
30743678
31483676
31123738
31123598
31183718
31183738
30943766
30763750
30503740
31003784
31143760
31003804
31043798
30883804
31483714
30883720
30743760
30743650
30943686
31163750
31043690
31003686
31123718
30983732
30863702
30983706
31363660
31003686
31223650
31323678
31203708
30963706
31003646
31143698
31283644
30843642
30983746
31043714
31243674
31303626
30883592
31103642
31263646
31163734
31103654
31483672
30823684
31423692
31163676
30923666
31063640
31023704
30963650
30783616
31163706
31643770
31243740
31023726
31203706
31143756
30863724
31603718
31723706
31643654
31763730
31243734
31023704
31643734
31523662
31443640
31463618
31663644
30963586
31463566
31343674
31283842
31763764
31663650
31863652
31583740
31363814
31243754
31963714
31783634
31503626
31603658
30923672
31223662
31163662
31223666
31283732
31723710
31643648
30663714
31163748
31323732
31243658
31483680
31383762
31183636
30983700
31323754
30623756
31163652
31483700
31223664
31403672
31343658
31663750
31363662
30683762
31343742
31163788
31523668
31243658
31063726
30803704
30923654
31423684
31123774
30943770
30923788
31323646
31183660
31523696
31243704
31463722
30983682
31683636
31743630
31063630
31843728
31343692
31043688
31403694
31083694
30983744
31863734
3180
3122
3124
3148
3166
3080
3112
3144
3142
3112
3094
3066
3136
3128
3072
3090
3080
3092
3076
3098
3102
3076
3044
3112
3092
3094
3066
3098
3082
3146
3144
3098
3068
3098
3140
3130
3088
3082
TimeLocation
1.481
1.751
0.781
2.851
0.521
1.601
4.151
3.971
1.481
3.101
1.021
0.531
0.931
1.601
0.801
1.051
6.321
3.931
5.451
0.971
7.552
3.752
0.102
1.102
0.602
0.522
3.302
2.102
0.582
4.022
3.752
0.652
1.922
0.602
1.532
4.232
0.082
1.482
1.652
0.722

Last Updated on February 11, 2019