Hypothesis Testing: P-Value and Null Value

This problem contains 4 parts based on the following information (also see attachment).

"The Florida Home Energy Commission lists the mean annual air-conditioning (A/C) expenditure for a well-insulated Central Florida home as $1.20 per square foot. Cool Crib Insulation (a home insulation company) is working hard to attract new customers. In the company's advertising, they claim that homes with their exclusive, patented insulation material have A/C costs that are below average for the region. A consumer-affairs investigator has surveyed a sample of 80 recent Cool Crib customers and listed their A/C expenditures (per square foot) in the following tab. The investigator is interested in examining whether the mean A/C expenditures for Cool Crib's clients really is less than the $1.20 per square foot average for the entire region. Based on these data, and using a significance level of 5% (i.e.  = .05), provide the answers to the following questions in the spaces provided:

Report all answers to this problem to a minimum of 4 decimal places.

Using the provided sample data,(in the attached excel spreadsheet), to answer the following questions:

a.     Write the expression for the correct alternative hypothesis statement for the test that must be carried out.

Ha: __________________ _________ _________
(or H1): (Population Parameter) (Operator) (Null Value)

b.    Perform the hypothesis test and record the "p-value" for this test.

The p-value for this hypothesis test is: _________________ 4 decimal places

c.   Which of the following statements is correct?

i) i. The mean annual A/C expenditure for Cool Crib clients appears to be significantly less than the regional average of $1.20 per square foot.
ii) ii. The mean annual A/C expenditure for Cool Crib clients appears NOT to be significantly less than the regional average of $1.20 per square foot.

Copy and past your choice from the statements above, in the space below.

d.           The investigator would next (separately) like to estimate, with 99% confidence, the mean annual A/C expenditures for all Cool Crib clients. Based on the same sample data (used in parts a. thru c. above), find the range in which he can be 99% confident that the actual mean annual A/C expenditures (for all Cool Crib clients) will fall?

Upper Limit __________________
Lower Limit __________________

This entire problem in excel is attached. It has 'data and workspace' spreadsheet to do all calculations.