Pallet and Phone Population Examples

Refer to the Excel file Pallet 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.
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.
What other assumptions are needed for question (1)?

Part III
At times we can generate a regression equation to explain outcomes. For example, an employee's salary can often be explained by their pay grade, appraisal rating, education level, etc. What variables could explain or predict an outcome in your department or life? If you generated a regression equation, how would you interpret it and the residuals from it?