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


Refer to the Excel smooth Pallet (solid to the assignment) to oration all the interrogations below:

The smooth contains the ponderosity in pounds from a exemplification of 368 pallets of Boston shingles and 330 pallets of Vermont shingles.

  1. For the Boston shingles, is there manifestation at the 0.05 smooth of reason that the population average ponderosity is opposed from 3150 pounds?
  2. Interpret the averageing of the p-value in (1)
  3. For the Vermont shingles, is there manifestation at the 0.05 smooth of reason that the population average ponderosity is opposed from 3700 pounds?
  4. Interpret the averageing of the p-value in (3)
  5. In (1) through (4) do you entertain to be restless about the normality conviction? Explain.

Refer to the Excel smooth Phone for the assignment below:

The smooth contains exemplifications of 20 problems reputed to two opposed offices of a telecommunication association and the season to intelligible these problems in minutes from the customers' lines.

  1. Assuming that the population variances from twain offices are similar, is there manifestation of a dissimilitude in the average cessation season betwixt the two offices at the 0.05 reason smooth.
  2. Find the p-value in interrogation (1) and construe the averageing.
  3. What other convictions are needed for interrogation (1)?