# Refer to the excel file pallet (attached to the assignment) to

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

Don't use plagiarized sources. Get Your Custom Essay on
Refer to the excel file pallet (attached to the assignment) to
Just from \$13/Page

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

1. For the Boston shingles, is there evidence at the 0.05 level of significance that the population mean weight is different from 3150 pounds?
2. Interpret the meaning of the p-value in (1)
3. For the Vermont shingles, is there evidence at the 0.05 level of significance that the population mean weight is different from 3700 pounds?
4. Interpret the meaning of the p-value in (3)
5. 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.

1. 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.
2. Find the p-value in question (1) and interpret the meaning.
3. What other assumptions are needed for question (1)?