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)?

Boston Vermont
3202 3792
3134 3652
3134 3652
3226 3726
3236 3728
3250 3676
3266 3704
3224 3656
3088 3666
3132 3648
3098 3708
3118 3682
3094 3680
3108 3670
3100 3728
3084 3708
3134 3678
3090 3660
3154 3718
3138 3636
3156 3644
3138 3684
3130 3688
3118 3724
3112 3682
3168 3660
3166 3672
3122 3692
3160 3672
3146 3700
3124 3694
3170 3706
3132 3650
3162 3692
3156 3746
3136 3728
3162 3726
3136 3714
3136 3730
3148 3768
3152 3740
3166 3720
3202 3626
3152 3692
3154 3730
3126 3726
3098 3734
3106 3712
3122 3684
3118 3718
3164 3742
3158 3736
3122 3730
3064 3666
3176 3664
3144 3688
3156 3694
3162 3684
3130 3688
3156 3688
3184 3702
3170 3676
3176 3656
3152 3632
3162 3652
3200 3658
3202 3684
3142 3670
3170 3678
3142 3674
3154 3674
3158 3634
3106 3684
3136 3708
3170 3670
3124 3684
3174 3746
3160 3688
3162 3702
3160 3666
3118 3670
3138 3700
3132 3658
3140 3664
3134 3682
3166 3672
3122 3730
3154 3712
3130 3720
3106 3700
3092 3722
3136 3728
3150 3692
3138 3726
3214 3686
3092 3708
3162 3732
3126 3724
3086 3730
3112 3698
3138 3686
3118 3680
3156 3732
3156 3718
3144 3700
3160 3718
3166 3666
3172 3714
3134 3706
3186 3718
3146 3712
3144 3688
3124 3736
3122 3706
3116 3720
3126 3714
3140 3740
3110 3724
3128 3744
3114 3728
3138 3728
3106 3680
3142 3652
3128 3634
3142 3640
3144 3728
3122 3724
3046 3704
3062 3668
3114 3684
3100 3652
3126 3756
3088 3702
3140 3840
3140 3696
3120 3702
3132 3732
3130 3736
3140 3752
3114 3696
3108 3732
3146 3702
3172 3640
3102 3672
3120 3756
3102 3710
3132 3736
3120 3726
3088 3800
3084 3784
3120 3804
3098 3740
3096 3730
3088 3778
3092 3718
3062 3810
3084 3786
3136 3766
3080 3736
3056 3738
3064 3726
3088 3764
3110 3678
3096 3728
3094 3716
3080 3856
3074 3816
3114 3792
3136 3808
3104 3802
3080 3746
3104 3800
3082 3780
3080 3756
3074 3768
3095 3768
3098 3728
3084 3724
3086 3736
3074 3760
3092 3708
3062 3688
3108 3650
3132 3636
3122 3628
3078 3656
3180 3630
3076 3730
3072 3662
3114 3746
3080 3726
3102 3702
3074 3678
3148 3676
3112 3738
3112 3598
3118 3718
3118 3738
3094 3766
3076 3750
3050 3740
3100 3784
3114 3760
3100 3804
3104 3798
3088 3804
3148 3714
3088 3720
3074 3760
3074 3650
3094 3686
3116 3750
3104 3690
3100 3686
3112 3718
3098 3732
3086 3702
3098 3706
3136 3660
3100 3686
3122 3650
3132 3678
3120 3708
3096 3706
3100 3646
3114 3698
3128 3644
3084 3642
3098 3746
3104 3714
3124 3674
3130 3626
3088 3592
3110 3642
3126 3646
3116 3734
3110 3654
3148 3672
3082 3684
3142 3692
3116 3676
3092 3666
3106 3640
3102 3704
3096 3650
3078 3616
3116 3706
3164 3770
3124 3740
3102 3726
3120 3706
3114 3756
3086 3724
3160 3718
3172 3706
3164 3654
3176 3730
3124 3734
3102 3704
3164 3734
3152 3662
3144 3640
3146 3618
3166 3644
3096 3586
3146 3566
3134 3674
3128 3842
3176 3764
3166 3650
3186 3652
3158 3740
3136 3814
3124 3754
3196 3714
3178 3634
3150 3626
3160 3658
3092 3672
3122 3662
3116 3662
3122 3666
3128 3732
3172 3710
3164 3648
3066 3714
3116 3748
3132 3732
3124 3658
3148 3680
3138 3762
3118 3636
3098 3700
3132 3754
3062 3756
3116 3652
3148 3700
3122 3664
3140 3672
3134 3658
3166 3750
3136 3662
3068 3762
3134 3742
3116 3788
3152 3668
3124 3658
3106 3726
3080 3704
3092 3654
3142 3684
3112 3774
3094 3770
3092 3788
3132 3646
3118 3660
3152 3696
3124 3704
3146 3722
3098 3682
3168 3636
3174 3630
3106 3630
3184 3728
3134 3692
3104 3688
3140 3694
3108 3694
3098 3744
3186 3734
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
Time Location
1.48 1
1.75 1
0.78 1
2.85 1
0.52 1
1.60 1
4.15 1
3.97 1
1.48 1
3.10 1
1.02 1
0.53 1
0.93 1
1.60 1
0.80 1
1.05 1
6.32 1
3.93 1
5.45 1
0.97 1
7.55 2
3.75 2
0.10 2
1.10 2
0.60 2
0.52 2
3.30 2
2.10 2
0.58 2
4.02 2
3.75 2
0.65 2
1.92 2
0.60 2
1.53 2
4.23 2
0.08 2
1.48 2
1.65 2
0.72 2