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:

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

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