This question must be answered manually and by using excel spreadsheet as an excel outlook or excel pdf file

A farmer believes that the average pumpkin from his crop weighs at least 7 pounds. To test his claim he selects 15 pumpkins randomly and weighs them. The weights (in pounds) are listed below

4.8 7.8 10.1 7.2 6.0 9.3

6.7 4.3 8.3 6.9 10.0 9.2 6.8

The sample statistics are mean = 7.43, s = 1.77

Can the farmer infer, at the 5% significance level that his claim is true? Assume the required conditions are satisfied.

Ho:__________________

H1:____________________

Conclusion: Reject Ho Do not reject Ho

Reason for conclusion: _________________________________________